PDP Automation and Ignoring Case Sensitivity?
Hi All -
I have been working on automating PDP for my company but have run into a bit of a snag. By default PDP is case sensitive and if I were manually creating policies using the Domo UI, it's easy enough to just tick the "Ignore case" checkbox.
However, when generating policies in an automated fasion, it seems like the ":ignore_case" flag you can append to the 'value' column in your PDP dataset only works if used on trusted attribues like you see below in Domo's own documentation
For my needs, I need to apply this same :ignore_case condition on values/strings that arent trusted attributes. In our instance we have a ton of datasets and some datasets have varying different case structures for the same value, this causes PDP to not filter all permutations of the same value correctly. Instead of asking developers/clients and the like to fix this in their ETLs across every dataset, I thought I'd try to just ignore case. Below is an example of one of my PDP rules:
Above you can see that I want PDP to filter where COUNTRY_NAME is Korea, Germany or Australia. But because some datasets contain "Korea", "korea" etc those values get missed in the PDP evaluation because it wants the exact case of "KOREA" for a match.
Is there some undocumented flag I can add somewhere so that PDP ignores case on static/non-attribute values?
If not, can I suggest allowing :ignore_case as an append to the end of the 'value' to ignore case on all values as a feature request?
Thanks!
Answers
-
This would be a great suggestion for the Ideas Exchange as this currently isn't possible.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
Thanks Grant! That seems like an oversight that can be easily implemented. I'll submit feedback to my CSM and the idea exchange.
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 297 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
- 54 App Studio
- 40 Variables
- 678 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 46 Workflows
- 8 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
- 32 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive