Hi
I would like to report a this Kibana canvas issue.
Let me first describe the test environment:
The canvas contains a dropdown filter and a Data table.
The kibana index is issued from syslog files. The main index fields are:
- host
- filename
- message
The dropdown filter allows the hostname to be selected with a very basic SQL command:
essql query="SELECT host FROM \"linux-log\" GROUP BY host "
| dropdownControl filterColumn="host" valueColumn="host" filterGroup="LinuxFilter"
| render
The data table code is the following:
filters "LinuxFilter"
| essql
query="SELECT
\"@timestamp\" as \"Date / Time\",
host,
filename,
message
FROM
\"linux-log\"
"
| mapColumn "Date / Time" fn={getCell | formatdate "DD-MM-YYYY / HH:mm:ss"}
| table
| render containerStyle={containerStyle border="3px double #444444"}
Everything works fine with most of the hostnames.
But as soon as a dash is included within the selected hostname, the data table output is empty.
Note: I experienced the same issue with both V7.12.1 and V7.16.1.
A similar issue was reported in Feb. 2020 but not relevant solution was posted.
Thank you for your help
Vincent