Oracle APEX Blogs - Jaydip Bosamiya - Oracle APEX Consultant

Oracle APEX Interactive Report (IR) has rich APIs to tweak, customize or control the user interactions. One of the API package I have recently used is APEX_IR . Purpose of this blog is to show you how you can re-use your IR run-time query and filters to build all custom reports. So, let's define a requirement - You have two regions in a page - First region with summary of Department wise salary total. Second region with all list of employees. Now, when I apply any filters to detail region (which will be IR) then, the data of summary region should also change. Create region 1 - summary region (classic report) with following query select    d.deptno,   d.dname,   sum(e.sal)   from dept d, emp e  where d.deptno = e.deptno    and e.empno in(select c001 from apex_collections where collection_name = 'P16_EMP') group by d.deptno, d.dname order by d.deptno Create region 2 - employee list region (IR) with f...

Oracle APEX 5 introduced a new feature called "Warn on Unsaved Changes" at page, item and button level. This is a great feature by enabling any unsaved changes to ask for user confirmation before leaving the page. Purpose of this blog is, if we have custom form element such as APEX_ITEM on a classic report or IR, will that by-default use this feature? Answer is No. You have to write code for that. I have seen there are several ways people have implemented this using custom code and logic. Now, here I have tried to use one of the APEX's JavaScript library function to achieve this. Following are the steps: 1. Set "Warn on Unsaved Changes = Yes" from page attribute section. 2. Declare a new variable under "Function and Global Variable Declaration" from page attribute section as below var gSerializeValue; 3. Create new dynamic action named "Initialize Warn on Unsaved Changes" as on page load event. 4. Add true action "Exe...

This blog is about how you can control the tab selection using jQuery for Tabs Container region. I have seen, there are many other-ways to achieve same - but I have tried to following APEX's way and manage the selection by APEX's JavaScript code. $('#<tabs_container_region_id> ul.t-Tabs:first').aTabs('getTabs')['#SR_<sub_tab_region_id>'].makeActive(); Working Demo Hope this helps. Regards, Jaydip Bosamiya jbosamiya@gmail.com