Need help on making aggregation on sail code with filter

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

I don't want to hit Db again for doing aggregation on same view. View is taking time to fetch data. So its hitting performance.

Hi,
it will be helpful if you can provide same data and your expected data.

here i am assuming, i may wrong here with your requirement:

suppose your view is returning the below data:
1,abc,1213,xyz
2,sdf,3434,asa
...
...

n,sfsdf,434,sfs

now if you want to use only second value from the data then you can use index function.

regards
abhay

I don't want single column i want full row after adding group by like we get in DB

It sounds like what you want to do is pull all the data you need once and store it in a load() variable. Then you can add filters to your grid. You wouldn't change the original list of all the data which is in load(), you'd change another local variable containing the subset of that data you want to show based on the filter. That variable containing the subset would be in a with() that's updated in real time, taking the data out of the load() one but only keeping the data you care to display in the with() one.

If that sounds about right, this recipe has example code. It uses a list of departments that you just replace with what you got from database.

docs.appian.com/.../recipe_filter_the_data_in_a_grid.html

It sounds like what you want to do is pull all the data you need once and store it in a load() variable. Then you can add filters to your grid. You wouldn't change the original list of all the data which is in load(), you'd change another local variable containing the subset of that data you want to show based on the filter. That variable containing the subset would be in a with() that's updated in real time, taking the data out of the load() one but only keeping the data you care to display in the with() one.

If that sounds about right, this recipe has example code. It uses a list of departments that you just replace with what you got from database.

docs.appian.com/.../recipe_filter_the_data_in_a_grid.html