Title: [opsview] [5348] Fixed ambiguous term for hostgroup status query
- Revision
- 5348
- Author
- tvoon
- Date
- 2010-11-10 14:52:08 +0000 (Wed, 10 Nov 2010)
Log Message
Fixed ambiguous term for hostgroup status query
Modified Paths
Modified: trunk/CHANGES
===================================================================
--- trunk/CHANGES 2010-11-10 14:45:39 UTC (rev 5347)
+++ trunk/CHANGES 2010-11-10 14:52:08 UTC (rev 5348)
@@ -8,6 +8,7 @@
Fixed systempreferences changes setting configuration status light
Fixed showing welcome page when first logged into Opsview for admin user
Fixed default value for auditlog's username column
+ Fixed ambiguous term for hostgroup status query
3.9.1.5340 8th November 2010
FIXES:
Modified: trunk/opsview-core/lib/Runtime/Searches.pm
===================================================================
--- trunk/opsview-core/lib/Runtime/Searches.pm 2010-11-10 14:45:39 UTC (rev 5347)
+++ trunk/opsview-core/lib/Runtime/Searches.pm 2010-11-10 14:52:08 UTC (rev 5348)
@@ -895,8 +895,10 @@
push @$select, "opsview_host_services.host_object_id as host_object_id", "opsview_hostgroups.name as hostgroup_name", "opsview_hostgroups.id as hostgroup_id";
$order_by = {
- group_by => [qw(hostgroup_id host_object_id service_state service_unhandled)],
- order_by => [qw(hostgroup_name hostgroup_id host_object_id)],
+
+ # Use opsview_hostgroups.id instead of hostgroup_id because hostgroup_id is ambiguous - could mean opsview_hostgroup_hosts.hostgroup_id
+ group_by => [qw(opsview_hostgroups.id host_object_id service_state service_unhandled)],
+ order_by => [qw(hostgroup_name opsview_hostgroups.id host_object_id)],
};
$where->{"opsview_host_services.host_object_id"} = \"= nagios_hoststatus.host_object_id";
$where->{"opsview_host_services.service_object_id"} = \"= nagios_servicestatus.service_object_id";
_______________________________________________
Opsview-checkins mailing list
[email protected]
http://lists.opsview.org/lists/listinfo/opsview-checkins
