How do I fix this problem?
I made a report and sorted on the timestamps and it looks and does great when previewed with Report Writer but when I publish it to Orion the sort shown is completely wrong.
Which report and which version are you on?
The report is EVENTS and the version is NPM 9.5 SP2.
Is this one of the out of the box reports and if so, what is the exact one? Might be quicker and easier to open a support ticket to resolve.
Here's the finished report. It started as out-of-the-box but I expanded on it. The NODES.COFB_CIRCUIT is a Custom Property.
And like I said - it looks great in Report Writer's Preview but not in Orion. In Preview it shows ASC Node Down - Node Up in correct order but it is reversed in Orion.
SELECT Events.EventTime AS Event_Time,Events_EventTypes.Name AS Event_Type_Name,Nodes.Caption AS NodeName,Nodes.IP_Address AS IP_Address,Nodes.Location AS Location,Events.EventType AS Event_Type,Nodes.COFB_Circuit AS COFB_Circuit,Nodes.Status AS Status,Nodes.StatusLED AS Status_Icon,Nodes.NodeID AS NodeID,Nodes.ResponseTime AS Response_Time,Nodes.MaxResponseTime AS Maximum_Response_Time
FROM Nodes INNER JOIN (Events INNER JOIN EventTypes Events_EventTypes ON (Events.EventType = Events_EventTypes.EventType)) ON (Nodes.NodeID = Events.NetworkNode)
WHERE ( EventTime BETWEEN 40015 AND 40015.5416666667 ) AND ( (Nodes.COFB_Circuit IS NOT NULL))
ORDER BY 1 ASC, 3 ASC
I opened a very similar ticket with SW and yesterday was told that SP3 will address the sorting in the browser issue. I am on SP2 as well.
They were able to duplicate the problem.
Jim
SP3 has been released -
