OroCRM Forums

Covering OroCRM topics, including community updates and company announcements.

Forums OroCRM Modify DataGrid Query

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

  • Creator
    Topic
  • #39045

    Nava
    Participant

    Hi,

    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)

You must be logged in to reply to this topic.

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

Yes No