Populate parameter labels and values by query result

  • 3 May 2022
  • 1 reply

Hi Community,

I don’t think it is currently possible but it would be very helpful if a parameter’s label and value fields could be populated by a query.

Ultimately, what I would like to achieve is to filter on a partition in the underlying database table. However, the partition IDs are actually associated with user-friendly labels which should be shown to the user and then automatically “translated” to the respective (ID) value.

I could of course hardcode this but I’d definitely prefer the dynamic way via query and I am sure that there are use cases where it would be quite tedious to type all the labels and values.

Has anyone else come across this issue or is this not a common use case?



1 reply

Userlevel 2

Hi Beate


Did you try using templated filters?



Alternative, you can create a SQL CROSS JOIN between a catalog table and a particular view to get all possible options to select

Hope it helps!