Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

[dev.icinga.com #9726] Custom variables added via the URL-parameter addColumns not added to the group by list when using PostgreSQL #1873

Closed
icinga-migration opened this issue Jul 24, 2015 · 5 comments
Closed

[dev.icinga.com #9726] Custom variables added via the URL-parameter addColumns not added to the group by list when using PostgreSQL #1873

icinga-migration opened this issue Jul 24, 2015 · 5 comments
Assignees
@lippserd
Labels
area/monitoring Affects the monitoring module bug Something isn't working

Comments

@icinga-migration
Copy link

This issue has been migrated from Redmine: https://dev.icinga.com/issues/9726

Created by elippmann on 2015-07-24 07:19:04 +00:00

Assignee: elippmann
Status: Feedback
Target Version: Backlog
Last Update: 2017-01-10 08:12:19 +00:00 (in Redmine)

http://localhost:8080/icingaweb2/monitoring/list/hosts?hostgroup\_name=&addColumns=*host*

Changesets

2016-12-20 12:27:38 +00:00 by (unknown) fcd2ad9

IdoQuery: group by queried custom variables if using PostgreSQL

refs #9726

Relations:
@icinga-migration
Copy link
Author

Updated by elippmann on 2015-07-24 07:20:25 +00:00

  • Relates set to 9692

@icinga-migration
Copy link
Author

Updated by elippmann on 2015-10-01 21:46:13 +00:00

  • Target Version changed from 2.0.0 to 273

@icinga-migration
Copy link
Author

Updated by elippmann on 2015-11-20 13:11:07 +00:00

  • Target Version changed from 273 to Backlog

@icinga-migration
Copy link
Author

Updated by aklimov on 2016-12-20 12:33:55 +00:00

  • Status changed from New to Feedback
  • Assigned to set to jmeyer

@icinga-migration
Copy link
Author

Updated by jmeyer on 2017-01-10 08:12:19 +00:00

  • Assigned to changed from jmeyer to elippmann

@icinga-migration icinga-migration added feedback bug Something isn't working area/monitoring Affects the monitoring module labels Jan 17, 2017
@icinga-migration icinga-migration added this to the Backlog milestone Jan 17, 2017
@Al2Klimov Al2Klimov mentioned this issue Feb 9, 2017
Closed
@nbuchwitz nbuchwitz mentioned this issue Sep 7, 2017
Closed
nbuchwitz pushed a commit to nbuchwitz/icingaweb2 that referenced this issue Sep 8, 2017
Group_by support for customvariables
ef29348 
Added group_by support for querying customvariablestatus table for hosts
and services

refs Icinga#1873
@nbuchwitz nbuchwitz mentioned this issue Sep 8, 2017
Closed
@dnsmichi dnsmichi added needs-feedback We'll only proceed once we hear from you again and removed feedback labels Nov 9, 2017
lippserd added a commit that referenced this issue Nov 16, 2017
@lippserd
pogsql: Group by custom variables when querying them
40ab9f6 
Custom variables added via the URL parameters addColumns or sort must be added to the GROUP BY list when using PostgreSQL.

refs #1873
@lippserd lippserd mentioned this issue Nov 16, 2017
Merged
lippserd added a commit that referenced this issue Nov 16, 2017
@lippserd
pogsql: Group by custom variables when querying them
d11519a 
Custom variables added via the URL parameters addColumns or sort must be added to the GROUP BY list when using PostgreSQL.

Credits to @nbuchwitz who came up with the initial fix for this.

refs #1873
@dnsmichi dnsmichi removed the needs-feedback We'll only proceed once we hear from you again label Jan 16, 2018
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@lippserd lippserd

Labels
area/monitoring Affects the monitoring module bug Something isn't working
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

IdoQuery: group by queried custom variables if using PostgreSQL Icinga/icingaweb2
3 participants
@dnsmichi @lippserd @icinga-migration