Home/Questions/Q 2792
In Process
amrit
amrit

amrit

View Profile
  • 1
Professional
Asked: 2020-10-30T21:37:09+05:30

Fill Interactive Grid from another table in Oracle Apex

  • 1

Hi,

I have a Sale Invoice page and want to fill IG when user select order number from dropdown and a Dynamic action fill the records into IG from orderItem table. how to achieve this using java script.

Just like fill a Oracle Tabular Form from cursor.

Thanks

igoracle apex

    2 Answers

    1. Vinish

      Vinish

      View Profile
      Enlightened

      You no need to do this using JavaScript, but you can do it using its default feature. Follow these steps:

      Create an interactive grid based on the OrderItem table and specify the where clause as following:

      order_number = :px_yourOrderList

      Add the item px_yourOrderList to items to submit.

      Then create a dynamic action on your OrderNumber drop-down list on the Change event to refresh the IG region.

      Now, whenever the user selects any order, the IG will refresh to show the data for the selected order number.

      • 0
    2. amrit

      amrit

      View Profile
      Professional

      Hi,

      Thanks for your reply. There is some other points how to add records to saleitem table when user submit and there are other columns in saleitem table which are update by user. we just need when create a new sale invoice pick the items list from order table and other value updated by user.

      Thanks

       

       

      • 0

    You must login to add an answer.