8.8.2 Supported Columns in Interactive Grids

Learn about column types supported by interactive grids.

Interactive grids support the following built-in column types. Depending on your application configuration, you may also have additional column type plug-ins available here. These display as <My Plug-in> [Plug-in]. To view the column type in Page Designer, select the column and find the Identification, Type attribute in the Property Editor.

Note:

You can also view this information in Page Designer Help. View the page containing the report in Page Designer. Select a column and then the Identification, Type attribute. Click the Help tab in the central pane.
Column Type Description

Actions Menu

Displays the Row Actions menu on each row of the interactive grid. Depending on the grid attributes and end user authorizations, the Row Actions menu includes options such as Single Row View, Add Row, Delete Row, and Refresh Row, and so on. These menu options enable end users to perform specific actions on the current row in the grid.

The Row Actions menu can be used in both editable and non-editable interactive grids, but the menu options differ slightly. For non-editable interactive grids, the Row Actions menu has a subset of options, for example Single Row View and Refresh Row, and does not include editable actions like Add Row, Delete Row and so on.

When an interactive grid is editable, the APEX$ROW_ACTION column is automatically added and set to a type of Actions Menu. For non-editable interactive grids, this column must be added manually.

Checkbox

Displays a single checkbox that the user can check or uncheck. The defined checked or unchecked value is stored in session state when submitted.

Checkbox Group

Displays multiple values as check boxes, enabling the end user to select multiple values. A list of values is required for items displayed as check boxes. The values corresponding to the checked boxes are stored in a single colon-delimited string.

Color Picker

Enables users to choose or enter a color. Colors can be selected from a color spectrum.

Date Picker

Enables users to enter a date. You can either use a text field that opens a date picker as a popup, or you can use an inline or native date picker.

Display Only

Displays a non-enterable text item.

Hidden

Items that are included within the page source but are not rendered. Hidden item values are saved in session state. They are generally used to store values required by page processing or other page items, but are not displayed to the end user.

HTML Expression

Displays a non-enterable item based on a HTML expression.

Link

Displays a non-enterable item as a link.

Markdown Editor

Displays a text area supporting markdown input, with text formatting options, support for including images, and a preview option to view the formatted text. The Markdown Editor enables you to write using easy-to-read, easy-to-write plain text, then convert it to structurally valid HTML using the various options provided and supported syntax.

Number Field

Displays a number field. This item type automatically validates that the value is a number.

Password

Displays an HTML password form element. As the end user enters text a black dot is displayed for that character instead of the actual character entered.

Percent Graph

Displays the value as a percentage graph. The value retrieved must be between 0 and 100.

Popup LOV

Displays a text item with a popup list of values icon. When the end user clicks the icon, a popup window appears with a search field and a list of supported values.

Popup LOV is best suited for large lists since end users can enter search criteria to reduce the available values displayed. For relatively small lists, a Select List is often better choice.

Radio Group

Displays multiple values as radio group options, enabling the end user to select a single value.

Rich Text Editor

Displays a rich text editor with comprehensive text formatting options. End users can enhance the content displayed in a similar fashion to using a word processor, such as Microsoft Word.

Row Selector

Displays a check box on each row of an interactive grid, enabling the selection of specific row(s) for row manipulation.

By default the APEX$ROW_SELECTOR column is set to a type of Row Selector. This column is automatically added when the interactive grid is made editable.

Select List

Displays an item with a built-in list of values selector. When the end user clicks the item, the list of supported values displays directly inline with the current item.

Select List is best suited for relatively small, discrete lists. End users can very quickly select a value from the list without needing to change focus to a popup dialog. For large lists, a Popup LOV is often a better choice.

Shuttle

Displays as a multiple select list that includes two boxes containing lists. The left list displays the source list of values that have not been selected and the right list shows the currently selected values. End users can select one or more values in a list then use the shuttle controls to move the selected values or all values.

The current values are stored in a single colon-delimited string.

Star Rating

Displays a numeric value as a number of stars or other icons. The end user can change the value by selecting the desired number of stars. The value can be adjusted by clicking the number of stars with the mouse or by using the keyboard.

The icon to be displayed, the background and foreground colors can be adjusted either in the component settings or in the individual item settings. To use individual items and colors, set the attribute Use Component Defaults to No.

As icons, you may use any icon from the Icon Font available in your application. For Universal Theme applications, use an icon from the Font APEX library. See Accessing Font APEX.

Switch

Displays as a flip toggle switch.

Text Field

Displays a text field.

Text Field with autocomplete

Displays a text field that displays a list of possible values, based on the text already entered by the end user, inline with the text item. The list is further refined as the end user types in more text.

Textarea

Displays a multiple-row text area.