Using Embedded lists in templates

[krishnaprasad68]

I am trying to include Embedded lists in a SCADA template. When ever i try to include the SQL query as animation it is showing the following error...." The following tags are invalid: '%.Comms.Hreg.Input%' " .
The query iam trying to use is as folllows 'SELECT "FullName" AS "~FullName", "Id", "Foreground", "Blink", "Background", "TypeDesc", "MemoryUsage" FROM CDBPOINT WHERE "FullName" LIKE ''' + "%.Comms.Hreg.Input%" +''' '.
Can any one suggest where i am going wrong ?

[sbeadle · Accepted solution]

Hi,

I think your % wildcards need to be in the string of the query:

'SELECT "FullName" AS "~FullName", "Id", "Foreground", "Blink", "Background", "TypeDesc", "MemoryUsage" FROM CDBPOINT WHERE "FullName" LIKE '%'' + ".Comms.Hreg.Input" +'%'' '

I can't tell if your animation property in the database ".Comms.Hreg.Input" is correct.