If 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 (more...)
While creating pages with the new UT I noticed that the breadcrumb breakes after the second level and this takes too much space.
And this is how it looks like after applying the css.
It is incredibly quiet around APEX release 5.1. Just a couple of days ago I was talking to Dietmar
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. Two days ago Markus
visited the EA site and this is
what he found there. Many exciting things to appear in the next versions. Read the details and you will (more...)
is a new blogger is the growing APEX community. He is a part of our APEX Experts team
and he is blogging mainly in german. He has a couple of interesting postings. Have a look.
On 28th of April I will be presenting at APEX Connect
in Berlin. The topic is Integration of APEX with HERE Maps
. 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 (more...)
If you experience a problem accessing My Demo Application (old and new version)
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 (more...)
In this blog post
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 (more...)
See this example
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.
See this example
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 Christian Rokitta
for your help.
APEX Dashboard Competition
initiated by Tobias Arnhold
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: Submit your application
and win some nice prices. Hurry up. The closing is on Friday the 1st of April 2016.
This small example
is showing how powerful jQuery is and how easy it is to use it in APEX. In this case
, 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 (more...)
Just created a new feature request for APEX at https://apex.oracle.com/pls/apex/f?p=55447:19:::NO:19:P19_ID:50481528500531591330407043519019274105
… Extend Interactive Report API - Get IR Query. The feature request is abut the following:
"This API should deliver a couple of different SQL statements for an interactive report. There are several possible requirements I can think of:
1. IR query including visible columns and filter values - actual SQL for the user session,
2. IR query including all columns and (more...)
If <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.
Oracle Live SQL
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.
I was just looking at the voting results for ORDS
. In the ORDS category Dietmar Aust
is leading and in the category APEX it is Morten Braten
. 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 PL/SQL Utility Library
or Dietmar's PDF Printing
The only thing I have (more...)
Don't forget to vote for the expert of your choice at https://community.oracle.com/community/database/awards
. There are a lot of good men there deserving your voice for their activities in the community and for their selfless engagement.
This small example
is showing hot to make sure at least one row in your tabular form has been selected prior to proceeding: https://apex.oracle.com/pls/apex/f?p=93000:806
This is definitely worth of mentioning. Go here
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 Filip
. This is a cool feature. Thanks.
Expert Oracle Application Express 2nd Edition seems to be available at Apress
. Buy this book and support the charity project in memory of Carl Backstrom
and Scott Spadafore
(previous members of the APEX Team). Please note that all
funds will be donated to the families of these two great men.
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.