Unable to select all values in default selection of dashboard prompt

Question

Hi,

I have been trying to use SQL query in dashboard prompt. I have used a query for choice list like

SELECT evaluate('Initcap(%1)',TRIM(BOTH ' ' FROM "Core Lease"."Landlord Name")) FROM  "Property" where "Operating Unit Organization"."Operating Unit Country"='Uganda' ORDER BY "Core Lease"."Landlord Name".

The choice list gives the desired vendor names.

But when I use the same query in default selection, only few values gets selected the remaining values remains unchecked.

I can't use All Column values option because I need to use it as Presentation variable

Can anyone let me know if I have to change any specific property or have to do some changes in config files.

Thanks

deeps · Answer

If you use the presentation variable like this in the report filters, you can set the prompt default to None:

And  UPPER("Column Name")  like UPPER('%@{pres_var}{%}%')

See if this helps .