APEX-PLUGIN.COM

..the apex plugin directory

an initiative of

Add your APEX Plugin info

Describe your Plugin’s features. You can upload the Plugin’s code and documentation, or, alternatively, submit the URLs to your Website, GitHup Repository or Blog.

You are here:
Follow us on Twitter
Process Type Plugin Quality Assurance

Quality Assurance

0

enhance the quality of developing APEX

With that Plugin you can define Rules based on SQL Queries, which check your Application.
These Rules can use the APEX Repository (APEX Views) to check Items, Regions, Dynamic Actions and every other object can be accessed in your database.

Further on you can also define rules based on your Table Content or based on the Oracle Metadata tables like user_objects.

The Region Plugin can be placed on any page in your APEX Application. The best Page to place the plugin is on the Global Page. Then the Plugin checks on every Page which is run your rule and prints out all objects which are in conflict with your rules.

Equal to the Advisor you can directly use a link to edit the APEX Element and solve the problem.

This Beta Release is combined to the presentation on KScope 2014.

Further information and a demo Case will be given in summer 2014 after the conference.

 

Installation of the Plugin:

Go into the APEX Workspace, where you like to install the Plugin and import the /APEX/region_type_plugin_com_mtag_olemm_qa_region.sql file as an Region Plugin.

Afterwards go into your SQL-Tool or into the SQL Workshop and install the database objects.

Use the Script 

plugin_qa_install.sql

to install the Objects.

At last you can import some demo rules which are included in the file

/DML/plugin_qa_rules.sql

 

Run the Plugin:

Go to your application and choose a page where you would like to run the checks. It's recommed to use the Global Page, for checking every Page and add a Region -> Plugin -> Quality Assurance - Region to this page.

It's also recommed to use a condition, that only developers can see the region. Use this PL/SQL Condition

 

APEX_Application.g_edit_cookie_session_id IS NOT NULL
then only People who are logged in into the APEX Workspace can see this region.
Special Requirements
The Plugin Release 0.2 requires at least APEX 4.1 to run.

Keywords
QA Plugin,Quality Assurance,Region Plugin,APEX Repository,Rules,Check

Oracle APEX Plugin
Company: MT-AG
Date added: 16.6.2014
Views: 6439
Votes: 0
Reviews: 0
Min. APEX Version:
4.1
Share on Facebook
Digg! Share on Digg
Save This Page
Link to:
Download
download apex plugin
If something is not correct please report it here: Report Listing
Do you have a question about this Plugin? Want to write a Review or Comment?
Login first.
Reviews / Questions / Comments are e-mailed to the author of the Plug-in.
Powered by Sigsiu.NET RSS Feeds

Disclaimer: The APEX Plugins on this site are not supported by Oracle Support Services.

If you have a question about a Plugin or need support: Login and select the plugin detail page. At the bottom you can enter your Question / Review / Remark.
Your message will be sent to the author of the plugin.