Oracle Apex: Using Server-Side Conditions

In Oracle Apex, server-side conditions execute at the time of page initialization. You can use the server-side condition for objects such as items, regions, buttons, processes and for dynamic actions. If you have used applied a server-side condition, then the object will not appear if the condition does not evaluate to true.

Here I am giving the details of the most used types of server-side conditions available in Oracle Apex.

Server-Side Conditions in Oracle Apex

  • Rows returned: You need to specify an SQL query if you choose this option. And the object will be processed or rendered only if the query will return at least one row.
  • No Rows returned: The object will be processed if the SQL returns no rows.
  • SQL Expression: The SQL expression evaluates to TRUE.
  • PL/SQL Expression: The PL/SQL expression evaluates to TRUE. For example, Substr(:P2_ACCOUNT_TYPE, 1, 2) = 'DR'.
  • PL/SQL Function Body: The PL/SQL function body returns TRUE. For example:
Begin
    If :P3_STATUS = 'A' then
       Return True;
    else
       Return False;
    End if;
End;
  • Request = Value: The page request is equal to the text you enter into the Value attribute.
  • Request != Value: The page request is not equal to the text you enter into the Value attribute.
  • The request is contained in Value: The page request is contained in the text you enter into the Value attribute. Mostly we use this condition for buttons and specify the button names in the Value attribute.

Oracle Apex - server-side conditions.

  • The request is NOT contained in Value: The page request is not contained in the text you enter into the Value attribute.
  • Item = Value: The value of the selected Item is equal to the text you enter into the Value attribute.
  • Item != Value: The value of the selected Item is not equal to the text you enter into the Value attribute.
  • Item is NULL: The value of the selected Item is empty.
  • Item is NOT NULL: The value of the selected Item is not empty.
  • Item is zero: The value of the selected Item is the number zero.
  • Item is NOT zero: The value of the selected item is not the number zero.
  • Item is NULL or zero: The value of the selected Item is empty or the number zero.
  • Item is NOT NULL and NOT zero: The value of the selected Item is not empty and not the number zero.
  • Item contains no spaces: The value of the selected Item has no spaces.
  • Item is numeric: The value of the selected Item is numeric.
  • Item is NOT numeric: The value of the selected Item is not numeric.
  • Item is alphanumeric: The value of the selected Item is alphanumeric, containing only letters or numbers and no special characters.
  • Item is in the colon-delimited list: The value of the selected Item is completely contained in the text you enter into the Value attribute. Specify the value separated by colons (:). For example ABC:XYZ.
  • Item is NOT in the colon-delimited list: The value of the selected Item is not completely contained in the text you entered into the Value attribute.

Related Tutorials:

Vinish Kapoor
Vinish Kapoor

Vinish Kapoor is a seasoned software development professional and a fervent enthusiast of artificial intelligence (AI). His impressive career spans over 20 years, marked by a relentless pursuit of innovation and excellence in the field of information technology. As an Oracle ACE, Vinish has distinguished himself as a leading expert in Oracle technologies, a title awarded to individuals who have demonstrated their deep commitment, leadership, and expertise in the Oracle community.

7 Comments

  1. Thank you. This is perfect and the function sql is excellent as it allows one to simulate ITEM IS NULL for example and add other rules for display or not.

    • Hi David , I need Update Item "UPDATED_USER" only when Button Save , NO Create, How use this feature??

  2. Hello I hope you can help me, when I place the request for the server side condition it does not execute as expected, some observation of how it should work, my application is in apex 20.2

  3. Thanks for your post. I have created a report and a 'Submit' button. I set the serverside condition on Report region- Request = Submit. When I press the Submit button, the report not coming up. Please help

Comments are closed.