Unable to select all values in default selection of dashboard prompt

Chandranshu Bhardwaj

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

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 .