SQL Query with Tag Reference in Embedded List

[justinoj]

Hi Experts, 

I'm looking for adding direct tag reference inside SQL query used in Embedded Lists. The aim is to place the embedded list inside template and instances can have queries 'relative to its area'. 

In the below embedded query WHERE condition, can I have a tag/variable reference which is relative? Something like CONCAT(%M(..FullName), '.%') which doesn't work.

SELECT TOP(100)
"RecordId", "SeverityDesc" AS "~SeverityDesc", "RecordTime" AS "~RecordTime", "Source", "Message", "User", "Category", "Foreground", "SeqNo", "CommentNo"
FROM
CDBEVENTJOURNAL
WHERE
"Source" LIKE CONCAT(%M(..FullName), '.%')

Thanks in advance,

Justin

[AdamWoodland · Accepted solution]

You'll need to do this in the animations not the Query tab, set the sql animation to:

'SELECT TOP(100) "RecordId", "SeverityDesc" AS "~SeverityDesc", "RecordTime" AS "~RecordTime", "Source", "Message", "User", "Category", "Foreground", "SeqNo", "CommentNo" FROM CDBEVENTJOURNAL WHERE "Source" LIKE ''' + "..FullName" + '.%'''

The ''' are three single quotes, two of which will be interpreted as a single quote as part of the SQL syntax, and the last quote will be ending the literal string

[justinoj]

Thanks Adam, that solved the problem.