how to add 'is not one of' query in list view for 'assigned to' field

[Balakrishna_ABK]

I want to exclude some of the assigned to users score based on email ids for asmt_metric_results table to show in report.

I couldn't see ''is not one of' to add in query. How to make it simple ? 

[Dr Atul G- LNG]

Hi @Balakrishna_ABK 

You need to provide the individual mail ID, and the operator is not. "Is Not one of " is not available for email ID by design.

[Balakrishna_ABK]

Hi @Dr Atul G- LNG , thanks for the reply but we have more than 100 ids to exclude which will make complex to add individually.

[Dr Atul G- LNG]

Hi @Balakrishna_ABK 

There is no way around it. Even if you write a script, you would still need to include 100 email IDs. So, there's no other way to do this.

[AnveshV38487537]

Hi @Balakrishna_ABK 

We can add Is one of by using Assigned to.Name in asmt_metric_result table but can not add Is not one of for multiple users at a time. need to add individually.