Canvas mapColumn and essql query

Elastic Stack Kibana
1

Hi,
I'm wondering if it is possible to use an essql query in a mapColumn.
I try to make second column and want to use the value in the first column to check if it exists in another index by using an essql query.

But I can not get it working for now I only get Null values, and I don't know how to use the getCell in the essql statement:

| var_set name="hosts" value={essql query="select scanner.target as targets from \"logs-scanner-scanlog\""}
| var name="hosts"
| mapColumn name="Critical" expression={ essql "select count(scanner.vcctarget) from \"reports-scanner-data\"" }
| table 
| render
2

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.