Another Way to Change the definition of the default Theme42 template

By
As default, the templates of newly created desktop application which subscribes default Theme42 will be locked.  If we open a certain template from shared components \ templates, we will find the description below from subscription section.
This template is subscribed to the corresponding template in the master theme. To modify this template, edit the master template and then refresh the theme. Alternatively you can create a local, unsubscribed copy of this template. Unsubscribed templates are editable and will not get overwritten by a theme refresh.
So there are two recommended ways to modify a template definition.

However, there is another scenario. I want to change the definition of the Standard region template frequently but I don't want to copy out, rename and reassign previous regions to the new template.

Here is a quick solution for this case. Just execute sql below to unlock the subscription.
 
1
2
3
-- give correct application id in line 3
update apex_050100.wwv_flow_page_plug_templates s
   set s.reference_id = null
 where s.flow_id = 200;
After commit and refresh the template definition page, we will find "delete" and "Apply Changes" buttons displaying and the definition of template are editable.
Note: this method is for developing, debugging and testing. Please do not use this on production. Because it's risky to modify app's metadata.
After developing, debugging and testing, we might need to re-subscribe the template to theme42 or might not. If need, we can execute update statement below and commit to restore the data.
 
1
2
3
4
5
6
7
-- adjust proper interval for flashback in line 4
update apex_050100.wwv_flow_page_plug_templates r
   set (reference_id, template) =
       (select reference_id, template
          from apex_050100.wwv_flow_page_plug_templates as of timestamp(systimestamp - interval '50' minute) t1
         where t1.flow_id = r.flow_id
           and r.id = t1.id)
 where r.flow_id = 200
We also can do the same operation to other tables for other components, like page, report if need.

Comments

Post a Comment

Popular posts from this blog

Note for APEX 5.1 UI, Theme, Templates and Substitution Strings

By
Image
From application shared components, User Interface section, we can get the hierarchy diagram as below.  Source SVG There are three levels, User Interface, Theme, and Template. UI attributes specify user interface options, including application level logo, favicon, user interface detection (especially application level CSS files for screen auto-detection ) and current theme Theme as a collection of templates, include theme level JavaScript, CSS, icons, image, skin style, and other static files serving current theme, component default template assignment, region default template assignment, and global template options (references between CSS classes and global style options, i.e. Button type option: tiny, Small or large) Template:  Major template types include page, region, report, button, breadcrumb, list and label (with yellow background color) Theme42 also includes templates for Legacy Calendar and Popup LOV as default but I don't draw in the diagram N...
Keep reading

RDS Customizable for APEX 5.1

By
Image
Background Is there a way to set a parent for regions that allocated or assigned to Region Display Selector, especially when there are multiple RDSes in one page? This is the first question when I used RDS in APEX 5.1. I think this is a common question after you find there is a Yes/No option for RDS without a parent node. Then I posted this question to Steven's Blog . er, Yes, I did. It's an old post but Steven still replied and re-posted my question to his twitter after checking with his team. How professional! And then I got the answer is no. No default or original way but the workaround with template or region type. Then I found the plugin RDS Customizable  (link is original design with version 1.1 ). It's for APEX 4+. I used it on APEX 5.1 and found there are some slight bugs. Now I renew it to work gracefully with 5.1 and update source code to github folder . region_type_plugin_com_blogspot_apexnotes_apex_rds_customizable_V1.2.sql : plugin v1.2 source code ...
Keep reading

Use Plugin Code Editor - Part 1/4: Demo

By
Image
If you want to use Code Editor plugin in Oracle APEX internal applications, you need 6 steps below to make it happen from scratch. get an application with f4000 theme (see  Use Theme: APEX 5.0 ) import f4000 to your APEX and export plugin "Code Editor" create test pages using Code Editor detect and add missed CSS and JavaScript files grant corresponding privilege to application parsing schema check issues and fix rock and roll Note: Here using internal Theme APEX5.0 is not mandatory but it's helpful from scratch. Now, you could jump over these steps,  import my demo applications and start you work with Code Editor. Demo If you find page loading without GIFs, please click HD GIFs link below (Due to the GIF size, it will take a while to load.): Native Hybrid Migrated Native Main features: theme APEX 5.0 supported all item type Code Editor plugins with 9 supported code modes with 11 items based on supported modes (PL/SQL Expression and Fun...
Keep reading