Forum Discussion

mkavcic's avatar
mkavcic
Frequent Visitor
4 years ago

Field parameters and URL filters

Hi, I have published a report with field parameter on my dashboard.   I have been trying to reference a field parameter in URL with no success.   How could I use the &filter=Table/Fieldname eq '...
Need Help
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi mkavcic ,

Just use "_x0020_" instead of space in the table name, like this:

&filter=Table _x0020_ name.

Special characters in table and column names

 

Special characters and spaces in table and column names require more formatting. When your query contains spaces, dashes, or other non-ASCII characters, prefix those special characters with an escape code starting with an underscore and an X (_x), then the four-digit Unicode, then another underscore. If the Unicode is fewer than four characters, you need to pad it with zeroes. Here are some examples.

Best Regards

Community Support Team _ Polly

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

mkavcic's avatar
mkavcic
Frequent Visitor
4 years ago

Hi,

I am not using any space in table name.

My example was  &filter=Table/Fieldname eq 'Tablename'[Fieldname] 

 

So no empty spaces.

  • mkavcic's avatar
    mkavcic
    Frequent Visitor
    3 years ago

    Is there anybody that uses URL filtering with FIELD PARAMETERS?

    I have searched everywhere and found no working solution.

    I have tried all the custom formatting options and URL filtering does not work.
    As far as I know, this is a bug.