OroCRM Forums

Covering OroCRM topics, including community updates and company announcements.

Forums Forums OroCRM Modify DataGrid Query

This topic contains 3 replies, has 2 voices, and was last updated by Ilya Antypenko Ilya Antypenko 2 years ago.

Starting from March 1, 2020 the forum has been switched to the read-only mode. Please head to StackOverflow for support.

  • Creator
  • #39045



    1) what I want is to modify datagrid query to apply filter’s value on join condition instead of where clause. Because I have left join in my query and applying filters on where clause converts my left join to inner join. I can add join condition with offsetSetByPath() method of DataGridConfig in onPreBuild listener. But can not prevent to apply filters on where clause.

    2) Another thing I want is to add orWhere() clause in datagrid query. I use addOrWhere() of getOrmQuery() of DataGridConfig in onPreBuild listener followed by this tutorial After that I get the SQL in onResultBefore listener and I see my condition apply with ‘AND’ instead of ‘OR’.

    My oro version is 1.8

Viewing 3 replies - 1 through 3 (of 3 total)
Viewing 3 replies - 1 through 3 (of 3 total)

The forum ‘OroCRM’ is closed to new topics and replies.

You will be redirected to [title]. Would you like to continue?

Yes No