Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal


  • Give kudos
  • Received
  • Given


  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Select Search multiple values


How do I search multiple values in a column?

For e.g. In the filters on JSD I have a column Employee. I need to search and select issues where movie like '%Rambo%' or movie like '%Tarzan%'

Is this possible with JQL?




1 answer

1 accepted

0 votes
Answer accepted

Depends on the field type.

For text though, try "movie ~ rambo or movie ~ tarzan"

For select type fields, "movie in (rambo, tarzan)" will work

Thanks @Nic Brough _Adaptavist_ 

My user behaviour is very broad

data types 

1) Text

2) Digits


Is there a way this can be achived without JQL?

No.  Simple search does a a series of limited "and" statements - issues need to match x and y and z.  Anything more complex needs explaining to the computer.  They're good at executing searches, but bad at guessing what we're really asking, we need to be crystal clear to them (even when we say "do a fuzzy search", it's a clear instruction)

Text is by its nature, fuzzy, we're looking for something close to <a target string>, that's what the ~ operator does.

I am not sure what you mean by "digits" though.  I know you mean "stuff with 0-9 in it", but those will always be held as an actual number, or as a string, so I'm not sure what you might be searching for.

Suggest an answer

Log in or Sign up to answer
Site Admin

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