# SQL error on template dataset using custom property in the where clause

**URL:** <https://forum.inductiveautomation.com/t/sql-error-on-template-dataset-using-custom-property-in-the-where-clause/111287>\
**Category:** Ignition\
**Tags:** vision\
**Created:** [October 8, 2025, 3:22pm UTC](https://forum.inductiveautomation.com/t/sql-error-on-template-dataset-using-custom-property-in-the-where-clause/111287 "2025-10-08T15:22:39Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\
**Post date:** [October 8, 2025, 3:38pm UTC](https://forum.inductiveautomation.com/t/sql-error-on-template-dataset-using-custom-property-in-the-where-clause/111287/2 "2025-10-08T15:38:09Z")

</div>

Tip: rather than format each line of code individually, select the whole block and use the \</\> button. It gives syntax highlighting too. Please see [Wiki - how to post code on this forum](https://forum.inductiveautomation.com/t/wiki-how-to-post-code-on-this-forum/77831).

---

_[View the full topic](https://forum.inductiveautomation.com/t/sql-error-on-template-dataset-using-custom-property-in-the-where-clause/111287)._