I want to have a dashboard with templating. The datasource of the dashboad is MSSQL, also known as TQL and the relevant line in the query is this one:
AND GroupName = ‘FullStack’
So the group name is actually a string in the database.
I know want to define a variable $team, so that the user of the dashboard can choose metrics for a specific team by choosing in the dropdown.
My problem is that I did not managed it to use that variable. I’ve tried things like
AND GroupName = $team /* Error here: No such column FullStack*/
AND GroupName = ‘’’$team’’’ /* Empty result where it should not be empty */
So how can I solve this problem?