Urlparams syntax

[luis.montecatine (Luis Montecatine Beltrán)]

Hello.
I'm trying to use urlparam on canvas on the "kibana_sample_data_ecommerce" index.
My param is "dy", and the value is "Tuesday".

When I use on markdown the syntax is:

My problem is when I try to use it on other visualitations, like dropdown filter or metric.
I'd like to use a urlparam in my query. For example, in a metric, I'd like to get the sum of the field "price" on Tuesdays.
Probably my syntax is wrong, if someone have some doc about urlparams I'll appreciated.

For dropdown vis:

It don't shows any data.

my elasticsearch query is:
essql query="SELECT day_of_week AS day FROM kibana_sample_data_ecommerce where day='{urlparam param=dy default=Monday}'"
| dropdownControl valueColumn="day" filterColumn="day"
| render

If I remove the where condition It works fine anyway:

And for metric vis:

It shows data, It must shows any value>0
But it shows 0.

The query preview also shows 0. So I think my syntax is wrong.
My query is:
"SELECT sum(products.price) AS price FROM kibana_sample_data_ecommerce where day_of_week='{urlparam "dy" default=Monday}' "

Can anyone help me with that or link some documentation about it?

Thanks. Luis.

[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?