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 1910
In Process
Farooq Ahmad
Farooq Ahmad

Farooq Ahmad

  • Lahore, Pakistan
  • 18 Questions
  • 23 Answers
  • 0 Best Answers
  • 190 Points
View Profile
  • 1
Farooq AhmadProfessional
Asked: October 6, 20202020-10-06T23:21:46+05:30 2020-10-06T23:21:46+05:30

Inline Dialog Refresh before opening

  • 1

Hi, Sir How I Do Refresh Inline Dialog Before Refresh ... Refresh DA I Did But Nothing happening.

apexrefresh
  • 2
  • 47
  • 0
  • 0
  • Share
    • Share on Facebook
    • Share on Twitter
Answer

    2 Answers

    1. Vinish

      Vinish

      • 1 Question
      • 547 Answers
      • 53 Best Answers
      • 3k Points
      View Profile
      Vinish Enlightened
      2020-10-07T08:45:31+05:30Added an answer on October 7, 2020 at 8:45 am

      Suppose you have inline dialog having an interactive report filtering its data using page item P13_DEPTNO to show the records for a particular department. To refresh it before opening, follow these steps:

      Assing a static id to your inline dialog, for example, "iDialog".

      Then use the following sequence of JavaScript commands to open and refresh it:

      apex.item('P13_DEPTNO').setValue(30);
      apex.region('iDialog').refresh();
      javascript:openModal('iDialog');
      • 0
      • Share
        Share
        • Share on Facebook
        • Share on Twitter
      • Farooq Ahmad

        Farooq Ahmad

        • Lahore, Pakistan
        • 18 Questions
        • 23 Answers
        • 0 Best Answers
        • 190 Points
        View Profile
        Farooq Ahmad Professional
        2020-10-07T21:20:53+05:30Replied to answer on October 7, 2020 at 9:20 pm
        This answer was edited.

        Thanks sir, great now, my requirements change a little. I have three-page items and one global parameter, and this all combines I pass into one another page item (: P2_QRY) and from that :P2_QRY the inline dialogue will run .... as I changing the parameter of page items :P2_QRY is not updating, and I use the following method. in :P2_QRY default SQL query:

         SELECT || '&GLOBAL_CODE=' || 
        :GLOBAL_CODE ||
        '&PRM1=' || :P2_PRM1 || '&PRM_2=' || :P2_PRM2 ||
        '&PRM_DATE_FROM=' || :P2_DATE_FROM || '&PRM_DATE_TO='
        || :P2_DATE_TO AS D FROM DUAL;

        I hope I explain it well.

        • 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 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