Grid display batch size

Hi Apoorva,

You need to use here the combination of load() and with() function.

The below link has provided the same example which i think you are looking,

https://docs.appian.com/suite/help/18.2/recipe_display_array_of_data_in_a_grid.html

 

Regards

Abhay

write your local!pagingInfo() inside load() and then gridFiedl() inside with() . Also include your rule for querying data inside with() and pass the local!pagingInfo() declared earlier inside load(), to the rule for querying data. Finally in the value and saveInto parameter of the gridField(), use local!pagingInfo().

Hi Apoorva,

You can achieve your requirement in two ways.
1. Fetch the entire data and store it into a load variable. Now use a with variable where you derive the subset of data to be displayed on each page using todatasubset() function. now display the filtered data in your grid.
2. use paging info as load variable and fetch the initial set of data using the paginginfo. Later in the grid saveInto along with saving the pagingInfo , fetch the new set of data using the fresh paging info and set it to the variable that is holding the initial set of data. This will automatically reflect the grid data with new set of data. This approach is suggested way to avoid the load on Appian if there is a huge amount of data that has to be shown. As you fetch chunks of data the performance will be good.

Note:In both the approaches make sure that you are not using array of arrays in any column. This will be considered as flat array and may lead to mismatch of count of data. (for example: {{1,2},{3,4},5,6} will be treated as {1,2,3,4,5,6} while displaying in paging grid. In this case we assume the count to be 4 but paging grid considers it as 6 leading the count mismatch )

define pagingInfo variable in Load()
and data subset in with()
so your data subset will have 10 (batch size) items at a time to display in grid
and will update it every time you click on next page. this time data subset will update and will have 9 items.

Hi Apoorva,

There may be multiple reasons for this issue.
1. If you are using any rule in gridColumn, May be this rule return for a single grid value.
2. Not creating datasubset and using query directly


So there may be more reasons.
Can you please send me the code of paging grid

Thanks

Check recipe for this  SAIL Recipe-Grid.

Use the totalCount correctly.

Hi Apoorva,

Use todatasubset() function to display data in grid format with batchsize of 10.

You can try below code:(For example)
load(
local!paginginfo : a!paginginfo(
startindex:1,
batchsize:10
),
with(
local!data:(retrieved data),
local!details: todatasubset(local!data,local!paginginfo),

a!gridfield(

a!gridtextcolumn(
label:"Name",
data: index(local!details,"field name",null))
),
-------------,
-------------,
value:local!paginginfo,
saveinto:local!paginginfo
)
)
)

Hi Apoorva

Try using datasubset()
docs.appian.com/.../fnc_system_a_datasubset.html

load(
local!data,

with(

local!datasubset:todatasubset(local!data,local!paginginfo)

)

)
1)you are specifying it to display 10 items
2)you are having 19 items
it will display the first 10 items with index as 1 to 10 and
when you are retrieving the next 9 items it will change the index to 1...9 for 11th to 19th item ie its having 9 items and you can achieve your pagination

Regards
JayaKrishna

look for the variable where they have defined, paginginfo should be defined in load(), and call the grid in with()