Advance Query Information

[bhuvanesh]

Hello Saviynt Team,
 

We started using advance query. i need to understand how to write and how to use user table and account/Entitlement table based on the requirement.
 

Thanks in advance

[rushikeshvartak]

Where are you using advanced query ? Rules / Certification ?

Rules - https://forums.saviynt.com/t5/saviynt-knowledge-base/advanced-usage-of-eic-identity-objects-in-provi...

[bhuvanesh]

Hi @rushikeshvartak 

Rules

[rushikeshvartak]

Refer https://forums.saviynt.com/t5/identity-governance/department-change-notification/m-p/74636#M47403

https://forums.saviynt.com/t5/saviynt-knowledge-base/advanced-usage-of-eic-identity-objects-in-provi...

[SowmithriV · Accepted solution]

hi @bhuvanesh , Advanced Query in Rules uses the HQL and here is the document that you can refer for further building. 

https://docs.saviyntcloud.com/bundle/KBAs/page/Content/Obtaining-the-attribute-details-from-tables-o...