# Insert named query into memory dataset column

**URL:** <https://forum.inductiveautomation.com/t/insert-named-query-into-memory-dataset-column/81651>\
**Category:** Ignition\
**Created:** [November 8, 2023, 12:34pm UTC](https://forum.inductiveautomation.com/t/insert-named-query-into-memory-dataset-column/81651 "2023-11-08T12:34:04Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![dcan87](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/dcan87/32/54071_2.png) [@dcan87](https://forum.inductiveautomation.com/u/dcan87)\
**Post date:** [November 8, 2023, 12:34pm UTC](https://forum.inductiveautomation.com/t/insert-named-query-into-memory-dataset-column/81651/1 "2023-11-08T12:34:04Z")

</div>

![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/a/0/a09b98172ef05377a12e4e7289f5e4e27d00913a.png)  
Is there a way to insert a named query into a dataset column cell?

Or should I be doing this another way?

My dataset is called from an indirect binding on a subview table. I want the comments cell to be a query of the latest comment in the db for that machine (SAP).

---

<div class="post-metadata">

**Author:** ![pascal.fragnoud](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pascal.fragnoud/32/24728_2.png) [@pascal.fragnoud](https://forum.inductiveautomation.com/u/pascal.fragnoud)\
**Post date:** [November 8, 2023, 12:38pm UTC](https://forum.inductiveautomation.com/t/insert-named-query-into-memory-dataset-column/81651/2 "2023-11-08T12:38:46Z")

</div>

Where does the rest of the dataset come from ?

---

<div class="post-metadata">

**Author:** ![dcan87](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/dcan87/32/54071_2.png) [@dcan87](https://forum.inductiveautomation.com/u/dcan87)\
**Post date:** [November 8, 2023, 1:04pm UTC](https://forum.inductiveautomation.com/t/insert-named-query-into-memory-dataset-column/81651/3 "2023-11-08T13:04:04Z")

</div>

It lives inside a memory tag dataset.

I am thinking it would be better to build out all my machines into my db table and then just created a filtered name query to bind to the data property of my subview table?

---

<div class="post-metadata">

**Author:** ![pascal.fragnoud](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pascal.fragnoud/32/24728_2.png) [@pascal.fragnoud](https://forum.inductiveautomation.com/u/pascal.fragnoud)\
**Post date:** [November 8, 2023, 1:06pm UTC](https://forum.inductiveautomation.com/t/insert-named-query-into-memory-dataset-column/81651/4 "2023-11-08T13:06:20Z")

</div>

Yes. Put what should be in a database, in a database.  
Then use the machine id to display the pull the relevant data when you need to display it.