SQL Tags query

Ignition
1

I have setup a SQLtag with a SQL Query as the expression mode. I cannot get the query to evaluate to anything other than null.

SELECT top(1) ActiveUserLogin
FROM DBName.dbo.Operators
WHERE (Operators.OperatorLocation = 1)

The query returns the expected value in the sql managment studio but sets the sqltag value to null.
Any ideas?
Thanks,
Chad

2

You need to specify a default database connection to run your SQL query through in the SQLTags Realtime Provider. Log in to the Ignition Gateway Configuration web page. Select SQLTags > Realtime and the left hand side. Edit your provider (probably default) and choose a default database. Press Save and your query should work.