Skip to content

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

Open
@hvanoch

Description

@hvanoch

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

$subQb->groupBy(sprintf('%s, %s', $groupBy, $fieldExpr));

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

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions