Count based on Grouping

JavaScript
1

I have 2 tables - Items and Users

Each item will be mapped to an user and I wish to get all users and the number of items mapped to them in the table.

What are the backendless way of doing this in JavaScript? I don’t want to loop the entire database and have a counter for calculating as it might slow down when table size increases.

2

We do not have support for aggregating functions (SUM, AVERAGE, etc) at the moment.

3

Thanks for update.