Hello DOJO
We have more than 100 dashboards identical to create.
Each dashboard is available for one user.
The difference betwwen each dashboard is based on the name of the user on rows of tables
Many queries inside the dashboard have a filter with a contains clause.
We are trying to have just one dashboard model, duplicate it and feed the queries with a specific variable depending on the name of the user.
The user must not be able to change the feed of the queries
Text input seems OK to provide a text to the query, but it is editable.
Is it possible to use a variable with a fixed value defined when the dashboard is created or duplicated and not configurable by the user?
I answer to myself.
I managed to make the App model.
I created a new query, filtered by client name.
Then I used column manipulation with a top 1 to keep only one row.
I selected just the name column.
I applied this query on a dropdown component.
The dropdown has just one row.
Finally I filtered all my queries with the dropdown feed.
it's OK but my question is still asked, is there a more "elegant" solution with something like a variable ?
Hi Joel,
In 10.4.12 we introduced something called 'Variables' in both Dashboards and Low-Code apps. This seems to be exactly what you want. You can find some more info here: Docs