Administration › Security and Role Management › Data Partitions › Search Data Partition Constraints › Data Partition Constraint Search Fields

Data Partition Constraint Search Fields

• Data Partition Name -- The data partition for which the constraint being defined.
• Table Name -- The database table controlled by the constraint.
• Constraint Type -- The type of constraint being defined. There are six constraint types for each table in a data partition. Each constraint type must be defined in a separate Constraint Type Detail window:
  • Create - Records that can be created in the data partition. New records must satisfy the constraint before they can be saved.
  • Defaults - Specifies values to be assigned to empty fields in a new record created in this data partition, at the time the record is stored. For example, initialization values for fields not specified by users creating the record.
  • Delete - Records in the table that can be deleted.
  • Pre-Update - Records in the table that can be retrieved for update. Records not satisfying this constraint are displayed read-only.
  • Update - Records that can be updated. Updated records must satisfy the constraint before they can be saved.
  • View - Records in the table that can be viewed. The condition is automatically applied to all lists selected by a user, in addition to any selection criteria specified by the user.
• Active -- Indicates whether the constraint is active or inactive.

Note: You can click the More icon to display the Additional Search Arguments field. This field is intended only for expert users who understand SQL and Majic and can use it to specify search arguments that are not available in the standard search filter fields. You can enter a SQL WHERE clause in this field to specify an additional search argument.