Property definition
After clicking NEXT on the Object Information page the Property Definitions page is displayed.
These fields are displayed:
- Property
- The name of the property to include in the object schema.
- Data Type
- The data type for the property. If the data type is object, a drill-down icon is displayed in this column. For BODs, Data Elements and Group Elements also show a drill-down icon in the data type column. Click this icon to view and edit child properties.
- Required
- Does not apply to DSV objects.
Indicates which properties are required to exist in the data object.
- Repeatable
- Applies to BODS only.
Indicates which properties can be repeated throughout the data object.
- Position
- Does not apply to BODs.
The order in which the properties should be displayed to the end user.
A single empty row in the data grid exists and is selected to define the first property. By default, String is the data type and the position value is 1.
You can add the property name, change the data type, or include additional constraints for each property.
-
Select the row in the data grid. On the right panel, this list of
fields is displayed.
- Property
- Change the name of the property. A property name is required.
- Title
- Does not apply to BODs.
Specify a friendly name for your property.
- Description
- Specify a description of the property.
- Property Type
- Applies to BODs only.
A drop-down list containing the different property types for BODs. Options are Group Element, Data Element, and Attribute.
Group elements can contain other group elements, data elements, and attributes. Data elements can only contain attributes. Attributes cannot contain any children.
- Position
- Use this field to change the assigned position.
Change the position value of the property. Any other property positions that are affected by this change are automatically adjusted.
- Alternatively, to reorder properties, click the drag icon in the first column of the data grid and drop the row to a new location in the list.
- Data Type
- A drop-down list containing valid data types for a
property.
For JSON and DSV, options are Array, Boolean, Date, Date Time, Integer, Number, Object, String, and Time.
For BODs, options are Boolean, Date, Date Time, Decimal, Duration, Integer, String, and Time.
- Required
- Select the check box to mark the property as required.
- Repeatable
- Select the check box to indicate that the property is repeatable.
- Value Restriction
- If the property should be defined as a constant,
enumeration, or pattern, use the drop-down list to select one of these options:
- None
Default selection.
- Constant
Does not apply to BODs.
A single value that the property must have in the data object.
- Enumeration
A list of unique values that are defined for the property. The value for this property in the data object must match one of the defined values exactly.
- Pattern
Applies to String properties only.
A regular expression that the value in the data object must validate against.
- None
- Constant
- Visible only if Constant is selected as the Value Restriction.
Specify the value that the property in the data object must have.
- Enumerations
- Visible only if Enumeration is selected as the Value Restriction.
Use the list builder to define the list of valid values for the property. Each item in the list must be unique.
To add a value to the list:
- Click the Add icon.
- Click inside the row that is displayed, to specify a value.
- Repeat for as many values as required.
To remove a value from this list:
- Select the value to remove.
- Click the Delete icon
- Pattern
- Visible only if Pattern is selected as the Value Restriction.
- Specify a regular expression that the value must validate against.
If the selected Data Type is Array, these fields are displayed:
- Array Items Data Type
- A drop-down list that contains supported data types for Array properties. Options are Any, Integer, Number, Object, and String. Type Any does not restrict the values to be a specific data type; all are valid.
- If Object is selected as the Array Items Data Type, a drill-down icon is displayed in the data type column in the data grid. Click this icon to view and edit the array object’s properties.
- Minimum Items
- The minimum number of items that must be included in the array.
- Maximum Items
- The maximum number of items that can be included in the array.
If the selected Data Type is Object, these fields are displayed:
- Minimum Properties
- The minimum number of properties that must be included in the object property.
- Maximum Properties
- The maximum number of properties that can be included in the object property.
If the selected Data Type is Integer, Decimal, or Number, these fields are displayed:
- Digits Before Decimal
- Applies to Decimal values for BODs only.
Specify the number of digits that are allowed before the decimal place in the value.
- Digits After Decimal
- Applies to Decimal values for BODs only.
Specify the number of digits that are allowed after the decimal place in the value.
- Total Digits Allowed
- Applies to Integer values for BODs only.
Specify the total number of digits allowed for the property value.
- Minimum
- Specify the lowest number that is allowed for the
property value.
If this value should be exclusive, select the Exclusive Minimum check box.
Does not apply to BODs; all minimum values are defined as inclusive.
- Maximum
- Specify the highest number that is allowed for the
property value.
If this value should be exclusive, select the Exclusive Maximum check box.
Does not apply to BODs; all maximum values are defined as inclusive.
- Multiple Of
- Does not apply to BODs.
Specify a number that the property value in the data object must be a multiple of.
Tip: This field can be used to specify the number of digits that are allowed after the decimal in the property value.
For example, in these situations:
- If two decimal values are allowed, specify
0.01
as the Multiple Of value. - If three decimal values are allowed, specify
0.001
as the Multiple Of value.
Multiple Of value is the number of digits allowed in the data object property. The value for the number of digits following the decimal in the Multiple Of field must end in 1 for desired results.
- If two decimal values are allowed, specify
If the selected Data Type is String, these fields are displayed:
- Minimum Length
- Specify the minimum number of characters that the property value must have.
- Maximum Length
- Specify the maximum number of characters for the property value.
- Format
- Does not apply to BODs.
The number of digits following the decimal in the drop-down list that contains the standard Formats for string properties. Use the drop-down to select the format the string value must validate against.
If the selected Data Type is Date, Time, or Date Time, these fields are displayed:
- Format
- Does not apply to BODs.
Select the format that the property value must have in the data object. The drop-down list contains supported datetime formats.
This table shows the different available formats for a selection that is based on the selected data type for the property:
Data Type Format Descriptions Date Time Standard Standard datetime format according to ISO 8601. Example: 2019-12-01T09:15:00Z
American Standard American datetime format. Example: 12/1/2019 9:15:00 AM
Epoch Milliseconds Epoch Milliseconds datetime format. Example: 1575191700000
Three Character Month Datetime format using the three-character abbreviation for the month. Example: 01-DEC-2019 09:15:00
Other Note: Only the defined formats available for selection are supported by Compass queries. Any other variation of a date or datetime is not recognized.Any other datetime format that is used by the property in the data object. Date Standard Standard date format according to ISO 8601. Example: 2019-12-01
American Standard American date format. Example: 12/1/2019
Basic Date Basic date format according to ISO8601 standards. Example: 20191201
Other Note: Only the defined formats available for selection are supported by Compass queries. Any other variation of a date or datetime is not recognized.Any other date format that is used by the property in the data object. Time Note: This format is not supported by Compass queries. Times without dates are treated as string values.Standard Standard time format according to ISO 8601. Example: 09:15:00
Other Any other time format that is used by the property in the data object. - Custom format
- If Other is selected in the Format drop-down list, specify the custom format the property uses in the data object. This field is hidden if any other format is selected.
- For more information regarding datetime properties, see “Using datetime formats” in the Infor ION Development Guide.
- Click the Add icon to add another property to the schema.
-
Repeat steps 1 and 2 until all properties that are required for the schema are added to
the data grid.
To remove any properties from the list, select the row to remove and click the Delete icon.
- Click NEXT to proceed with the Additional Metadata page.