Define Advanced Properties for a Field
Use the Advanced page in the Field Properties window to define database options, attributes, and more.
To define advanced properties for a Field:
- Open the Field Properties window.
- Click the Advanced page.
- Define database options for the Field.
- Define attributes for the Field.
- Define localization options for the Field.
- Set value splitting options.
- View advanced Field information.
- Enable encryption for the Field.
- Publish the Blueprint (File>Publish Blueprint) to commit the changes, or save the Blueprint (File>Save Blueprint) to continue making other changes.
Define Database Options
Use database options to store the Field in the database, allows nulls, and recalculate Field values when a Business Object is loaded.
To set database options for a Field:
- Select the Stored in database check box to store the Field's value in the database table that represents the Business Object. Clear this check box only if this is a calculated Field that gets its value from other Fields stored in the database.
- Select the
Allow nulls check box to allow the Field to be
stored in the database even if it does not contain a value.
Note: The Allow Nulls option is not selected by default when a User creates a new logical Field.
- Select the Recalculate after load check box to recalculate the Field’s value each time the Business Object is loaded.
- Provide a Custom storage name to use for the database column that represents the Field. If the custom storage name is populated by default, it is recommended that you do not change it.
Attributes are additional pieces of information (or meta-data) that can be associated with a Field. Some attributes are automatically set, but others must be provided manually. For example, a Knowledge Category general attribute indicates that a Field contains a category that should be submitted for Knowledge review.
Database attributes are used to indicate special attributes used for a Business Object’s database table. Most of these are set by the system. Only advanced Users should define attributes. For more information about attributes, please contact Cherwell Support.
To define attributes for a Field:
- Click the down arrow to expand the General Attributes section or the Database Attributes section.
- Click an empty row and provide the attribute name and associated value (if applicable).
Define Localization Options
Use these options to enable localization support for Fields and to view current and specific culture information for the Field. Localization options are available in systems where Globalization is enabled.
- Supports Localization
For a Current Culture Field, you can select or clear this check box to enable localization for the Field.
- Current Culture Field
For a Specific Culture Field, you can see the culture for the Field you are editing.
Define Presentation Options
Presentation options enable you to define how and where the Field is exposed to Users.
- Exclude from Form
Select this check box to exclude the Field from being displayed in all Forms (including summary forms and mini-summary Forms). In addition, the Field will not be available in the Field Editor.
- Exclude from Grid
Select this check box to exclude the Field from being displayed in all Grids. In addition, the Field will not be available in the Grid Editor.
Select this check box to separate the Field into a folder based on category. Then, select a category in the drop-down, or provide a new category in the field. When the Field is displayed (example: In the Form Editor, anywhere you can select a Field as a token, etc.), it is categorized by folder (example: Common, System, etc.).
Set Value Splitting Options
Use value splitting to split a name Field into various components. For example, you can split a Full Name Field into last name, first name, middle initial, and suffix into separate Fields in the Business Object.
You can also view and add values for the title and suffix name components.
View Advanced Information
View additional advanced information for the Field:
- Field ID
Click this button to see the Field's internal ID. This ID can be used instead of the Field name in many places in the system. For example, the ID is used internally so that Fields can be renamed without breaking any Relationships.
- Find Dependencies
Click this button to scan the Field for a list of other definitions in the system that use this Field. When the scan is finished, the Definition Dependencies window opens, listing the dependent definitions.
Enable Encryption for the Field
You can enable encryption for Fields in Major Business Objects. Minor objects cannot be promoted to major objects to enable encryption.
Before encrypting Fields, review the best practices.
To enable encryption for the Field:
- Select the Enable Field Encryption check box.
- In the drop-down, select an encryption key (encryption keys are managed using the Server Manager).