Skip to Main Content
Forums

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Pretius Plug-in "Nested Report" referencing master ID in detail report

FofanaFeb 1 2017 — edited Feb 2 2017

Hello,

I am trying to use the pretius plug-in "Nested Reports" in a master-detail situation in order to collapse the detail row upon clicking the master row

http://apex.pretius.com/apex/f?p=105:70::::::#R158758849394630814

But I need to reference the master ID in the detail report.

On the Plugin site the sample sql code is not working in a SQL query (see picture) I am getting ORA-00911: invalid character...

pastedImage_0.png

So I am thinking of calling a function on click of the master row to set the current ID in an application Item that I will put in the where clause of the detail.

But seems complex and long way to go, is there anything that I am not setting in the plugin?

Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 2 2017
Added on Feb 1 2017
#apex-discussions
3 comments
1,072 views