tag:blogger.com,1999:blog-12214002.post1104906543797434839..comments2024-03-09T06:56:57.099-05:00Comments on Let's Wreck This Together...with Oracle Application Express!: Preserving checked checkboxes in a reportJoel R. Kallmanhttp://www.blogger.com/profile/01915290758512999160noreply@blogger.comBlogger17125tag:blogger.com,1999:blog-12214002.post-51934782571609792017-04-17T22:45:13.820-04:002017-04-17T22:45:13.820-04:00Hi Pulkit,
Yes - this will work for page load as ...Hi Pulkit,<br /><br />Yes - this will work for page load as well. You're storing the checked values in a collection, and your query now joins in the collection.<br /><br />JoelJoel R. Kallmanhttps://www.blogger.com/profile/01915290758512999160noreply@blogger.comtag:blogger.com,1999:blog-12214002.post-50828823997710199252017-04-17T05:20:47.265-04:002017-04-17T05:20:47.265-04:00Hi!
Will it preserved the session on page load as...Hi!<br /><br />Will it preserved the session on page load as well? If No, than How can we preserved checkbox on page load?<br />Thank you in advance!Udit Nagpalhttps://www.blogger.com/profile/01697284529646227650noreply@blogger.comtag:blogger.com,1999:blog-12214002.post-30581765311304937972015-11-16T21:10:24.029-05:002015-11-16T21:10:24.029-05:00Hi Naveen,
I'm not sure I understand the ques...Hi Naveen,<br /><br />I'm not sure I understand the question. You can get the value from EMP_COLLECTION by querying the APEX_COLLECTIONS view where COLLECTION_NAME = 'EMP_COLLECTION'.<br /><br />JoelJoel R. Kallmanhttps://www.blogger.com/profile/01915290758512999160noreply@blogger.comtag:blogger.com,1999:blog-12214002.post-30153049221135477372015-11-16T04:10:55.944-05:002015-11-16T04:10:55.944-05:00Hi Joel,
How we will get value from "EMP_COLL...Hi Joel,<br />How we will get value from "EMP_COLLECTION"Anonymoushttps://www.blogger.com/profile/04155271310598815082noreply@blogger.comtag:blogger.com,1999:blog-12214002.post-90450006088295017192013-12-09T19:40:56.725-05:002013-12-09T19:40:56.725-05:00Hi "Unknown",
I'm not sure what the...Hi "Unknown",<br /><br />I'm not sure what the problem is. Even the example I wrote back in 2008 still works. http://apex.oracle.com/pls/otn/f?p=138:1:0<br /><br />JoelJoel R. Kallmanhttps://www.blogger.com/profile/01915290758512999160noreply@blogger.comtag:blogger.com,1999:blog-12214002.post-32948971824584156522013-12-03T09:00:20.145-05:002013-12-03T09:00:20.145-05:00hi Joel,
very good post.
I've tried to every...hi Joel,<br /><br />very good post.<br /><br />I've tried to everything that you did + changes suggested by Carl.<br /><br />Can't get it to work at all.<br /><br />javascript can't seem to run the app level pl\sql code that creates the collection etc.<br /><br />I'm running 11gr2 and apex 4.22.<br /><br />any further suggestions will be much appreciated.<br /><br />thanks.Unknownhttps://www.blogger.com/profile/02578235520127154072noreply@blogger.comtag:blogger.com,1999:blog-12214002.post-16351787571807471862011-03-07T09:12:12.780-05:002011-03-07T09:12:12.780-05:00Hi Satya,
You are best to please post your questi...Hi Satya,<br /><br />You are best to please post your question on the OTN discussion forum at http://forums.oracle.com/forums/forum.jspa?forumID=137.<br /><br />Thanks.<br /><br />JoelJoel R. Kallmanhttps://www.blogger.com/profile/01915290758512999160noreply@blogger.comtag:blogger.com,1999:blog-12214002.post-17321604101098210262011-03-07T09:07:39.370-05:002011-03-07T09:07:39.370-05:00Hi Joel,
I am new and learning apex and trying to ...Hi Joel,<br />I am new and learning apex and trying to implement the collections query in my page. I got this error.<br />--<br />1 error has occurred<br />The report query needs a unique key to identify each row. <br />The supplied key cannot be used for this query. Please edit the report attributes <br />to define a unique key column. ORA-01445: cannot select ROWID from, or sample, a join view without a key-preserved table<br />--<br />Please help me to resolve this.<br />SatyaSatyahttps://www.blogger.com/profile/03116621993663762378noreply@blogger.comtag:blogger.com,1999:blog-12214002.post-17939178836256091462008-08-08T11:04:00.000-04:002008-08-08T11:04:00.000-04:00thank you for this nice post. I was wondering how ...thank you for this nice post. I was wondering how we can add "select all" button to this solution?<BR/><BR/>thanks in advanced,Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-12214002.post-44098283062396413092008-08-02T20:32:00.000-04:002008-08-02T20:32:00.000-04:00How can I modify this "Preserving checked checkedb...How can I modify this "Preserving checked checkedboxes in a report" example to include all the fields in the select statement. In addition to Preserving checked checkedboxes, I want to add all the other column values in the select statement to the 'EMP_COLLECTION' collection.<BR/><BR/>Thanks for posting this example!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-12214002.post-7142243458667822312008-06-13T13:01:00.000-04:002008-06-13T13:01:00.000-04:00Nevermind. It wasn't the javascript, but the on de...Nevermind. It wasn't the javascript, but the on demand process that had the error. I have it working fine now.<BR/><BR/>Bill FergusonBill Fergusonhttps://www.blogger.com/profile/12231706222455052872noreply@blogger.comtag:blogger.com,1999:blog-12214002.post-17440358719928080282008-06-13T12:54:00.000-04:002008-06-13T12:54:00.000-04:00Hi Joel,The code (javascript) seems to work fine w...Hi Joel,<BR/><BR/>The code (javascript) seems to work fine with Firefox, but (not surprisingly) not with IE7. Any hints as to why?<BR/><BR/>Thanks,<BR/>Bill FergusonBill Fergusonhttps://www.blogger.com/profile/12231706222455052872noreply@blogger.comtag:blogger.com,1999:blog-12214002.post-23561754410325521452008-04-28T16:54:00.000-04:002008-04-28T16:54:00.000-04:00Don't ask me why it wasn't working before...but it...Don't ask me why it wasn't working before...but it is now. I may have had some other small typo in the on demand process. But anyway, using ApEx 3.0, you should change the on demand process to utilize the application item that you created.<BR/><BR/>E.g: change:<BR/>l_value := wwv_flow.g_x01;<BR/><BR/>to:<BR/>l_value := :TEMPORARY_ITEM;degzhaushttps://www.blogger.com/profile/05305172626395427542noreply@blogger.comtag:blogger.com,1999:blog-12214002.post-41622253188146405612008-04-28T16:10:00.000-04:002008-04-28T16:10:00.000-04:00Great reel, Joel! We are running ApEx 3.0 (hopefu...Great reel, Joel! We are running ApEx 3.0 (hopefully will be upgrading to 3.1.1 ASAP). Given Carl's comment about using an Application Item, would I need to change my Application On-Demand Process to account for that?<BR/><BR/>I'm trying to modify this line:<BR/>l_value := wwv_flow.g_x01;<BR/><BR/>to:<BR/>l_value := &TEMPORARY_ITEM.;<BR/><BR/>If you could point me in a better trajectory, I'd greatly appreciate it.<BR/><BR/>Thanks Again for the wonderful blog!! --Johndegzhaushttps://www.blogger.com/profile/05305172626395427542noreply@blogger.comtag:blogger.com,1999:blog-12214002.post-73380043541914239572008-03-24T15:42:00.000-04:002008-03-24T15:42:00.000-04:00Arie & Carl,Thanks for your review and very helpfu...Arie & Carl,<BR/><BR/>Thanks for your review and very helpful comments & additions.<BR/><BR/>JoelJoel R. Kallmanhttps://www.blogger.com/profile/01915290758512999160noreply@blogger.comtag:blogger.com,1999:blog-12214002.post-78071263234303525472008-03-20T16:58:00.000-04:002008-03-20T16:58:00.000-04:00@Arie Vikas is alright I've had IM conversations w...@Arie Vikas is alright I've had IM conversations with him in last week.<BR/><BR/>@Joel There were a couple 3.1 features that you had there, here's is an example of 3.0 and 3.1 and also it changes the AJAX to asynchronous so the UI works a bit quicker. <BR/><BR/>In a 3.0 instance create a Application Level Item named TEMPORARY_ITEM and then use this code.<BR/><BR/>/*<BR/>Pre 3.1 <BR/>*/<BR/>function f_UpdateCollection( cb ){<BR/> var get = new htmldb_Get(null,$x('pFlowId').value,'APPLICATION_PROCESS=UpdateCheckboxValue',0);<BR/> get.add('TEMPORARY_ITEM',cb.value);<BR/> get.GetAsync(function(){return;});<BR/> get = null;<BR/>}<BR/><BR/>In 3.1 and going forward you don't need the TEMPORARY_ITEM and you can use this code.<BR/><BR/><BR/>/*<BR/>3.1 and up<BR/>*/<BR/>function f_UpdateCollection( cb ){<BR/> var get = new htmldb_Get(null,$v('pFlowId'),'APPLICATION_PROCESS=UpdateCheckboxValue',0);<BR/> get.addParam('x01',cb.value);<BR/> get.GetAsync(function(){return;});<BR/> get = null;<BR/>}Carl Backstromhttps://www.blogger.com/profile/05017816632779478810noreply@blogger.comtag:blogger.com,1999:blog-12214002.post-33391958962038410602008-03-20T10:40:00.000-04:002008-03-20T10:40:00.000-04:00Hi Joel,Very useful entry on a problem that seems ...Hi Joel,<BR/><BR/>Very useful entry on a problem that seems to be around forever. Now we have one good reference for a good solution.<BR/><BR/>When Vikas was still an active member of the forum (and I really hope he is OK) he tried a bit different approach to this problem. He actually changed the pagination mechanism to save the changes of each tabular form view, prior to pagination - http://forums.oracle.com/forums/thread.jspa?threadID=476665 . This way all the changes, on all the columns were saved. I believe your approach can be extended to include more columns as well.<BR/><BR/>One last remark. In your JavaScript code, you are using the $v() built-in function. I believe this function is available for version 3.1 only.<BR/>For those who will try to use your code on earlier versions, they should use the $x('pFlowId').value or html_GetElement('pFlowId').value syntax.<BR/><BR/>Regards,<BR/>Arie.Arie Gellerhttps://www.blogger.com/profile/07065126195116682377noreply@blogger.com