I have a data set with a description and unique identifier. I need to create a parameter that uses this data set to show the user a dropdown of the description, but uses the unique identifier as the value passed to filter.
example
- status description, status id in the parameter data set,
- main data to be filtered only has status id
the goal is for the user to pick a status description (in process, complete, on hold) and have that statuses id from the parameter data set be used to filter the main data