tag:blogger.com,1999:blog-1271763227002553835.post5779282691307554207..comments2024-03-26T08:42:34.744+01:00Comments on Notes on Oracle: Multirecord Master-Detail ReportAlex Nuijtenhttp://www.blogger.com/profile/06345615264010120428noreply@blogger.comBlogger10125tag:blogger.com,1999:blog-1271763227002553835.post-17821429593451502632017-09-12T20:10:22.262+02:002017-09-12T20:10:22.262+02:00It works in APEX 5.0 I've just implemented it....It works in APEX 5.0 I've just implemented it. Maybe, you are something missing?!<br /><br />Thanks, Alex for this tutorial! Anonymoushttps://www.blogger.com/profile/09993708508134902452noreply@blogger.comtag:blogger.com,1999:blog-1271763227002553835.post-9001621731873988722016-12-08T12:42:47.895+01:002016-12-08T12:42:47.895+01:00Hello,
I have also tried this solution in Apex 5 ...Hello,<br /><br />I have also tried this solution in Apex 5 and it won't work and help would be greatly appreciated.Bhavin Adhvaryuhttps://www.blogger.com/profile/02159997681508106430noreply@blogger.comtag:blogger.com,1999:blog-1271763227002553835.post-59809699793784339152016-08-15T14:47:07.197+02:002016-08-15T14:47:07.197+02:00I'm trying to do this in Apex 5 and it won'...I'm trying to do this in Apex 5 and it won't work; any help would be greatly appreciated.<br />The part that doesn't work is populating the hidden field. I've set that to Value Protected = "No" so there's no reason why it can't be populated but it just won't.<br />As I come to think of it; the field DOES get populated, it just gets populated with Null. If I pre-populate it with a valid value (10,20...), the details query picks that up but when I click on a link in the master section, the refresh results in a empty area so I conclude the hidden item is set to Null.<br />Please help?Anonieme Bloggerhttps://www.blogger.com/profile/14077768633246715122noreply@blogger.comtag:blogger.com,1999:blog-1271763227002553835.post-37602781700312049092016-04-28T10:54:02.493+02:002016-04-28T10:54:02.493+02:00Yeah, yeah, it's over a year, but I'd like...Yeah, yeah, it's over a year, but I'd like to share my experiences, as it helped me tremendously, but I also ran into problems. (i'm on apex 4.2 for this)<br /><br />1. I had to do a submit instead of a refresh as the second true action<br />2. As my main report had navigation buttons, I had to set the event scope to Dynamic (as opposed to static), otherwise it would not work on the next page.<br />3. As the field is hidden, I had to set it to Value Protected = No (mainly because of the submit).<br /><br />With that it worked beautifully. Many thanks.<br />KlaasAnonymoushttps://www.blogger.com/profile/07065272753432965328noreply@blogger.comtag:blogger.com,1999:blog-1271763227002553835.post-42173932864701140782015-04-24T10:27:06.265+02:002015-04-24T10:27:06.265+02:00Hmmm... not that I can think of - Do you have your...Hmmm... not that I can think of - Do you have your application on apex.oracle.com? Or could you send me an export of your application? Alex Nuijtenhttps://www.blogger.com/profile/06345615264010120428noreply@blogger.comtag:blogger.com,1999:blog-1271763227002553835.post-86779512368851172942015-04-23T22:05:02.754+02:002015-04-23T22:05:02.754+02:00Yes I did. I have gone over your example carefull...Yes I did. I have gone over your example carefully and tried to replicate it. The Dynamic action has 2 true actions, first executes the java script second refreshes the detail report region.<br /><br />The detailed report works fine if I hard code the id into it, so I guess somehow the id is not being passed in the link or the dynamic action is not firing.<br /><br />Are there any common mistakes people make that you can think of ?<br /><br />ThanksAnonymoushttps://www.blogger.com/profile/03559015059572682631noreply@blogger.comtag:blogger.com,1999:blog-1271763227002553835.post-46546530558813305132015-04-23T09:42:52.473+02:002015-04-23T09:42:52.473+02:00The class "show-employees" is a method t...The class "show-employees" is a method to attach the DA to the row. When the link is clicked the value of the clicked EMPNO is placed in a hidden item.<br />The detail query uses this hidden item in the WHERE clause.<br />There are two TRUE actions: 1 to set the hidden item and 1 to refresh the details report.<br />Did you include the refresh of the detail report?Alex Nuijtenhttps://www.blogger.com/profile/06345615264010120428noreply@blogger.comtag:blogger.com,1999:blog-1271763227002553835.post-43648105995672641122015-04-23T04:55:40.957+02:002015-04-23T04:55:40.957+02:00Thanks Alex,
I tried this with no success, nothin...Thanks Alex,<br /><br />I tried this with no success, nothing happens when I hit the link. There is a class called show-employees in your example. Does this have to be created ?<br /><br />Steve.Anonymoushttps://www.blogger.com/profile/03559015059572682631noreply@blogger.comtag:blogger.com,1999:blog-1271763227002553835.post-53744850169033827492014-12-22T09:51:49.278+01:002014-12-22T09:51:49.278+01:00Hi Paubry,
P9_DEPTNO is a hidden item. Right click...Hi Paubry,<br />P9_DEPTNO is a hidden item. Right click on the region > Create Page Item > type: hidden and that's it.<br /><br />AlexAlex Nuijtenhttps://www.blogger.com/profile/06345615264010120428noreply@blogger.comtag:blogger.com,1999:blog-1271763227002553835.post-33413376395303087712014-12-19T22:58:06.431+01:002014-12-19T22:58:06.431+01:00Hello,
Well I tried this and it get an error &quo...Hello,<br /><br />Well I tried this and it get an error "Unable to find item ID....". How does your item P9_DEPTNO get created ?<br /><br />Thanks,paubryhttps://www.blogger.com/profile/10405133674416985510noreply@blogger.com