I have a paging grid on a form and am using the todatasubset() function in the D

Howard over 10 years ago

I have a paging grid on a form and am using the todatasubset() function in the Data Set field and set the Rows per Page field to 10 in the Forms Designer.
"=todatasubset( pv!avpChecklist,a!pagingInfo( startIndex: 1,batchSize: -1, sort: a!sortInfo( field: "checkListName", ascending: true())))"
When I run the process, it shows all the records in the process variable on one page, sorted on the checkListName field. I was expecting to have 10 records on the page with the ability to "page" through all the records.
Am I missing something in the pagingInfo()? TIA....

Discussion posts and replies are publicly visible

0 Bishnu Panigrahi
Appian Employee
over 10 years ago

When using the forms designer, don't use system functions (functions prefixed with a!). Instead, use data!pagingInfo. Also, another way to limit the number if items displayed in the grid is by using the "Rows per Page" paging grid feature.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Howard over 10 years ago

Ok, when I do that it I can't control which field to sort on when the form is loaded.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Steven Miccile
Appian Employee
over 10 years ago

forum.appian.com/.../Function_Recipes
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Howard over 10 years ago

That worked. Thanks.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel