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

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


Apr, 2017 - Permalink