Visual Builder

Get Involved. Join the Conversation.

Topic

    Nazeer Anantha
    Editable table with 5k RecordsAnswered
    Topic posted August 28, 2019 by Nazeer AnanthaRed Ribbon: 250+ Points 
    11 Views, 9 Comments
    Title:
    Editable table with 5k Records
    Summary:
    5K or more data in UI with ArrayDataProvider on Editable table
    Content:

    Hi All,

    I have created REST API in OIC, which is being used in VBCS. my REST API can give 5K data or more. 

    how can I show this 5K data in UI with ArrayDataProvider on Editable table?

    Currently, Editable table is working fine with less data(100-200 records) if it is huge data how can I handle.

    Please suggest me a solution. 

    Thanks,

    Nazeer.

    Best Comment

    Shay Shmeltzer

    So start with a read only table that uses SDP - which has built in pagination support (assuming your backend service supports this).

    When they find a row they want to edit, use a pop-up to allow editing it.

    https://blogs.oracle.com/shay/edit-form-in-a-popup-with-oracle-visual-builder

    Comment

     

    • Shay Shmeltzer

      Are you really expecting your end user to edit 5000 rows? Are they expected to scroll through 5K of rows to find the specific ones they want to edit?

      Isn't it more logical to let them first filter and choose a specific set of rows, and only then go and edit that set?

      • Nazeer Anantha

        yes, Shay. I already implemented with Filter criteria 14 fields and made 4 fields are mandatory. it was good. but in yesterday demo end user told not to put any mandatory fields.

        if I won't put any mandatory field on blank search REST API is giving in 5k to 6k records but in VBCS UI it's taking a lot of time and in between one popup is coming to say wait or exit as usual.

        not able to show the 5k records in UI. is there any way to handle.

        Note: any suggestion is fine. scrolling on table or pagination with Editable table, anything is fine.

        Thanks,

        Nazeer.

         

        • Shay Shmeltzer

          To clarify, are you saying that the customer doesn't want mandatory search fields? Or are you saying they want to edit 5K records in one go?

          You can hide the table until they specify some search criteria, and only show it after they filled in the conditions.

          If you are planning on returning many rows, I would suggest trying to paginate the data so you only show x amount of records at a time.

          • Nazeer Anantha

            yes, Customer doesn't want mandatory search fields.

            Can you please tell me, how can I paginate the data. where I should pagination logic. please provide me some sample if possible.

            Thanks,

            Nazeer.

            • Shay Shmeltzer

              If the customer doesn't want mandatory fields - just don't mark them as mandatory and hide the table using oj-bind-if until they fill in some search criteria.

              It doesn't mean they have a use case for editing 5K records.

              • Nazeer Anantha
                ***. Agreed, but customer is expecting to see the full data on blank search. After blank search customer wants to scroll or paginate for edit the rows which customer wants to edit.
                • Shay Shmeltzer

                  So start with a read only table that uses SDP - which has built in pagination support (assuming your backend service supports this).

                  When they find a row they want to edit, use a pop-up to allow editing it.

                  https://blogs.oracle.com/shay/edit-form-in-a-popup-with-oracle-visual-builder

                  • Nazeer Anantha
                    My backend service is from OIC app driven orchestration. I should create a SDP variable on my REST end point. Can this SDP variable used as table data and paginate data?
                    • Shay Shmeltzer

                      If your backend service doesn't have out-of-the-box pagination, SDP won't help.

                      You'll need to create a service that knows how to handle pagination, and you'll then need to write a transform option for the service so SDP will know how to communicate with it.