I have 10 row in Notes CDT and I am using below script to display the data in P

ankitb0003

Certified Lead Developer

over 10 years ago

I have 10 row in Notes CDT and I am using below script to display the data in Paging grid, it is displaying 5 rows in ascending order as expected but when I click on next page arrow in paging grid to view next 5 set of data it is loading form with same set of data.

=todatasubset(pv!Notes,type!PagingInfo(startIndex:1, batchSize:5,sort:{field: "createdOn", ascending: true}))

Please verify my code.
...

Discussion posts and replies are publicly visible

0 darbyk
Certified Lead Developer
over 10 years ago

This looks like its on a form as opposed to a SAIL right? I don't believe that's a valid way of doing it for forms; instead try just doing todatasubset(pv!Notes) then at the bottom of the left hand page in the modeler tool when you've clicked on the corresponding paging grid, there is a "Rows Per Page" option and set that to 5. Now it should work as expected. Hope that helps
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 ankitb0003
Certified Lead Developer
over 10 years ago

yes this will work but it will not sort the data on date.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel