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
The forum ‘OroCRM’ is closed to new topics and replies.