@variable syntax

[former_member539471]

(abc.xyz LIKE '%@variable('BOUSER')%'

OR

abc.mnp = @variable('BOUSER'))

is this a correct syntax....I get parsing error in universe conditions....says missing right parenthesis.....

any inputs appreciated.

Pali

[Former Member · Accepted solution]

Hi Pali,

In your second code statement:

abc.mnp = @variable('BOUSER'))

I can see a second parantheses. You would need to delete the second right parantheses-something like:

abc.mnp=@variable ('BOUSER')

In your first code statement, I think the @variable cannot be used within inverted commas since it would end up treated as a string. You need to create a final string that would concatenate the '%' symbols for you.

Off the top of my head, can you please check if this syntax works:

abc.xyz LIKE concat('%',concat(@variable('BOUSER'),'%'))