tag:blogger.com,1999:blog-2132893136140848212.post3608501106123998016..comments2023-09-09T03:03:30.219-06:00Comments on Martin Giffy D'Souza on Oracle APEX: Updateable Interactive Report for APEXMartin D'Souzahttp://www.blogger.com/profile/06992954599899886499noreply@blogger.comBlogger27125tag:blogger.com,1999:blog-2132893136140848212.post-59502895109297080842016-06-17T11:08:08.602-06:002016-06-17T11:08:08.602-06:00Jaya, as this is an old post I won't be updati...Jaya, as this is an old post I won't be updating it for APEX 5.0. Also APEX 5.1 has the Interactive Grid which is much better than this solution.Martin D'Souzahttps://www.blogger.com/profile/06992954599899886499noreply@blogger.comtag:blogger.com,1999:blog-2132893136140848212.post-58403248818959718242016-06-02T17:03:11.223-06:002016-06-02T17:03:11.223-06:00Hi Martin,
Can you share the application for Apex...Hi Martin,<br /><br />Can you share the application for Apex 5.0 version. I am not able to get the jquery and jApex plugins.Anonymoushttps://www.blogger.com/profile/07360036101865691294noreply@blogger.comtag:blogger.com,1999:blog-2132893136140848212.post-6051095998596453692015-12-04T03:31:44.802-07:002015-12-04T03:31:44.802-07:00Thank you Martin :-)Thank you Martin :-)Anonymoushttps://www.blogger.com/profile/06927402662772602272noreply@blogger.comtag:blogger.com,1999:blog-2132893136140848212.post-26015184691487212822013-07-18T09:19:08.973-06:002013-07-18T09:19:08.973-06:00Hi Gaurav,
This article should resolve your issue...Hi Gaurav,<br /><br />This article should resolve your issue: http://www.talkapex.com/2010/06/how-to-only-display-column-when.html<br /><br />MartinMartin D'Souzahttps://www.blogger.com/profile/06992954599899886499noreply@blogger.comtag:blogger.com,1999:blog-2132893136140848212.post-2031343294273896332013-06-16T03:13:57.785-06:002013-06-16T03:13:57.785-06:00Hi. How can I add new row to updateable interactiv...Hi. How can I add new row to updateable interactive report?Denishttps://www.blogger.com/profile/10385204096672634376noreply@blogger.comtag:blogger.com,1999:blog-2132893136140848212.post-39498257827372086832013-04-08T01:07:11.479-06:002013-04-08T01:07:11.479-06:00Hello Martin,
First of all thank so much.
I am fa...Hello Martin,<br />First of all thank so much.<br /><br />I am facing Issue in "downloading editable Interactive Report"<br />I am using APEX version -> Application Express 4.0.2.00.07 ,Database 11g.<br /><br />One of my field in the Interactive Report (Dname ) is editable means user can update the value of DNAME but when I am downloading my I.R (csv format ) using Action button ,the DNAME is coming in the below format,I want to be in the same format as EMPNO.<br /><br />EMPNO DNAME<br />1234 <input type="hidden" ..........so on<br /><br />Note: I am using I.R query as<br />SELECT<br />"EMPNO",<br />"APEX_ITEM.HIDDEN(1,EMPNO)|| APEX_ITEM.TEXT(2,DNAME) "DNAME"<br />FROM EMP.<br /><br />Please Help.<br /><br />Thank you..<br />Regards,<br />GauravAnonymoushttps://www.blogger.com/profile/06927402662772602272noreply@blogger.comtag:blogger.com,1999:blog-2132893136140848212.post-71316113276452082772013-03-16T09:01:18.161-06:002013-03-16T09:01:18.161-06:00Please read the section called "Create Applic...Please read the section called "Create Application Process" in this post.Martin D'Souzahttps://www.blogger.com/profile/06992954599899886499noreply@blogger.comtag:blogger.com,1999:blog-2132893136140848212.post-27407100250310143692013-03-16T01:01:19.339-06:002013-03-16T01:01:19.339-06:00Hi Martin,
I was trying your example in apex 4.2 ...Hi Martin,<br /><br />I was trying your example in apex 4.2 but it throws an error while creating on demand process for "AP_UPDATE_COLLECTION_CELL" as<br />error : " To create an on-demand page process, at least one application level process must be created with the type 'ON-DEMAND'". Please tell me how to overcome that and also you have mentioned about uploading .js files please tell me where i will get that. I<br />have pasted your Java script given on this page to Html Header so is it correct.<br /><br />Regards,<br />Rajat<br /><br />RAJAT SHARMAhttps://www.blogger.com/profile/15622299180414922378noreply@blogger.comtag:blogger.com,1999:blog-2132893136140848212.post-52827062284471562692013-01-27T22:13:12.508-07:002013-01-27T22:13:12.508-07:00Hi Birthe,
I'm happy to hear that it's st...Hi Birthe,<br /><br />I'm happy to hear that it's still useful to people several years later. I won't be publishing a downloadable demo as it's an old post (and all the code is above).<br /><br />Here are some tips to help debug:<br />- Put some logging information in your Application Process which updates the collection. This will let you know if you're actually updating the collection.<br />- Use firebug to make sure the AJAX request is going through.<br />- Create another report region that is a SELECT * FROM APEX_COLLECTIONS to see what you currently have in your collections. You can create a button/dynamic action to refresh this report to see if your collection is being updated.<br /><br />Hope this helps,<br /><br />MartinMartin D'Souzahttps://www.blogger.com/profile/06992954599899886499noreply@blogger.comtag:blogger.com,1999:blog-2132893136140848212.post-7307778141018256212013-01-21T13:43:56.602-07:002013-01-21T13:43:56.602-07:00Hi Martin,
your example is also useful several ye...Hi Martin,<br /><br />your example is also useful several years later.<br /><br />Unfortunately I have a problem with the update. I can not see any reaction also using a button to refresh the result query. Maybe it is possible to give a possibility to download your page for this example ?<br /><br />Many thanks,<br />BirtheAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-2132893136140848212.post-22724329629950505592010-02-16T05:01:13.083-07:002010-02-16T05:01:13.083-07:00Thanks martin for your questions. I'm using In...Thanks martin for your questions. I'm using Internet Explorer 7.<br /><br />I will chec kthe console and then post my comment again for that.Unknownhttps://www.blogger.com/profile/17602545321991567987noreply@blogger.comtag:blogger.com,1999:blog-2132893136140848212.post-633591502092907902010-02-11T20:58:09.957-07:002010-02-11T20:58:09.957-07:00Hi Ananth,
Do you develop in Firefox and use Fire...Hi Ananth,<br /><br />Do you develop in Firefox and use Firebug? Can you look at the console to see if anything is happening when you change a value in the IR?<br /><br />Thank you,<br /><br />MartinMartin D'Souzahttps://www.blogger.com/profile/06992954599899886499noreply@blogger.comtag:blogger.com,1999:blog-2132893136140848212.post-11779999556057931512010-01-25T10:40:56.089-07:002010-01-25T10:40:56.089-07:00I checked that the jquery file I put out in the st...I checked that the jquery file I put out in the static file was a new version (jquery-1.4.min.js). I changed the javascript to indicate this new version as <br />//SCRIPT src="#APP_IMAGES#jquery-1.4.min.js" type=text/javascript></SCRIPT// . However this is still not working as it should? Any insights is assistedUnknownhttps://www.blogger.com/profile/17602545321991567987noreply@blogger.comtag:blogger.com,1999:blog-2132893136140848212.post-36677154120421823762010-01-25T00:01:29.817-07:002010-01-25T00:01:29.817-07:00hi Martin,
I created the variosu regions, collec...hi Martin, <br /><br />I created the variosu regions, collections & then uploaded the JS queries etc bu the updateable columns are not updatng or saving the changes done. how do i resolve this now? it seems ot be same problem like Derek had is what I'm facing now? (ie Changes are not saving)Unknownhttps://www.blogger.com/profile/17602545321991567987noreply@blogger.comtag:blogger.com,1999:blog-2132893136140848212.post-34187127698674816642010-01-04T06:10:56.343-07:002010-01-04T06:10:56.343-07:00Thanks Martin
For your help in getting my Updatea...Thanks Martin<br /><br />For your help in getting my Updateable IR working with your code.<br /><br />This is a really great piece of software I'm sure many besides myself are finding it immensely useful.<br /><br />Thanks<br />DerekUnknownhttps://www.blogger.com/profile/07910368204072013838noreply@blogger.comtag:blogger.com,1999:blog-2132893136140848212.post-22844385367795924792010-01-03T21:19:44.492-07:002010-01-03T21:19:44.492-07:00Hi Martin
The developer signon should be with you...Hi Martin<br /><br />The developer signon should be with you now.<br /><br />Thanks<br />DerekUnknownhttps://www.blogger.com/profile/07910368204072013838noreply@blogger.comtag:blogger.com,1999:blog-2132893136140848212.post-18893198666475658872010-01-03T08:53:09.370-07:002010-01-03T08:53:09.370-07:00Hi Derek,
I just tried and I think I can see the ...Hi Derek,<br /><br />I just tried and I think I can see the problem, however I'd need access to your workspace to modify the application.<br /><br />Could you please create a developer user and send me the workspace login credentials to myfirstnameATclarifit.com?<br /><br />Thank you,<br /><br />MartinMartin D'Souzahttps://www.blogger.com/profile/06992954599899886499noreply@blogger.comtag:blogger.com,1999:blog-2132893136140848212.post-76450330557309421002010-01-03T04:00:15.765-07:002010-01-03T04:00:15.765-07:00Hi Martin
I have put a stripped down version of m...Hi Martin<br /><br />I have put a stripped down version of my Questionnaire app to save time on to apex.oracle.com<br />I have put in the custom_auth used by oracles sample I hope that helps<br />URL http://apex.oracle.com/pls/apex/f?p=39536:1:127057230376098:::::<br /><br />demo/winton<br /><br />The code to update the collection is copied pretty much exactly, but doesn't update either, no surprise<br /><br />If there's an access problem let me know what I need to do.<br /><br />Extremely grateful for your reply<br /><br />Thanks<br />DerekUnknownhttps://www.blogger.com/profile/07910368204072013838noreply@blogger.comtag:blogger.com,1999:blog-2132893136140848212.post-35071301069114291652010-01-02T15:54:43.442-07:002010-01-02T15:54:43.442-07:00Hi Derek,
I may have mislabeled my comment "...Hi Derek,<br /><br />I may have mislabeled my comment "//Set all updateableIR columns onChange events" really binds the onchange event to all your updateable columns.<br /><br />So no, as long as you include that class on columns that have inputs, as in my example, everything should be taken care of you with the above code.<br /><br />If you're still having issues, you could post you code on apex.oracle.com and I can take a look.<br /><br />MartinMartin D'Souzahttps://www.blogger.com/profile/06992954599899886499noreply@blogger.comtag:blogger.com,1999:blog-2132893136140848212.post-81353633900219344872010-01-01T06:12:35.140-07:002010-01-01T06:12:35.140-07:00Martin
I'm trying to use your code to build a...Martin<br /><br />I'm trying to use your code to build a Questionnaire.<br />I have build the collection, the IR report loaded the Jquery and jApex script into static files.<br />The problem is the changes aren't being reflected from screen to collection.<br />I'm not sure what <br />//Set all updateableIR columns onChange events <br />eludes to.<br />Do I need to setup onChange events for the text, radiogroups and select lists I have setup in the IR.<br />I'm a PL/SQL programmer with no javascript<br /><br />Regards<br />DerekAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-2132893136140848212.post-24668401658559349702009-09-30T10:14:23.761-06:002009-09-30T10:14:23.761-06:00Martin,
I think that a viable workaround for the ...Martin,<br /><br />I think that a viable workaround for the APEX_ITEM display issue (Roel - September 15, 2009 1:25 AM) is as follows:<br /><br />- for each APEX_ITEM item, also include the 'raw' value from the collection - do not make this visible in the report. Educate users to only use this column for filtering etc and to not make it visible in the report.<br />- disable filter etc on the apex_item item, but not on the 'raw' value<br />- user can now filter on the 'raw' value, which will appear in the column list under the 'Other' option group.<br /><br />Until APEX matures to the point that this functionality is available out of the box we have to do workarounds like this in order to meet our Business requirements.<br /><br />Thanks,<br /><br />Paul DuncanAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-2132893136140848212.post-30562737358534254802009-09-16T11:29:26.321-06:002009-09-16T11:29:26.321-06:00Hi Lev,
Using the outer join is an excellent idea...Hi Lev,<br /><br />Using the outer join is an excellent idea for rows that can't be updated. You also don't need to add all the columns into the collection, just the updateable ones. <br /><br />I wanted to leave things as simple as possible for this example, so please don't take it as a production ready solution.<br /><br />Thanks for your feedback.<br /><br />MartinMartin D'Souzahttps://www.blogger.com/profile/06992954599899886499noreply@blogger.comtag:blogger.com,1999:blog-2132893136140848212.post-14702819654898475782009-09-15T09:41:47.236-06:002009-09-15T09:41:47.236-06:00Hi Martin,
Really interesting solution.
Just one...Hi Martin,<br /><br />Really interesting solution. <br />Just one suggestion for the next version - I think you don't have to copy all data to collection - you could use outer join in IR query - then collection will have only updated rows. <br />It's not websheets but this solution is very helpful.<br /><br />LevAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-2132893136140848212.post-76728108863026924642009-09-15T05:02:00.866-06:002009-09-15T05:02:00.866-06:00Hi Roel,
You're absolutely right. Filtering o...Hi Roel,<br /><br />You're absolutely right. Filtering or applying any IR functionality against columns that have inputs isn't going to work. To help out, I've changed the demo app to remove functionality on those columns. I've also set the deptname as display only so that you can filter on it and still see your changes etc.<br /><br />You're also right that this is not a websheets replacement. It does what it does and nothing more. Its main goal is to allow end users to filter on non-input columns then update the appropriate data. Anything more than that and this is not the right solution.<br /><br />Thanks for your feedback.<br /><br />MartinMartin D'Souzahttps://www.blogger.com/profile/06992954599899886499noreply@blogger.comtag:blogger.com,1999:blog-2132893136140848212.post-65586987017006307852009-09-15T01:25:28.887-06:002009-09-15T01:25:28.887-06:00Looks cool. But did you try to set highlighting? I...Looks cool. But did you try to set highlighting? If you use the dropdown list for the expression you don't get what you want (and if you just enter something it doesn't work either). The same holds for selecting a filter via the column header. Sorting doesn't work, computations don't work, charts won't work....so it is not websheets yet....<br />Cheers<br />RoelRoelhttps://www.blogger.com/profile/03592016581410637420noreply@blogger.com