App Owner Certification - Advanced Filter for Entitlement

[kfoley1]

Hello - we are trying to configure and Application Owner certification and use the Advanced Campaign Configurations to exclude certain entitlements from the certification. We need to exclude entitlements where the entitlement customproperty1 says 'out of scope', can you please provide a query that can be used in the Entitlements Query to exclude those entitlements?

[dgandhi]

Entitlement Query: customproperty1 not in ('Out of Scope')

[kfoley1]

Hi @dgandhi - when I use this query the certification comes out blank and marked as 'Complete', this query is also not working data analyzer. 

Query to show 3 entitlements - 2 of which in CP1 have 'Out of Scope'

When I add ' customproperty1 not in ('Out of Scope')' it returns zero. 

If I switch to say 'in ('Out of scope') then it does work correctly 

Any ideas how to get this query working with the 'not in ('out of scope')

[dgandhi]

have you tried not like '%Out of Scope%'

[kfoley1 · Accepted solution]

The following query in advanced campaign config for worked:

customproperty1 not in ('Out of Certification Scope')

[dgandhi]

How the solution is different from what that was proposed earlier?