Queries, parameters and public dashboards

Hello,

We have three pressing issues with our redash public dashboard and hoping that someone could point us in a right direction.

Issue #1.

We ran into some issues with parameters. We have the following query:


SELECT user_id,
       `top_prediction_%`,
       `top_prediction_(text)`,
       datetime(DateTime) AS thedate,
       UserIdNum
FROM query_3
WHERE cast(useridnum as int) = '{{ useridnum }}'
  AND thedate >= '{{ mydate.start }}'
  AND thedate <= datetime('{{ mydate.end }}')
  AND RequestType = '3'

We use it to create a visualization on a dashboard that we publish publicly. However we get this warning:

sharing is currently not supported for dashboards containing queries with text parameters

Where in our query exactly do we have text parameters? We thought that the date parameters are allowed on public dashboards and the useridnum does not seem to be a text parameter.

Issue #2.

We have a number of users and would like to have one public dashboard for all of them, with user ids being in a dropdown list. However, we need somehow restrict this dropdown list so our users can only select their user id with other user ids being greyed out, not shown, or restricted somehow. What is the best way to go about it?

Issue #3

The public dashboard with visualizations from both non-parameters and with parameters queries does not refresh automatically.

Technical details:

  • Redash Version: 10
  • Browser/OS: chrome
  • How did you install Redash: self hosted on AWS