|
Duplicate |
Team B
[ZBX-12646] Incorrect query in Frontend ( Availability report ) Created: 2017 Aug 31 Updated: 2024 Apr 10 Resolved: 2017 Sep 05 |
|
| Status: | Closed |
| Project: | ZABBIX BUGS AND ISSUES |
| Component/s: | Frontend (F) |
| Affects Version/s: | 3.2.7, 3.4.1 |
| Fix Version/s: | 3.2.8rc1, 3.4.2rc1, 4.0.0alpha1, 4.0 (plan) |
| Type: | Problem report | Priority: | Trivial |
| Reporter: | Dmitrijs Lamberts | Assignee: | Alexander Vladishev |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Issue Links: |
|
||||
| Team: | Team B | ||||
| 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: Open Reports -> Availability report page. 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 |
| Comments |
| Comment by Alexander Vladishev [ 2017 Aug 31 ] |
|
Fixed in dev branch svn://svn.zabbix.com/branches/dev/ZBX-12646 |
| Comment by Ivo Kurzemnieks [ 2017 Sep 01 ] |
|
(1) No translation string changes. sasha CLOSED |
| Comment by Alexander Vladishev [ 2017 Sep 05 ] |
|
Fixed in:
|