Is there a way to get the count of all the columns for users?

Hi, DB structure of the source table would really help in figuring out ways to implement grouping mechanism, but beforehand I can say if you plan to use a query entity expression, you might have to 'group by' on two columns(user and role) at-least and use an aggregation function on other columns like id. If you find queryEntity doesn't support grouping on multiple columns(I'm not sure) then you have to see if the same can be done using a todatasubset function(after getting data in raw format with out grouping). Once you are able to get the data in this format you can display it in a grid.

Hi, DB structure of the source table would really help in figuring out ways to implement grouping mechanism, but beforehand I can say if you plan to use a query entity expression, you might have to 'group by' on two columns(user and role) at-least and use an aggregation function on other columns like id. If you find queryEntity doesn't support grouping on multiple columns(I'm not sure) then you have to see if the same can be done using a todatasubset function(after getting data in raw format with out grouping). Once you are able to get the data in this format you can display it in a grid.