Pretius / apex-nested-reports

Pretius APEX Nested Reports
http://http://apex.pretius.com/apex/f?p=105:NESTED_REPORTS
MIT License
40 stars 8 forks source link

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

Preview

Alt text

License

MIT

Features at Glance

Roadmap

Installation

Installation package

  1. src/PRETIUS_APEX_NESTED_REPORTS.sql - the plugin package specification
  2. src/PRETIUS_APEX_NESTED_REPORTS.plb - the plugin package body
  3. src/dynamic_action_plugin_pretius_apex_nested_reports.sql - the plugin installation files for Oracle APEX 5.1 or higher

Installation procedure

To successfully install/update the plugin follow those steps:

  1. Install package PRETIUS_APEX_NESTED_REPORTS in Oracle APEX Schema owner (ie. via SQL Workshop)
  2. Install the plugin file dynamic_action_plugin_pretius_apex_nested_reports.sql using Oracle APEX plugin import wizard
  3. Configure application level componenets of the plugin

Usage guide & Demo application

Basic usage

Example nested report is based on emp and dept table.

  1. Create new application
  2. Create new page
  3. Create Classic Report based on SQL query *
  4. Create derivied column and configure it as follows:
    1. Change derivied column Type to Link
    2. Set Target to URL
    3. Set URL to javascript: void(0); and click OK
    4. Set Link Text to <span class="fa fa-search"></span><span class="DEPTNO" style="display: none">#DEPTNO#</span>
    5. Set Link Attributes to class="dept"
  5. Create new dynamic action and configure it as follows:
    1. Set Event to Click
    2. Set Selection Type to jQuery Selector
    3. Set jQuery Selector to .dept
    4. Set Event Scope to Dynamic
    5. Set Static Container (jQuery Selector) to body
  6. Create true action and configure it as follows:
    1. Set Action to Pretius Nested Reports [Plug-In]
    2. Set Details query to **
    3. Set Affected Elements > Selection Type to Region
    4. Set Affected Elements > Region to Classic Report defined in step 3.
    5. (Not required) Adjust the plugin behaviour up to your needs using the plugin attributes
  7. Save and run page

* SQL Query for step 3

select * from dept

** SQL Query for step 6.ii

select * from emp where deptno = '#DEPTNO#'

Demo application

Check different plugin configurations and use cases in our Live Demo

Free support

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?

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:

Implementation issues

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: apex-plugins@pretius.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.

Comercial support

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 apex-plugins@pretius.com. We offer:

Changelog

2.0.2

2.0.0 / 2.0.1

1.0.0

Known issues

About Author

Author Website Github Twitter E-mail
Bartosz Ostrowski http://ostrowskibartosz.pl @bostrowski @bostrowsk1 bostrowski@pretius.com, ostrowski.bartosz@gmail.com

About Pretius

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.

Address Website E-mail
Żwirki i Wigury 16A, 02-092 Warsaw, Poland http://www.pretius.com office@pretius.com