Hi, can someone suggest me how to sort column while writing any search query. For example here is one query:
@accounts(source.name:TestApplication) AND attributes.customeAttribute3: “D” AND attributes.employeeStatus: “T”
Here I want to display Termination Date column as Ascending sorted order.
If you want to sort a column in the GUI you can simply add the wanted attribute in the column chooser and then then press the arrow on that column to filter on Ascending/Descending.
You can not, however, as far as I’m aware, manage this case the same way via API. You instead would have to make a HTTP request with the v3/search endpoint and specify your query in the Request Body. Then, if you’re using it in a workflow, you could potentially use a JSONExpression to filter on the response body of that call to only display Termination Dates, however, you would need to check what is returned from your query first via API in, for example, Postman.
This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.