I'm trying to apply a multiple sort on a query process report, trying to retrieve process tasks by different sorts, but I'm having an error:
errorMessage: "Grouping and aggregation are not supported. (APNX-1-4203-027)"
It seems is not supported for query process report, any solution?
a!queryProcessAnalytics( report: cons!TST_TASK_REPORT, contextProcessModels: cons!TST_PROCESS_MODEL, query: a!query( selection: a!querySelection( columns: { a!queryColumn( field: "c1" ), a!queryColumn( field: "c2" ) } ), pagingInfo: a!pagingInfo( startIndex: 1, batchSize: 10, sort: { a!sortInfo( field: "c1", ascending: true ), a!sortInfo( field: "c2", ascending: true ) } ) ))
Discussion posts and replies are publicly visible
Is possible but maybe not for queryProcessAnalytics. At the documentation you have it with queryEntitiy.
https://docs.appian.com/suite/help/18.1/Query_Recipes.html
You can wrap the a!queryProcessAnalytics in a!toDataSubset and pass in multiple sorts as the pagingInfo of the data subset.
Hi felixsantiagoa,
Its clearly mentioned in the documentation that multi-sorting inside a!queryProcessAnalytics is not possible.
https://docs.appian.com/suite/help/19.2/fnc_system_a_queryprocessanalytics.html
The first valid SortInfo object in the query paging field is used to sort the results; other SortInfo objects are ignored.
Kindly try the approach suggested by