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.