Kibana -Canvas : Unable to access URL param value

Elastic Stack Kibana
1

Hi Team ,
I am trying to filter out values from my Drop down filter.
I want to use URL Param for the same. I have specified url param and trying to get its value in my SQL query. But I am getting result as No documents found.
Please help me to solve this issue.

Canvas URL : https://logs-payerrelations.com/app/canvas?user=xyz#/workpad/workpad-fbbf73c1-41d0-431f-a7ed-ad020748c753/page/1

SQL Query : SELECT * FROM "pv_dashboard_99*" WHERE "USERNAME_1" ="'{urlparam param=user default=abc}'"

I also tried using only single quote i.e. '{urlparam param=user default=abc}' but it didn't work. Can you please help @Joe_Fleming
Thanks for the help in advance

2

If you create an element with this expression, does the result look good ?

urlparam param="user" default="abc"
| string "SELECT * FROM \"pv_dashboard_99*\" WHERE USERNAME_1 = " {context}
| render as="debug"

If so, then the next step is to inject the parameter properly in your essql expression, using a ? and a parameter:

essql query="SELECT * FROM \"pv_dashboard_99*\" WHERE USERNAME_1 = ?" parameter={urlparam param="user" default="abc"}
3

If you need more Kibana Canvas examples you can get them from elastic content share