Create the properties

  1. Complete the following fields.
    If, after the configuration has been deployed at least once, the user modifies one or more of the fields followed by an asterisk (*), he must create a new object version of the object before he can deploy.

General properties are displayed on the screen independent of the values of other fields in the form.

Name Data Type Type / Max. length Contents
Name (*) All String / 30

Name of the property.

Use the name Filler<Nb> (Filler1, Filler2...) to represent a placeholder in the output structure for properties that might be added in future versions of a given Object Type. They will be ignored when building the list of available columns for a query.

Type (*) All String / 8 Type of the property
Description All String / 250 Short description of the property
Mandatory All String / 1
  • Yes: the property must be filled.
    A checkValue is automatically added for the field.
  • No: the property is not mandatory.
  1. Complete the additional fields.
Name Type Type / Max. length Contents
Inherits All except Filler String / 30

Properties of parent Element or Object.

The current property value will be the same value as the one specified in the parent.

At export time, the parent property value is written in the file. This mechanism is used to handle flat files that link Elements and Element parent by repeating the parent identifiers on the children Elements.

When you declare inherited properties, you do not have to maintain duplicated values. Modifications are only applied on the parent property.

Property separator All except Filler and String String / 1

Used only in case of import/export as a Variable Flat file

Character that specifies the delimiter that must be used after the property value during import and export.

If no value is provided, the default writer separator is used instead.

Variable (*) All except Filler String / 1
  • Yes: Check this box if this property is a variable property, that is a property that is neither imported nor exported but only used internally.
  • Example: Variables can be used to store intermediate computation results for edition purposes.
  • No: Otherwise
DB Column name All except Filler String / 30 Name of the column of the Database Table used to store the property values.
Key All except Filler String / 1

Check this box if this property is a key property.

A key is an ordered set of properties of the same Business Object Type or Element Type that must have no empty values and be unique.

Restrictions:

  • Only on single key can be defined per scope on a Business Object Type or an Element Type.
  • Inherited and computed properties cannot be used in a key.
  • A property cannot be a part of both a local and a global key.
  • A property cannot be both a sequence and a part of a key.

Possible values are:

  • No - the property is not a member of the key.
  • Local - the property is a member of the local key.
  • Global - the property is a member of the global key.

The constraint on the key is checked when a Business Object or an Element is:

  • Created
  • Duplicated, copied, moved
  • Modified
  • Saved
  • Imported via a CSV import
Generated Integer, Long, String String / 1 If is set when duplicate, create, copy or move actions are performed, this property will be modified in order to maintain the uniqueness constraint.
Identifier String String / 1 If is set, the value of this property should have an identifier form.
Sequence Integer or Long String / 1

Check this box if this property is a sequence property.

If a business property is a sequence, its value is generated on each created Business Object or Element (created or imported from CSV/Excel).

The scope of the sequence is always local.

Restrictions:

  • A property that is part of a key or unique cannot be a sequence.

  • Inherited and computed properties cannot be sequences.

CSV import

If the input file:

  • contains the column that corresponds to the sequence property, the sequence values from the file are imported as they are.
  • does not contain the column that corresponds to the sequence property: new sequence values are generated for each imported line.

Criterion (*) All except Filler String / 1

If true, the property will be indexed in the Datastore.

It is required to define each inherited Porperty Type as criteria.

 

  1. For computed properties, complete the additional fields.
Name Type / Max. length Contents
Operation String / 10

Name of the operation that is applied on the children objects: Elements for Business Objects:

  • sum: sum of the values of the children objects for the target property
  • avg: average of the values of the children objects for the target property
  • count: number of children objects
  • max: maximum value of the children objects for the target property
  • min: minimum value of the children objects for the target property
  • list: list of values of the children objects for the target property. The number of stored values depends on the maximum number of characters set to the computed field.
  • any: value of any child for the target property
Target path String / 100

Name of the selected child type: Element Type for the Object Types

Target property String /30

Name of the child type property on which the operation must be performed.

Filter String / 500

Filter that selects the children objects to take into consideration for the operation.

The expression is composed of a conjunction or a disjunction of tests where each test is expressed as <property> <operator> <value>.

<property> corresponds to the system and user properties of the objects on which the filter is applied: Collection or Object.

Possible operators are:

  • is null, not null
  • like, not like
  • =, !=, >, <, >=, <=
  • in { <v1> , <v2>}

Values must be written between double quotes.

Example: DIRECTION="D"

Related Links