Is it possible to use multiple $VAR in one and the same Text widget?
Example with an SQL data source,
select message from nas_alarmswhere origin = 'myOrigin'
select message from nas_alarms
where origin = 'myOrigin'
This can give me several results, and by only using one $VAR it gives me [object Object] in the text widget.
I don't believe this is possible. By setting $VAR, the Text widget is expecting a single a value to display as variable. You need to set an SQL query that does not return multiple rows. The SQL Table widget can display the output of multiple rows returned by a SQL datasource.