In this article, we will explore how to default input parameters with multiple values from the LOV. First, the multiple input values check box should be turned on to work.
If we have a single default value, we can directly enter that default value on the parameters screen on the data model.
Default will show up like below:
However if we want to default two values from the dropdown, then we can’t simply put AU Annual Leave,AU Personal Leave as it doesn’t work.
We have to put it as “AU Annual Leave”,”AU Personal Leave” to make it work.
The values must be imputed in double quotation marks for varchar characters and separated by a comma.
Output will look like:
Hope this helps.
