Forum Discussion

Claudius's avatar
Claudius
Boss
3 years ago

How to pull topic count per node by author? GROUP BY anyone?

Hi, I would like to programmatically generate a list of authors on an idea board and their number of idea submissions using LiQL. In generic SQL I would simply GROUP BY author.id while pulling the b...
REST API v2 & LiQL
AbhishekGu's avatar
AbhishekGu
Khoros Staff
3 years ago

Hello Claudius,
I just tried and confirm that GROUP BY is not possible in LiQL.

So, the only option we have which you suggest above.

use following LiQL:

SELECT id, author.id FROM messages WHERE board.id = '<board-id>'

And then count, author's article. 

Regards,
Abhishek Gupta