Can we apply 'Key in' and 'key not in' both in a single query

[Sandeep Vashisht]

Can we apply 'Key in' and 'key not in' both in a single query. I am trying to do but it pick only one at a time.

[Nic Brough -Adaptavist-]

Yes, but you'll get nothing or everything back from it.   Could you explain what you're actually searching for?

[Sandeep Vashisht]

i have a list of tickets from current sprint. Now i need to add few in the list from other sprint and that i can do successfully with 'key in'. Also i need to exclude few from the list which i cannot do by using 'key not in'. 

[John Funk]

Hi Sandeep - Can you share the query you have so far?

[Sandeep Vashisht]

sprint = xxx AND fixVersion in (xxx) AND type not in (Sub-task, Bug, Story-Bug) OR key in (Ticket number) or key not in (ticket number)

[John Funk]

Yes, when you get to the Key in (ticket number) or key not in (ticket number) it is going to bring back everything because every issue is going to match that.