APEX-PLUGIN.COM

..the apex plugin directory

an initiative of

Add your APEX4.0 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
Dynamic Action Plugin Pretius APEX Nested Reports

Pretius APEX Nested Reports

10

Expand row details

Oracle APEX dynamic action plugin v1.0

The plugin is dynamic action plugin implementing nested reports within APEX classic reports. Scope of data, data appearance and behavior is customizable within the plugin attributes.

Live demo, instructions and more details about the plugin are available directly at demo application.

Special Requirements
Firefox, IE8+, Chrome

Keywords
nested, report, detail, row

Company: Pretius
Date added: 1.8.2016
Views: 3717
Votes: 58
Reviews: 61
Min. APEX Version:
5.0
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.
0 
Edit to RE: Foreign key column only visi
by Bartosz Ostrowski
on March 21, 2017
Comment engine escaped HTML tags :-(

<span class="CUSTOMER_ID" style="display:none">#CUSTOMER_ID#</span>#CUSTOMER#
0 
RE: Foreign key column only visible?
by Bartosz Ostrowski
on March 21, 2017
Alex, again, please read inline APEX help instructions ( section "Referencing not visible columns" ).

Below I have pasted part of inline help for Plugin query attribute (unfortunately without styling)

---------------------------------
Referencing not visible columns

When column in report has "Type" = "Hidden" it is not rendered in report and can't be referenced by the plugin. To reference such column, its value has to be provided within visible column.

In Classic report are defined columns

column CUSTOMER_ID, Type = "Hidden"
column CUSTOMER, Type = "Plain Text"

Column CUSTOMER is visible and can contain CUSTOMER_ID value. To do so go to section Column Formatting > HTML Expression and enter HTML:

#CUSTOMER#
-----------------------------------
10 
Foreign key column only visible?
by Alex
on March 21, 2017
Does the foreign key column mandatory to be visible?
10 
Foreign key column only visible?
by Alex
on March 21, 2017
Does the foreign key column mandatory to be visible?
0 
Alex [Does not work after pagination]
by Bartosz Ostrowski
on March 21, 2017
Alex,

1. The plugin (dynamic action plugin) works after changing pagination only IF dynamic action is configured properly. Every dynamic action (ragrdless whether it's plugin or not) won't work after changing pagination if you don't set scope to DYNAMIC.

2. If you would read instruction (inline APEX help) you would know that you have to use colum aliases.

3. If you would read roadmap you would know multi level will be available in next release which is planned for 2017Q1/Q2.
4 
Does not work after pagination
by Alex
on March 21, 2017
Does not work after changing the pagination.
How to customize columns headers in nested report?
Is there only one level of nesting?
0 
RE: Jason Error
by Bartosz Ostrowski
on March 14, 2017
Ramson, have you tried just saving the query by pressing SAVE button in Page designer (not component view)?

Anyway, contact me via email bostrowski@pretius.com
10 
Jason Error
by Ramon
on February 28, 2017
Hi,

I get this error when I put the where clause filter in the query of the Dynamic Action.

Error occured while retrieving AJAX data: parsererror
SyntaxError: JSON.parse: unexpected character at line 1 column 1 of the JSON data

WHERE
ID_AUTORIZADOR = #ID_AUTORIZADOR#

Any help I would appreciate.

Regards

Ramon
10 
Jason Error
by Ramon
on February 28, 2017
Hi,

I get this error when I put the where clause filter in the query of the Dynamic Action.

Error occured while retrieving AJAX data: parsererror
SyntaxError: JSON.parse: unexpected character at line 1 column 1 of the JSON data

WHERE
ID_AUTORIZADOR = #ID_AUTORIZADOR#

Any help I would appreciate.

Regards

Ramon
10 
Jason Error
by Ramon
on February 28, 2017
Hi,

I get this error when I put the where clause filter in the query of the Dynamic Action.

Error occured while retrieving AJAX data: parsererror
SyntaxError: JSON.parse: unexpected character at line 1 column 1 of the JSON data

WHERE
ID_AUTORIZADOR = #ID_AUTORIZADOR#

Any help I would appreciate.

Regards

Ramon
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.