Pfilters
Hi,
I just watched Marks video about how to use pfilters so I thought id give it a shot with this beastmode.
CONCAT('<a href="https://trimble-tt-16502962.domo.com/page/2050403531?pfilters=[',
'{%22column%22:%22Lane%22,%22operand%22:%22IN%22,%22values%22:[%22',
`Lane`,
'%22]}',
']" target="_blank">',Lane
,'</a>')
The output on the card looks something like this
WAPAKONETA, OH%22]}]" target="_blank">ALBANY, NY> WAPAKONETA, OH.
I thought Id go to the documentation that mark linked in his video https://domo-support.domo.com/s/article/360042933114?language=en_US to try and find the answer but that page says the following.
Any idea how to fix either of these problems?
Best Answer
-
This is just a guess, but it could be possible that some of your
Lane
values contains characters that are causing this to break, for which you should URL Encode it, just to be sure nothing is breaking it. Sadly, MySQL does not offer a URLENCODE function AFAIK, so you'll need to do with a bunch of replacements, these are some of the most common ones:%20 - space %27 - single quote %7C - | %26 - & %5E - ^ %2B - + %2D - - %25 - %
%22 - "having this in your text might cause it to break, so I'd suggest replacing them, first you should replace the % sign and then all of the others, so you'll use something like:
REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(`Lane`,'%','%25'),' ','%20'),'''','%27'),'|','%7C'),'&','%26'),'^','%5E'),'+','%2B'),'-','%2D'),'"','%22')
There are many more characters that might need to be escaped, but these are the most common ones, so if it stills breaks, try looking at the lanes that are causing this to break and then identify what character is the one where it is breaking.
1
Answers
-
Looks like you're using %22 which is a " character which would end your HREF property on your A tag. Try using single quotes instead (%27)
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
Domo changed their KB site, so that link no longer works as you found out. Here is an updated link where you can find the Domo Documentation.
https://domo-support.domo.com/s/article/360043430113?language=en_US
Scroll down to Create Page Analyzer Links.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.2 -
GrantSmith I tried replacing all the %22 to %27 and that had the same result. Its weird because if I take out the first `Lane` the link displays the correct information but on the page it takes me to, it does not filter it by lane.
0 -
This is just a guess, but it could be possible that some of your
Lane
values contains characters that are causing this to break, for which you should URL Encode it, just to be sure nothing is breaking it. Sadly, MySQL does not offer a URLENCODE function AFAIK, so you'll need to do with a bunch of replacements, these are some of the most common ones:%20 - space %27 - single quote %7C - | %26 - & %5E - ^ %2B - + %2D - - %25 - %
%22 - "having this in your text might cause it to break, so I'd suggest replacing them, first you should replace the % sign and then all of the others, so you'll use something like:
REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(`Lane`,'%','%25'),' ','%20'),'''','%27'),'|','%7C'),'&','%26'),'^','%5E'),'+','%2B'),'-','%2D'),'"','%22')
There are many more characters that might need to be escaped, but these are the most common ones, so if it stills breaks, try looking at the lanes that are causing this to break and then identify what character is the one where it is breaking.
1 -
marcel_luthi That seemed be the issue. I had a > sign in the Lane. My workaround was to replace > with "to". Thanks for the help!
1
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 299 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 616 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 55 App Studio
- 40 Variables
- 682 Automate
- 175 Apps
- 451 APIs & Domo Developer
- 46 Workflows
- 10 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive