In the previous post
I talked about Master-Detail and that it wasn't that easy to do Master-Detail-Detail today declaratively in APEX 4.2 (and 5.0).
Below is a screenshot of FOEX
(a framework build on top of APEX) and a Master-Detail-Detail in there.
You can see the live example at https://www.apexrnd.be/ords/f?p=FOEX_FDOCS:MASTER_DETAIL_DETAIL:0::NO:::
Here's a screenshot of the page behind the scenes:
At first it might seem complex, but it isn't. In FOEX (more...)
In the last posts we used following tables to show (Report)
and edit (Form)
Another way to work with this data is using a Master-Detail report/form.
In the master we have our customer info and in the detail the products he's interested in.
Oracle APEX provides a wizard to create a Master-Detail Form
You just follow the wizard to set it up:
By default the wizard will only show related tables, which is (more...)
A couple of day ago a had a task to combine a list with itself. The result should be a two column report of each possible combination.
What should note be part of the result:
- same element combination should be excluded
- duplicate rows (even if the sides are switched)
Because I was just not able to solve it myself *actually it's awful after I now know how to do it*
I had to (more...)
Oracle is gearing up to release APEX 5.0... the final early adopter release (EA3) will be released soon. Over 6000 people participated in APEX EA2...
Here's the email of Joel Kallman:
As EA3 will be very close to the final release of APEX 5.0 many more people will probably join EA3, so keep ready for it! I look forward what color scheme people will create with Theme Roller and how they make the (more...)
In the previous post
I showed some options how you can represent a many-to-many table relationship in a report using the LISTAGG Oracle function.
In this post we will edit a record and see how we can represent the data in a Form and save the data back to the different tables.
First I create a Form on the main table (customers) by just following the wizards.
Next I'll add a Shuttle item to the (more...)
Consider my case: I've a customer table and a products table. Customers can select multiple products they want to have. The diagram look like this: Customers on the left, Products on the right and a table in between that says which customers like which products. Customers might have multiple products and products might be linked to multiple customers - so a many-to-many relationship.
There're many ways to represent this data in a report. Here's a (more...)
In the previous post
I talked about scalable vector images. In this post we will integrate Font Awesome in our APEX app, but the steps for the same if you would pick another library.Step 1:
we need to make the library available in our APEX application.
The easiest way to make the library available in your entire application is to add the following line in your Page Template:
How do I know it's that (more...)
After I described how to successfully import XML files
into an APEX application and gave some basic information about the analyzing of xml data
It's time for another example. This time we want to get all detail elements of a master element in one row.
Example XML data:
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<team name="SG Dynamo Dresden" league="3. Liga"/>
<team name="RB Leipzig" league="2. Liga"/>
For a couple of years now webdesigners and developers don't use image icons anymore, instead we moved to scalable vector icons.
Before you had to create different images for the different formats and colours you wanted. Then to gain performance we created one big image with all those smaller images in it (called a sprite).
Next with some CSS we showed a part of the bigger image. A hassle...
In fact the evolution of using (more...)
In 2015 most APEX-only conferences are scheduled in history. I definitely recommend to attend at least one of the conferences as it's a great time to meet other people, industry experts and the APEX Development Team.
You'll find me at following conferences:25-MAR-2015: APEX World - Rotterdam, the Netherlands
Every year a hit - and this year extra special as it will be at a different location - the beautiful SS Rotterdam. It's not decided (more...)
Completly rewritten new version of APEX Blogging Platform is now released.
Der Umgang mit CONNECT BY ist für mich immer wieder ein Highlight. Ob Positiv oder Negativ lasse ich mal außen vor. :)
Unbeachtet meiner Meinung ist es die sinnvollste Lösung um Baum-Verkettungen zu generieren.
Eine Anforderung die ich zuletzt gleich zweimal lösen musste war die Darstellung der finalen Ketten.
Das Ganze war recht einfach mit Hilfe einer analytischen Funktion zu lösen:
Last week I spent 4 days at the annual UK Oracle User Group conference, this time around called Tech14
. It was my first UKOUG
conference in a number of years and I set out with the intention of treating it like an all you can eat buffet of APEX presentations and workshops.
So, what were the APEX highlights of Tech14? Well, I have to start with the presentations given by Joel Kalman
, David Peake (more...)
In my previous post
a couple of days back, I demonstrated a simple Apex demo
pulling dynamic data from the database in the form of a bubble chart. I promised to share the code so here it is.
I'm on a train up to Liverpool for the UK Oracle User Group Tech 14 conference, and decided it's about time for a post showing something I've been working on. I don't post often these days, which I blame on work and family commitments, but is actually just down to pure laziness. Anyhow, I'm feeling in the mood so I'll just get on with it in case the desire to catch some zzz's becomes overwhelming. (more...)
Just checked if the http://www.odtug.com/apex
is available again and it is. It seems the people there are filtering blogs because I don't see my blog post
from yesterday appearing there and I don't understand why. Is that just because I said that the old blog listing was much better? Or this is just another technical problem they have? Am I going to be removed from that blog listing forever if I continue saying (more...)
Die letzten Wochen waren verdammt arbeitsintensiv und es wird bis Weihnachten nicht viel besser werden. Meetings, Telko's, PL/SQL, SQL, APEX alles verpackt in unterschiedlichsten Projekten.
Umso mehr waren die 3 Tage #DOAG2014 eine gute Erholungspause und eine Quelle für neue Motivation und Ideen.
Mein eigener Vortrag zum Thema "Dynamisches Arbeiten mit Grafiken in APEX" kam sehr gut an und zeigt einmal mehr das APEX Enthusiasten auch am letzten Tag 09:00 Uhr bereit sind sich weiterzuentwickeln. (more...)