7 Jun
2019
7 Jun
'19
4:20 a.m.
Branch: refs/heads/master
Home: https://github.com/tribe29/checkmk
Commit: 1c8637ebec21745ad1bb57f44220ba8acd83ebff
https://github.com/tribe29/checkmk/commit/1c8637ebec21745ad1bb57f44220ba8ac…
Author: Sven Panne <sven.panne(a)tribe29.com>
Date: 2019-06-07 (Fri, 07 Jun 2019)
Changed paths:
A .werks/6972
Log Message:
-----------
6972 Support SQL-style quoting for filtering dict-valued columns
Some Livestatus columns do not contain a simple value or a list of such values,
they contain a dictionary of key/value pairs. More concretely, the
<ul>
<li><tt>custom_variables</tt></li>
<li><tt>label_sources</tt></li>
<li><tt>labels</tt></li>
<li><tt>tags</tt></li>
</ul>
columns in the
<ul>
<li><tt>contacts</tt></li>
<li><tt>hosts</tt></li>
<li><tt>hostsbygroup</tt></li>
<li><tt>services</tt></li>
<li><tt>servicesbygroup</tt></li>
<li><tt>servicesbyhostgroup</tt></li>
</ul>
tables contain dictionary values. Livestatus filter for such columns have a
special syntax:
C+:
Filter: COLUMN OPERATOR KEY VALUE
C-:
As an example, the query:
C+:
GET hosts
Filter: tag = agent cmk-agent
C-:
returns all hosts where the tag "agent" has the value "cmk-agent".
Note that the
key and the value are separated by whitespace. But this makes it impossible to
query for a tag name with spaces. To support more general keys and values in
such filters, Livestatus now additionally supports SQL-style quoting for such
column filters:
C+:
Filter: labels = 'It''s so' 'cool, man!'
C-:
This filter matches a label with key "It's so" and value "cool,
man!". Note the
use of 2 consecutive single quotes to represent 1 single quote. The previous
syntax still works, the new syntax is triggered by a leading single quote in the
key and/or value.
Change-Id: I14d72f742f4d81132568455f180ee01a577e0322