Filtering or Reporting on a Watch List

[Jordan Blake]

What is the recommended way to report on watch_list CONTAINS "email address". The default filter UI always assumes a user reference, but we can add emails to watch lists manually. How can I filter and locate specific email addresses OOB?

I've had to create a dynamic filter to insert the email address, but this doesn't seem perfect since adding the dynamic filter to a "List" field type referencing sys_user also opens that filter up to any reference of sys_user. This is confusing and clunky. Is there a way to just pass a string value in the reference field?

[Jaspal Singh · Accepted solution]

Hi Jordan,

Seems you are correct it will always consider a reference field but you can follow below workaround.

Open the desired table & then filter by

Watchlist | Contains | abc@abc.com 

Replace abc@abc.com with your email address & then Run the filter

Once done look for the browser URL & you will find there is nothing after watch_listLIKE

Simply suffix it with text like watch_listLIKEabc@abc.com

Hit the URL & then you get what is expected.

[Jordan Blake]

This does work, but it's a terrible user experience for non-admins. I remember in the older filtering UIs it allowed you to pass a string value in with reference fields. I'm disappointed there is not an operator available to mirror that. 

[Jaspal Singh]

Yes, I agree & thus told it is a workaround. Until you find a solution for this you can use above as workaround & also submit a HI ticket & confirm once you get an update over it.

[Kevin Carey]

This works for when you have a specific email address. Does anyone know of a way to search for a string like "@gmail.com". We have started using external emails to notify contractors with updates. I'm trying to come up with a report with users from the same domain.