How can I sort and properly page a paging grid that is populated from CDT data u

wendys42 over 10 years ago

How can I sort and properly page a paging grid that is populated from CDT data using Appian 6.7.1? I have tried to both create a paginginfo variable as well as just passing in the required parameters in the todatasubset function (ie. {startIndex:1, batchSize:10,sort:{field:"Date", ascending:false()}}). I can get the data to sort, however - I can only view the number of records that I have specified as the "batchSize". If I enter 0 or -1 as the batch size, I get no results. If I enter 10 as the batch size, when I click to go to page 2 to see the next set of records, the screen says "waiting" and stays on page 1. Can someone please let me know what I need to do to make the sorting and paging work together? Thanks!...

Discussion posts and replies are publicly visible

Parents

0 elizabeth.epstein over 10 years ago

In the "Data Set" configuration field of the Paging Grid, try:
=todatasubset(pv!myCDT,data!pagingInfo)

That should properly apply the grid paging settings (Batch Size = "Rows Per Page" configuration, and Sort = whatever the user clicked on to sort) to your data set.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 elizabeth.epstein over 10 years ago

In the "Data Set" configuration field of the Paging Grid, try:
=todatasubset(pv!myCDT,data!pagingInfo)

That should properly apply the grid paging settings (Batch Size = "Rows Per Page" configuration, and Sort = whatever the user clicked on to sort) to your data set.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data