platform icon indicating copy to clipboard operation
platform copied to clipboard

"Cannot group by undefined identification or result variable." when applying filter

Open hvanoch opened this issue 7 years ago • 1 comments

When we use a SQLfunction inside the Group By statement in the datagrid we get the error Cannot group by undefined identification or result variablewhen applying a filter on a toManyrelation. This is caused by https://github.com/oroinc/platform/blob/d93ef23734d61d63688b2266dc5e99e96f25c914/src/Oro/Bundle/FilterBundle/Filter/AbstractFilter.php#L121

when using a doctrine function in a group by it should also be put inside the select (as AS HIDDEN)

hvanoch avatar Oct 02 '18 13:10 hvanoch

Internal ticket id BAP-20456.

anyt avatar Mar 04 '21 12:03 anyt