Skip to main content
aishwaryap610839
aishwaryap610839
July 15, 2022
Question

a!queryProcessAnalytics the sort field in pagingInfo

  • July 15, 2022
  • 2 replies
  • 0 views

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.

    2 replies

    stefanhelzle0001
    stefanhelzle0001
    July 15, 2022

    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.

    peter.lewis
    peter.lewis
    Employee
    July 15, 2022

    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.

      Terms & ConditionsAccessibility statement