Forum Discussions
I am working on changes to an existing VBCS page in OIC. I have a combo box and the LOV are coming from a ORDS end point. This end point is based on a table in ATP which has around 6000 rows. MY requirement is to show these 6k records in a LOV with Pagination so that user can scroll through the pages and select the data they need.
Can anyone please suggest how to proceed with this. I tried with the combobox one and pulling the data via the ords rest api but i dont get any values in the LOV. The Lov shows values but everything says "Undefined". The same thing works if i use a Fusion rest API.
I have 2 issues as stated above:
1. LOV is displaying all values as undefined using a ORDS Rest API
2. I need to implement pagination on a LOV once #1 above is resolved
I am new to VBCS; so any inputs are greatly appreciated.
Thanks
Sandeep
Hi Sandeep,
If the values are coming as undefined than the mapping of the option-label and option-value to combo-box is incorrect. Kindly check the mapping. In case, the mapping is correct then test your ORDS API using (postman) or (service connection test option) to verify you are receiving the correct data or not.
Regarding 6000 records, Using service data provider as a data source for the combo-box and enabling load-scroll option in combo-box you can achieve that. Initially it will load 25 records. when user scrolls more it will load records accordingly. Another option, You can use array data provider as a data source and in application level VB enter event, you can add all the 6000 records into an ADP variable. for this you need to set limit parameter in your ORDS API to 6000.
Thanks
Apps2fusion Team
Thanks for the inputs. I am able to get the LOV working with Array Data Provider. I was not successful to do the same with Combo-box one. I ended up changing to Select-Single and use ADP for the values.
Hello,
Hope you are doing great!
We hope we were able to help you out with this query and all your questions were cleared, If you have anything to add on, Our team will surely help you out with it.
For now, with your consent, we can close this query.
Thanks & Regards
