I want to know how can I use a operator such as UNIQUE or DISTINCT

Natalia Mojica

Hi, trying to create a filter where i can filter only an specific sprint, i read that i can use UNIQUE or DISTINCT, but i dont know how this operator works on jql. The above is because with only the desired sprint filter, I still get tickets that have been carried over

Bill Sheboy

Hi @Natalia Mojica 

JQL is not a SQL, and so does not have the UNIQUE or DISTINCT constraints (or many other basic SQL features).  (There may be marketplace addons for JQL to add some of these.)

If you are trying to find issues in the current sprint, and which have not been carried over from prior ones, you could try this JQL:

project = yourProjectName 
 AND sprint IN openSprints()
 AND sprint NOT IN closedSprints()

To learn more about such JQL features, please look here: https://support.atlassian.com/jira-software-cloud/docs/jql-operators/

Kind regards,
Bill