Inline Dialog Refresh before opening

2 Answers

1. 

   

   Vinish

   • 1 Question
   • 733 Answers
   • 63 Best Answers
   • 4k 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

     • Lahore, Pakistan

     • 20 Questions
     • 23 Answers
     • 0 Best Answers
     • 201 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