Support AND, OR and NOT for labels in filters

253 votes

Currently, a host needs to have all labels of a filter, so it is an AND operation.
It would be very helpful, if a OR operation can be used, so hosts of either of the defined labels are shown

Released Suggested by: Ralf Schwarzmaier (18 Apr, '22) • Upvoted: 01 Mar • Comments: 15

Comments: 15

04 May, '22
Gerd
While you are add it, could we get label filtering by regex?
11 May, '22
Robert Sander
OR operation is achieved by using two rules in the ruleset
12 May, '22
Andy
This is for filters not rules. You can't add multiple filters for a view, for example
23 May, '22
Andy
It would be nice if the labes, when used in filters or rules could be split by key:value and allows for wildcard/regex search.
For example you have one label key called city and the values contains a countrycode+city. So you could for example want to search for city:de to include all german sites. As this data (iirc) is stored in redis it would be possible to even show all the values that belongs to a specific key as dropdowns making the query faster.
25 May, '22
KG
I like that. While you are at it, maybe that's too large but it would be sweet if all the fields/filters etc. would behave somehow the same and had the same rules applied. E.g. its not very intuitive that service-names do regex-matching by default while hostname-fields need a "~" prefix for that as they are exact match otherwise.
Maybe that needs to be another feature to vote for but that way this will all continue to look stitched together...
28 Jun, '22
Thomas Lippert Admin
Planned for the Checkmk 2.2 release
29 Sep, '22
Thomas Lippert Admin
Just to be clear. This ticket is for filters. If boolean operations are required for rules, please create a separate feature request. Thanks!
02 Nov, '22
Gerd Stolz
@Thomas Lippert: Be careful what you wish for :) j/k thanks for the clarification - I created a FR for the rule side of things: https://checkmk.featureupvote.com/suggestions/339982/support-regex-for-labels-in-rules
19 Dec, '22
Tanja Hohenstatt Admin
>>> CALL FOR FEEDBACK <<<

We designed two variations of the UI for which we want your feedback (5 questions survey): https://www.surveymonkey.de/r/VHDZKYZ
Please provide your feedback until January, 10th 2023.
06 Jan, '23
Lars Sörensen
It should also be possible to select "all that don't have the label assigned".
08 Jan, '23
Thomas Lippert Admin
Yes, this is possible as well with the NOT operator
Click to enlarge

10 Feb, '23
Thomas Lippert Admin
The implementation of this feature is now done. Please see the attached screenshot on how it looks for a host filter
11 Feb, '23
Andy
Nice
When will the 2.2 first beta be released? :-)

Will the filter allow for duplicates in the key?
For example I have a label called city:munich and another city:berlin and I want to filter on hosts that are in Munich and Berlin, or some cities but not Munich, will that be possible?
Click to enlarge

12 Feb, '23
Thomas Lippert Admin
Yes, this does work. See example. The result set consist of hosts either in a Munich or Berlin datacenter

An announcement about or beta test plans will come soon
15 May, '23
Thomas Lippert Admin
Will be shipped in Checkmk 2.2.0. Moved to done, so I can share the plans for Checkmk 2.3.0 by marking the respective tickets