Oracle Apex - (Cross) Conditional Formatting/Navigation

About

The conditions in Oracle Apex applies to an object. An object as an item may represent a collection of value (ie a column value of a row). When you want to apply a condition only on this value (row), you cannot use the standard conditions feature.

For instance, n a report, you may want conditionally:

  • to show/hide a column,
  • change the color of a value that depends of the value of an other column (Cross Condition)
  • … etc

The key concept in this technique is to manage the conditional part in a SQL statement (with a CASE WHEN statement for instance) and use the returned conditional value to format the output with CSS property applied to HTML.

Example

The link below will be shown only if the Status is 'Complete'.

Use an integer for your status in place of a text in production code, please

select
case when status <> 'Complete' then  'none' else 'initial' end as display_link,
case when status <> 'Complete' then id else null end as bop_id
from
myTable;

_


Powered by ComboStrap