Grid display batch size

Question

I am trying to display a grid on the record dashboard with a batch size of 10 
 a!pagingInfo( startIndex: 1, batchSize: 10 ) 
 but get an error on the summary view of the record dashboard as follows: 
 A grid component [label=&ldquo;Sess&rdquo;] has an invalid value for &ldquo;columns&rdquo; and &ldquo;value&rdquo;. All &ldquo;data&rdquo; arrays must not contain more items than the specified &ldquo;batchSize&rdquo;, but &ldquo;batchSize&rdquo; was 10 and the largest column data array had 19 items. (APNX-1-4198-000) 
 
 When i change the code to batchSize: -1 then it shows the entire grid on the same page. But I want it in pages of 10. 
 
 Any help would be appreciated. TIA!!

harishkumart · Answer

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 )

vamshidhar · Answer

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 
) 
) 
)

Abhay Giri · Answer

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

ankita0004 · Answer

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

kumara0002 · Answer

Check recipe for this SAIL Recipe-Grid . 
 Use the totalCount correctly.