Contents Now Platform Administration Previous Topic Next Topic Configure reference qualifiers Subscribe Log in to subscribe to topics and get notified when content changes. ... SAVE AS PDF Selected Topic Topic & Subtopics All Topics in Contents Share Configure reference qualifiers System administrators can configure reference qualifiers that enable filtering of the associated reference field. About this task 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. Note: 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. Procedure Navigate to the reference field on the form or table on which you want to define a reference qualifier. Right-click the reference field label and select Configure Dictionary. 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. 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. From the Use reference qualifier choice list, select the reference qualifier to implement. 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 define a new dynamic filter option. Advanced: In the Reference qual field, enter an encoded query string, JavaScript that returns a query string, or the name of a script include or business rule to run. 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. Click Update. Constrain the assigned to field by role This example shows how to use JavaScript to restrict the incident Assigned to field choices to only the users with the itil_admin role.Constrain the assignment group fieldThis example shows how to use an advanced reference qualifier with JavaScript and a script include to restrict the incident Assignment group choices to only the groups that contain the user specified in the Assigned to field. On this page Send Feedback Previous Topic Next Topic
Configure reference qualifiers System administrators can configure reference qualifiers that enable filtering of the associated reference field. About this task 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. Note: 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. Procedure Navigate to the reference field on the form or table on which you want to define a reference qualifier. Right-click the reference field label and select Configure Dictionary. 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. 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. From the Use reference qualifier choice list, select the reference qualifier to implement. 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 define a new dynamic filter option. Advanced: In the Reference qual field, enter an encoded query string, JavaScript that returns a query string, or the name of a script include or business rule to run. 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. Click Update. Constrain the assigned to field by role This example shows how to use JavaScript to restrict the incident Assigned to field choices to only the users with the itil_admin role.Constrain the assignment group fieldThis example shows how to use an advanced reference qualifier with JavaScript and a script include to restrict the incident Assignment group choices to only the groups that contain the user specified in the Assigned to field.
Configure reference qualifiers System administrators can configure reference qualifiers that enable filtering of the associated reference field. About this task 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. Note: 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. Procedure Navigate to the reference field on the form or table on which you want to define a reference qualifier. Right-click the reference field label and select Configure Dictionary. 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. 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. From the Use reference qualifier choice list, select the reference qualifier to implement. 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 define a new dynamic filter option. Advanced: In the Reference qual field, enter an encoded query string, JavaScript that returns a query string, or the name of a script include or business rule to run. 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. Click Update. Constrain the assigned to field by role This example shows how to use JavaScript to restrict the incident Assigned to field choices to only the users with the itil_admin role.Constrain the assignment group fieldThis example shows how to use an advanced reference qualifier with JavaScript and a script include to restrict the incident Assignment group choices to only the groups that contain the user specified in the Assigned to field.
