Hello,

We used URL like
http://somehost/status/service?filter=unhandled&order=last_state_change_desc&order=host&order=service&includeunhandledhosts=1
for sorting in time order.

But it doesn't work after upgrading to 3.13.1

So I manage to get it working again with the following patch.

----------------------------cut here-----------------------------------
$ diff -u OpsviewHostObjects.pm.bak OpsviewHostObjects.pm
--- OpsviewHostObjects.pm.bak   2011-11-09 10:55:58.000000000 +0900
+++ OpsviewHostObjects.pm       2011-11-09 11:32:31.000000000 +0900
@@ -340,7 +340,7 @@
                 "servicestatus.current_check_attempt",
                 "servicestatus.max_check_attempts",
                 \"UNIX_TIMESTAMP(servicestatus.last_check)",
-                \"UNIX_TIMESTAMP(servicestatus.last_state_change)",
+                \"UNIX_TIMESTAMP(servicestatus.last_state_change) AS
last_state_change_timev",
             ],
             "+as" => [
                 "host_object_id",
----------------------------cut here-----------------------------------


Is this a valid solution ?
_______________________________________________
Opsview-users mailing list
[email protected]
http://lists.opsview.org/lists/listinfo/opsview-users

Reply via email to