tag:blogger.com,1999:blog-15612533758004643942024-03-13T11:59:19.529+01:00Denes Kubicek ApEx BLOGDenes Kubicekhttp://www.blogger.com/profile/01962373591521960882noreply@blogger.comBlogger220125tag:blogger.com,1999:blog-1561253375800464394.post-87804846161850558552017-02-21T07:33:00.002+01:002017-02-21T07:33:50.408+01:00APEX 5.1 New Features - neuer TerminAPEX 5.1 ist endlich da. Oracle Application Express wird mit jedem Release besser und zieht immer mehr Entwickler weltweit in seinen Bann. Es ist einfach, einfache wie auch komplexe Applikationen auf Basis des Oracle Stacks zu entwickeln. Es macht sogar richtig Spaß !
<br/><br/>
Mit APEX 5.1 sind als wichtiges neues Feature die Interactive Grids mit dazu gekommen. Wir haben sehr lange auf eine moderne Möglichkeit gewartet, Excel - ähnliche Funktionen auf einer Webseite mit APEX zu implementieren. Jetzt ist es endlich soweit :) .
Sogar Master-Detail-Detail-Detail-... Beziehungen sind umsetzbar, unsere Anwender werden sich freuen.
<br/><br/>
Darüber hinaus gibt es auch in vielen anderen Bereichen wichtige Neuerungen, die uns das Leben erleichtern. Gleichzeitig sind aber auch einige wichtige Dinge zu beachten, damit wir ein reibungsloses Upgrade durchführen können.
<br/><br/>
In diesem Kurs lernen Sie die neuen Funktionalitäten von Oracle Application Express 5.1 kennen, insbesondere wie Sie diese erfolgreich in der Praxis einsetzen.
<br/><br/>
Lernen Sie von und diskutieren Sie mit den weltweit bekannten Oracle APEX Experten:
<br/><br/>
Denes Kubicek, langjährige Projekterfahrung in den Bereichen Oracle und APEX mit multisite Applikationen, Preisträger des "Oracle APEX Developer of the Year 2008" Awards des Oracle Magazines, ein Oracle ACE Director und sehr bekannt im Oracle APEX OTN Forum für seine Beispielapplikation und <br/><br/>
Dietmar Aust, erfahrener Oracle Consultant mit Spezialisierung auf Oracle APEX, Oracle ACE und aktiv in den OTN Foren zu APEX und Oracle XE, mit regelmäßigen Präsentationen auf den einschlägigen Oracle Konferenzen (DOAG, ODTUG, Oracle Open World).
<br/><br/>
<br/><br/>
<div class="separator" style="clear: both; text-align: center;"><a href="http://www.opal-consulting.de/apex/f?p=107:7:0:::7:P7_CLS_ID:1461" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEirmOQpoNK-yY5m7TiBcxYJbPXJ_FChLaHQWxGJKui8qi1ZN9w2wZUUgeZnXGosDigwFvEeSWlbpKo74Ep7ZZ00MJQZU7rBrUZhmLSs7ihSQiDLfDXa_HZ9Ko3icD-oywh7CuLFSl9PIK4/s320/2017-05-29-APEX-51-New-Features-Banner.png" width="320" height="82" /></a></div> Denes Kubicekhttp://www.blogger.com/profile/01962373591521960882noreply@blogger.com5tag:blogger.com,1999:blog-1561253375800464394.post-49877475522396414952017-01-16T08:57:00.001+01:002017-01-16T08:57:22.480+01:00APEX 5.1 New FeaturesAPEX 5.1 ist endlich da. Oracle Application Express wird mit jedem Release besser und zieht immer mehr Entwickler weltweit in seinen Bann. Es ist einfach, einfache wie auch komplexe Applikationen auf Basis des Oracle Stacks zu entwickeln. Es macht sogar richtig Spaß !
<br/><br/>
Mit APEX 5.1 sind als wichtiges neues Feature die Interactive Grids mit dazu gekommen. Wir haben sehr lange auf eine moderne Möglichkeit gewartet, Excel - ähnliche Funktionen auf einer Webseite mit APEX zu implementieren. Jetzt ist es endlich soweit :) .
Sogar Master-Detail-Detail-Detail-... Beziehungen sind umsetzbar, unsere Anwender werden sich freuen.
<br/><br/>
Darüber hinaus gibt es auch in vielen anderen Bereichen wichtige Neuerungen, die uns das Leben erleichtern. Gleichzeitig sind aber auch einige wichtige Dinge zu beachten, damit wir ein reibungsloses Upgrade durchführen können.
<br/><br/>
In diesem Kurs lernen Sie die neuen Funktionalitäten von Oracle Application Express 5.1 kennen, insbesondere wie Sie diese erfolgreich in der Praxis einsetzen.
<br/><br/>
Lernen Sie von und diskutieren Sie mit den weltweit bekannten Oracle APEX Experten:
<br/><br/>
Denes Kubicek, langjährige Projekterfahrung in den Bereichen Oracle und APEX mit multisite Applikationen, Preisträger des "Oracle APEX Developer of the Year 2008" Awards des Oracle Magazines, ein Oracle ACE Director und sehr bekannt im Oracle APEX OTN Forum für seine Beispielapplikation und <br/><br/>
Dietmar Aust, erfahrener Oracle Consultant mit Spezialisierung auf Oracle APEX, Oracle ACE und aktiv in den OTN Foren zu APEX und Oracle XE, mit regelmäßigen Präsentationen auf den einschlägigen Oracle Konferenzen (DOAG, ODTUG, Oracle Open World).
<br/><br/>
<br/><br/>
<div class="separator" style="clear: both; text-align: center;"><a href="http://www.opal-consulting.de/apex/f?p=107:7:0:::7:P7_CLS_ID:1461" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEikbdaqczmnYfNRXSJiPNiTyuasnYpDuCDbmxToS4ulNW6FEzqacQvnzZepVa8yumuqbW9tm0xUce_NUQTnVtayETTbSkHhyphenhyphenxbhQOfN7Q6cadfhibuVPsWVQs8qMynYHotUlq1siK5xQ1s/s320/2017-03-02-APEX-51-New-Features-Banner.png" width="320" height="82" /></a></div>Denes Kubicekhttp://www.blogger.com/profile/01962373591521960882noreply@blogger.com1tag:blogger.com,1999:blog-1561253375800464394.post-36176579267039385142016-09-23T17:30:00.003+02:002016-09-23T17:30:30.517+02:00Wiederholung APEX 5.0 Best PracticesWegen der großen Nachfrage veranstalten wir jetzt einen Zusatztermin für den APEX 5.0 Best Practice Kurs am 21.Nov - 23. Nov. 2016.
<br/><br/>
<a href="http://www.opal-consulting.de/apex/f?p=107:8:0::NO:8:P8_CLS_ID:1381">Anmeldung zum Kurs</a>
<br/><br/>
<a href="http://www.opal-consulting.de/apex/f?p=107:8:0::NO:8:P8_CLS_ID:1381"><img src="https://apex.oracle.com/pls/apex/dkubicek/r/files/static/v5Y/2016-11-21-APEX-5-Best-Practices-Banner.png"/></a>Denes Kubicekhttp://www.blogger.com/profile/01962373591521960882noreply@blogger.com1tag:blogger.com,1999:blog-1561253375800464394.post-51108105718284379922016-06-20T14:34:00.001+02:002016-06-20T14:35:19.752+02:00APEX UT - Display Image in a ListIf using universal theme, we can switch from a classic navigation bar to a list and display it where usually a navigation bar is displayes - right top of the page. The problem with the list is that it will escape any html code in the list name. If we want to display an image, we will get the html code. To go arround that problem, we can use the "user defined attributes" for the lists and put the image into the "Badge Value". This list will then display the image almost as expected. We will need to apply additional css to make the background of the "Badge Value" transparent and to adjust the font to the rest of the navigation bar list:
<br/>
<br/>
.t-Button--navBar .t-Button-badge {background-color: transparent !important; font-weight: 400 !important; font-size: 1.2rem !important}
<br/>
<br/>
This is then how it appears:
<br/>
<br/>
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEglwGsuKdyNZMAQIfH31obJx01WauUG7uFQvNxtFl9nYubIVSKOnpEgVAlpFoYVNiYkU9K7QQ9B_xw57zR1oEkLGUb98EPBCQuVKyAbUqy2dccPtgdL2fE4Dul6nDVFoaQ1Vuo1P1nNF9k/s1600/navigation_bar_list.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEglwGsuKdyNZMAQIfH31obJx01WauUG7uFQvNxtFl9nYubIVSKOnpEgVAlpFoYVNiYkU9K7QQ9B_xw57zR1oEkLGUb98EPBCQuVKyAbUqy2dccPtgdL2fE4Dul6nDVFoaQ1Vuo1P1nNF9k/s320/navigation_bar_list.png" /></a></div>
<br/>
<br/>
Here, we can add the "Badge Value":
<br/>
<br/>
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi-5l_3IiMXe6rx8eNAvNn69u3r0n7pOYlIA2P-o6nzPgD1nyWRJEYzMTqZB60LrLr-xxzNswujptV74A3l50soB_Li5REygzI1bdsjF2HBt7EuVXGoblY3rGSmi-hN9aI5h14ZPfpU7lw/s1600/navigation_bar_badge.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi-5l_3IiMXe6rx8eNAvNn69u3r0n7pOYlIA2P-o6nzPgD1nyWRJEYzMTqZB60LrLr-xxzNswujptV74A3l50soB_Li5REygzI1bdsjF2HBt7EuVXGoblY3rGSmi-hN9aI5h14ZPfpU7lw/s320/navigation_bar_badge.png" /></a></div>
<br/>
<br/>
Finaly, here we can change our navigation bar from classic to list or oposite:
<br/>
<br/>
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgAfc-Ic0d0s3vCX_e32PfXbI6Qi_bgads4k-Usj0_MBf3nmTGQKoq2vlezurtdltI3mKUlVgqxJe3aFihHZQ0eh-qHQUD9E2h2to4I2K4JZEQWhJtV78CoDt4aZLUlEiT_rkuyh0uU-nM/s1600/navigation_bar_setting.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgAfc-Ic0d0s3vCX_e32PfXbI6Qi_bgads4k-Usj0_MBf3nmTGQKoq2vlezurtdltI3mKUlVgqxJe3aFihHZQ0eh-qHQUD9E2h2to4I2K4JZEQWhJtV78CoDt4aZLUlEiT_rkuyh0uU-nM/s320/navigation_bar_setting.png" /></a></div>Denes Kubicekhttp://www.blogger.com/profile/01962373591521960882noreply@blogger.com1tag:blogger.com,1999:blog-1561253375800464394.post-32369419988347074092016-06-14T13:28:00.001+02:002017-04-07T18:42:44.320+02:00APEX Modify UT BreadcrumbWhile creating pages with the new UT I noticed that the breadcrumb breakes after the second level and this takes too much space. <a href="https://apex.oracle.com/pls/apex/f?p=193000:812" target="new">This example</a> shows how to go arround that problem with just a couple of css styling lines.
<br/>
<br/>
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgujQBBFlgE03uR_ERhrIPef60xFKwM-TvlrEJ5zPgOq5etE_kEasOLkDV5nUcTgvPgrwQERv8CEFEMMmmY4rmlGPsi2G87s3oBYv0UR7g0qibV3sWcqAH61C5eGDqq4t9HGkhlnsJa2dM/s1600/ut_breadcrumb.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgujQBBFlgE03uR_ERhrIPef60xFKwM-TvlrEJ5zPgOq5etE_kEasOLkDV5nUcTgvPgrwQERv8CEFEMMmmY4rmlGPsi2G87s3oBYv0UR7g0qibV3sWcqAH61C5eGDqq4t9HGkhlnsJa2dM/s320/ut_breadcrumb.png" /></a></div>
<br/>
<br/>
And this is how it looks like after applying the css.
<br/>
<br/>
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg9NH17NYSvJ35awx_7PvRC3iemEcChut-qRCXfRketSrIzYxzN9EHZhRECK2os_ZR3UVmN8KWMQ1LnvgYpEyCCGJaLODLG2QMVn6U-RHri4t02J6cqz02dlp9mpqf4zmCwJRubeMm9CqI/s1600/ut_breadcrumb_modified.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg9NH17NYSvJ35awx_7PvRC3iemEcChut-qRCXfRketSrIzYxzN9EHZhRECK2os_ZR3UVmN8KWMQ1LnvgYpEyCCGJaLODLG2QMVn6U-RHri4t02J6cqz02dlp9mpqf4zmCwJRubeMm9CqI/s320/ut_breadcrumb_modified.png" /></a></div>Denes Kubicekhttp://www.blogger.com/profile/01962373591521960882noreply@blogger.com2tag:blogger.com,1999:blog-1561253375800464394.post-84056303075401701892016-06-05T12:08:00.001+02:002016-06-05T13:34:03.313+02:005.1 EAIt is incredibly quiet around APEX release 5.1. Just a couple of days ago I was talking to <a href="http://www.opal-consulting.de" target="new">Dietmar</a> and we were asking ourselves when is APEX 5.1 going to be released because of our training schedule for the rest of the year. On Tuesday this week <a href="http://apex-experts.de/ords/website/home">Markus</a> visited the EA site and <a href="http://markushohloch.de/apex-5-1-ea-is-coming-soon/" target="new">this is</a> what he found there. Many exciting things to appear in the next versions. Read the <a href="http://markushohloch.de/apex-5-1-ea-is-coming-soon/" target="new">details</a> and you will get an idea about what is comming.
<div class="separator" style="clear: both; text-align: center;"><a href="http://markushohloch.de/apex-5-1-ea-is-coming-soon/" ><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg0GvQAj03s04Eyd5elnjiCg2wF2eCLKgtrfB-cIyfcQ0MErOiL9nm2nadxIYV3e89EbJ6hmyKkwjkiANopTF-DE9ANBKPu69a3TgAupdXVh77V8nV96gCkVLG-cogmwz2V82PAU2QzwOo/s320/ea51.png" /></a></div>
Denes Kubicekhttp://www.blogger.com/profile/01962373591521960882noreply@blogger.com6tag:blogger.com,1999:blog-1561253375800464394.post-42670444164426522072016-06-05T11:59:00.001+02:002016-06-05T11:59:38.995+02:00New APEX Blog<a href="http://markushohloch.de/" target="new">Markus Hohloch</a> is a new blogger is the growing APEX community. He is a part of our <a href="http://apex-experts.de/ords/website/home" target= "new">APEX Experts team</a> and he is blogging mainly in german. He has a couple of interesting postings. Have a look.
</br>
</br>
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgWOEg11A1YPU1kcjiiYZpbOcc6xuezJ8E-ayjyKtv7TtgzMyRQSujLuiQ1kokjOx12Ezqq8fPC0OJVgipbvYJpKy_Gf2WIwPFBcAPu2OAimpho2mBxRxu8oJ2GVBb_iozfAl8MR9bILTc/s1600/markus_hohloch_blog.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgWOEg11A1YPU1kcjiiYZpbOcc6xuezJ8E-ayjyKtv7TtgzMyRQSujLuiQ1kokjOx12Ezqq8fPC0OJVgipbvYJpKy_Gf2WIwPFBcAPu2OAimpho2mBxRxu8oJ2GVBb_iozfAl8MR9bILTc/s320/markus_hohloch_blog.png" /></a></div>
</br>
</br>
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi1RKo_M4-VZ9qcR3sl6oeMl4l6gpRoLcvEGeR1a2IkQxbNF_2zok_DogAiqJ3ZOk6Ci-j_Kmb3J65uJpT1BGfSrtvTKQnvHQGbgYgYcV7wxpkCeeAf2TF3gMhYLXeE5HymusWOiW0kV2w/s1600/apex_experts.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi1RKo_M4-VZ9qcR3sl6oeMl4l6gpRoLcvEGeR1a2IkQxbNF_2zok_DogAiqJ3ZOk6Ci-j_Kmb3J65uJpT1BGfSrtvTKQnvHQGbgYgYcV7wxpkCeeAf2TF3gMhYLXeE5HymusWOiW0kV2w/s320/apex_experts.png" /></a></div>Denes Kubicekhttp://www.blogger.com/profile/01962373591521960882noreply@blogger.com0tag:blogger.com,1999:blog-1561253375800464394.post-67044884478685075612016-04-06T19:12:00.001+02:002016-04-06T19:12:48.046+02:00My Presentation at APEX Connect 2016On 28th of April I will be presenting at <a href="https://apex.doag.org/de/home/">APEX Connect</a> in Berlin. The topic is Integration of APEX with <a href="https://maps.here.com" target="new">HERE Maps</a>. If you are interested to see how you can integrate APEX with Maps (HERE or Google or some other) please join the presentation. The best thing is that this integration ist done using APEX Plugins only. I will try to show as many functionalities as possible including Routing, Tracing, Positioning and a combination of all the features together.
<br/>
<br/>
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh2dg39X3JN2bbm0g93BSeR2cwLk2EYKgE9BoVozB-MyPGTAGV6tNxjpSOEzjAcOiZAGnDS1LuLcbFGNoar5w33iYcVPRetK1fphyphenhyphenM5GCl6a4Axy0fgCHNbqx-Uwpm-TjTIt3seivnxct8/s1600/apex_connect_presentation.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh2dg39X3JN2bbm0g93BSeR2cwLk2EYKgE9BoVozB-MyPGTAGV6tNxjpSOEzjAcOiZAGnDS1LuLcbFGNoar5w33iYcVPRetK1fphyphenhyphenM5GCl6a4Axy0fgCHNbqx-Uwpm-TjTIt3seivnxct8/s320/apex_connect_presentation.png" /></a></div>Denes Kubicekhttp://www.blogger.com/profile/01962373591521960882noreply@blogger.com0tag:blogger.com,1999:blog-1561253375800464394.post-79815820527234698392016-03-29T07:34:00.001+02:002017-04-07T18:42:32.459+02:00My Demo ApplicationIf you experience a problem accessing <a href="https://apex.oracle.com/pls/apex/f?p=193000:LOGIN_DESKTOP::::::" target="new">My Demo Application (old and new version)</a> at apex.oracle.com, that means there is a reason for that. One of the users deleted all the applications in my workspace and installed some of his own. I don't think this was intended but it is still a lot of work and I am trying to geta all the important stuff back online. After that I will need to rethink the way of accessing the workspace. It happened for the second time within the last four months.<br/><br/><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjgygSEhDDzYBFVVujNmhNmx68-7D7hYBlh56j-5iE_u8LYtipf3KN0BFqOWJSWFQD9YWzHN3uGbFGWzbwiBeQARV-d3X3IIrj64SGfd6I_rRp22a1zAhwV18pGoMUaRGk7TT8S4Kl17BU/s1600/demp_application.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjgygSEhDDzYBFVVujNmhNmx68-7D7hYBlh56j-5iE_u8LYtipf3KN0BFqOWJSWFQD9YWzHN3uGbFGWzbwiBeQARV-d3X3IIrj64SGfd6I_rRp22a1zAhwV18pGoMUaRGk7TT8S4Kl17BU/s320/demp_application.png" /></a></div>
Denes Kubicekhttp://www.blogger.com/profile/01962373591521960882noreply@blogger.com7tag:blogger.com,1999:blog-1561253375800464394.post-68567733296329878052016-03-03T09:34:00.001+01:002017-04-07T18:42:25.248+02:00APEX 5 - Opening and Closing Modal Window - Part TwoIn <a href="http://deneskubicek.blogspot.de/2015/07/apex-5-opening-and-closing-modal-window.html" target="new">this blog post</a> from 2015 I explained how to open a modal window from an item and pass the values back, display a sucess message, etc. This page also contains an item plugin to make it easier to do the whole stuff and avoid hardcoding. I have never published this plugin. Hopefully this functionality is going to be a standard part of 5.1. Now, I was asked to make this working with a file browse item as well. I extended that example and created a new one showing how to do that with changing and clicking on a file browse item. You can see this example <a href="https://apex.oracle.com/pls/apex/f?p=193000:404" target="new">here</a>. If you have an account for my workspace, you can even download the plugin and make it working in your environment. Enjoy.
<br/>
<br/>
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgTtI9Yrt-FVJ-zP-LPuDjRCqDSOjfAq-4gM2a-V83cupKowvgS9S1t-9H_8QAaaNs4kUNroQHnflwbP6G5sXve8qDHe43L_AQFOOFTfVKtVxELop1Cp0pPFKFReq_lY0qP5ut1TAM0ga4/s1600/modal_dialog_second.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgTtI9Yrt-FVJ-zP-LPuDjRCqDSOjfAq-4gM2a-V83cupKowvgS9S1t-9H_8QAaaNs4kUNroQHnflwbP6G5sXve8qDHe43L_AQFOOFTfVKtVxELop1Cp0pPFKFReq_lY0qP5ut1TAM0ga4/s320/modal_dialog_second.png" /></a></div>Denes Kubicekhttp://www.blogger.com/profile/01962373591521960882noreply@blogger.com4tag:blogger.com,1999:blog-1561253375800464394.post-42798983062043708232016-02-28T14:51:00.000+01:002017-04-07T18:42:16.040+02:00Change Item Position using jQuerySee <a href="https://apex.oracle.com/pls/apex/f?p=193000:810" target="new">this example</a> on how to change the item position. In APEX you can position the buttons after the action bar in an interactive report. However, you can't put the items there. Using jQuery this is easy to achieve.
<br/>
<br/>
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhuARbDm-psnkvVh_n0ENQttsd2JqjyiZsb7Nawc4YaqA83cJkWc0M5qHHW5MlmtrQrnB2UL-f6s5TOF5Sgfyg8Er8NwDAVPvueFZYCvfgieNNBjmxIqv_pm692zpOMuGoC1-3pklLRVOM/s1600/position_items.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhuARbDm-psnkvVh_n0ENQttsd2JqjyiZsb7Nawc4YaqA83cJkWc0M5qHHW5MlmtrQrnB2UL-f6s5TOF5Sgfyg8Er8NwDAVPvueFZYCvfgieNNBjmxIqv_pm692zpOMuGoC1-3pklLRVOM/s320/position_items.png" /></a></div>Denes Kubicekhttp://www.blogger.com/profile/01962373591521960882noreply@blogger.com0tag:blogger.com,1999:blog-1561253375800464394.post-75711391695438484982016-02-28T14:47:00.002+01:002017-04-07T18:42:05.431+02:00React on Tab ChangeSee <a href="https://apex.oracle.com/pls/apex/f?p=193000:813" target="new">this example</a> on how to react on tab change in APEX 5. The problem is to determine the right selector to trigger the corresponding dynamic action. Thanks <a href="http://rokitta.blogspot.de/" target="new">Christian Rokitta</a> for your help.
<br/>
<br/>
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjHivd6C_0H-4gJoaCE1P8P4_vqE2ChWEbFM34nl_nMF_RoQs5rrwKAIf_ANJTSiTjfsC78Y9Ug_mKMIaVsqg2KwlNVxQnrQYNAqpbRoWvz0olAr2Cn3jyCj5RLNO6art6psvvyoywdLE4/s1600/tab_change.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjHivd6C_0H-4gJoaCE1P8P4_vqE2ChWEbFM34nl_nMF_RoQs5rrwKAIf_ANJTSiTjfsC78Y9Ug_mKMIaVsqg2KwlNVxQnrQYNAqpbRoWvz0olAr2Cn3jyCj5RLNO6art6psvvyoywdLE4/s320/tab_change.png" /></a></div>Denes Kubicekhttp://www.blogger.com/profile/01962373591521960882noreply@blogger.com1tag:blogger.com,1999:blog-1561253375800464394.post-45995708644161666752016-01-17T22:01:00.001+01:002016-01-18T07:16:29.707+01:00APEX Dashboard Competition<a href="https://apex.oracle.com/pls/apex/f?p=59374:1" target="new">APEX Dashboard Competition</a> initiated by <a href="http://www.apex-at-work.com/" target="new">Tobias Arnhold</a> is now online. If you want to compete against your colleagues all you need to do is to create a nice looking dashboard based on the prepared set of data, crate a packaged application and send it to the jury. You can apply here: <a href="https://apex.oracle.com/pls/apex/f?p=59374:4:#section-submission" target="new">Submit your application</a> and win some nice prices. Hurry up. The closing is on Friday the 1st of April 2016.
<br/>
<br/>
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhSe-LaFyjyyhO1oW1a8qFsch3jGPjdyexLRRn_zjaKoUSpMgKfhwnq15gw0qPsprHxojrELhPxUGb47Jz9ltT8mB3tzLbLXJqRTWGCYKmN-UX5xrr-QjjgsW2lE6gisJnNopt_ZMRrT6E/s1600/apex_competition.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhSe-LaFyjyyhO1oW1a8qFsch3jGPjdyexLRRn_zjaKoUSpMgKfhwnq15gw0qPsprHxojrELhPxUGb47Jz9ltT8mB3tzLbLXJqRTWGCYKmN-UX5xrr-QjjgsW2lE6gisJnNopt_ZMRrT6E/s320/apex_competition.png" /></a></div>Denes Kubicekhttp://www.blogger.com/profile/01962373591521960882noreply@blogger.com0tag:blogger.com,1999:blog-1561253375800464394.post-16545160836778301662015-12-22T09:31:00.001+01:002017-04-07T18:41:57.507+02:00Remove Blanks from Formated Date Column<a href="https://apex.oracle.com/pls/apex/f?p=193000:808" target="new">This small example</a> is showing how powerful jQuery is and how easy it is to use it in APEX. In <a href="https://apex.oracle.com/pls/apex/f?p=93000:808" target="new">this case</a>, I needed to correct the oracle formatting, which adds blanks to the name of the day prior to comma. Probably oracle RPAD's the day names to the longest (Wednesday). Those are showing in APEX as one blank - see the left column. The only good way to go around that annoying side effect is to use jquery and basically one line of code.<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjCfzralA7iZqOUuygJrj4KQFk9zm11bz3XeVBFDAzVjbkF02VU33q7whqGFGN2ZtBAfDzyOKlqPxFyWBQrNPSNUibyKTnJKGoqiGUIKe_LF8oFWkqpchTpzoWdxNdL2ZZA6slnvb8W74A/s1600/removing_spaces.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjCfzralA7iZqOUuygJrj4KQFk9zm11bz3XeVBFDAzVjbkF02VU33q7whqGFGN2ZtBAfDzyOKlqPxFyWBQrNPSNUibyKTnJKGoqiGUIKe_LF8oFWkqpchTpzoWdxNdL2ZZA6slnvb8W74A/s320/removing_spaces.png" /></a></div>
<br/><br/>
Denes Kubicekhttp://www.blogger.com/profile/01962373591521960882noreply@blogger.com3tag:blogger.com,1999:blog-1561253375800464394.post-83977521629880963452015-12-03T08:41:00.002+01:002015-12-03T08:41:55.121+01:00APEX Feature RequestJust created a new feature request for APEX at <a href="https://apex.oracle.com/pls/apex/f?p=55447:19:::NO:19:P19_ID:50481528500531591330407043519019274105" target="new">https://apex.oracle.com/pls/apex/f?p=55447:19:::NO:19:P19_ID:50481528500531591330407043519019274105</a> … Extend Interactive Report API - Get IR Query. The feature request is abut the following:
<br/><br/>
"This API should deliver a couple of different SQL statements for an interactive report. There are several possible requirements I can think of:
<br/><br/>
1. IR query including visible columns and filter values - actual SQL for the user session,<br/>
2. IR query including all columns and the original SQL,<br/>
3. get column names of an IR with or without column alias,...<br/><br/>
Having this SQL we should be able to run it as EXECUTE IMMEDIATE, without having to replace any binds.<br/><br/>
This feature could be included in the actions menu and available as a plugin for dynamic actions - new dynamic action feature (action)."<br/><br/>
Please, feel free to go there and vote for it.
<br/><br/>
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjDd7SGyGwE2qy3ukgOpddL9pKomvPEYa9gclHXkYLqKuAnKT5663Ml8VwfM5fsAcrPauptRMHhSevX_pzOZn0DDW-N7dtswqvD9Z9Mqcd6ekMKkJKTYKNJyHNRcL4Rt1tmP52ol0xB2S0/s1600/feature_request.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjDd7SGyGwE2qy3ukgOpddL9pKomvPEYa9gclHXkYLqKuAnKT5663Ml8VwfM5fsAcrPauptRMHhSevX_pzOZn0DDW-N7dtswqvD9Z9Mqcd6ekMKkJKTYKNJyHNRcL4Rt1tmP52ol0xB2S0/s320/feature_request.png" /></a></div>Denes Kubicekhttp://www.blogger.com/profile/01962373591521960882noreply@blogger.com0tag:blogger.com,1999:blog-1561253375800464394.post-80970153564511471962015-10-22T13:54:00.001+02:002015-10-22T13:54:50.436+02:00Select all Checkboxes in IR - APEX 5If <input type="checkbox" onclick="$f_CheckFirstColumn(this)"> doesn't work for you in APEX 5 Interactive Reports then you will need to disable Fixed Headings (standard). Fixed headings splits the report into two tables and the function won't work.
<br/>
<br/>
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgvrMPMDYdG7tpqLZAdXCSqHVhZ_0k72s8yqYjn10j-qif3-Zvqrfuhe0KIT63hRxwOiXEJ_ho6cNsItLwslspC4VnDRQ8Jy3yrgAcdxoeW3bIXiqLSO3wzVva9smuEQ4s6-ToTiwS3zgY/s1600/fixed_headings.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgvrMPMDYdG7tpqLZAdXCSqHVhZ_0k72s8yqYjn10j-qif3-Zvqrfuhe0KIT63hRxwOiXEJ_ho6cNsItLwslspC4VnDRQ8Jy3yrgAcdxoeW3bIXiqLSO3wzVva9smuEQ4s6-ToTiwS3zgY/s320/fixed_headings.png" /></a></div>Denes Kubicekhttp://www.blogger.com/profile/01962373591521960882noreply@blogger.com5tag:blogger.com,1999:blog-1561253375800464394.post-86802305929044529412015-10-22T13:45:00.000+02:002015-10-22T13:47:43.404+02:00Oracle Live SQL<a href="https://livesql.oracle.com/apex/livesql/file/index.html" target="new">Oracle Live SQL</a> is a great source for learning SQL and PL/SQL. It has a lot of good examples and interactive educational tutorials. The best thing is, it runs on APEX ;) Add this site to your bookmarks.
<br/>
<br/>
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhhtepqKKXThqy5kZntWOzVZi7yFDIWtjS2RPunxRm3hmeNhPHw2ADJVTZf7Pv1fv0zk_zOeSAHbpttjW06L47I0O8rVEkOpdYFUw7HioPgcQe-3yo5DCsx_BhJN47sgXMlQi1nbLQ4d4I/s1600/live_sql.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhhtepqKKXThqy5kZntWOzVZi7yFDIWtjS2RPunxRm3hmeNhPHw2ADJVTZf7Pv1fv0zk_zOeSAHbpttjW06L47I0O8rVEkOpdYFUw7HioPgcQe-3yo5DCsx_BhJN47sgXMlQi1nbLQ4d4I/s320/live_sql.png" /></a></div>Denes Kubicekhttp://www.blogger.com/profile/01962373591521960882noreply@blogger.com0tag:blogger.com,1999:blog-1561253375800464394.post-80774073078413119892015-10-09T07:49:00.000+02:002015-10-09T13:43:07.071+02:00Oracle Database Developer Choice Awards (2nd)I was just looking at the voting results for <a href="https://community.oracle.com/community/database/awards/ords-voting" target="new">ORDS</a> and <a href="https://community.oracle.com/community/database/awards/apex-voting" target="new">APEX</a>. In the ORDS category <a href="www.opal-consulting.de/" target="new">Dietmar Aust</a> is leading and in the category APEX it is <a href="http://ora-00001.blogspot.de/" target="new">Morten Braten</a>. So far so good. These men deserve the award for sure - they did a lot for the community and the most of us are using (or have used) their solutions. Think of Morten's <a href="https://github.com/mortenbra/alexandria-plsql-utils" target="new">PL/SQL Utility Library</a> or Dietmar's <a href="http://www.opal-consulting.de/apex/f?p=20090928:4" target="new">PDF Printing</a>...
<br/><br/>
The only thing I have a problem with is the absolutely microscopic number of votes. The most votes in the category ORDS has Dietmar - 134. In APEX it is 98 votes for Morten. Even <a href="http://jaris.blogsite.org/apex/f?p=BLOG:AUTHORS:0:::::">Jari Lane</a> who is very well known in the APEX community and has helped numerous people with his solutions has received all together 103 votes - obviously almost the half of it as down-voitng. To my point of view this is incredible. But if I think back and do a comparison with my own experience then this is actually normal. In the last seven years I have received more than 9.000 emails from the community asking either for access to my <a href="https://apex.oracle.com/pls/apex/f?p=31517:1" target="new">workspace</a>, my <a href="https://apex.oracle.com/pls/apex/f?p=31517:1" target="new">Demo Application</a> or asking for an APEX solution of some kind. As a result of that I have created almost 4.000 accounts and answered 95% of those emails. But all together, maybe 50 receivers responded saying thank you.
<br/><br/>
Conclusion:
<br/><br/>
Shame on us. We are lazy and cynic. We are constantly talking about how big the APEX community and how strong it is. Maybe, because there are a few people out there like Dietmar, Jari, Jürgen Schuster, Morten and few others. The rest seem to be there only when they need something.
<br/><br/>
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgbeASgmx-NKlowyh4D-581zqdI_FyTWXjaeXYjxNZ2M5tmskOZEKWyA625cauJ6wO310lO9K2-j0FeZGCCUPjVD_TJCrIkmHx3XZMBoTDn06-My0oxC020BGVE8rJW9n2aZczML337C_M/s1600/dev_choice.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgbeASgmx-NKlowyh4D-581zqdI_FyTWXjaeXYjxNZ2M5tmskOZEKWyA625cauJ6wO310lO9K2-j0FeZGCCUPjVD_TJCrIkmHx3XZMBoTDn06-My0oxC020BGVE8rJW9n2aZczML337C_M/s320/dev_choice.png" /></a></div>Denes Kubicekhttp://www.blogger.com/profile/01962373591521960882noreply@blogger.com5tag:blogger.com,1999:blog-1561253375800464394.post-61072107884497948582015-09-23T07:28:00.003+02:002015-09-23T07:28:48.930+02:00Oracle Database Developer Choice AwardsDon't forget to vote for the expert of your choice at <a href="https://community.oracle.com/community/database/awards" target="new">https://community.oracle.com/community/database/awards</a>. There are a lot of good men there deserving your voice for their activities in the community and for their selfless engagement.
<br/>
<br/>
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiy5_R5orxM7PqHzdTkNjTHpjyMrjmW7lm4DV_fkO30GWSodOo_g1w8JLnoduH80ss-VomcZ1lCgL1_4zSdjQkIGmIsmlJJb0_3A3_P_0OaQsmE_UpldQhEMr06JHGiezVVFbebmN_m4UE/s1600/dev_choice.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiy5_R5orxM7PqHzdTkNjTHpjyMrjmW7lm4DV_fkO30GWSodOo_g1w8JLnoduH80ss-VomcZ1lCgL1_4zSdjQkIGmIsmlJJb0_3A3_P_0OaQsmE_UpldQhEMr06JHGiezVVFbebmN_m4UE/s320/dev_choice.png" /></a></div>Denes Kubicekhttp://www.blogger.com/profile/01962373591521960882noreply@blogger.com2tag:blogger.com,1999:blog-1561253375800464394.post-19105806104772395582015-08-29T13:44:00.000+02:002015-08-29T18:32:16.489+02:00Count Selected Rows<a href="https://apex.oracle.com/pls/apex/f?p=93000:806" target="new">This small example</a> is showing hot to make sure at least one row in your tabular form has been selected prior to proceeding:
<br/><br/>
<a href="https://apex.oracle.com/pls/apex/f?p=93000:806" target="new">https://apex.oracle.com/pls/apex/f?p=93000:806</a>
<br/><br/>
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjwCzXJfQOHHBe-qzozAAQLnT0u6fidPyZxToEbLuPt6BYowNzCvGUlTQgQiGohhiaBjL4vD8wrtEJPMtYEii8-oBdXVdVR8MbFYjEty79UbkFXylQGR0y_qlMY6eF4DAEsy-EqYKuJDR0/s1600/checkboxes.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjwCzXJfQOHHBe-qzozAAQLnT0u6fidPyZxToEbLuPt6BYowNzCvGUlTQgQiGohhiaBjL4vD8wrtEJPMtYEii8-oBdXVdVR8MbFYjEty79UbkFXylQGR0y_qlMY6eF4DAEsy-EqYKuJDR0/s320/checkboxes.png" /></a></div>Denes Kubicekhttp://www.blogger.com/profile/01962373591521960882noreply@blogger.com0tag:blogger.com,1999:blog-1561253375800464394.post-18671328549645340022015-08-29T11:36:00.001+02:002015-08-29T11:36:07.241+02:00Switch Panes in Page DesignerThis is definitely worth of mentioning. Go <a href="http://blog.oratronik.org/?p=138" target="new">here</a> and download this plugin for Firefox or Chrome. You will like it. It switches the panes in the Page Designer so you can much easier access the properties of the selected elements. Congrats <a href="http://blog.oratronik.org" target="new">Filip</a>. This is a cool feature. Thanks.
<br/><br/>
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh1QEpE7IOHxkldDOrC7VvR8rsYlsiurDz4b_vBv5RHn_Mna8xaS4_JPp-GFAfXkPxZxhjBmPNr33L7-khu6Cmmw2SICSzaJLUd385_TzLn4kuuHJAeB8zbGm5bpQpEC-q5RGmGcTMKbGU/s1600/switch_pane.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh1QEpE7IOHxkldDOrC7VvR8rsYlsiurDz4b_vBv5RHn_Mna8xaS4_JPp-GFAfXkPxZxhjBmPNr33L7-khu6Cmmw2SICSzaJLUd385_TzLn4kuuHJAeB8zbGm5bpQpEC-q5RGmGcTMKbGU/s320/switch_pane.png" /></a></div>Denes Kubicekhttp://www.blogger.com/profile/01962373591521960882noreply@blogger.com0tag:blogger.com,1999:blog-1561253375800464394.post-49553283099162453592015-08-05T10:00:00.001+02:002015-08-05T10:01:41.676+02:00Expert Oracle Application Express 2nd EditionExpert Oracle Application Express 2nd Edition seems to be available at <a href="http://www.apress.com/9781484204856" target="new">Apress</a>. Buy this book and support the charity project in memory of <a href="http://carlback.blogspot.com/" target="new">Carl Backstrom</a> and <a href="http://joelkallman.blogspot.com/2010/03/scott-spadafore.html" target="new">Scott Spadafore </a>(previous members of the APEX Team). Please note that <b>all</b> funds will be donated to the families of these two great men.
</br>
</br>
<div class="separator" style="clear: both; text-align: center;"><a href="http://www.apress.com/9781484204856" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgWOPoDuem_qL4IYYflaVUBNvriNushOlHBHmlmVtRSCV9tX0VAY4EHTcx8cEQSGvvcBoyC5un7_e8P7y3Xgnri5ZjH57WS6hkyGNLddHYyPgT_1KGmM9852QMqoxts9UoXGB6Yg57BhQU/s320/A9781484204856-3d.png" /></a></div>
Denes Kubicekhttp://www.blogger.com/profile/01962373591521960882noreply@blogger.com1tag:blogger.com,1999:blog-1561253375800464394.post-69689765766405135132015-07-22T10:33:00.001+02:002015-07-22T10:33:40.878+02:00New APEX Blog<a href="http://blog.oratronik.org/" target="new">This</a> is a new blog on APEX. I expect a lots of good stuff there in the future. The last example describes how to modify the Page Designer and move the panes, adjust the layout and simplify the development of an application since accessing element attributes is much easier that way. I think this is worth of looking at and maybe the APEX team considers this as an improvement for the future release.
<br/>
<br/>
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjDrAz_hJXF_xfT22UvAsBuGwDkHEJYqGPIe6jpB2O5YTRRc3z_mb9AB9Gxef22pb239nirRLnk1bbI7DjmCrchv7nH7Hfck9H5flLQR4-zBhgpvbv2mMbHEeLIMYnu-RHlk6cszzxpsgM/s1600/filip_blog.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjDrAz_hJXF_xfT22UvAsBuGwDkHEJYqGPIe6jpB2O5YTRRc3z_mb9AB9Gxef22pb239nirRLnk1bbI7DjmCrchv7nH7Hfck9H5flLQR4-zBhgpvbv2mMbHEeLIMYnu-RHlk6cszzxpsgM/s320/filip_blog.png" /></a></div>
<br/>
<br/>
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgXDe5lJ1Qa2U7kciQrKnMpjuNxHyNY5ZcE1fTNvSpVdRQpb8_zdxwIJk91UHQavQqUfXqNj081Fp12yjNUUpnnsQTXPZAoVutdokpocMdqJ32D_jBqpAXA-HaYvLDtH4ywLIyDZ3fLnq0/s1600/filip_blog_pane.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgXDe5lJ1Qa2U7kciQrKnMpjuNxHyNY5ZcE1fTNvSpVdRQpb8_zdxwIJk91UHQavQqUfXqNj081Fp12yjNUUpnnsQTXPZAoVutdokpocMdqJ32D_jBqpAXA-HaYvLDtH4ywLIyDZ3fLnq0/s320/filip_blog_pane.png" /></a></div>Denes Kubicekhttp://www.blogger.com/profile/01962373591521960882noreply@blogger.com3tag:blogger.com,1999:blog-1561253375800464394.post-19603128431147020872015-07-15T12:56:00.000+02:002017-04-07T18:41:34.067+02:00APEX 5 - Opening and Closing Modal Window<a href="https://apex.oracle.com/pls/apex/f?p=193000:402" target="new">This example</a> is showing how to open a Modal Page from any element in your application. It is easy to get it working using some standards like a button or a link in a report. However, it is not 100% clear how to get it working with some other elements which don't have the redirect functionality built in (item, region title, custom links, etc.). This example is also showing how to get the success message displayed on the parent page after closing of the Modal Page.
<br/>
<br/>
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiWb-huR8sVUdgH_GlFgp3Cg6vCAIdGqKN_jsHzhQyWDA43XR5Q7mlOKQxsWCJSLyBHMEYIR6sfikn4flAENEUF5MBECX17z73TXfutpGFdZAkHMjOexivG8WSk2EoNxncYZpumGwnPplw/s1600/modal_dialog_I.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiWb-huR8sVUdgH_GlFgp3Cg6vCAIdGqKN_jsHzhQyWDA43XR5Q7mlOKQxsWCJSLyBHMEYIR6sfikn4flAENEUF5MBECX17z73TXfutpGFdZAkHMjOexivG8WSk2EoNxncYZpumGwnPplw/s320/modal_dialog_I.png" /></a></div>Denes Kubicekhttp://www.blogger.com/profile/01962373591521960882noreply@blogger.com13tag:blogger.com,1999:blog-1561253375800464394.post-67689625532569567282015-07-08T14:12:00.003+02:002015-07-08T14:12:58.886+02:00APEX 5.0 New Features Training September 2015<br/></br>
<div class="separator" style="clear: both; text-align: center;"><a href="http://www.opal-consulting.de/apex/f?p=107:7:0:::7:P7_CLS_ID:1221" target="new"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEii67bLIoxAIRgA8eXlMzYQytjApSq8c8SyuZ4yRY51fChx7k5l6UHMTP8azDhU_K11MT5FfFDJfkzLSWGOT49M9ejYUG0m1QozqwcLwi7lBscsvwc9KgH1mAMXx-3WP89emNcWxlbGujE/s320/2015-09-28-APEX-5-New-Features-Banner.png" /></a></div>
<br/><br/>
Oracle Application Express 5.0 wurde am 15.04.2015 freigegeben und ist als Download verfügbar.
<br/><br/>
Wir haben jetzt alle über zwei Jahre auf das neue Release gewartet ... und das Warten hat sich mehr als gelohnt ... die neuen Möglichkeiten werden Sie umhauen!
<br/><br/>
Wir haben die neuen Möglichkeiten genau unter die Lupe genommen und sind selbst total begeistert, weil sie das tägliche Arbeiten extrem vereinfachen. Wir haben schon einige Anwendungen in APEX 5.0 neu programmiert und einige ältere Versionan auf 5.0 umgestellt.
<br/><br/>
Mit dem neuen Pagedesigner sind wir so produktiv wie noch nie, das Universal Theme erlaubt auf einfache Weise, richtig elegante Applikationen zu entwickeln. Damit ist wirklich ein Durchbruch gelungen, die Konfiguration (über Template Optionen) und selbst farbliche Anpassungen sind ein Kinderspiel, der integrierte Theme Roller ist einfach genial!<br/><br/>
Modale Dialoge, multiple Interaktive Berichte pro Seite, Erweiterungen für die mobilen Endgeräte, ein komplett neues File-Handling und viele neue Security - Features ... dieses Release ist wirklich umfangreich!
<br/><br/>
Neben diesen großen Features wurden auch wieder über 100 kleinere oder auch größere Verbesserungen implementiert.
<br/><br/>
In unseren Kursen haben wir schon über 200 APEX-Fans die besten Herangehensweisen, Tipps und Tricks beigebracht. Durch die Hands-On Übungen vertiefen wir diese und Sie können diese sofort einsetzen ... oder Sie schlagen sie nach ... wenn Sie sie später brauchen ;). Aber auf jeden Fall wissen Sie nach dem Kurs, was möglich ist!
<br/><br/>
Wir beide (Denes und Dietmar) entwickeln seit 2006 fast jeden Tag mit APEX Applikationen für unsere Kunden, wir haben mit APEX schon alles ausprobiert.
<br/><br/>
Nehmen Sie die Abkürzung und lernen Sie von den Besten, was für die Praxis am wichtigsten sein wird.
<br/><br/>
Um die Vorteile des neuen Releases möglichst schnell nutzen zu können, melden Sie sich am besten sofort an und sichern Sie sich Ihren Platz!<br/>
<ul>
<li>Klicken Sie auf den Link <a href="http://www.opal-consulting.de/apex/f?p=107:8:0::NO:8:P8_CLS_ID:1221" target="new">"Anmeldung zum Kurs"</a>.</li>
<li>Tragen Sie Ihre Anmeldedaten ein und klicken Sie auf den Button "Anmelden".</li>
<li>Sie bekommen sofort eine Bestätigungs-Email zugeschickt.</li>
<li>Sobald Sie in der Email auf den Link zur Bestätigung klicken, haben Sie Ihren Platz gesichert und sind auf jeden Fall dabei!</li>
</ul>
<br/><br/>
<a href="http://www.opal-consulting.de/apex/f?p=107:8:0::NO:8:P8_CLS_ID:1221" target="new"> Anmeldung zum Kurs </a>
<br/><br/>
P.S.: Die vollständige Agenda und weitere Infos zum Kurs gibt es online in der <a href="http://www.opal-consulting.de/apex/f?p=107:7:0:::7:P7_CLS_ID:1221" target="new">Kursbeschreibung</a>. Denes Kubicekhttp://www.blogger.com/profile/01962373591521960882noreply@blogger.com0