and more in a single search tool across platforms. Read the announcement here. |
04/06/2023 05:18 AM
Hi Team,
We are trying to launch role owner certification for the SOX Critical medium and high.
We don't see any option for this and when we are trying to achieve with Role Query we are not able to get the correct query or it shows SQL syntax error.
Please let us know what we should we use to filter the SOX critical for role owner certifications.
Thanks,
Dharmen
Solved! Go to Solution.
04/06/2023 07:26 AM - edited 04/06/2023 07:26 AM
try sox_critical in (3,4) for including Medium and High respectively
04/06/2023 10:18 PM
I have tried this its not working
04/06/2023 10:18 AM
Hi Dharmen,
Can you try below and check?
and ro.rolekey.SOX_CRITICAL in (3,4)
We used CP2 and it did worked so similarly you can try for SOX_CRITICAL field.
Thanks
Devang
04/06/2023 10:18 PM
Thanks Devang,
I have tried but its shows syntax error.
04/07/2023 12:50 AM
We need to use in below format
and ro.rolekey.soxcritical in (3,4)
Its working fine now.
Thanks,