Hallo! I try to sort the xml output by multiple values. I already tried:

.../api/table.xml?content=sensors&columns=objid,downtimetime,device,sensor,lastvalue,status,message,priority,minigraph,checkbox&filter_status=5&filter_status=4&filter_status=10&sortby=-status,-downtimetime&username=xxx&password=xxx

and

.../api/table.xml?content=sensors&columns=objid,downtimetime,device,sensor,lastvalue,status,message,priority,minigraph,checkbox&filter_status=5&filter_status=4&filter_status=10&sortby=-status&sortby=-downtimetime&username=xxx&password=xxx

Both are not working. I try to sorty by status (descending) first, then by downtime (descending) to get the ERROR sensors to the top of the list with the longest downtime on top, below the ERROR sensors then the WARNING sensors.

What's the right syntax to sort by multiple columns?

Thank you!

Marc

Article Comments

Attention: This article is a record of a conversation with the Paessler support team. The information in this conversation is not updated to preserve the historical record. As a result, some of the information or recommendations in this conversation might be out of date.

You can't sort by multiple columns, simple as that :)


Apr, 2017 - Permalink