Cloud Software Group, Inc. EBX®
Documentation > User Guide > Data models > Implementing data models
Navigation modeDocumentation > User Guide > Data models > Implementing data models

Properties of data model elements

After the initial creation of an element, you can set additional properties in order to complete its definition.

Basic element properties

Common basic properties

The following basic properties are shared by several types of elements:

Information

Additional non-internationalized information associated with the element.

Minimum number of values

Minimum number of values for an element.

As primary keys cannot be multi-valued, they must have this property set to '1' or 'undefined'. The minimum number of values is automatically set to '0' when defining the field as a selection node.

Maximum number of values

Maximum number of values for an element. When set to a value greater than '1', the element becomes multi-valued.

As primary keys cannot be multi-valued, they must have this property set to '1' or 'undefined'.

For tables, the maximum number of values is automatically set to 'unbounded' upon creation. The maximum number of values is automatically set to '0' when defining the field as a selection node.

Validation rules

This property is available for tables and fields in tables except Password fields, reusable types, fields in complex reusable types, and selection nodes. Used to define powerful and complex validation rules with the help of the provided XPath 1.0 criteria editor.

See Criteria editor for more information.

This can be useful if the validation of the value depends on complex criteria or on the value of other fields.

It is also possible to indicate that a rule defines a verification for a value that is mandatory under certain circumstances. In this case a value is mandatory if the rule is not satisfied. See Constraint on 'null' values for more information.

Using the associated wizard, you can define localized labels for the validation rule, as well as define a localized message with severity to be displayed if the criteria is not met.

When defining the severity of the validation message it is possible to indicate whether an input that would violate a validation rule will be rejected or not when submitting a form. The error management policy is only available on validation rules defined on a field and when the severity is set to 'error'. If the validation rule must remain valid, then any input that would violate the rule will be rejected and the values will remain unchanged. If errors are allowed, then any input that would violate the rule will be accepted and the values will change. If not specified, the validation rule always blocks errors upon the form submission by default.

If a validation rule is defined on a table, it will be considered as a 'constraint on table' and each record of the table will be evaluated against it at runtime. See Constraints on table for more information.

Basic properties for fields

The following basic properties are specific to fields:

Default value

Default value assigned to this field. In new data creation forms, the default value appears automatically in the user input field. The default value must comply with the defined type of the field.

See Default value for more information.

Conversion error message

Internationalized messages to display to users when they enter a value that is invalid for the data type of this field.

Computation rule

This property is available for fields in tables, except in reusable types. Defines a rule for computing the value of the field using the provided XPath 1.0 editor.

See criteria editor

This can be useful if the value depends on other values in the same record, but does not require a programmatic computation.

The following limitations exist for computation rules:

  • Computation rules can only be defined on simple fields inside a table.

  • Computation rules cannot be defined on fields of type OResource or Password.

  • Computation rules cannot be defined on selection nodes and primary key fields.

  • Computation rules cannot be defined when accessing an element from the validation report.

Advanced element properties

Common advanced properties

The following advanced properties are shared by several types of elements:

Default view and tools > Visibility

Specifies whether or not this element is shown in the default view of a dataset, in the text search of a dataset or in the data service "select" operation.

  • Model-driven view

    Specifies whether or not the current element is shown in the default tabular view of a table, the default record form of a table, and in the default view of a dataset if the current element is a table.
    Default dataset view, tabular view and default record form generated from the structure of the data model.
    If the current element is inside a table, then setting the property to 'Hidden' will hide the element from the default tabular view and default record form of the table without having to define specific access permissions. Current element will still be displayed in the view configuration wizard to be able to create a custom view that displays this element.
    If the current element is a table, then setting the property to 'Hidden' will hide the table from the default view of a dataset without having to define specific access permissions.
    This property is ignored if it is set on an element that is neither a table nor in a table.

  • All views

    Specifies whether or not the current element is shown in all views of a table in a dataset.
    Setting the property to 'Hidden in all views' will hide the element in all views of the table, whether tabular (default tabular view included) or hierarchical, without having to define specific access permissions. The current element will also be hidden in the view configuration wizard. That is, it won't be possible to create a custom view that will display this element.
    This property is ignored if it is set on an element that is not in a table.
    This property is not applied on forms. That is, setting the property to 'Hidden in all views' will not hide the element in a record form but only in views.

  • Structured search tool

    Specifies whether or not the current element is shown in a dataset structured search tool.
    Setting the property to 'Hidden in structured search' will hide the element in the structured search tool of a dataset. The element will remain searchable in the quick search tool. This property is ignored if it is set on an element that is not in a table.

  • Quick search

    Specifies whether or not the current element is included in the quick search tool.
    Setting the property to 'Excluded from Quick search' will exclude the element in the quick search tool of a dataset. The element will remain searchable in the structured search tool. This property is ignored if it is set on an element that is not in a table.

  • Data services

    Specifies whether or not the current element is shown in the data service select operation.
    Setting the property to 'Excluded from Data Services' will hide the element in the data service "select" operation.
    This property is ignored if it is set on an element that is not in a table.

See Default view in the Developer Guide.

Default view and tools > Widget

Defines the widget to be used. A widget is an input component that is displayed in forms in associated datasets.
If undefined, a default widget is displayed in associated datasets according to the type and properties of the current element.
It is possible to use a built-in widget or a custom widget. A custom widget is defined using a Java API to allow the development of rich user interface components for fields or groups.
Built-in and custom widgets cannot be defined on a table or an association.
It is forbidden to define both a custom widget and a UI bean.
It is forbidden to define on a foreign key field both a custom widget and a combo-box selector.

See UIWidgetFactory for more information.

Default view and tools > Combo-box selector

Specifies the name of the published view that will be used in the combo-box selection of the foreign key.
A selection button will be displayed at the bottom right corner of the drop-down list. When defining a foreign key, this feature allows accessing an advanced selection view through the 'Selector' button that opens the advanced selection view, from where sorting and searching options can be used.
If no published view is defined, the advanced selection view will be disabled.
If the path of the referenced table is absolute then only the published views corresponding to this table will be displayed. If the path of the referenced table is relative then all the published views associated with the data model containing the target table will be displayed. This property can only be set if no custom widget is defined.

See Defining a view for the combo box selector of a foreign key in the Developer Guide.

UI bean

Attention

From version TIBCO EBX® 5.8.0, it is recommended to use widgets instead of UI Beans. Widgets provide more features than UI Beans, and no further evolution will be made on UI beans. See widget for more information.

This property is available for all elements except tables and associations. Specifies a Java class to customize the user interface associated with this element in a dataset. A UI bean can display the element differently and/or modify its value by extending the UIBeanEditor class in the Java API.

Transformation on export

This property is available for fields and for groups that are terminal nodes. Specifies a Java class that defines transformation operations to be performed when exporting an associated dataset as an archive. The input of the transformation is the value of this element.

See NodeDataTransformer for more information.

Access properties

Defines the access mode for the current element, that is, if its data can be read and/or written.

  • 'Read & Write' corresponds to the mode RW in the data model XSD.

  • 'Read only' corresponds to the mode R- in the data model XSD.

  • 'Not a dataset node' corresponds to the mode CC in the data model XSD.

  • 'Non-terminal node' corresponds to the mode -- in the data model XSD.

See Access properties in the Developer Guide.

Comparison mode

Defines the comparison mode associated with the element, which controls how its differences are detected in a dataset.

  • 'Default' means the element is visible when comparing associated data.

  • 'Ignored' implies that no changes will be detected when comparing two versions of modified content (records or datasets).

    During a merge, the data values of ignored elements are not merged even if the content has been modified. However, values of ignored data sets or records being created during the operation are merged.

    During an archive import, values of ignored elements are not imported when the content has been modified. However, values of ignored datasets or records being created during the operation are imported.

See Comparison mode in the Developer Guide.

Apply last modifications policy

Defines if this element must be excluded from the service allowing to apply the last modifications that have been performed on a record to the other records of the same table.

  • 'Default' means that the last modification on this element can be applied to other records.

  • 'Ignored' implies that the last modification on this element cannot be applied to other records. This element will not be visible in the apply last modifications service.

See Apply last modifications policy in the Developer Guide.

Node category

Defines a category for this element. Categories allow controlling the visibility of data in a dataset to users. A node with the category 'Hidden' is hidden by default. Restriction: category specifications other than 'Hidden' do not apply to table record nodes.

See Categories in the Developer Guide.

Advanced properties for fields

The following advanced properties are specific to fields.

Check null input

Implements the property osd:checkNullInput. This property is used to activate and check a constraint on null at user input time.

By default, in order to allow for temporarily incomplete input, the check for mandatory elements is not performed upon user input, but only upon dataset validation. If a mandatory element must be checked immediately upon user input, set this property to 'true'.

Note

A value is considered mandatory if the 'Minimum number of values' property is set to '1' or greater. For terminal elements, mandatory values are only checked in activated datasets. For non-terminal elements, the values are checked regardless of whether the dataset is activated.

See Constraints, triggers and functions in the Developer Guide.

Trim whitespaces

Trim white spaces

Implements the property osd:trim. This property is used to indicate whether leading and trailing white spaces must be trimmed upon user input. If this property is not set, leading and trailing white spaces are removed upon user input.

See Whitespace handling upon user input in the Developer Guide.

UI bean

See Common advanced properties.

Function (computed value)

This property is available for non-primary key fields. Specifies a Java class that computes the value of this field programmatically. This can be useful if the value of the field depends on other values in the repository, or if the computation of the value needs to retrieve data from a third-party system.

A function can be created by implementing the ValueFunction interface.

Disable validation

Specifies if the constraints defined on the field must be disabled. This property can only be defined on function fields. If true, cardinalities, simple and advanced constraints defined on the field won't be checked when validating associated datasets.

Transformation on export

See Common advanced properties.

Access properties

See Common advanced properties.

Auto-increment

This property is only available for fields of type 'Integer' that are contained in a table. When set, the value of the field is automatically calculated when a new record is created. This can be useful for primary keys, as it generates a unique identifier for each record. Two attributes can be specified:

Start value

Value with which to begin the auto-increment. If this attribute is not specified, the default value is '1'.

Increment step

Amount the value is incremented based on the previous value of the auto-increment. If this attribute is not specified, the default is value is '1'.

Disable auto-increment checks

Specifies whether to disable the check of the auto-incremented field value in associated datasets against the maximum value in the table being updated.

Auto-incremented values have the following behavior:

See Auto-incremented values in the Developer Guide.

Default view

See Common advanced properties.

Node category

See Common advanced properties.

Inherited field

Defines a relationship from the current field to a field in another table in order to automatically fetch its field value.

Source record

A foreign key or white space-separated sequence of foreign keys that leads from the current element to the record from which to inherit this field's value. If this property is not specified, the current record is used as the source record for the inheritance.

Source element

XPath of the element in the source record from which to inherit this field's value. The source element must be terminal, belong to the record described by 'Source record', and its type must match the type of this field. This property is mandatory when using field inheritance.

See inheritance in the glossary.

For more information, see also Inherited fields.

Advanced properties for tables

The following advanced properties are specific to tables.

Table

Primary key

A list of fields in the table that compose the table's primary key. You can add or remove primary key fields here, as in the 'Data structure' view.

Each primary key field is denoted by its absolute XPath notation that starts under the table's root element.

If there are several elements in the primary key, the list is white-space delimited. For example, "/name /startDate".

Presentation

Specifies how records are displayed in the user interface of this table in a dataset.

Presentation > Record labeling

Defines the fields to provide the default and localized labels for records in the table.

Can also specify a Java class to set the label programmatically, or set the label in a hierarchy. This Java class must implement either the UILabelRenderer interface or the UILabelRendererForHierarchy interface.

Attention: Access rights defined on associated datasets are not applied when displaying record labels.
Fields that are usually hidden due to access rights restrictions will be displayed in labels.

Presentation > Default rendering for groups in forms

Specifies the default display rendering mode of the groups contained in this table. If nothing is defined here, the default policy set in the Administration area will be used to display groups.

See Record form: rendering mode for nodes in the Administration Guide.

Enabled rendering for groups

Specifies a display rendering mode to be enabled for groups in the table in addition to the modes 'expanded' and 'collapsed', which are always available. Tabs must be enabled on the table to have the option to display groups as tabs. Similarly, links must be enabled to have the option to display groups as links.

Default rendering for groups

Specifies the default display rendering mode to use for the groups contained in this table. If a group does not specify a default mode then the default mode defined for this table will be used. Links must be enabled to define the default rendering mode as 'Link'. Select a rendering mode according to network and browser performance. Link mode is lighter as its content is not displayed on the same page, whereas the expanded and collapsed modes are heavier.

Note: When the tabs view is enabled on a table, any groups that would otherwise have used links are automatically converted to collapsed mode. This is done to avoid the inherent display layout complexities that would arise from links and tabs coexisting in the same user interface.

Presentation > Specific rendering of forms

Defines a specific rendering for customizing the record form in a dataset.

See UIForm and UserServiceRecordFormFactory for more information.

Toolbars

Defines the toolbars to use in this table.

Toolbars can be edited in the Configuration > Toolbars section.

Tabular view top: Defines the toolbar to use on top of the default table view.

Tabular view row: Defines the toolbar to use on each row of the default table view.

Tile view item: Defines the toolbar to use on each item of the tile view.

Record top: Defines the toolbar to use in the record form.

Hierarchy top: Defines the toolbar to use in the default hierarchy view of the table.

See Toolbars for more information.

History

Specifies when historization is to be performed, and the level of guarantee requested. The available history profiles can be edited in Administration > History and logs.

See History configuration in the repository for more information.

Specific filters

Defines record display filters on the table.

Actions

Specifies the actions that are allowed on the table in associated datasets. By default, all actions are allowed unless specific access rights are defined in a dataset.

Uniqueness constraints

Indicates which fields or set of fields must be unique across the table.

Triggers

Specifies Java classes that defines methods to be automatically executed when modifications are performed on the table, such as record creation, updates, deletion, etc.

A built-in trigger for starting data workflows is included by default.

A built-in trigger to define a script for a trigger is also included by default.

See Triggers in the Developer Guide.

Access properties

See Common advanced properties.

Default view

See Common advanced properties.

Node category

See Common advanced properties.

Advanced properties for groups

The following advanced properties are specific to groups.

Value container class (JavaBean)

Specifies a Java class to hold the values of the children of this group. The Java class must conform to the JavaBean standard protocol. That is, each child of the group must correspond to a JavaBean property in the class, and all properties must have getter and setter accessors defined.

UI bean

See Common advanced properties.

Transformation on export

See Common advanced properties.

Access properties

See Common advanced properties.

Default view

Visibility

See Common advanced properties.

Rendering in forms

Defines the rendering mode of this group. If this property is not set, then the default view for groups specified by the container table will be used. 'Tab' and 'Link' are each only available when the container table enables it.

Tab position

This attribute specifies the position of the tab with respect to all the tabs defined in the model. This position is used for determining tab order. If a position is not specified, the tab will be displayed according to the position of the group in the data model.

Node category

See Common advanced properties.

/ebx_search.png User guide table of contents

Documentation > User Guide > Data models > Implementing data models