Pretius Nested Reports
Oracle APEX dynamic action plugin v2.0.2 The plugin is dynamic action plugin implementing nested reports within APEX Classic Reports, Interactive Reports and static HTML tables. Scope of data, data appearance and behavior is customizable with the plugin attributes.
Table of Contents
- Features at glance
- Usage guide & Demo application
- Free support
- Become a contributor
- Comercial support
- Known issues
- About Author
- About Pretius
Features at Glance
- Compatible with Classic report, Interactive report and any HTML based table
- Nested report is defined as SQL query
- Nested report data can be limited with value from parent report
- Nesting levels is unlimited
- Data can be rendered with default template (table based) or with custom template (Mustache library)
- Default callback and Default template can be highly customized
- "No data found" attribute should be translatable
- Default template:
- filtering data via columns
- sorting data via columns (db side)
- number of rows
- Plugin events on collapsing and expanding row (default callback)
- Support for Interactive report
- More attributes to customize
src/PRETIUS_APEX_NESTED_REPORTS.sql- the plugin package specification
src/PRETIUS_APEX_NESTED_REPORTS.plb- the plugin package body
src/dynamic_action_plugin_pretius_apex_nested_reports.sql- the plugin installation files for Oracle APEX 5.1 or higher
To successfully install/update the plugin follow those steps:
- Install package
PRETIUS_APEX_NESTED_REPORTSin Oracle APEX Schema owner (ie. via SQL Workshop)
- Install the plugin file
dynamic_action_plugin_pretius_apex_nested_reports.sqlusing Oracle APEX plugin import wizard
- Configure application level componenets of the plugin
Usage guide & Demo application
Example nested report is based on
- Create new application
- Create new page
Classic Reportbased on SQL query
- Create derivied column and configure it as follows:
- Change derivied column
<span class="fa fa-search"></span><span class="DEPTNO" style="display: none">#DEPTNO#</span>
- Change derivied column
- Create new dynamic action and configure it as follows:
Static Container (jQuery Selector)to
- Create true action and configure it as follows:
Pretius Nested Reports [Plug-In]
Affected Elements > Selection Typeto
Affected Elements > Regionto
Classic Reportdefined in step 3.
- (Not required) Adjust the plugin behaviour up to your needs using the plugin attributes
- Save and run page
* SQL Query for step 3
select * from dept
** SQL Query for step 6.ii
select * from emp where deptno = '#DEPTNO#'
Check different plugin configurations and use cases in our Live Demo
Pretius provides free support for the plugins at the GitHub platform. We monitor raised issues, prepare fixes, and answer your questions. However, please note that we deliver the plug-ins free of charge, and therefore we will not always be able to help you immediately.
Interested in better support?
- Become a contributor! We always prioritize the issues raised by our contributors and fix them for free.
- Consider comercial support. Options and benefits are described in the chapter below.
Bug reporting and change requests
Have you found a bug or have an idea of additional features that the plugin could cover? Firstly, please check the Roadmap and Known issues sections. If your case is not on the lists, please open an issue on a GitHub page following these rules:
- issue should contain login credentials to the application at apex.oracle.com where the problem is reproduced;
- issue should include steps to reproduce the case in the demo application;
- issue should contain description about its nature.
If you encounter a problem during the plug-in implementation, please check out our demo application. We do our best to describe each possible use case precisely. If you can not find a solution or your problem is different, contact us: email@example.com.
Become a contributor!
We consider our plugins as genuine open source products, and we encourage you to become a contributor. Help us improve plugins by fixing bugs and developing extra features. Comment one of the opened issues or register a new one, to let others know what you are working on. When you finish, create a new pull request. We will review your code and add the changes to the repository.
By contributing to this repository, you help to build a strong APEX community. We will prioritize any issues raised by you in this and any other plugins.
We are happy to share our experience for free, but we also realize that sometimes response time, quick implementation, SLA, and instant release for the latest version are crucial. That’s why if you need extended support for our plug-ins, please contact us at firstname.lastname@example.org. We offer:
- enterprise-level assistance;
- support in plug-ins implementation and utilization;
- dedicated contact channel to our developers;
- SLA at the level your organization require;
- priority update to next APEX releases and features listed in the roadmap.
PL/SQLfix to multiple columns value placeholders by @darshanputtaswamy #16
ORA-06502: PL/SQL: numeric or value errorby @rimblas #7
sizemethod removed in favor for
lengthproperty - compatibility for APEX 18+
2.0.0 / 2.0.1
JSHighlighting nested reports no longer embeds CSS rules within DOM as <style></style> tag
JSDefault callback supports special events that can be triggered using anchor with special classes (refresh, expand all, collapse, collapse all)
JSThe plugin triggers event on collapsing and expanding nested report
JSThe plugin can be bound with "dialog close" event to refresh nested report after closing modal page
JSThe plugin no longer supports TR tag as triggering element
JSHTML within nested report is fully supported
JSNested report can be bound to any HTML table (the plugin is not limited to Classic or Interactive Report)
PL/SQL"#COLUMN_VALUE#" marker should be surrounded with apostrophes to avoid APEX query compilation error. When value is number, apostrophes are removed by the plugin automatically.
PL/SQLNested report uses DBMS_SQL.BIND_VARIABLES to bind values from GUI (APEX items included)
PL/SQLThe plugin supports special column aliases in nested report to create headings without content or font-awesome icon as heading
PL/SQLThe plugin supports SQL comments within nested report query
PluginInteractive Report is supported
PluginThe plugin no longer checks compatibility between nested report and parent report. Setting the plugin is easier and only requires existing span tag with proper class and value marker
PluginThe plugin supports embedding nested report within nested reports (the number of nested reports is not limited by the plugin)
PluginThe plugin configuration errors are now displayed as nested report with error and hint (not only in console)
Plugin attributesNew styles of "Default callback" loading indicator (align to report, align to cell, embed in cell, replace cell content).
Plugin attributesNew plugin attribute for extending "Default template" HTML with preceding and following HTML.
Plugin attributesDefault template supports stretching
Plugin attributesAnimation duration for expanding and collapsing nested report can be specified in „Plugin component settings”
- Initial release
- Column alias can't contain period - #13
|Bartosz Ostrowski||http://ostrowskibartosz.pl||@bostrowski||@email@example.com, firstname.lastname@example.org|
Pretius Sp. z o.o. Sp. K.
Pretius is a software company specialized in Java-based and low-code applications, with a dedicated team of over 25 Oracle APEX developers. Members of our APEX team are technical experts, have excellent communication skills, and work directly with end-users / business owners of the software. Some of them are also well-known APEX community members, winners of APEX competitions, and speakers at international conferences. We are the authors of the translate-apex.com project and some of the best APEX plug-ins available at the apex.world. We are located in Poland, but working globally. If you need the APEX support, contact us right now.
|Żwirki i Wigury 16A, 02-092 Warsaw, Poland||http://email@example.com|