Sprint field is not recognized on a JQL query

[Shlomi_Galmi]

Hi.

When I'm trying to create a report via JQL query, I get an error that the "Sprint" field does not exist, although the sprint does exist. Here are the steps I performed:

1. Searching for the tasks in sprint 45 (sprint code is 152). Here's a quote of the query:

Sprint = 152 ORDER BY created DESC

2. Got the error description: The option '152' for field 'Sprint' does not exist.

3. It should be emphasized that when I enter the sprint board there are many tasks.

I would appreciate your help on this matter. Unfortunately, due to another bug in Atlassian's app, I don't have the option to add screenshots.

Thank you

Shlomi

[Mykenna Cepek]

Whenever I'm having trouble with JQL, I always go back to the Issue Search, and ensure that the JQL works as expected there. Auto-complete works best there.

Once my query works in the Issue Search, then I'll copy/paste that JQL someplace else (e.g. in a Filter, or Quick Filter, or Confluence Jira Search, etc).

[Shlomi_Galmi]

Hi Mykenna.

Thank you for your answer.

I did what you suggested, to my surprise I found that I can't filter the "Sprint" field (it doesn't exist in the filter). I tried to create a ticket for Atlassian on the issue, but unfortunately, this is also not possible in their system (there is a bug when the bug was created).

And all this despite the fact that there are tasks within the sprint...

[Nic Brough -Adaptavist-]

There does not seem to be a bug in the issue creation when I try to raise a support request, you'll need to explain that if you want help raising an issue.

But, also, you probably don't need to raise one.  Have you tried the advanced filter (plain text JQL rather than drop-down field lists)?

[Shlomi_Galmi]

Hi Nic.

Yes, I tried... that was the problem in the first place.

Here is a screenshots of the JQL query and the error that I received. You can see that the sprint is exist (created on 24 SEP 2022). I do have tasks in this sprint. The problem is not if there are tasks assigned to this sprint, But the existence of the sprint...

[Nic Brough -Adaptavist-]

Have you tried using the name of the sprint?  The one the search is suggesting?

[Shlomi_Galmi]

It doesn't work either... here is a screenshots:

---

[Shlomi_Galmi]

Do you know if Atlassian has any call center I can reach?

It looks like no matter what I'll do, it won't work...

[Nic Brough -Adaptavist-]

The tooltip in one of your earlier screenshots shows the autocompletion working, so I'm not sure where you are stuck now.

[Nic Brough -Adaptavist-]

This is going to sound condescending, for which I am sorry, it is certainly not meant to be.

Are you sure you have a sprint called simply "152"?, and that there is at least one issue you can see in it?

I recently got bitten by a sprint called something like " 152" - the JQL didn't offer me it in the auto-complete when typing "sprint = 1..." because there was an invisible character at the start of the name.

[Shlomi_Galmi]

Yes, I tried... that was the problem in the first place.

Here is a screenshots of the JQL query and the error that I received. You can see that the sprint is exist (created on 24 SEP 2022). I do have tasks in this sprint. The problem is not if there are tasks assigned to this sprint, But the existence of the sprint...

[Thulasi]

Issue resolved ? What is the workaround to fix this ? 

[Shlomi_Galmi]

Hi @Thulasi 

Unfortunately, the issue hasn't been solved yet.

The workaround is to add the following condition in the JQL query:
cf[10020] = "<Sprint Number>"