Change View Sort Order

Hello All,

I have a need to change the sort order(ascending/descending) on one of my views. I am not a programmer of any type, but I couldn't find where to change how to do this. The particular one I am attempting to change is this "Broadband Interfaces with High Codeword Errors". It currently has 3 columns, no errors, corrected, uncorrectable. I want to change it from sorting on the no errors to the corrected, and in the ascending order.

Thanks,

-Lyle

Find more posts tagged with

Accepted answers

All comments

ldove

Bump. Anyone?

-Lyle

vhcato

Lyle,

Assuming you know where the resource files are on your server, you should be able to edit this particular resource file. I don't have the Broadband version of Orion, so I don't have that particular resource, but here's where you can change it in the "High Errors and Discards Today" resource. Perhaps you can locate the similar line in your resource and change it there.

This is actually one long line, but it will get wrapped on the forum.

SQLResource.SQL="SELECT Top 10 Nodes.NodeID, Nodes.VendorIcon, Nodes.Caption as NodeName, Nodes.GroupStatus, Interfaces.InterfaceID, Interfaces.InterfaceIcon, Interfaces.Caption, Interfaces.StatusLED, Interfaces.InErrorsToday, Interfaces.OutErrorsToday, Interfaces.InDiscardsToday, Interfaces.OutDiscardsToday FROM Interfaces INNER JOIN Nodes ON Interfaces.NodeID = Nodes.NodeID Where (Interfaces.InErrorsToday+Interfaces.OutErrorsToday+Interfaces.InDiscardsToday+Interfaces.OutDiscardsToday)>" & HighErrorsDiscards & " ORDER BY (Interfaces.InErrorsToday+Interfaces.OutErrorsToday+Interfaces.InDiscardsToday+Interfaces.OutDiscardsToday) Desc, Nodes.Caption, Interfaces.Caption "

See the "Desc" towards the end? Changing it to "Asc" will reverse to ascending.

Hope this helps...

Vic