paging grids

Question

hello all, 
 I am using paging grid and also user can filter based on drop down. Drop down values are dynamically load from view(distinct dept names will be in dropdown if data is available for that id record).If there are records , grid is working fine(pageinfo 1,5). If there is no record for the particular Id then I am getting the below message. Please let me know if you have any thoughts.Thanks 
 &ldquo;totalCount&rdquo; must not be null or less than the number of items in any of the &ldquo;data&rdquo; arrays, but &ldquo;totalCount&rdquo; was 0 and the largest column data array had 1 items

aloks0189 · Answer

I believe null check is not required, because when you use paging grid then if the data is not available or null then it shows emptyGridMessage (when your datasubset.data is empty or null or {}). 
 
There can be multiple root cause behind this. I suspect your query entity is returning empty double quotes "" when data is empty while querying the db. It will be easy to trace this out if you can share your code snippet as well as the datasubset value (when the data is empty).

Mike Schmitt · Answer

It's not very useful to speculate further until/unless baratc supplies us with example code as originally requested, since there could be so many possibilities. 
 However since everyone else already is, i'll post mine: 
 My biggest suspected culprit here is that the data elements of the columns are not properly handling the empty set condition, which is a common mistake i've seen with SAIL designers who are new to paging grids. 
 This would be caused by defining the data element like: 
 data: property(local!dataSubset.data, "myElement", null) 
 This would cause the error message as described in the original post since when the dataSubset returns an empty Data array, the 'null' would return one element instead of an empty set. The proper way of writing this (and this should be everyone's default setup for paging grid columns until/unless something more complex is required) is as follows: 
 data: property(local!dataSubset.data, "myElement", {})

shafaly · Answer

Hi baratc, 
 
It seems you are doing some manipulation to render data in any column . The solution for this is just add null check for every gridTextColumn like 
 
if( isnull(property(local!dataSubset,"data",{})), {} ,property(local!dataSubset.data, "myElement", {}) )