# UDT instance creation from SQL table rows

**URL:** <https://forum.inductiveautomation.com/t/udt-instance-creation-from-sql-table-rows/26989>\
**Category:** Ignition\
**Created:** [July 30, 2019, 1:56pm UTC](https://forum.inductiveautomation.com/t/udt-instance-creation-from-sql-table-rows/26989 "2019-07-30T13:56:33Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![wschauer](https://avatars.discourse-cdn.com/v4/letter/w/ecccb3/32.png) [@wschauer](https://forum.inductiveautomation.com/u/wschauer)\
**Post date:** [July 30, 2019, 1:56pm UTC](https://forum.inductiveautomation.com/t/udt-instance-creation-from-sql-table-rows/26989/1 "2019-07-30T13:56:33Z")

</div>

What is the best way to automatically create UDT instances for every row in a given table?  
Essentially I want to have a UDT tag group that mirrors a SQL table where each UDT has elements corresponding to the column names of the table.

I know its possible through scripting to take take in the dataset with a prep query but seems like there may be a simpler more elegant solution that im missing.  
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:** [July 30, 2019, 3:51pm UTC](https://forum.inductiveautomation.com/t/udt-instance-creation-from-sql-table-rows/26989/2 "2019-07-30T15:51:06Z")

</div>

Please provide some context–what exactly are you trying to do? What part(s) of Ignition will be consuming this data?

---

<div class="post-metadata">

**Author:** ![wschauer](https://avatars.discourse-cdn.com/v4/letter/w/ecccb3/32.png) [@wschauer](https://forum.inductiveautomation.com/u/wschauer)\
**Post date:** [July 30, 2019, 4:26pm UTC](https://forum.inductiveautomation.com/t/udt-instance-creation-from-sql-table-rows/26989/3 "2019-07-30T16:26:12Z")

</div>

The plan is to have some containers on a vision window be filled with this data. We are re-creating a board with magnetic tiles that we use to schedule production in ignition.  
We have a sql table which is populated with all open work orders and I am trying to bring each row into a container for use on the vision window. Each row in the table consists of product #, Issue Date… Then users would be able to re-arrange the tiles in depending on work flow on the production floor.