'IF', 'OR', 'WILDMATCH' in a single comment.

[Architect]

Somehow I am stuck with a script, and not able to figure out the meaning of the below logic.

Please explain what is the meaning of this line -

"if([Product Name] = 'Bucket' or WildMatch([Group Name],'*aa-wt*','*aa-wp*'),1,0) as _ProductFlag"

[DavidM · Accepted solution]

For product with name 'Bucket' or group names containing strings aa-wt, aa-wp (characters can be in front, or behind that string) the ProductFlag is set 1, for all others it is set to 0

[Architect]

Hi  David,

Thanks for the reply. Is there any other way to represent the same logic in code.

As I am facing some Bug while working with this line of code.

[DavidM]

Can you describe the mistake? As the code seems to be ok.

You can use nested if for example:

if([Product Name] = 'Bucket',1,

  if(WildMatch([Group Name],'*aa-wt*','*aa-wp*'),1,0)) as _ProductFlag