Create the properties

  1. Complete the following fields.
  2. If, after the configuration has been deployed at least once, you modify one or more of the fields followed by an asterisk (*), you must create a new object version of the object before you can deploy.
  3. General properties are displayed on the screen independent of the values of other fields in the form.
  4. 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
    Computed (*) All String / 1

    No: the property is a standard property that stores a value.

    Yes: the property is computed by applying an operation to sub-elements.

    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.

  6. Complete the additional fields.
  7. Name Data Type Type / Max. length Contents
    Is identifier All String/ 1

    Yes: if the property is an identifier of the collection.

    No: otherwise.

    The identifier properties are used at import (Merge mode) to decide if a file is imported in a new collection or in an existing one.

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

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

    • 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: Object Type for the Collection 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: FILENAME like "Acc"

Related Links