Visual Builder

Get Involved. Join the Conversation.

Topic

    Venkata P
    How to get table data on click of a button and update some...Answered
    Topic posted October 17, 2019 by Venkata PGreen Ribbon: 100+ Points, tagged Custom Code, JET, Layout, UI, Web 
    26 Views, 3 Comments
    Title:
    How to get table data on click of a button and update some columns in another table
    Summary:
    Get table data on click of a button and update some columns in another table
    Content:

    Hi All,

    I have the below requirement,

    1. I have a BC with name parameters and it is displayed in table with another new columns which are not part of BC fields as below

    • Name
    • Id
    • Type
    • Remarks --> This is a input text column which is not part of BC fields

    2. Now user will update multiple rows in the remarks column and click on save button on the bottom of the table

    3. Now these remarks should be updated to another BC named RemarkDetails with the remarks data inserted into it. Remarks details has below columns

    • Id
    • ParameterReportID --> This is same as ID in parameters BC
    • Remarks -> This is entered by user in the UI table 

    Ask is to how I can capture the table data in the webpage into a variable and loop over it and insert remarks into another BC ? 

    Thanks in Advance !!!

    Regards,

    Venkat P

     

     

      

     

     

    Version:
    19.3.1.2

    Best Comment

    Shay Shmeltzer

    This sounds like an editable table scenario, where the save button will call the insert (POST) operation on another BO.

    This blog should give you the starting point for this - you just need to switch the save button to call the REST API of another BO.

    https://blogs.oracle.com/vbcs/editable-tables-in-visual-builder-the-oracle-jet-6-way

    Comment