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.
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:
Path '"AssetID":',AssetID,'' is not well-formed.
Ignition Vision version 8.0.16