Database connector : Case statement in a Insert Query (CreateAccountJSON)

[BinduVaranasi]

Hi Team,

I am trying to implement a case statement in the createAccountJSON. 

In the insert query , I need a case statement syntax which will fetch the correct value depending on the user attributes. I had tried the below possible values , but no luck.

a) CASE WHEN ((${user.entity} == 'XX') and (${user.customproperty5} == 'YY')) THEN 'AA' ELSE 'BB' END

b) ${CASE WHEN ((user.entity == 'XX') and ( user.customproperty5 == 'YY')) THEN 'AA' ELSE 'BB' END}

c) ${(user?.entity == 'XX' && user?.customproperty5=='YY') ? 'AA': 'BB' }

d) CASE WHEN ((user.entity == 'XX') and ( user.customproperty5 == 'YY')) THEN 'AA' ELSE 'BB' END

Please help me to get the right syntax

Thanks

Bindu.

[pmahalle]

Hi @BinduVaranasi ,

Can you try below one:

CASE WHEN (('${user.entity}' == 'XX') and ('${user.customproperty5}' == 'YY')) THEN 'AA' ELSE 'BB' END

[BinduVaranasi]

Hi @pmahalle ,

The above expression also did not work. 

Please confirm if we can use multiple conditions in the case statements with and condition. 

Please let me know if any.

Thanks

Bindu.

[pmahalle · Accepted solution]

Yes you can add multiple conditions.

Hey try with single = instead of two as below. It's SQL not groovy or java

CASE WHEN (('${user.entity}' = 'XX') and ('${user.customproperty5}' = 'YY')) THEN 'AA' ELSE 'BB' END

[armaanzahir]

Hi @BinduVaranasi ,

Can you share the whole createaccountjson you're trying. In MySql, Case statements do support multiple conditions separated by a logical operand. 

What is the target database?

Thanks,

Armaan

[BinduVaranasi]

Hi @pmahalle 

single = worked . Thanks for the solution.

@armaanzahir I am using the Database connector. 

Thanks

Bindu.