Visual Builder

Get Involved. Join the Conversation.

Topic

    Chris Thom
    LOV only returning 25 valuesAnswered
    Topic posted November 4, 2019 by Chris ThomBlue Ribbon: 750+ Points 
    21 Views, 2 Comments
    Title:
    LOV only returning 25 values
    Summary:
    LOV only returning 25 values
    Content:

    I have a LOV in which there could be 30K plus values to select from.  For performance reasons, I created a Business Object in the application and plan to synchronize that BO daily.  In my research, I found that it was recommended to create a Type and Variable at the application level and then populate that vs doing it at the page level (click here).  I followed all of the steps and ran my application, but it is only returning the first 25 rows.  Using the Developer Tools in Chrome, I was able to see where VB is somehow adding in a limit of 25 to the "get" call to populate my application variable.  Any thoughts on A) how to change the limit and B) is this the right way to populate a LOV that has 30K+ possible values?

    Chris

    Version:
    19.1.3

    Best Comment

    Shay Shmeltzer

    There is a limit parameter that you can pass in the call to the REST service endpoint of your BO - and you can have it set to higher than 25.

    That being said, I'm not sure I would suggest fetching 30K records into the client - even if it is fetched just one time.

    In a case like that you are better off using the default behavior of the LOV created on BOs - where we fetch 15 values into the list and allow you to type other values, which then creates a query that will bring those values to the LOV.

     

    Comment

     

    • Shay Shmeltzer

      There is a limit parameter that you can pass in the call to the REST service endpoint of your BO - and you can have it set to higher than 25.

      That being said, I'm not sure I would suggest fetching 30K records into the client - even if it is fetched just one time.

      In a case like that you are better off using the default behavior of the LOV created on BOs - where we fetch 15 values into the list and allow you to type other values, which then creates a query that will bring those values to the LOV.

       

    • Chris Thom

      Per your suggestion, I just used the endpoint for my BO as the source for the select list.  I'm then able to use the filtering option to limit the rows.

      Thanks - Chris