tag:blogger.com,1999:blog-1003209687173038896.post87993622082839211..comments2024-03-02T05:54:53.634+01:00Comments on APEX by G: APEX 5.1 Master detail (with Interactive/Classic Detail Report)Marko Goričkihttp://www.blogger.com/profile/00170426101592251779noreply@blogger.comBlogger11125tag:blogger.com,1999:blog-1003209687173038896.post-23442562825590940292020-01-16T08:47:53.095+01:002020-01-16T08:47:53.095+01:00THANKS for yout help!THANKS for yout help!Anonymoushttps://www.blogger.com/profile/12147068186069791133noreply@blogger.comtag:blogger.com,1999:blog-1003209687173038896.post-11451461218152832062020-01-07T22:29:19.026+01:002020-01-07T22:29:19.026+01:00I tried this solution. It works great for the add ...I tried this solution. It works great for the add row. But after I save the record and the grid is refreshed, if I click on a row to edit I get this error: <br /><br />interactiveGrid.min.js?v=19.2.0.00.18:10 Uncaught TypeError: <br /><br />Cannot read property 'attr' of null<br /> at a..._identityChanged (VM669 interactiveGrid.min.js:10)<br /> at a..._identityChanged (desktop_all.min.js?v=19.2.0.00.18:27)<br /> at a..._setModelValue (VM669 interactiveGrid.min.js:7)<br /> at a..._setModelValue (desktop_all.min.js?v=19.2.0.00.18:27)<br /> at a...setActiveRecordValue (VM669 interactiveGrid.min.js:7)<br /> at a...setActiveRecordValue (desktop_all.min.js?v=19.2.0.00.18:27)<br /> at HTMLDivElement. (VM669 interactiveGrid.min.js:9)<br /> at HTMLDivElement.dispatch (desktop_all.min.js?v=19.2.0.00.18:2)<br /> at HTMLDivElement.v.handle (desktop_all.min.js?v=19.2.0.00.18:2)<br /> at Object.trigger (desktop_all.min.js?v=19.2.0.00.18:2)<br />Theresahttps://www.blogger.com/profile/01456834585982455420noreply@blogger.comtag:blogger.com,1999:blog-1003209687173038896.post-37245639360214037812019-11-09T05:02:17.080+01:002019-11-09T05:02:17.080+01:00Hi Marko. I was able to refresh the table dynamica...Hi Marko. I was able to refresh the table dynamically from my interactive grid but I was not able to uncheck the selected row in the grid(In your case Departments table). Can you help me to resolve this issue.Anonymoushttps://www.blogger.com/profile/16518910380827651252noreply@blogger.comtag:blogger.com,1999:blog-1003209687173038896.post-89795924310411645182019-08-29T09:58:53.068+02:002019-08-29T09:58:53.068+02:00WHERE TO WRITE THIS PL/SQL CODE
BEGIN
FOR i IN (SE...WHERE TO WRITE THIS PL/SQL CODE<br />BEGIN<br />FOR i IN (SELECT workspace_id<br />FROM apex_workspaces<br />WHERE workspace = :WORKSPACE_NAME)<br />LOOP<br />apex_util.set_security_group_id(i.workspace_id);<br />END LOOP;<br />FOR i IN (SELECT *<br />FROM apex_application_translations<br />WHERE application_id = :APP_ID<br />AND translatable_message = 'APEX.IG.SUMMARY')<br />LOOP<br />apex_lang.update_message(<br />p_id => i.translation_entry_id,<br />p_message_text => 'Interactive Grid. Report: %0, View: %1');<br />COMMIT;<br />EXIT;<br />END LOOP;<br />END;<br />Anonymoushttps://www.blogger.com/profile/14208503115708469137noreply@blogger.comtag:blogger.com,1999:blog-1003209687173038896.post-74373543421282325702019-05-03T16:14:24.015+02:002019-05-03T16:14:24.015+02:00This comment has been removed by the author.Jasminhttps://www.blogger.com/profile/00396885879137643840noreply@blogger.comtag:blogger.com,1999:blog-1003209687173038896.post-30765890820733415382019-02-14T13:02:50.424+01:002019-02-14T13:02:50.424+01:00Somehow when I tested it seemed to me it will alwa...Somehow when I tested it seemed to me it will always be t1000, but as you said it is changing. Anyway, thank you for your help and nice article! Jasminhttps://www.blogger.com/profile/00396885879137643840noreply@blogger.comtag:blogger.com,1999:blog-1003209687173038896.post-17883390953717020092019-02-14T12:56:04.245+01:002019-02-14T12:56:04.245+01:00That's better. Because t1000 is only for the f...That's better. Because t1000 is only for the first row added...Marko Goričkihttps://www.blogger.com/profile/00170426101592251779noreply@blogger.comtag:blogger.com,1999:blog-1003209687173038896.post-66368463353067241532019-02-14T12:53:13.886+01:002019-02-14T12:53:13.886+01:00Marko, just to add new improvement based on your l...Marko, just to add new improvement based on your logic using regex:<br /><br />this.data.selectedRecords.length != 1 || this.data.model.getValue(this.data.selectedRecords[0], "ID").match('^t([0-9]{4})')<br />? <br />'' : this.data.model.getValue( this.data.selectedRecords[0], "ID")Jasminhttps://www.blogger.com/profile/00396885879137643840noreply@blogger.comtag:blogger.com,1999:blog-1003209687173038896.post-60939800413998322872019-02-14T12:37:19.167+01:002019-02-14T12:37:19.167+01:00Thank you very much Marko. Meanwhile I've solv...Thank you very much Marko. Meanwhile I've solved the problem with this JavaScript Expression:<br /><br />this.data.selectedRecords.length != 1 || this.data.model.getValue( this.data.selectedRecords[0], "ID") == 't1000'<br />? <br />'' : this.data.model.getValue( this.data.selectedRecords[0], "ID")<br /><br />because I've found that ID genereted by the "Add Row" is always t1000.Jasminhttps://www.blogger.com/profile/00396885879137643840noreply@blogger.comtag:blogger.com,1999:blog-1003209687173038896.post-14071458624580846702019-02-14T11:44:24.588+01:002019-02-14T11:44:24.588+01:00Hi,
I'm not sure how your PK value looks lik...Hi, <br /><br />I'm not sure how your PK value looks like but you can use a regular expressions. Change JavaScript Expression of the Set Value DA to:<br />fSetItem(this)<br /><br />and add this JS function to the page Function and Global Variable Declaration property (or somewhere globally):<br /><br />function fSetItem(pThis){<br /> var vReturnId = ''; <br /><br /> if(pThis.data.selectedRecords&&pThis.data.selectedRecords.length == 1){<br /> var vReturnId = pThis.data.model.getValue(pThis.data.selectedRecords[0], "DEPTNO"); <br /> if (vReturnId.match('^t([0-9]{4})')){<br /> vReturnId = ''; <br /> }<br /> } <br /><br /> return vReturnId;<br />}<br /><br />In this example function regular expression checks if PK value is like t0000-t9999<br /><br />Br,<br />MarkoMarko Goričkihttps://www.blogger.com/profile/00170426101592251779noreply@blogger.comtag:blogger.com,1999:blog-1003209687173038896.post-90515026342915847592019-02-14T10:41:33.736+01:002019-02-14T10:41:33.736+01:00hi marko. I liked your article very much. I tried ...hi marko. I liked your article very much. I tried it, but for instance when you have "add row" button in master region, and click it, you will get "Ajax call returned server error ORA-01722: invalid number for", because hidden item is based on number type, and the value populated by the action "add row" is string until you save it. how to solve this issue?Jasminhttps://www.blogger.com/profile/00396885879137643840noreply@blogger.com