# Template canvas dataset provided by SQL

**URL:** <https://forum.inductiveautomation.com/t/template-canvas-dataset-provided-by-sql/110869>\
**Category:** Ignition\
**Tags:** ignition81, vision\
**Created:** [September 23, 2025, 9:11am UTC](https://forum.inductiveautomation.com/t/template-canvas-dataset-provided-by-sql/110869 "2025-09-23T09:11:23Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Matej\_Joob](https://avatars.discourse-cdn.com/v4/letter/m/ba9def/32.png) [@Matej\_Joob](https://forum.inductiveautomation.com/u/Matej_Joob)\
**Post date:** [September 23, 2025, 9:11am UTC](https://forum.inductiveautomation.com/t/template-canvas-dataset-provided-by-sql/110869/1 "2025-09-23T09:11:23Z")

</div>

Hello dear colleagues,

I’m trying to create a versatile menu, containing few buttons (mainly for opening pop-ups). The list of buttons which are displayed is controlled by simple stored procedure and the result is dataset which is then utilized by _Template canvas_ to display only desired buttons.

However, I can’t figure out how to make these buttons to read tags and other information for specific machines. If I use _SQL Query_ as _Property Binding_, the menu displays correct buttons, but these are basically dysfunctional, since they cannot utilize data provided by UDT for a specific machine. If I use Cell Update and link the correct _Property_ as a _Value_ for each row, it works just fine in terms of being linked to a particular machine-apart from the fact that the dataset is static, not dynamically generated by a stored procedure. The only way is to use _SQL Query_ option as a source of data then.

I understand that the _Parameters_ column in the dataset needs to be provided with data in a dictionary format, so I made sure that this condition is met and set this value directly in the source table in SQL (e.g. _{TagFolderName:ShiftInfoCL.tplcnv\_PL.TagFolderNameParamString}_). However, when provided by SQL Query, Ignition seems to be using this value as a static, not as a link to specific object property.

Is there any way how to provide dataset from SQL and simultaneously make the data in _Parameters_ column dynamic?

Thank you very much for any guidance or inspirational ideas!

---

<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 23, 2025, 11:39am UTC](https://forum.inductiveautomation.com/t/template-canvas-dataset-provided-by-sql/110869/2 "2025-09-23T11:39:20Z")

</div>

> [@Matej\_Joob](#):
>
> Ignition seems to be using this value as a static

Correct. You cannot pass live tags. You must design your templates to accept a string tagpath parameter, and use indirect binding within the templates.

(Yes, IU shows the use of UDT parameters in templates. Don't do it.)