Active Objects: Is it possible to get count using group by in AO?

[Shailesh Shailesh]

Is it possible to get count using group by in AO?

[Remo Siegwart · Accepted solution]

Yes, it should be possible like this:

Query query = Query.select("selected_column").group("grouped_column");
ao.count(YourEntity.class, query);

This results in the following SQL statement:

SELECT COUNT(selected_column)
FROM ao_xxxxx_your_entity
GROUP BY grouped_column

You can also leave the Query.select() statement blank, which results in SELECT COUNT(*).

Hope this helps

[Shailesh Shailesh]

There is a problem with it. It only picks up the first value. Group by should yield in columnCount: columnValue. Current work around we have is we run this query with columnValue in where clause (whick makes group by clause useless).

[Raul Gallegos]

So to use default count, the only way is like:

Query query = Query.select();

ao.count(YourEntity.class,query)

Can't we only use:

ao.count(YourEntity.class);

??