I am using a report on my NOC dashboard for node status. I wish to sort the status icon as follows:
Thanks in advance for any advice.
Paul
I would create a custom query and then add a case statement so create a sort field
something like:
select nodeid, caption, statusdescription,
case when status=1 then 4 when status=2 then 1 else status end AS [sort]
from Orion.nodes
sort by [sort] desc
status integer to your needs are not reflected above.
Not sure if the above could be done with the custom table report resource without needing custom swql or sql.
never tried to case values with it.
