Oracle Apex - (Cross) Conditional Formatting/Navigation

Card Puncher Data Processing

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;

Oracle Apex Cross Conditional Link With Display





Discover More
Card Puncher Data Processing
Oracle Apex - Condition (Display, Processing)

A condition is a small unit of logic that helps you control: the display of regions, items, buttons, charts, and tabs and the execution of processes, computations, and validations. item (a column)CSSconditional...



Share this page:
Follow us:
Task Runner