Custom where clause in Transaction Group

Ignition
1

Hello,

I’m running into issues with AND statement in custom WHERE clause in standard transaction group. Single condition WHERE clause works fine.

This works:

This doesn’t work:

Can anybody advise on what am I doing wrong?

Thank you.

2

What is the data type of the Designator column? If it is a string, you’ll need single quotes around the variable reference.

1 Like
3

That was it.

Thank you, Phil!