Click HERE to see how Saviynt Intelligence is transforming the industry. |
05/22/2024 07:58 AM
Hi,
I am trying to configure a Technical Rule that is currently failing because the department name contains a single quote.
Départment name example: Département de l'infrastructure
In Data Analyzer testing, if I replace the single quotes around the name with double quotes it fixes the problem but it gives me an error trying something similar in Technical Rules / Advanced Config query.
a.departmentname like "%Département de l'infrastructure%"
How can we successfully do this in Technical rule advanced config? At first I was trying without advanced config but I noticed it was not working. This is why I am now trying with advanced config.
Thank you.
Solved! Go to Solution.
05/22/2024 08:39 AM
You can escape the special characters. Below document for your reference:
Thanks,
Devang Gandhi
If this reply answered your question, please Accept As Solution and give Kudos to help others who may have a similar problem.
05/22/2024 09:06 AM
05/22/2024 11:55 AM
Hi Saathvik,
Thank you very much this is working fine now!
I had also tried putting the required quote between quotes like this but it was not working. I was close... 🙂 Thank you!
a.departmentname like '%Département de l'''infrastructure%'