# How to query internal dataset?

**URL:** <https://forum.inductiveautomation.com/t/how-to-query-internal-dataset/56575>\
**Category:** Ignition\
**Created:** [February 25, 2022, 3:22pm UTC](https://forum.inductiveautomation.com/t/how-to-query-internal-dataset/56575 "2022-02-25T15:22:59Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![hewking32](https://avatars.discourse-cdn.com/v4/letter/h/b5ac83/32.png) [@hewking32](https://forum.inductiveautomation.com/u/hewking32)\
**Post date:** [February 25, 2022, 3:22pm UTC](https://forum.inductiveautomation.com/t/how-to-query-internal-dataset/56575/1 "2022-02-25T15:22:59Z")

</div>

hi  
I hope somebody already solved that problem 🙂  
I have a dataset memory tag which i would like to use to query but I don’t know how.  
As i understand system.db.query(SQLQuery) is only for external tables - is it right?  
Regards

---

<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:** [February 25, 2022, 3:26pm UTC](https://forum.inductiveautomation.com/t/how-to-query-internal-dataset/56575/2 "2022-02-25T15:26:57Z")

</div>

You are in luck! Long ago, I needed this and created a module that includes it. The “SQL” is more of a pythonic pseudo-SQL, but looks an awful lot like regular SQL for most cases:

[Simulation Aids](https://inductiveautomation.com/moduleshowcase/module/automation-professionals-llc-simulation-aids)

Use the [view() expression function](https://www.automation-pros.com/simaids/doc/expression.view.html).

Don’t let “Buy this module” discourage you – it is **free**.

---

<div class="post-metadata">

**Author:** ![hewking32](https://avatars.discourse-cdn.com/v4/letter/h/b5ac83/32.png) [@hewking32](https://forum.inductiveautomation.com/u/hewking32)\
**Post date:** [February 25, 2022, 3:30pm UTC](https://forum.inductiveautomation.com/t/how-to-query-internal-dataset/56575/3 "2022-02-25T15:30:02Z")

</div>

thanks again Phil you are very helpful
