I am trying embed a dashboard and apply filters using the pfilter param and it is not working

chrisb · 2024-02-02T17:00:26+00:00

There was an error rendering this rich post.

Currently I am having issues getting the pfilter query param with the embed working in an iframe. I have followed many of the examples out there and have replaced every special character in the value with their ascii counter parts but nothing has seemed to work
Here is an example of what I have been trying:
[{%22column%22:%22FIELD.Name%22,%22operand%22:%22EQUALS%22,%22values%22:[%Field.Value%22]}]

Can a period in the field names be causing an issue?

Find more posts tagged with

Filters

Dashboard

Embed

Accepted answers

trafalger

I know when doing it on a card you need to the ` to the fields like

pfilters[{%22column%22:%22JobNum%22,%22dataType%22:%22STRING%22,%22operand%22:%22IN%22,%22values%22:
[%22',`JobNum`,'%22]}]">',JobNum,'</a>')

but not 100% certain if you have to do it in embed.

All comments

trafalger

My go-to troubleshooting method for this is to put a static value in for your field, to determine where it's erroring out.

Can you rename the column (or try another column) temporarily and see if that helps? I could see the period causing issues

chrisb

I have tried all that with the exception to renaming the column as this data set is used elsewhere.

chrisb

And I just tried renaming the column to remove the periods and it did not work still

trafalger

I know when doing it on a card you need to the ` to the fields like

pfilters[{%22column%22:%22JobNum%22,%22dataType%22:%22STRING%22,%22operand%22:%22IN%22,%22values%22:
[%22',`JobNum`,'%22]}]">',JobNum,'</a>')

but not 100% certain if you have to do it in embed.