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

Incorrect query in Frontend ( Availability report )

    Details

    • Team:
      Team B
    • Sprint:
      Sprint 15, Sprint 16
    • Story Points:
      0.5

      Description

      When making availability report using Host mode and filtering by specific host group, query is selecting all nested Host groups that has nothing to do with filtered one.

      Example scenario:
      Create Host group - Test group ( with host "1" inside it )
      Create Host group - Nested/nested1 ( with host "2" inside it )
      Create Host group - 1_Nested/1_nested1 ( with host "3" inside it )

      Open Reports -> Availability report page.
      Query from debug:

      SQL (0.000292): SELECT g.groupid,g.name FROM groups g WHERE (g.name IN ('Nested','Nested/1_Nested'))
      report2.php:434 ? CFrontendApiWrapper->get() ? CApiWrapper->__call() ? CFrontendApiWrapper->callMethod() ? CApiWrapper->callMethod() ? CFrontendApiWrapper->callClientMethod() ? CLocalApiClient->callMethod() ? call_user_func_array() ? CHostGroup->get() ? DBselect() in include/classes/api/services/CHostGroup.php:318
      

        Attachments

          Activity

            People

            • Assignee:
              sasha Alexander Vladishev
              Reporter:
              dmitrijs.lamberts Dmitrijs Lamberts
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: