# Retrieve a subset of a dataset tag

**URL:** <https://forum.inductiveautomation.com/t/retrieve-a-subset-of-a-dataset-tag/12182>\
**Category:** Ignition\
**Created:** [September 28, 2016, 2:38pm UTC](https://forum.inductiveautomation.com/t/retrieve-a-subset-of-a-dataset-tag/12182 "2016-09-28T14:38:23Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Lonewulfe](https://avatars.discourse-cdn.com/v4/letter/l/e68b1a/32.png) [@Lonewulfe](https://forum.inductiveautomation.com/u/Lonewulfe)\
**Post date:** [September 28, 2016, 2:38pm UTC](https://forum.inductiveautomation.com/t/retrieve-a-subset-of-a-dataset-tag/12182/1 "2016-09-28T14:38:23Z")

</div>

The project I am developing has multiple screens that use the same base query but filter it based upon a variable(s) specific to the screen (Used in the where statement).

I thought about using a dataset tag for the base query and then trying to run a query off the tag. This would greatly reduce the number of queries hitting the database connection.

I have looked at the lookup function but this only returns one object.

Is it possible to grab a subset of a dataset tag?

---

<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:** [September 28, 2016, 2:53pm UTC](https://forum.inductiveautomation.com/t/retrieve-a-subset-of-a-dataset-tag/12182/2 "2016-09-28T14:53:00Z")

</div>

Yes, with the help of the Simulation Aids module, available [here](https://www.automation-pros.com/modulesales.html). You would use the [view()](https://www.automation-pros.com/simaids/doc/expression.view.html) expression function to reduce one dataset into another using its pseudo-SQL syntax.

---

<div class="post-metadata">

**Author:** ![Lonewulfe](https://avatars.discourse-cdn.com/v4/letter/l/e68b1a/32.png) [@Lonewulfe](https://forum.inductiveautomation.com/u/Lonewulfe)\
**Post date:** [September 28, 2016, 3:05pm UTC](https://forum.inductiveautomation.com/t/retrieve-a-subset-of-a-dataset-tag/12182/3 "2016-09-28T15:05:06Z")

</div>

thank you for your help. I attempted to download it but unfortunately the download link isnt working (states the page cannot be found). I have emailed their support for a resolution. As soon as I can get it downloaded and tested, I will mark this as complete.

---

<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:** [September 28, 2016, 3:15pm UTC](https://forum.inductiveautomation.com/t/retrieve-a-subset-of-a-dataset-tag/12182/4 "2016-09-28T15:15:52Z")

</div>

[quote=“Lonewulfe”]I attempted to download it but unfortunately the download link isnt working (states the page cannot be found). I have emailed their support for a resolution.[/quote]That would be me. (-: Link fixed.