1 Reply Latest reply on Oct 17, 2017 2:00 PM by deeps

    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