nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Accepted answers

All comments

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.

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...

Screen Shot 2022-10-02 at 18.53.14.png

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

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...

Shlomi.Galmi

Hi Nic.

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

Thulasi_jo56vi

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>"

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-software

jira-software-cloud