How to filtering metabase widget via external button

Get Help
1

Hy everyone,

i'm trying to setup a dashboard in metabase which will be embedded into an external portal of our client. One of the requirements is that all the widget that will be exporting must be filtered from external buttons that represent some specific field of table in the datamart. So, the widget cannot be filtered from metabase directly, but via a third party script. I know that is possibile to pre-filter data represented by a widget thanks to signed parameters (https://www.metabase.com/docs/latest/administration-guide/13-embedding.html)

So, i wanna know if this function will work also with my request.

thank you in advance

2

Hi @aresb
Yes, you should be using Embedding with Locked parameters.

1 Like
3

Hi flamber,

im trying to use a locked parameters on my query.
here it is the sintax for CATEGORY

SELECT "PUBLIC"."PRODUCTS"."CATEGORY" AS "CATEGORY", "PUBLIC"."PRODUCTS"."VENDOR" AS "VENDOR", "PUBLIC"."PRODUCTS"."PRICE" AS "PRICE", "PUBLIC"."PRODUCTS"."RATING" AS "RATING", "PUBLIC"."PRODUCTS"."CREATED_AT" AS "CREATED_AT"
FROM "PUBLIC"."PRODUCTS"
WHERE CATEGORY ={{CATEGORY}}

the problem is this
once i lock parameters from embending page, metabase take me back to editor without any possibility of editing

How can i solve this ?

4

@aresb Sounds like you are using an older version of Metabase. Latest release is 0.43.1: https://github.com/metabase/metabase/releases/latest

5

Thanks for your precious support.
I'll take advantage of this thread for answering you another question:
embedding preview shows me only a locked content, with no possibility to see chart/table in it.
I've read through many topics that one of the solutions could be changing http to https in general settings.
Mine is set in this way -- http://xx.yyy.aa.bbb:3000.
Shall I change this in some other way? Thanks

6

@aresb I don't understand. Make sure you Site URL is set exactly to how you are accessing Metabase.
Admin > Settings > General.