The prioritization component accepts an expression as the prioritization. You could concatenate the properties and sort alphabetical. But that may be suboptimal for numeric results. Alternatively you can probably get this done with a combination of filter and group-by shapes but I don't think there is an easy generic way. However I have not seen this request before - so why do you want to sort this way? Do you have an example?
I too have a similar kind of requirement to implement. I have a pagelist and need to sort it based on 3 columns. PFB for the sample results. Here I should sort first on the earliest date if we get any same dates records then go for highest amount if we get equal amount records with same date then go for least certificate number. Can you please suggest some approach in strategy.
Posted: 1 year ago
Updated: 1 year ago
Posted: 18 Nov 2020 5:10 EST Updated: 18 Nov 2020 7:06 EST
Unfortunately the prioritization (sort) component does not take multiple conditions. So as I mentioned before, a workaround could be to turn the properties into fixed width strings, then sort on the concatenation of these strings. Not pretty but it may do the job. So by padding the numbers with zeros you get e.g.
"20201110T120000.000 GMT" + "0000100" + "00007"
And then just use this in your prioritization expression
To pad a numeric value to a string of 5 characters you can use an expression like