Forum Discussion

peterlu's avatar
peterlu
Champion
11 years ago

Categories Boards Posts Count - API v2 version

<#assign menuItems = ["CategoryA", "CategoryB", "CategoryC"] /> <div class="lia-component-custom-community-browser"> <div class="panel"> <ul> <#list menuItems as item> <#-- possible ...
PaoloT's avatar
PaoloT
Lithium Alumni (Retired)
11 years ago

Hi peterlu 

 

ah I see. A way to do that in an SQL-Like language would be to select a post count by board ID, having a category in the where clause and then grouping by the board ID. I don't think group by is currently available in LiQL - maybe worth pinging JeffY to see if this in in the plans (although I imagine it is a quite sizeable task to add this feature).

 

In the meantime, you could alway perform the aggregation in your code, having something like (where Cat1 and Cat2 are your categories)

 

SELECT id,board.id FROM messages WHERE category.id IN ('Cat1','Cat2');

 And then paginate the result, which could be slightly more compact.

 

Kind Regards,

Urvashi's avatar
Urvashi
Mentor
11 years ago

Hi PaoloT ,

 

I guess this is perfectly fine, as this would reduce the REST Calls upto much extent. As we can get the desired data in on one page for all the categories at the same time.

So thanks to Lithium for V2.

 

 

Thanks!

Urvashi