# Dynamic easy chart "dataset" vs "where clause"

**URL:** <https://forum.inductiveautomation.com/t/dynamic-easy-chart-dataset-vs-where-clause/30588>\
**Category:** Ignition\
**Tags:** ignition80\
**Created:** [December 10, 2019, 11:45pm UTC](https://forum.inductiveautomation.com/t/dynamic-easy-chart-dataset-vs-where-clause/30588 "2019-12-10T23:45:54Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![tom.ha](https://avatars.discourse-cdn.com/v4/letter/t/8491ac/32.png) [@tom.ha](https://forum.inductiveautomation.com/u/tom.ha)\
**Post date:** [December 10, 2019, 11:45pm UTC](https://forum.inductiveautomation.com/t/dynamic-easy-chart-dataset-vs-where-clause/30588/1 "2019-12-10T23:45:54Z")

</div>

Hi ,

I learn easy chart ignition 8.0 on inductive university, they mention about indirect easy chart, or dynamic chart. But in IGNITION 8.05, I looked for “dataset” in properties editor of easy chart, it was changed to “where clause”. Could you explain how to create dynamic chart with where clause.

Thanks

---

<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:** [December 11, 2019, 1:26pm UTC](https://forum.inductiveautomation.com/t/dynamic-easy-chart-dataset-vs-where-clause/30588/2 "2019-12-11T13:26:05Z")

</div>

Use a database pen. The details of those are kept in the component in the `pens` dataset property. One of those details is the Where Clause. You can manipulate that `pens` property to add/remove/change what is displayed.

---

<div class="post-metadata">

**Author:** ![tom.ha](https://avatars.discourse-cdn.com/v4/letter/t/8491ac/32.png) [@tom.ha](https://forum.inductiveautomation.com/u/tom.ha)\
**Post date:** [December 11, 2019, 2:38pm UTC](https://forum.inductiveautomation.com/t/dynamic-easy-chart-dataset-vs-where-clause/30588/3 "2019-12-11T14:38:17Z")

</div>

Thank you pturmel

Can you give me a small detail sample how to do it?

Datapens in easy chart customizer?

---

<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:** [December 11, 2019, 4:11pm UTC](https://forum.inductiveautomation.com/t/dynamic-easy-chart-dataset-vs-where-clause/30588/4 "2019-12-11T16:11:41Z")

</div>

The following is an example for manipulating Tag Historian pens (the `tagPens` dataset instead of the `pens` dataset), but the same operations are used (slightly different set of columns).

> [@EasyChart: Working with Datasets (Python)](http://forum.inductiveautomation.com/t/easychart-working-with-datasets-python/9668):
>
> Objective: To add Tag Pens to Easy Chart through scripting. EasyChart seems to use DataSets to store the Tag Pens that are displayed on the chart. The DataSet includes a number of columns that store the configuration of the Tag being charted (i.e. Name, Tag\_Path, Color…). Question: How do you add a new row through event scripts to this DataSet to add a new Tag Pen to the EasyChart?

---

<div class="post-metadata">

**Author:** ![tom.ha](https://avatars.discourse-cdn.com/v4/letter/t/8491ac/32.png) [@tom.ha](https://forum.inductiveautomation.com/u/tom.ha)\
**Post date:** [December 11, 2019, 4:32pm UTC](https://forum.inductiveautomation.com/t/dynamic-easy-chart-dataset-vs-where-clause/30588/5 "2019-12-11T16:32:18Z")

</div>

![Capture](https://us1.discourse-cdn.com/inductiveautomation/original/2X/c/cf447c80992b4e46a003f9feed9239af2e0e5542.png)

I do not see dataset, or tagpen in my version

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [December 11, 2019, 5:16pm UTC](https://forum.inductiveautomation.com/t/dynamic-easy-chart-dataset-vs-where-clause/30588/6 "2019-12-11T17:16:59Z")

</div>

Change the property filter to ALL:

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/2X/5/5fac517b95a544bbed629c3c7277c0cf689e2ece.png)

---

<div class="post-metadata">

**Author:** ![tom.ha](https://avatars.discourse-cdn.com/v4/letter/t/8491ac/32.png) [@tom.ha](https://forum.inductiveautomation.com/u/tom.ha)\
**Post date:** [December 11, 2019, 6:18pm UTC](https://forum.inductiveautomation.com/t/dynamic-easy-chart-dataset-vs-where-clause/30588/7 "2019-12-11T18:18:21Z")

</div>

Thank for help. I got it 🙂