Configure reference qualifiers

System administrators can configure reference qualifiers that enable filtering of the associated reference field.

Pourquoi et quand exécuter cette tâche

This task walks you through creating a reference qualifier in the system dictionary. When creating a reference qualifier in the system dictionary, it not only applies to that table, but also to all the children of the table.

Remarque :

You can also create reference qualifiers on extended tables through dictionary overrides. Dictionary overrides only impact the extended table and any of its children, not the parent table.

Procédure

1. Navigate to the reference field on the form or table on which you want to define a reference qualifier.
2. Right-click the reference field label and select Configure Dictionary.
3. Under Related Links, select Advanced view.
   The simple reference qualifier is available in both the default view and the advanced view. The dynamic and advanced reference qualifiers are available only in the advanced view.
4. In the Reference Specification section, verify that the table in the Reference field contains the table that you want associated with the reference field, or select another table if necessary.
5. From the Use reference qualifier choice list, select the reference qualifier to implement.
6. Configure the qualifier based on the type of reference qualifier.
   • Simple: Build the condition using the choice lists.
   • Dynamic: Either select an existing dynamic filter option or Create a dynamic filter option.
   • Advanced: In the Reference qual field, enter an Encoded query strings, JavaScript that returns a query string, or the name of a script include or business rule to run.
7. Complete the Reference Specification — Additional Customization section, as appropriate.

   Field	Description
   Reference key	Identifies a field other than sys_ID to use as the unique identifier for the reference field.
   Reference cascade rule	Defines what happens to a record if the record it references is deleted. Possible options include: None Cascade Clear Delete Delete no workflow Restrict
   Reference floats	Flag that determines whether to Configure the edit option for one-to-many relationships.
   Dynamic creation	Flag that determines if the system should create a new record when a value for the reference field does not match an existing record. If you select this option, enter a script that specifies how to create the record in the Dynamic creation script field.

8. Click Update.