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 Master-detail dynamic action

Master-detail dynamic action

10
Categories: Dynamic Action Plugin
Author: non-apexoid

Plugin provides creating master ­ detail relations between classic reports such as:   

  • Simple master­-detail.
  • More complex master-detail­-detail reports etc.
  • One master ­ several details
  • Combination of mentioned above,  including Interactive reports and charts.

Updated: bug fixed, master report key value could not be extracted from report column containing input element. To correct installed plugin simply reload javascript file from src catalog of distribution.


Keywords
master,detail,classic,report

Oracle APEX Plugin
Company: non-apexoid
Date added: 17.1.2015
Views: 9052
Votes: 7
Reviews: 11
Min. APEX Version:
4.2
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 
by orabin
on December 7, 2016
Good program Master-detail dynamic action!

Noted one trouble of your plug-in. When there is on the very first line a master report - the plug-in doesn't work.
How to treat it?
0 
by non-apexoid
on June 14, 2016
Hi! Plugin do not use any tables to store information. Please provide more detailed information about error, for exampe apply apex debug output/ Wwith best regards? non-apexoid
0 
by non-apexoid
on June 14, 2016
Hi! Plugin do not use any tables to store information. Please provide more detailed information about error, for exampe apply apex debug output/ Wwith best regards? non-apexoid
0 
by non-apexoid
on June 14, 2016
Hi! Plugin do not use any tables to store information. Please provide more detailed information about error, for exampe apply apex debug output/ Wwith best regards? non-apexoid
10 
Trying to use plug-in
by Jerry Sidler
on June 2, 2016
Running APEX 5.0.2 Followed directions and double checked... When starting page getting
apex_error_code: WWV_FLOW_PLUGIN.RUN_PLSQL_ERR
original message: Error in PLSQL code raised during plug-in processing.
original_additional_info: ORA-06550: line 48, column 9: PL/SQL: ORA-00942: table or view does not exist ORA-06550: line 39, column 3: PL/SQL: SQL Statement ignored
ora_sqlcode: -6550
ora_sqlerrm: ORA-06550: line 48, column 9: PL/SQL: ORA-00942: table or view does not exist ORA-06550: line 39, column 3: PL/SQL: SQL Statement ignored
component.type: APEX_APPLICATION_PAGE_DA_ACTS
component.id: 76282998907432025
component.name: PLUGIN_RU.NONAPX.MASTERDETAIL

Any help appreciated.. This plug-in is exactly what I need.
0 
Trying to use plug-in
by Jerry Sidler
on June 2, 2016
Running APEX 5.0.2 Followed directions and double checked... When starting page getting
apex_error_code: WWV_FLOW_PLUGIN.RUN_PLSQL_ERR
original message: Error in PLSQL code raised during plug-in processing.
original_additional_info: ORA-06550: line 48, column 9: PL/SQL: ORA-00942: table or view does not exist ORA-06550: line 39, column 3: PL/SQL: SQL Statement ignored
ora_sqlcode: -6550
ora_sqlerrm: ORA-06550: line 48, column 9: PL/SQL: ORA-00942: table or view does not exist ORA-06550: line 39, column 3: PL/SQL: SQL Statement ignored
component.type: APEX_APPLICATION_PAGE_DA_ACTS
component.id: 76282998907432025
component.name: PLUGIN_RU.NONAPX.MASTERDETAIL

Any help appreciated.. This plug-in is exactly what I need.
0 
Trying to use plug-in
by Jerry Sidler
on June 2, 2016
Running APEX 5.0.2 Followed directions and double checked... When starting page getting
apex_error_code: WWV_FLOW_PLUGIN.RUN_PLSQL_ERR
original message: Error in PLSQL code raised during plug-in processing.
original_additional_info: ORA-06550: line 48, column 9: PL/SQL: ORA-00942: table or view does not exist ORA-06550: line 39, column 3: PL/SQL: SQL Statement ignored
ora_sqlcode: -6550
ora_sqlerrm: ORA-06550: line 48, column 9: PL/SQL: ORA-00942: table or view does not exist ORA-06550: line 39, column 3: PL/SQL: SQL Statement ignored
component.type: APEX_APPLICATION_PAGE_DA_ACTS
component.id: 76282998907432025
component.name: PLUGIN_RU.NONAPX.MASTERDETAIL

Any help appreciated.. This plug-in is exactly what I need.
0 
by non-apexoid
on September 18, 2015
Plugin works in Apex 5 as in Apex 4 with some tunings due to using 42 theme (please take a look at my demo).
1.The best way to mark current row is to set "Mark master report current row by" option to "Style selector name" and to define corresponding style, for example:

/* master-detail current row selection */
td.nonapx-masterdetail-curr-row {
background-color:#FAFAD2 !important;
}
.t-Report--rowHighlight .t-Report-report tr:hover td.nonapx-masterdetail-curr-row, .t-Report--rowHighlight .t-Report-report tr:nth-child(2n+1):hover td.nonapx-masterdetail-curr-row {
background-color:#FFFACD !important;
}

2. If you don't want show master key value, use hidden field and set "Report columns/items used as master key values"
option to INPUT:fXX, where fXX is name of hidden input.
10 
by tultu
on September 9, 2015
Sorry, forgot to rate it(first time write a review:-)), this is definitely a 5 Star!!
0 
by tultu
on September 9, 2015
Worked great!!

I did a little differently with the document(somehow it didn't work for me when I used the exact setting in the document, not sure whether this is the document bug or something else on my side, I am on Apex 5),

Here is my setting:

? Mark master report current row by: background color
? Current row style or background color: #5a92d9 !important

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