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
Did you check this?
https://docs.appian.com/suite/help/21.3/read-only-grid-configuration.html#paging-&-sorting
Do you want to show only 500 rows at all, or 500 per page?
show only 500 rows.
Interesting requirement ... what's the purpose?
I would create an expression which fetches the data including paging info for paging in the grid. Then I would manipulate the totalCount attribute using a!update to be 500 or less.
Then the grid should manage everything else.
users don't want to see older records. if I move away from recordType in grid, then we will be losing OOB features in the grid for eg search box, user filters, record actions, and the Export to Excel button. our business users dont like taking away this feature. Moreover, update funtion is not present in version 20.4
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?
Then add a user filter, define "old" as "created before now() - N days" and make this the default. In case someone needs to check an older one, he still can do that.