How to implement it in interface using grid?

Question

Hi Team, 
 Can anyone please help me how can I implement the case given below in interface using grid:

Col A 
 Count 
 Col B

a 
 1

a 
 2

a 
 1

Total a 
 4

b 
 1

b 
 2

Total b 
 3

It should display the count of col A for each category. Any other suggestions might be helpful.

Richard Michaelis · Answer

puh, this goes deep and needs a lot of explaination. you need a query rule regarding aggregation: see here: https://docs.appian.com/suite/help/21.4/Appian_Data_Types.html#query https://docs.appian.com/suite/help/21.4/fnc_system_a_query.html https://docs.appian.com/suite/help/21.4/Appian_Data_Types.html#aggregation https://docs.appian.com/suite/help/21.4/fnc_system_a_queryaggregationcolumn.html second: you need to fill your grid with the suitable query result. Informations about gridfields. docs.appian.com/.../Paging_Grid_Component.html

Farnaz · Answer

Hi Shubham, 
 I agree with others, you can create an internal CDT (not mapped to any table) with the required fields. 
 Create an expression rule and map you required data using two variables - one retrieving the data (a and b) and the other retrieving the aggregate data (Total a, Total b). 
 Then map your required data in the internal CDT with a!forEach() 
 In the interface map a local variable with the Expression Rule and use this local variable as data in grid. 
 
 Regards, 
 Farnaz

Tanvir Sarkar · Answer

Create a rule using Query Aggregation to get the count of each column. Then use the rule as data source for readonly grid

How to implement it in interface using grid?

Top Replies