Oracle Apex - (Form|Page) (Field|Item)

Card Puncher Data Processing

About

An item (also called a field) is a HTML form elements such as text fields, select lists, and check boxes.

Every item has a session state value that can be referenced by a variable.

Variable

Name

Item names must:

  • Be unique within an application.
  • Not include quotation marks.
  • Begin with a letter or a number, and subsequent characters can be letters, numbers, or underscore characters.
  • Be case-insensitive.
  • Should not exceed 30 characters. Items longer than 30 characters cannot be referenced using bind variable syntax.
  • Cannot contain letters outside the base ASCII character set

By default, wizards prefix page item names with:

P<page no>_<item name>

Default

The default attribute on the Edit Page Item page. The default value is used when the item's value is not derived from session state and when the source value is NULL.

Source

Post Calculation Computation Example:

initcap(:P10_MY_ITEM); 

Attributes

Item attributes affect the display of items on a page.

For example, these attributes can impact:

  • where a label displays,
  • how large an item is,
  • and if the item displays next to or below the previous item.

List of attributes

Attributes Description
Sequence Specify the display sequence for this component. The sequence determines the order of evaluation.
Prompt Enter the label for this HTML form element. You may include HTML, JavaScript, and shortcuts. You can also use the substitution string #CURRENT_ITEM_NAME# to obtain the name of the item associated with this label.
Field Template Determines the label template. Label templates enable you to define the user interface attributes in a central place and share that definition among many labels.
Region Defines the region in which the item displays. All items must be in a region.
New Line Determines whether this item displays on the same line as the previous item or whether it displays on the next line. Items are laid out in an HTML table. Select Yes to have an item display as the first field in a new row in the table.
New Field If set to Yes, this item is rendered into its own HTML table cell which is the default. If set to No, the item is rendered into the same HTML table cell as the previous page item. Note that rendering into the same table cell looks more attached to the previous page item.
Width Specifies the length (in characters) of the form element that displays for this item.
Height Specifies the height (in lines) for text areas and multi select lists.
Column Span Items are laid out in HTML tables. This property defines the value to be used for the COLSPAN attribute in the table cell.
Row Span Items are laid out in HTML tables. The attribute determines the value to be used for the ROWSPAN attribute in the table cell that the item displays in.
Post Element Text or HTML code is rendered immediately after the page item element.

Type

built-in

  • text fields,
  • text areas,
  • password,
  • radio groups,
  • select lists,
  • check boxes,
  • date pickers,
  • and popup list of values

Specific

Developers can create their own custom item types using plug-ins.

Level

There are two types of items:

In the session windows, you can see them:

Oracle Apex Items Type

Page

Page items are placed on a page and have associated user interface properties, such as:

  • Display Only,
  • Label
  • and Label Template.

Examples of page-level items include a check box, date picker, display as text, file browse field, popup list of values, select list, or a text area.

Application

Application items are not associated with a page and therefore have no user interface properties.

Security

Oracle Apex - Security Configuring page item security

Management

Initialization

Oracle Apex - Item (Initialization | Evaluation | Populating | Computation)

Bulk Editing

You can use the Page Items page to edit the sequence, field label, template, region, and overall position for all items on a page.

Scripting

You can use the APEX_ITEM package to create form elements dynamically based on a SQL query instead of creating individual items page by page.





Discover More
Oracle Apex Page Type
Oracle Apex - (Application) page

A page is the basic building block of an database application. Application pages share a common: session state and authentication. Individual pages are organized using containers called regions....
Oracle Apex Cross Conditional Link With Display
Oracle Apex - (Cross) Conditional Formatting/Navigation

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...
Card Puncher Data Processing
Oracle Apex - (Page Rendering|Show Page| HTML Request)

Page rendering is the process of generating an HTML page (from the database) when a page is requested using a URL. This engine process assembles all the page rendering attributes including: regions,...
Card Puncher Data Processing
Oracle Apex - Bind Variable

Bind variables syntax can be used for SQL or PL/SQL to reference session state of a specified item. Items Bind...
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...
Card Puncher Data Processing
Oracle Apex - Form

Forms are made up of fields (called items) stored procedure table or view query web service Master Detail form Tabular (Multiple row update) Summary (read-only form)
Card Puncher Data Processing
Oracle Apex - Item (Initialization | Evaluation | Populating | Computation)

Content on the initialization process of the value of an item (ie session state) The Sequence attribute of an item determines the order of evaluation. See also Simple form populating Page...
Oracle Apex Report Columns Metadata
Oracle Apex - Metadata

The metadata of Oracle Apex are stored in a schema prefixed with APEX. From this schema, you can query the whole application definition: from page to columns APEX_APPLICATION_ALL_AUTH APEX_APPLICATION_AUTH...
Card Puncher Data Processing
Oracle Apex - Plugin

Plug-Ins can create the following custom components: item types, region types, processes and Dynamic Actions. API The APEX_PLUGIN...
Card Puncher Data Processing
Oracle Apex - Region

A region is an area on a page that serves as a container for content. Regions can contain: text, custom PL/SQL, reports, charts, maps, calendars, web service content, or forms....



Share this page:
Follow us:
Task Runner