Hi,
I'm creating an Attestation Policy to attest some accounts, by identites managers, annually and I needed to differ between VIP managers to delegate them to a specific approval team. To do so I needed to devide my workflow in two and make a condition using an Approval procedure - CD (Calculated Approval), but when I use the SQL wizard to the condition which creates me the following query
EXISTS ( SELECT 1 FROM (SELECT UID_Person FROM Person WHERE IsVIP = 0) as X WHERE X.UID_Person = AttestationCase.UID_PersonHead )
it fails and on the ITShop/Attestation pannel tells me that the condition is not met for all cases. When I put the following arbitrary query, it works with all cases, but dosn't really do the trick I need and it doesn't work properly
EXISTS ( SELECT 1 FROM (SELECT UID_Person FROM Person WHERE IsVIP = 0) as X, (SELECT UID_PersonHead FROM AttestationCase) as Y WHERE X.UID_Person = Y.UID_PersonHead )
Is there any solution for this problem?
Regards,
Abdalla