Data Field Settings
- 20 Dec 2024
- 2 Minutes to read
- Print
- DarkLight
Data Field Settings
- Updated on 20 Dec 2024
- 2 Minutes to read
- Print
- DarkLight
Article summary
Did you find this summary helpful?
Thank you for your feedback
Overview
Each Data Structure has its own data fields that can be individually configured. These settings are on the right side of the creation window of the Data Structure. For more information on Data Structures, see About Data Structures.
Data Field Information
Note:
Updating the Data Field settings after creating the data structure might cause implications. Particularly, changing the Name and the Data Type might cause duplication of the table and remove the data from the original table.
| Setting Name | Description | ||
|---|---|---|---|
| Is List | Configures this data field to store a list of items of this type instead of a single item. Opens up new options under Advanced. | ||
| Allow Null (No Value) | This setting allows this data field to accept a null value. | ||
| Text Length | By default, all String data fields are set to NVARCHAR, and this feature allows for the setting of character length for the String. | ||
| Default (255 characters) | NVARCHAR | This is the default character length set to 255 characters. | |
| Specify | NVARCHAR | This allows to specify a character length. | |
| Max | NVARCHAR | This sets the maximum character length and is determined by the database being utilized. | |
| KeyField | VARCHAR | This represents the primary key and enables the specification of the character length for the Primary Field. | |
Display Information
| Setting Name | Description |
|---|---|
| Categories | Creates a group for the data field |
| Display Label | Defines a label to display the data field in property editors |
| Display Order | Order to display the data field |
Advanced
| Setting Name | Description |
|---|---|
| Override Database Field Name | Allows SQL Keywords to be used as data field names |
| Create Database Index | Allows this data field to be used as a Database Index |
| Contains PII | Encrypts the data in the database (Cannot be reverted). When enabled, data is encrypted with 256-bit AES. |
| Encrypt Data | Encrypts the data in the database (Can be reverted). When enabled, data is encrypted with 256-bit AES. |
| SelectEditor | Changes the data fields flow 'Constant' editor type |
| Suggested Values | Data added here is used to show selectable values in a drop-down menu while adding/editing Entities and is not restrictive. |
| Configure Custom Attributes | Allows for custom attributes on the selected data field |
| Include Field In Description | The Data field name will be included in its description |
| Is Lookup List Key Field | The selected data field is the key field for Lookup lists generated from this data structure. |
| Use Visibility Rule | Allows for Visibility Rules to be created for a selected data field. This function can only be selected when editing an existing Data Structure |
Is List
Selecting Is List under DATA MEMBER INFORMATION causes these options to be displayed.
| Setting Name | Description |
|---|---|
| Store As Comma Separated String | Stores the list data as comma separated values. This makes the data easier to use in Fetch steps. |
| Store As JSON | Stores the list data in the JSON format. This can allow the data to be easy to use in many situations. |
Feature Changes
| Description | Version | Release Date | Developer Task |
|---|---|---|---|
| Added "Store As Comma Separated String" option. | 9.3 | October 2024 | [DT-041796] |
For further information on Data Structures, visit the Decisions Forum.
Was this article helpful?
