I like to show results of some SQL queries in one dashboard. The SQL query fetches one row with one value (e.g. select count(*) from TABLE where-clause).
Can I push the result in the Text widget? If I add the SQL query to Text widget the Text widget remains empty, only a tooltip hover up "Last Value: <result> with DateTimeStamp".
I'd like to see it like this: "Number of dead sessions: <Result-of-SQL-query>".
Is this possible - maybe using of a variable/parameter?
What version of UIM are you using? I think it was 8.1 that introduced a SQL Table Widget that will display the results of your query. If you assign the SQL Query Data Source to the Text Widget, you will need to type $VAR into the text box of the text widget. That will display the value. Or you can enter in the text box "Number of dead sessions: $VAR." and that will work to.
I'm using UIM 8.2.
And yes, that's exactly what I need.
I read the dashboard docs on wiki more than once but I never found a hint. But just when I have read again (after your reply) I found the hint for $VAR.
Thanks a lot