Page Analyzer Links (or Deep Linking with Filters)
I am trying to create this BM calc but instead of the example shown in DOMO where you create a column with the link (Deep Link Col3) and also display the value (Owner Name Col1) I am trying to do it as one column but I am getting an error on the card. The link takes you to the page and you can see the filter is added to the page but the card has an error.
My table is really a list similar to the one above but I transposed it across in a mega table
CONCAT('<a href="https://xxxxxxxx.domo.com/page/xxxxxxxxxx',
'?pfilters=[{
%22column%22: %22Line of Business Level 3%22,
%22dataSourceId%22: %228377d31b-580b-473f-bbe5-956b70277394%22,
%22dataType%22: %22string%22,
%22operandtype%22: %22IN%22,
%22values%22: [%22',`Line of Business Level 3`,'%22]
}]"
target=%22_blank%22>'
,`Line of Business Level 3`,'</a>')
What am I doing wrong?
Answers
-
Hi @Jessica
Have you tried compressing the pfilters to be on a single line instead of multiples?
Also, try
target="_blank"
instead of URL encoding the quotestarget=%22_blank%22
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
Changed it to this, still error
CONCAT('<a href="https://xxxxxx.domo.com/page/xxxxxxxxx',
'?pfilters=[{
%22column%22: %22Line of Business Level 3%22,%22dataSourceId%22: %228377d31b-580b-473f-bbe5-956b70277394%22,%22dataType%22: %22string%22,%22operandtype%22: %22IN%22,%22values%22: [%22',`Line of Business Level 3`,'%22]
}]"
target="_blank">'
,`Line of Business Level 3`,'</a>')
0 -
On this issue, I found that from DOMO support my code was actually working but that we are experiencing a caching issue that is being addressed.
1
Categories
- 10.5K All Categories
- 3 Connect
- 913 Connectors
- 250 Workbench
- 458 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 476 Datasets
- 183 Visualize
- 249 Beast Mode
- 2.1K Charting
- 11 Variables
- 16 Automate
- 354 APIs & Domo Developer
- 88 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 245 Distribute
- 62 Domo Everywhere
- 242 Scheduled Reports
- 20 Manage
- 41 Governance & Security
- 168 Product Ideas
- 1.2K Ideas Exchange
- 9 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive