Hi @GraurSebastian,
To achieve this, you can create a Script Include in ServiceNow and then call it from your reference qualifier. Here's how you can do it:
1. **Create a Script Include**:
Go to `System Definition` > `Script Includes` and create a new one. Let's name it `UserReferenceQualifier`.
Here's a sample code for the Script Include:
var UserReferenceQualifier = Class.create();
UserReferenceQualifier.prototype = {
initialize: function() {},
// Function to get the reference qualifier for User field in Incident table
getUserReferenceQualifier: function() {
var gr = new GlideRecord('incident');
gr.query();
var userIDs = [];
while (gr.next()) {
userIDs.push(gr.user.toString()); // Assuming 'user' is the reference field
}
return 'sys_idNOT IN (' + userIDs.join(',') + ')';
},
type: 'UserReferenceQualifier'
};
```
2. **Call the Script Include from Reference Qualifier**:
Now, you can use this Script Include in your reference qualifier script. Assuming you're setting the reference qualifier for the `user` field on the `incident` table:
var refQualifier = new UserReferenceQualifier();
refQualifier.getUserReferenceQualifier();
```
This setup will ensure that the reference field for users in the incident table does not display duplicate entries in the list collector.
This is just example, you can do for your field.
Please hit helpful and accept this as a solution if it solved your problem.
Thank you!
