Like named departments in JQL search

Matthew Gaffney

When doing a JQL advanced search we have an issue with like named departments. We want to see everything where

Department ~ "Technology"

but not see

Department ~ "Educational Technology Media Services"

. 

 

We found that we can exclude the Media Services issues by including a search similar to this: 

Department ~ "Technology" AND Department !~ "Media"

 

But really this is all part of a larger advanced search for multiple departments within a college. We'd like to come up with a way to find all these departments without having to exclude any other like named departments across campus. 

 

Another couple of departments are even closer in name "Health & Recreation Services" and "Health, Recreation & Community Services". 

 

Any clarity anyone can provide is much appreciated. 

Thank you! 

Matthew Gaffney

After working through with support, it took a re-index to have the full effect. 

This was the fix:

I assume you connected the "Department" field with a user Profile field. In the "User Profile Settings" under "User Profile Fields" you can change the configuration of the search template. In your case I would recommend the "Exact Searcher" for your case. This enables you to search for an exact term with the EQUALS operator "=" instead of the CONTAINS operator "~".