# Custom where clause in Transaction Group

**URL:** <https://forum.inductiveautomation.com/t/custom-where-clause-in-transaction-group/16548>\
**Category:** Ignition\
**Tags:** ignition78\
**Created:** [January 10, 2018, 5:10pm UTC](https://forum.inductiveautomation.com/t/custom-where-clause-in-transaction-group/16548 "2018-01-10T17:10:32Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Peter.Dmitriev](https://avatars.discourse-cdn.com/v4/letter/p/7ea924/32.png) [@Peter.Dmitriev](https://forum.inductiveautomation.com/u/Peter.Dmitriev)\
**Post date:** [January 10, 2018, 5:10pm UTC](https://forum.inductiveautomation.com/t/custom-where-clause-in-transaction-group/16548/1 "2018-01-10T17:10:32Z")

</div>

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:  
 ![](https://us1.discourse-cdn.com/inductiveautomation/original/2X/7/79de4ca512af855f5edd1116bc5ec4ee68091b0d.PNG)

This doesn’t work:  
 ![](https://us1.discourse-cdn.com/inductiveautomation/original/2X/a/abafe166f3cedfc1032068172663787490e10f19.PNG)  
 ![](https://us1.discourse-cdn.com/inductiveautomation/original/2X/d/d3c85bf5865010bd00d5b59317f7f437bfc9c032.PNG)

Can anybody advise on what am I doing wrong?

Thank you.

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [January 10, 2018, 6:01pm UTC](https://forum.inductiveautomation.com/t/custom-where-clause-in-transaction-group/16548/2 "2018-01-10T18:01:40Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Peter.Dmitriev](https://avatars.discourse-cdn.com/v4/letter/p/7ea924/32.png) [@Peter.Dmitriev](https://forum.inductiveautomation.com/u/Peter.Dmitriev)\
**Post date:** [January 10, 2018, 6:14pm UTC](https://forum.inductiveautomation.com/t/custom-where-clause-in-transaction-group/16548/3 "2018-01-10T18:14:44Z")

</div>

That was it.

Thank you, Phil!