Warning  Jobserver and all related Jobserver integrations are end of life starting October, 2024, with the exception of Public Sector customers using GovCloud or on-prem environments. For more information, go to Announcements.

Create an advanced data type

Important This feature isn't available in the latest UI.

If the basic data types, such as numbers and text, are not specific enough, you can create your own advanced data types.

Prerequisites

Steps

  1. On the main toolbar, click Products icon → Catalog.
    The Catalog homepage opens.
  2. In the submenu, click Advanced Data Types.
  3. Above the table, to the right, click Add Advanced Data Type.
  4. In the Add Advanced Data Type dialog box, fill in the new data type properties.
    OptionDescription
    NameThe name of the advanced data type. The name has to be unique, including the basic data types.
    DescriptionThe description of the advanced data type.
    Base data type

    The data type used as basis for the advanced data type:

    • Text
    • Geographical
    • True/False
    • Date
    • Time
    • Date and Time
    • Whole Number
    • Decimal Number
    • Array
    • N/A

    Examples

    Base data type

    		Field name

    Patterns

    Text

    Email address

    [a-z0-9]+[_a-z0-9\.-]*[a-z0-9]+@[a-z0-9-]+(\.[a-z0-9-]+)*(\.[a-z]{2,4})

    Text

    IP address

    \b(?:(?:2(?:[0-4][0-9]|5[0-5])|[0-1]?[0-9]?[0-9])\.){3}(?:(?:2([0-4][0-9]|5[0-5])|[0-1]?[0-9]?[0-9]))\b

    Date

    Custom Date

    yyyy-MM-dd

    Time

    Custom Time

    HH mm

    Date and TimeCustom Date and TimeMM/dd/yyyy HH:mm:ss
    True/FalseBoolean (French)
    • true: vrai, v
    • false: faux, f
    Advanced data type (variable field name)

    The field name depends on the selected base data type.

    Base data type

    		Field name

    Description

    TextRegular expressions

    List of regular expressions.

    For more information about regular expressions, see regular-expressions.info.

    GeographicalRegular expressions

    List of regular expressions.

    For more information about regular expressions, see regular-expressions.info.

    DateDate pattern List of date patterns using the DateTimeFormatter format. See the official Java documentation.
    TimeTime patternList of time patterns using the DateTimeFormatter format. See the official Java documentation.
    Date and TimeDate and Time pattern List of date and time patterns using the DateTimeFormatter format. See the official Java documentation.
    Whole NumberNumeric formatLocale for the format of whole numbers.
    Decimal NumberNumeric formatLocale for the format of decimal numbers.
    True/False
    • True values
    • False values
    • List of values that are accepted as True value.
    • List of values that are accepted as False value.
    Array or N/A Not applicable for advanced data type detection.
  5. Click Save.