Apex 5 Universal Theme – Navigation Experiment #1


The idea was to have a left sidebar menu where all the top level menu entries are always open. The reason is to optimize screen estate and avoid clicks when navigating to some sub menu.

Opening the second level menu entry

The following solution is a cheat. It does not really use a list with two different hierarchy levels. Instead it is using a normal side navigation menu. But the entries on the first level (top level entires) are enhanced with attributes, that will make some entries look more important, than other entries.

Here is the css to do so.

font-size: 1.5em;
line-height: 1.5em;
text-shadow: 2px 2px 4px #000000;
div.FlatHierachie-Item {
font-size: 0.75em;
line-height: 1.5em;

This css will work only if the list template is changed.

Each entry for a top level menu point will get an additional class:



The following fields need to be changed:

  • List Template Current
  • List Template Current with Sublist Items
  • List Template Noncurrent
  • List Template Noncurrent with Sublist Items

The Sublist entries will stay as they were.

Additionally the Navigation list itself needs to be changed.

Each top level list entry will get an additional attribute number 06 set to “Main”.


All second level list entries will get there parent entry removed.
To remain the ordering of the list, it is advisable to RESEQUENCE the list entries first, before removing the parent information.

This is the most manual work to do. Also it is not so easy to get back to the old list, therefore we should first make a copy .

And this is how the result looks like:


Overview about other Experiments

Interactive Reports in Apex 3.1-5.1

Just a short collection of features that were added to Interactive Reports in the different Apex versions.

This is not from a developers perspective but mainly from user experience. It can be used to emphasize upgrading to a more recent apex version.

Apex 3.1

Interactive Reports introduced

Apex 3.2

Apex 4.0

  • Subscriptions
  • Websheets with IRs
  • Row filters

Apex 4.1

  • Public subscriptions

Apex 4.2

  • Group by

Apex 5

  • Pivot
  • frozen headers
  • Multiple IRs on one page
  • enhanced group by

Issues: html tags in headers might give issues. Html tables in columns might give problems with frozen header javascript.

Apex 5.1

  • interactive grid: First impressions look astonishing. Good chance  that they will completely replace interaktive reports.
  • New chart engine (OracleJet)