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
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