[icinga-checkins] icinga.org: icinga-web/next: Cronks Downtimes and Downtime History: Duplicate alias 'sh' in query

git at icinga.org git at icinga.org
Thu Apr 18 12:22:10 CEST 2013


Module: icinga-web
Branch: next
Commit: 8db05a425784f59be83329845f784fd8ba0be8a7
URL:    https://git.icinga.org/?p=icinga-web.git;a=commit;h=8db05a425784f59be83329845f784fd8ba0be8a7

Author: Marius Hein <marius.hein at netways.de>
Date:   Thu Apr 18 12:21:18 2013 +0200

Cronks Downtimes and Downtime History: Duplicate alias 'sh' in query

Remove hostgroup join in downtime* target queries. Alias sh already
present in base query and therefore not not needed to join again.

fixes #3975

---

 app/modules/Api/config/views/misc.xml |    2 --
 1 files changed, 0 insertions(+), 2 deletions(-)

diff --git a/app/modules/Api/config/views/misc.xml b/app/modules/Api/config/views/misc.xml
index 61ba86d..42b384b 100644
--- a/app/modules/Api/config/views/misc.xml
+++ b/app/modules/Api/config/views/misc.xml
@@ -97,7 +97,6 @@
 
             <credential name="IcingaHostgroup" type="dql">
                 <leftjoin>h.hostgroups hg</leftjoin>
-                <leftjoin>s.host sh</leftjoin>
                 <leftjoin>sh.hostgroups shg</leftjoin>
                 <leftjoin>hg.object ohg</leftjoin>
                 <leftjoin>shg.object sohg</leftjoin>
@@ -221,7 +220,6 @@
 -
             <credential name="IcingaHostgroup" type="dql">
                 <leftjoin>h.hostgroups hg</leftjoin>
-                <leftjoin>s.host sh</leftjoin>
                 <leftjoin>sh.hostgroups shg</leftjoin>
                 <leftjoin>hg.object ohg</leftjoin>
                 <leftjoin>shg.object sohg</leftjoin>





More information about the icinga-checkins mailing list