Click HERE to see how Saviynt Intelligence is transforming the industry. |
05/21/2024 06:40 AM
I'm trying to create a Role Owner certification campaign for only Roles that are flagged as high privilege or high SOX critical. These attributes do not seem like they are available using Role Query HQL.
Solved! Go to Solution.
05/21/2024 07:15 AM - edited 05/21/2024 07:16 AM
Hi @JKeyser can you try the below query
and r.privileged >=4 and r.soxcritical >= 4
05/21/2024 07:23 AM
I am still seeing a syntax error here
Below is recognized as valid syntax, but does not apply the appropriate filtering:
privileged >= 4 and sox_critical >= 4
05/21/2024 07:28 AM
Apologies. there was a typo. Please try the below query. It should work
and r.priviliged>= 4 and r.soxcritical >= 4
05/21/2024 07:43 AM
Thanks @naveenss , that appears to have solved my issue.
Is there a resource that defines the Hibernate equivalent of these column names? For example, in this instance the roles.SOX_CRITICAL column in the database is represented as Roles.soxcritical using Hibernate.
05/21/2024 10:53 PM
Hi @JKeyser refer to the below documentation