Hi,
I want to perform some group by operation on sail code on required dataset with some filters.
Do we have any way to do that on sail code not on expression rules ?
Actually i have received bulk data set from one view and i want to use one list of one field value to traverse whole dataset, so just fo that details i don't want to hit database again, for that i want to do group on existing dataset only, so if we have any option for grouping on sail code plz suggest.
Regards
Saurav
Discussion posts and replies are publicly visible
Hi Sauravk,
use the query aggregation while fetching the data from view so you will get only required data not all data. you can use below link for reference
https://docs.appian.com/suite/help/18.1/recipe_aggregate_data_from_a_data_store_entity_and_conditionally_display_in_a_chart_or_grid.html
regards
Abhay
Because as per the recommended standard approach, we should perform aggregation while querying the data. Whereas you want to perform aggregation over already exist datasubset.