Groupby on multiple fields using DQL

[MichelDiz]

@Asim_Khan

@groupby(key: UserStatus.type)

As far I remember, you can add several predicates separately by comma.

@Asim_Khan

@groupby(key: [Us

But you can’t do this. A single Alias for all predicates. That’s not possible.

@Asim_Khan

How can I extract the Date from the DateTime field just like we do in SQL using Extract function and then use it inside the groupby

You can’t. That would be a new feature request.

@Asim_Khan

How can we convert the timezone at runtime while querying the data.

Not possible, again that would be a new feature request.

There are several requests for datetime. For now we have only since. And indexing.