Pagination not working on grid field (version 23.3) for non-admin users

Question

Hi everyone, 
 I'm having an issue with a grid in my interface. When using System Administrator account, the data loads correctly when the next page button is clicked. 
 
 But when using a Basic User account, the grid shows the same first-page data, and the paging control is not updating as well. 
 I checked all related objects used in the code, all have Viewer access for the Basic User's group. 
 
 Code snippet: 
 a!gridField_23r3( 
 data: local!grid.data, 
 pageSize: 5, 
 pagingSaveInto: fv!pagingInfo, 
 validations: {} 
 ) 
 
 Thanks in advance for any insights!

Stefan Helzle · Answer

I am pretty sure this line makes no sense: 
 pagingSaveInto: fv!pagingInfo, 
 This should be a local used to perform paging in the query.

Harsha Sharma · Answer

As long as the user can see page 1 there is no configuration that can disable/hide the next page data. So it is not due to any configuration or security issues. Suggest you to have the basic user test from a different browser or check the same grid after clearing cache/cookies. Also investigate if a specific user is facing this or all basic users. Depending on the users affected further investigation can be done. Let us know how it goes/ what you find.

Shubham Aware · Answer

Can you check if the Basic User has Viewer permissions on the Data Store (not just the CDT/Entity/Record)? Also, does your query have any security filters or record-level security that might be limiting what Basic Users can see? https://docs.appian.com/suite/help/25.3/Data_Stores.html#security Also, Does local!grid use fv!pagingInfo in the query's pagingInfo parameter?

Mike Schmitt · Answer

Checking in to agree with Harsha - nothing in terms of account-type security would generally allow a given user to load the first page of a grid but then fail to be able to see the second page. I'm guessing that if you fix the issue Stefan pointed out - the "pagingSaveInto" currently being something nonsensical - that might smoothe over internal issues in such a way that the error goes away (i suppose there's a chance that the error it gives basic users is somehow not as strong when seen by an admin, though if so I can't imagine why or how).

harshitag0021 · Answer

Hi, 
 Instead of using fv!pagingInfo, try to use local!pagingInfo with startIndex and batchsize as required. Then you can use the local!pagingInfo into pagingSaveInto. 
 for example: - 
 local!pagingInfo: a!pagingInfo(startIndex: 1, batchSize: 10) 
 
 I hope this will resolve the query.

Pagination not working on grid field (version 23.3) for non-admin users

Top Replies