if else condition in user account correlation rule

[rohan32]

Hi,

I want to implement conditioning in the user account correlation rule where -

If the account name is starting with 'a-' (ex :  a-rgupta@abc.com) ,

then use ( users.customproperty60 = accounts.customproperty27)

else  ( ( users.email = accounts.customproperty4)

Is there a way to use this conditioning in user correlation rule? If yes - can you please help with the syntax

[rushikeshvartak]

Use case when condition of sql

[rohan32]

@rushikeshvartak 

Using the condition below , pls comment if you have any other suggestions  or the syntax looks fine - 

CASE WHEN (accounts.name like 'a-%')
THEN (accounts.customproperty27=CONCAT(users.customproperty60,'.dte'))
ELSE (users.email = accounts.customproperty4) END

[rushikeshvartak]

Yes did it worked ?