How to filter tickets that were not in a particular earlier sprint

[Gayathri Senthil]

I'm trying to retrieve the issues that did not belong to a particular sprint but were worked upon in the given time period . Please help me with a query as Not in function isn't working .

[Deric]

Try using as part of your query "AND Sprint!=NN", where NN is the sprint number.

[Gayathri Senthil]

Tried this but gives the tickets that were a part of that sprint that i dont want it to be in and are in a new sprint . 

Example: I want the tickets that were not a part of a closed sprint 10  but may be a part of any other sprint . When I use not in it only checks the current sprint its assigned to and displays a ticket that was earlier in sprint 10 but now is assigned to sprint 11 . On the ticket you can see that it was linked to sprint 10 as well . 

[Deric]

As far as I know the query only works on the currently assigned sprint.

It's better if you show a specific example. Maybe someone can help you then.