Hi @Sunil31,
Yes, you can achieve this in ServiceNow by using Reference Qualifiers. Reference Qualifiers are used to filter the records that are available in a reference field based on certain conditions, including the value of other variables. In your case, you want to filter records in a reference field based on the table selected by the user.
Navigate to the reference field in the form designer.
- In the reference field's settings, find the "Advanced Reference Qualifier" field or similar options, which allow you to define a script.
- Create a script that evaluates the value of the variable, which allows the user to select the table name. You'll use this variable to determine the filter condition.
- Depending on the table selected by the user, you should set a filter condition that restricts the records displayed in the reference field.
Here's a sample script:
function getTable() {
// Get the selected table from the variable (assuming your variable's name is 'table_selection')
var selectedTable = current.variables.table_selection;
// Define the filter condition based on the selected table
if (selectedTable == 'incident') {
return 'active=true^table=incident';
} else if (selectedTable == 'service_request') {
return 'active=true^table=service_request';
} else if (selectedTable == 'problem') {
return 'active=true^table=problem';
} else {
return 'active=true^table=task'; // Default to the 'TASK' table
}
}
// Return the filter condition
return getTable();
Once you've created the script, set the reference field's Advanced Reference Qualifier to the script you created.
Test the form by selecting different table names in your variable and observe how the reference field's options change accordingly.
This approach will dynamically filter the records in the reference field based on the user's selection of the table name variable. The script provided is a basic example; you may need to adapt it to your specific requirements, and you should always consider security and access control when implementing reference qualifiers.
If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.
Thanks,
Arsalan
