comment count in item table datapage

[crshuman]

We have two tables item and comment. Users can leave comments on items. A comment has a field for item_id to make the relation to only show the list of comments that are associated with a specific item on the respective item's detail page. I'd like to display the comment count for each item in the table of results when doing a search for items.

[MayMusic]

In your report page you can group by the Id and then use COUNT aggregation http://howto.caspio.com/datapages/creating-datapages/advanced-reporting/totals-aggregation.html :wink: :wink: :wink: :wink:

[NailDyanC]

Hi, just to update this post. Here are the new and updated links you can use:

Data Grouping:

https://howto.caspio.com/datapages/reports/advanced-reporting/data-grouping/

Totals and Aggregation:

https://howto.caspio.com/datapages/reports/advanced-reporting/totals-and-aggregations/