Skip to main content
P
ptc-50390081-Visitor
1-Visitor
February 17, 2015
Question

multi-field sort on a query

  • February 17, 2015
  • 2 replies
  • 1319 views

Is there a way to perform a multi-field sort on a query? For example, I would like to sort by date and then by relative priortiy.

    2 replies

    M
    mrump16-Pearl
    16-Pearl
    February 17, 2015

    Unfortunately this is not possible for Queries, but can easyly be done in a report.

    HTH Matthias

    J
    JoeBartlett21-Topaz I
    21-Topaz I
    February 17, 2015

    It looks like there is an existing enhancement request to have this functionality added (see this article). Please contact Integrity Technical Support and your organization will be added to the request.

    J
    JoeBartlett21-Topaz I
    21-Topaz I
    February 17, 2015

    One more thing: if you click on ColumnB first to sort its values, then click on columnA to sort its values, you will see what you want. The results will be primarily sorted alphabetically based on ColumnA values, but then a secondary sort is done on ColumnB. There is no official way to specify multiple sort fields but you can accomplish the sorting you want on a per-query basis. Note that this has to be done each time you run a query in a new view. As far as I know, this behavior is only limited to 2 columns sorted in this way.

    Terms & ConditionsCookie settingsAccessibility statement