1 Reply Latest reply on Sep 27, 2018 1:00 PM by Thomas Dodds

    How to increase drop down values in BI-publisher parameter/prompt

    3051139

      Hi Team,

      I want to increase the drop down values in BI-Publisher parameters,

      By default we are getting only 1000 values, but our requirement to  get upto 2000+ values.

       

      please suggest is there any config file that we need to update to get a more then 2000+ values in BI-Publisher parameters.

       

       

      Thanks,

      Avin

        • 1. Re: How to increase drop down values in BI-publisher parameter/prompt
          Thomas Dodds

          It's not a requirement - it's a wish.  It's a wish that comes when no one is vetting the capabilities of the system being used.

           

          How many discreet values can you put in an IN clause in SQL?

           

          Oracle chokes:  ORA-01795: maximum number of expressions in a list is 1000

           

          So ... why would you allow users to possible select even 1001 values (which will get sent in the SQL as an IN clause with too many values)? 

           

          Looks like you need a different look at it ... I don't have any details from you to make any other suggestions.