Is it possible to select all the rows(from all the pages) in a paging grid using SAIL?

Question

Need a way to select all the rows in a paging grid and display the selection in the grid(a check against all the rows on all the pages).

Shivam Gupta · Accepted Answer

Yes it can be possible, but you have to build that feature by your own as Appian don't provide that functionality you can create a dynamic link on click of which all rows will be selected once you click on that link it should save all the unique identifiers of the cdt data that you are displaying (primary key generally) create one expression rule and query only the unique identifier for that CDT, from this rule you will receive a list of all the unique identifiers of the cdt structure that you have created(don't forgot to parse all the identifiers using tointerger() function {generally all the primary keys will be autogenerate numbers only}) So, when you click that link a!save( local!selected, rule!nameofexpressionrule() ) Here local!selected is the variable that is keeping values of the rows which are selected or not Hope this will work for you.

Alok Patro · Answer

You have feature to select all the rows in a particular page by just checking the check box besides the header row. 
And even if you navigate between pages after the selection , once you are back to the page where you have selected all the rows the selection is preserved. 
 
Further to that, if you need all the rows you can use the rule calling the query entity/query rule to do that. 
 
Hope it make sense to you .