How to format the data that is returned from the query to display in the grid
Test it Out
Adjust the sorting of name field of live view and make sure the paging info values will reset to descending alphabetical order
Notable implementation details
The grid displays the text representation of all types, including Appian Objects such as a user, so we applied our own formatting
a!forEach() is used in these formatting cases because the expressions used to format this data will only evaluate the first value in the datasubset. For expressions that can handle arrays, a!forEach() is typically not needed.
Sorting for name is currently by first name. This can be adjusted at the field parameter of the first a!gridTextColumn().