Sign Up

Hey, Dev!
Are you looking for a forum full of active developers to help you?
So if you want to:
➡️ Get answers for your development issues
➡️ Help others
➡️ Write an article
➡️ Get rewarded for your active participation
Then this place is just for you and it is 100% FREE.

Have an account? Sign In


Have an account? Sign In Now

Sign In

Forgot Password?

Don't have account, Sign Up Here

Forgot Password

Lost your password? Please enter your email address. You will receive a link and will create a new password via email.

Have an account? Sign In Now

Sorry, you do not have a permission to ask a question, You must login to ask question.

Forgot Password?

Need An Account, Sign Up Here
Sign InSign Up

OrclQA.Com

OrclQA.Com Logo OrclQA.Com Logo
Search
Ask A Question

Mobile menu

Close
Ask a Question
  • Home
  • Blog
  • New Questions
  • Tutorials
    • Oracle
    • Oracle Apex
    • Python
  • Tags
  • Users
  • Badges & Points
  • About
Home/Questions/Q 2792
In Process
amrit
amrit

amrit

  • 2 Questions
  • 1 Answer
  • 0 Best Answers
  • 32 Points
View Profile
  • 1
amritContributor
Asked: October 30, 20202020-10-30T21:37:09+05:30 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
  • 52
  • 0
  • 0
  • Share
    • Share on Facebook
    • Share on Twitter
Answer

    2 Answers

    1. Vinish

      Vinish

      • 1 Question
      • 473 Answers
      • 46 Best Answers
      • 2k Points
      View Profile
      Vinish Legendary
      2020-10-31T06:23:34+05:30Added an answer on October 31, 2020 at 6:23 am

      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
      • Share
        Share
        • Share on Facebook
        • Share on Twitter
    2. amrit

      amrit

      • 2 Questions
      • 1 Answer
      • 0 Best Answers
      • 32 Points
      View Profile
      amrit Contributor
      2020-10-31T10:36:45+05:30Added an answer on October 31, 2020 at 10:36 am

      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
      • Share
        Share
        • Share on Facebook
        • Share on Twitter

    You must login to add an answer.

    Forgot Password?

    Sidebar

    Ask Question
    Write a Post
    • Recent
    • Answers
    • Bheem

      How to deploy oracle apex app in oracle SaaS

      • 0 Answers
    • Rameez Tariq

      How to create View with Blob column through DBLINK

      • 0 Answers
    • Huy Nguyen

      Dynamic action on column on Interactive Grid

      • 3 Answers
    • GudDud

      Load PDF into APEX, Edit it and Print it.

      • 0 Answers
    • Huy Nguyen
      Huy Nguyen added an answer Thank you for your good idea. March 5, 2021 at 12:09 pm
    • Vinish
      Vinish added an answer Oh, this will work for only new rows. For existing… March 5, 2021 at 11:22 am
    • Vinish
      Vinish added an answer I think you do not need to create the dynamic… March 5, 2021 at 11:14 am
    • Vinish
      Vinish added an answer Are you converting your CLOB to varchar2 in the report?… March 5, 2021 at 6:56 am
    • Vinish
      Vinish added an answer You can reduce the number of column span for the… March 4, 2021 at 7:53 am

    Recent Blog Posts

    • Vinish

      Oracle Apex - Display External File in Region

    • Vinish

      Oracle PL/SQL Download BLOB File to Disk

    • Vinish

      Oracle Convert External File to BLOB

    • Vinish

      Oracle Apex Calendar Example

    • Vinish

      Oracle Apex - Open Modal Dialog Page Using JavaScript

    Explore

    • Home
    • Blog
    • New Questions
    • Tutorials
      • Oracle
      • Oracle Apex
      • Python
    • Tags
    • Users
    • Badges & Points
    • About

    © 2021 OrclQA.Com. All Rights Reserved. Privacy Policy