Learn about conditions available in App Builder.
A condition is a small unit of logic that helps developers control the display of regions, items, buttons, and tabs as well execute processes, computations and validations. When you apply a condition to a control or component, the condition is evaluated. Whether a condition passes or fails determines whether a control or component displays, or page processing executes.
You can specify conditions by selecting a condition type when you create the control (region, button, or item) or component (tab, list, or navigation bar), or by making a selection under the condition attribute.
See Also:
"Understanding Conditional Rendering and Processing" and "Conditions Available in App Builder"
Parent topic: Available Conditions
The following table describes many App Builder conditions. To view a complete listing of all available conditions for a given control or component, expand the condition type list.
Table C-1 Available Conditions
| Condition | Description |
|---|---|
|
Rows returned |
The SQL query returns one or more rows. |
|
No Rows returned |
The SQL Query returns no rows |
|
SQL Expression |
The SQL expression evaluates to TRUE. |
|
PLSQL Expression |
The SQL expression evaluates to TRUE. |
|
PL/SQL Function Body |
The PL/SQL function body returns TRUE. |
|
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. |
|
Request is contained in Value |
The page request is contained in the text you enter into the Value attribute. |
|
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 colon delimited list |
The value of the selected item is completely contained in the text you enter into the Value attribute. |
|
Item is NOT in colon delimited list |
The value of the selected Item is not completely contained in the text you entered into the Value attribute. |
|
User Preference = Value |
The value of the Preference entered is equal to the text you enter into the Value attribute. |
|
User Preference != Value |
The value of the Preference entered is not equal to the text you enter into the Value attribute. |
|
Current Page = Page |
The current page is equal to the value you enter into Page. |
|
Current Page != Page |
The current page is not equal to the value you enter into Page. |
|
Current Page is in comma delimited list |
The current page is in the comma separated list you enter into Pages. |
|
Current Page is NOT in comma delimited list |
The current page is not in the comma separated list you enter into Pages. |
|
Current page is in Printer Friendly mode |
The current page has been toggled to 'Printer Friendly Mode' by the end user. |
|
Current page is NOT in Printer Friendly mode |
The current page has not been toggled to 'Printer Friendly Mode' by the end user. |
|
Page/Region is Read Only |
Either the page or parent region, if appropriate, 'Read Only' condition evaluates to TRUE. |
|
Page/Region is NOT Read Only |
The page and parent region, if appropriate, are displayed normally. |
|
User is authenticated (not public) |
The end user is logged into the application. See Also: "Establishing User Identity Through Authentication" for information about authentication |
|
User is the public user (user has not authenticated) |
The end user is not logged into the application. |
|
Inline Validation Errors Displayed |
An inline validation error is displayed on the page, following a page submission. |
|
Inline Validation Errors NOT displayed |
An inline validation error is not displayed on the page. |
|
Current Language = Value |
The end user is currently running the application in the language you enter into the Value attribute. |
|
Current Language != Value |
The end user is not currently running the application in the language you enter into the Value attribute. |
|
Current Language is contained in Value |
The end user is currently running the application in one of the languages you enter into the Value attribute. |
|
Current Language is NOT contained in Value |
The end user is not currently running the application in one of the languages you enter into the Value attribute. |
|
Never |
The component is never rendered. Note: Changing a condition to Never will remove any existing condition. For temporarily disabling a component, Oracle recommends using the Build Option attribute. |
Parent topic: Available Conditions