Use this dialog box to specify a new default entity or to edit an existing default entity.
Relationship
Specify a relationship in which the entity participates as the relationship for the default.
Invert
Specify that the default condition is the opposite of the condition expressed in the selected relationship.
Conditions
Optional. Specify conditions on the other entities in the relationship. A condition consists of the following elements:
Select the entity, other than the current entity, for which you want to set a condition. In the example, status equals current, the entity is status.
Choose the operator from the list. Greater than and less than are not available for text entities. In the example, status equals current, the operator is equals.
Enter the value for the condition. The value may be numeric or text. In the example, status equals current, the value is current.
When the entity is a date the following values are accepted:
Dates in the form MM/DD/[YY]YY
Times in the form HH:MM[:SS]
Datetimes in the form MM/DD/[YY] HH:MM:[:SS]
Months in the form MM/[YY]YY
Years [YY]YY
Special text such as "today", "this month", and "this year."
Note Because there is no "is null" or "is not null" available as a condition, it may not be obvious how to get defaults like:
employees whose ages are not null
or
employees whose termination dates are null.
However, they are not needed because creating the default employees have ages on the entity employees gives the behavior the user expects. The question, "List the employees," shows only the employees who have ages.
Similarly, creating the default employees have termination dates on the entity employees and setting the Invert on the default causes the question, "List the employees," to show only employees who do not have a termination date.
Default conditions invalid when these relationships are used
Specify the relationships in which this entity participates and for which you do not want to use default conditions if the relationship is used in the question.
For example, if you specified employees who have termination dates relationship, the default relationship employees who are active would not be used if a user asks, "Which employees have terminated?"