In the function a!queryProcessAnalytics the sort field in pagingInfo can contain multiple sort field without conflicting the result data correctly? I have two fields that are to be sorted together but it seems the results are conflicting because of it.
Discussion posts and replies are publicly visible
https://docs.appian.com/suite/help/22.2/fnc_system_a_queryprocessanalytics.html#usage-considerations
When a query is passed, the query's pagingInfo overrides the report's configured sorting and paging. The first valid SortInfo object in the query paging field is used to sort the results; other SortInfo objects are ignored.
Yeah one thing that's a bit tricky is that a!query() supports multiple sorts when used in other functions like a!queryEntity(), but unfortunately when used in a!queryProcessAnalytics() it only uses the first sort.
You could always return the data first and then use a grid to apply multiple sorts - you just need to make sure in this case that you return all the results from the query and pass the entire dataset to your grid.