Urlparams syntax

[Nathan_Reese]

Here is all I could find on urlparam

Canvas function reference | Kibana Guide [8.11] | Elastic

Global Variables in Canvas

@JamesNotJamez There's not a way to create a "global" value directly, but you could perhaps use the urlparam function as a substitute here. That function allows you to read a value from query params in the URL. When you have a workpad open, the URL in your browser should look something like this: http://localhost:5601/app/canvas#/workpad/... You can add query params before the # in there, like so: http://localhost:5601/app/canvas?target=5000#/workpad/ So now you have a query param named targ…

Using urlparam in an Elasticsearch SQL query in Kibana Canvas

Hey @Sahiru_Gunawardene, welcome to the discussion boards! Give this syntax a try. I do want to caution you though -- this is widely considered unsafe, as you are taking data from the URL (which the user controls) and injecting it into a SQL query: filters | essql query={string "SELECT project, release, sum(effort) FROM my_index where field= '" {urlparam param=varFromURL default=1000} "' group by field1, field2" | table | render

I could not get urlparam working in a where clause of an SQL statement.

Can you open an issue at Sign in to GitHub · GitHub?