Remove Account based on its Entitlement in Certification

[fuko]

Hi team,

How can I filter BASE ACCOUNTS based on their entitlements and create Remove Account task when the certifier revokes them?

I tried using Entitlement/AccountEntitlement1 Query in Advanced Campaign Configurations, but only the accesses are filtered, and only Remove Access task is created on revoke. Tested on Entitlement Owner and Application Owner type Campaign.

Thanks

[fuko · Accepted solution]

Using this query in Accounts query of Advance Campaign Configuration works

accountkey in (select ae.accountkey from Account_entitlements1 ae where entitlement_value in ('abc', 'def'))