# Dynamic Template Canvas

**URL:** <https://forum.inductiveautomation.com/t/dynamic-template-canvas/39444>\
**Category:** Ignition\
**Created:** [October 6, 2020, 9:08pm UTC](https://forum.inductiveautomation.com/t/dynamic-template-canvas/39444 "2020-10-06T21:08:32Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Tim](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/tim/32/3361_2.png) [@Tim](https://forum.inductiveautomation.com/u/Tim)\
**Post date:** [October 6, 2020, 9:08pm UTC](https://forum.inductiveautomation.com/t/dynamic-template-canvas/39444/1 "2020-10-06T21:08:33Z")

</div>

How can a format a MSSQL query to return the templates dataset for the Template Canvas component?

When I run this in the database query browser I get a valid result. But on the templates property I get an error.

```auto
SELECT AssetName AS 'name',
'Indicator' AS 'template',
CONCAT('{"AssetID":',AssetID,'}') AS 'parameters',
0 AS 'x',
0 AS 'y',
0 AS 'width',
0 AS 'height',
0 AS 'layout',
1 AS 'z'
FROM Table

```

I receive the following error:

```auto
Path '"AssetID":',AssetID,'' is not well-formed.

```

Ignition Vision version 8.0.16