# Easy Chart Database Pens use where clause with vision client tag or Root Container.Text Field.text

**URL:** <https://forum.inductiveautomation.com/t/easy-chart-database-pens-use-where-clause-with-vision-client-tag-or-root-container-text-field-text/78430>\
**Category:** Ignition\
**Tags:** ignition81, vision\
**Created:** [August 27, 2023, 6:44pm UTC](https://forum.inductiveautomation.com/t/easy-chart-database-pens-use-where-clause-with-vision-client-tag-or-root-container-text-field-text/78430 "2023-08-27T18:44:27Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![phuong.nguyen.sw](https://avatars.discourse-cdn.com/v4/letter/p/9de053/32.png) [@phuong.nguyen.sw](https://forum.inductiveautomation.com/u/phuong.nguyen.sw)\
**Post date:** [August 27, 2023, 6:44pm UTC](https://forum.inductiveautomation.com/t/easy-chart-database-pens-use-where-clause-with-vision-client-tag-or-root-container-text-field-text/78430/1 "2023-08-27T18:44:27Z")

</div>

Hi,  
I am trying create Easy Chart with Database pens, and I want to use Where Clause:  
BatchID = '[client]Batch/batchID\_Chart' (this is vision client tag) which I bind it to a Text Field data text, when I ran the chart filled Text field with batch ID number but it did not return any data nor any error then I try a different way that is BatchID = '{Root Container.Text Field.text}' but it did not return any data nor any error neither . I upload both configuration pictures which I try to create. Is it possible to use vision client tag or Root Container.Text Field.text for Where clause in Easy Chart? Please help.

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/4/b/4b0828fe47bf1cff1768855d20b958eb01972bed.png)

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/8/4/844ba5b6a8b718cdb60bf6eed6279180f75ad3df.png)

---

<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:** [August 27, 2023, 7:03pm UTC](https://forum.inductiveautomation.com/t/easy-chart-database-pens-use-where-clause-with-vision-client-tag-or-root-container-text-field-text/78430/2 "2023-08-27T19:03:00Z")

</div>

Not directly, no.

But you can use a custom property with an expression binding to construct the complete string for the where clause, then use a cell update binding on the `pens` property to make the chart use that string on the target pen.

---

<div class="post-metadata">

**Author:** ![phuong.nguyen.sw](https://avatars.discourse-cdn.com/v4/letter/p/9de053/32.png) [@phuong.nguyen.sw](https://forum.inductiveautomation.com/u/phuong.nguyen.sw)\
**Post date:** [August 27, 2023, 8:25pm UTC](https://forum.inductiveautomation.com/t/easy-chart-database-pens-use-where-clause-with-vision-client-tag-or-root-container-text-field-text/78430/3 "2023-08-27T20:25:30Z")

</div>

Can you make an example of that? I am not sure how to do that.  
Thanks