Filter for tickets from domain except one domain

[WasimBuden]

Hi All,

Is there a query to build a filter to see all tickets opened in a project except one domain say i need to exclude tickets from abc.com and see all other tickets?

[Earl McCutcheon · Accepted solution]

Hello @WasimBuden ,

Currently this is not possible as the User field types do not support a partial text contains "~" operator.  A full list of supported and unsupported operators in Fields for JQL can be seen in "Advanced search reference - JQL fields" 

Check out the following Thread that discusses this, noting the workaround suggested via ScriptRunner:

• https://community.atlassian.com/t5/Jira-questions/Is-there-any-way-to-search-for-a-certain-email-address-domain/qaq-p/76178

However,  I cannot confirm if this workaround will be possible in Jira Cloud as the Scripted Field functionality mentioned is only Partially operational in the Cloud version of the allocation as covered here "Differences to ScriptRunner for JIRA Server" , I would recomend reaching out to Vendor to see if this snippet does extend to noted example.

Regards,
Earl