Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

"~" does not work with "Support Team"



it is observed that operator "~" does not work with "Support Team" 

if we enter"Support Team" ~ "JDE*" it does not shows any result.

Can you please explain what is the way to get the result for support team where a keyword JDE is found



Deepak Patnaik


Hi @Deepak Patnaik ,

The correct JQL depends on the type of custom field.
What type of field is "Support team" in your Jira?

And if you search for a basic filter on the "Support team" field, what option do you get to fill in?

Regards, Marco

See also documentation about JQL

Like Deepak Patnaik likes this

Welcome to the Atlassian Community!

~ only works with variable text fields.  I suspect your team field is a selection type field, which have a fixed range of values, and hence only support searching for the options, not partial searches of the option names.

Your search probably needs to be done by calling out the exact options you are looking for - Team in (JDE-1, JDE-ABC, Support-JDE, etc)

Like # people like this

Thanks for your reply and yes i agree with you.

I tried using in operator but the problem is if i put all the JDE team names, the length is exceeding 1000 character and it shows error message in smart filter.

As all the team name starts with JDE it would be easy to use ~ "JDE*" but it does not work :( 

Why do you have so many JDE support teams listed?  The need to search by text suggests your data is structured incorrectly in Jira, and you should be considering other ways to do it. 

I don't know your data or your business, so I can't make any strong recommendations, but I do suspect you should be splitting up your projects, or, if it really does need to be one field, using a cascading select list rather than a select list with thousands of options.

Like Marco Brundel likes this

So many support team because we have two team level 1 and level 2 (escalation) for every module of JDE.  And due to this length is exceeding 1000 character. Like JDE we have 15 other towers and I want to create a dashboard by tower.  To track JDE tower i want to put all support team falling under it and similarly for other towers as well. And I cannot split it because it will show inaccurate statistics by way of chart and graphs.

@Nic Brough _Adaptavist_ , @Marco Brundel  Pease let me know if you find a work around or any solution to this.

So why aren't you using a cascading select?  Or at least storing the "module" in a separate field so that you can do easy searches like "support team = JDE and module = xyz"?

Like Marco Brundel likes this


Log in or Sign up to comment

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you