Table control
The table control is a container with the basic layout elements of a table window, including a toolbar with filter and search functionality and icons for previous and next row and page. You can place a table control within a section, tab, or window control and you can place a table column control or a section control within a table control.
The table control layout also includes a table column control and a details box where you can enter a section. The table control is similar to the table window in the List tab of most applications. The tables enable the user to search for and display records from one or more tables in a columnar format. You can use the standard filter feature to display only records that meet specified criteria.
You can insert a section control into the details section of a table control. The details section is an empty, rectangular box at the bottom of the window.
General properties
Attribute name | Description |
---|---|
Control ID | Each control in a presentation is assigned a unique Control ID that is read-only. |
Label | Enter a text value for the label. This
label is specific to the application and is not stored in the |
Input Mode | Input mode options are:
|
Select Mode | The select mode controls whether a table shows a single record or multiple records. |
Bean Class | You can specify the name of a data bean class to use when creating the data source for the control. If not defined and the control is creating a data source, the default psdi.webclient.system.DataBean class is used. Typically, you use this property to create custom event methods or to override the manner in which the data source obtains its MboSet. |
Order By | You can specify the order in which a SQL query fetches data for the data source for this control. |
Data Source ID | Specify a data source ID if you want this
control to use a different data source than the parent. If the control
is creating a data source and the Data Source ID property is not
set, the ID defaults to the ID of the control. If the data source
is blank, the control inherits the data source from the parent. If
no parent controls have a data source specified or if the parent is
the application, Each application
has a presentation file that defines the main MBO for the application,
the |
Business Object | Specify the name of a MBO in this field to determine which MBO the control uses to show and process information. If a MBO is not specified, the control uses the data source of its parent control. When you set a MBO for this control a data source is created that can be referenced from other controls. |
Parent Data Source ID | You can specify the ID of a data source to use as the parent object for a relationship, or to specify a parent object for a bean class if necessary. Then specify the relationship that uses this parent in the Relationship field. If the field is left blank, the control uses the data source ID of its parent control as the Parent Data Source ID |
Relationship | If you specified a value in the Parent Data Source ID field, specify a value in this field that identifies the relationship between this control and the new data source. A relationship uses a WHERE clause to determine what to show and process from the data source. The control creates a datasource that is by default used by the child controls. You can search for relationship values in the tab. |
Width | Specify a number to change the default width of the table. The default width for a table is 1000. You can decrease the width of a table to 400®, the minimum width required to maintain the contents of the toolbar, including the table title and icons. |
Description | Text in this field displays under the label in the title bar of the table. |
Title Attributes | Reserved for future use. |
Start Empty | If you select this option, the table always opens without displaying records. If you do not select the option (the default), the table automatically shows records that match the search query when opened. |
Filterable | If you select this option, a filter row is provided to enable the user to search the table. The Filterable property is enabled by default and the setting automatically applies to table columns in the table. This option must be selected if you want to use the Filter Expanded property. |
Collapsed | If you select this check box, the section is collapsed by default in the user interface and the user must click to maximize the section. |
Advanced properties
Attribute name | Description |
---|---|
Collapsed Empty Label | You can specify a value that will override the table title (label property) when the table is collapsed and empty. |
Collapsed Label | You can specify a value that will override the table title (label property) when the table is collapsed. |
Parent Empty Label | If this table is a child of a parent table, and that table is empty, this value overrides the title of the parent table. |
Row Details Expanded | Select this check box if you want a table to display the expanded detail sections for each record in the table. The default setting is not to expand the detail sections for a table row. |
Application Restrictions | Enter a Where Clause that filters information displayed in the table. If you enter a restriction, it modifies the overall Where Clause for the application. You cannot change the restriction at runtime. |
Listeners | Enter the ID or IDs of one or more data sources that you want to refresh whenever there are changes to this control. Listener controls can be located anywhere within the application. Separate multiple values with a comma. |
Signature Option |
You can specify a signature option that can restrict access to this control or change the properties of this control based on a condition that you specify. To create a signature option, click Add/Modify Signature Options in the Select Action menu. To specify a condition, click the Configure Conditional Properties button. |
Sig Option Data Source ID |
An MBO must be used to evaluate whether or not a user has access to a signature option. Specify the value of the data source that performs this evaluation if it is different to the data source that is configured for this control. |