I am using a paging grid to display information in a task form with the todatasu

Howard over 10 years ago

I am using a paging grid to display information in a task form with the todatasubset() function. It displays the information properly, but I am unable to use the controls in the paging grid (sorting by column, moving to other pages in the grid). The expression that is being used is =todatasubset(pv!statusAccum, a!pagingInfo(startIndex: 1, batchSize: 4, sort: a!sortInfo(field: "statusDateT",ascending: false))). The CDT is not linked to a datastore and does not have a primary key. Am I missing something in the expression or with the CDT? Thanks....

Discussion posts and replies are publicly visible

0 rayudua over 10 years ago

Did you check the count of the pv.
What do you see the total
Usually shows 1 of 4 etc based on total.
Also if cdt has been updated and you just did analysis it wont reflect in todatasubset ()
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Howard over 10 years ago

It does show the correct count of variable. It just that when you click on the control (page number or arrow) it stays on that page. The CDT in the process is at the current level.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 lesliem over 10 years ago

howardng, did you ever find a fix for this? I am having the same issue.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Howard over 10 years ago

I had to create a script task node to sort the data before the user input task node that had the paging grid. In the script task, I followed this function recipe to sort the data. forum.appian.com/.../Function_Recipes
and saved the output to a variable that is used in the data set of the paging grid.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel