Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-22042

Cannot view host groups prototypes in host prototype settings on template.

XMLWordPrintable

    • Team C
    • Sprint 95 (Dec 2022)
    • 0.125

      Steps to reproduce:
      Open host prototype on some template with existing host group prototypes.
      There should be listed some host group prototypes which was added earlier.

      Result:
      See screenshot...

      Query

      SELECT gp.hostid,gp.name FROM group_prototype gp WHERE gp.hostid=82764 AND gp.name!='';
      

      is not fetch result. i.e. current host group prototypes.

      If you use this query it works for Oracle.

      SELECT gp.hostid,gp.name FROM ZABBIX.group_prototype gp WHERE gp.hostid=82764 AND gp.name IS NOT NULL
      

      MySQL and PostgreSQL works fine with original query.

      Expected:
      So host group prototypes should be loaded. properly

        1. 1.JPG
          503 kB
          Andrei Gushchin
        2. 2.JPG
          113 kB
          Andrei Gushchin

            vmaksimovs Vladimirs Maksimovs
            neogan Andrei Gushchin (Inactive)
            Team C
            Votes:
            2 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated:
              Resolved: