Hi ,
I am using Record type as a data source as grid field . I have the requirement to show the first 500 record list in the grid after applying filters and sorting. I did something like this.
local!pagingInfo: a!pagingInfo(startIndex: 1, batchSize: 500),
a!gridField( label: "Read-only Grid", labelPosition: "ABOVE", data: local!employeeData, columns: { a!gridColumn( label: "First Name", sortField: "firstName", value: fv!row.firstName ), a!gridColumn( label: "Last Name", sortField: "lastName", value: fv!row.lastName ) }, pagingsaveinto: local!pagingInfo )I understand batchsize will not help as it will return 500 rows for each page. Can some one help here
Discussion posts and replies are publicly visible
You could create a View by selecting * from the table, sort it by ID and LIMIT the result by 500 and then use this View as a data source. Would this help your use case?