I am not able to use sprint in JQL to search on issues

[Umesh Rangappa]

I am using JIRA 5.1 and Greenhopper 6.x. As per the documentation I am using Agile Board to create and manage Sprints, Release.

If I want to search on a sprint using jql / issue navigator I am not able to. I see Sprint in the dropdown. But when I give a value like sprint = "Sprint 1" it says no issues found.

Any help ?

[ConradR]

This is not possible in the standard:

https://confluence.atlassian.com/display/GHKB/Greenhopper%3A+How+to+search+for+a+Sprint+using+JQL

But this plugin will help you:

https://marketplace.atlassian.com/plugins/com.onresolve.jira.groovy.groovyrunner

https://jamieechlin.atlassian.net/wiki/display/GRV/Scripted+JQL+Functions#ScriptedJQLFunctions-inSprint%28boardname,sprintname%29

[C_ Faysal]

no need to install this plugin for this JQL.

but it extends the search function with IssueFunction:

[C_ Faysal]

oh i missed asking for your GH version...

conrad is right..

In Greenhopper v.6.0.4 it is not possible to search for Sprint names in JQL.

so if you use latest release this standard jql will work for you

[Umesh Rangappa]

Installed version:6.1.0

is the version we are using ... can we search on the name ?

[C_ Faysal]

to find out just try it in the navigator...

[Umesh Rangappa]

sorry let me rephrase it.

which version supports name ?

[C_ Faysal]

oh sorry for not understanding....i tried in the latest release...that is 6.1.3.1

but what makes me wonder...

I see Sprint in the dropdown. But when I give a value like sprint = "Sprint 1" it says no issues found.

you said you can add "Sprint"

you get no results when you use the sprint id instead of name? like i already posted above

Sprint = 20

where 20 is the id if a sprint called "Sprint 8"

[Renjith Pillai]

Use latest GH (6.1.3.1), type 'Sprint =' and the drop down will automatically show the names.

[C_ Faysal]

hi umesh.

sprint = "Sprint 1" is not correct.

i see this is using some IDs instead.

so in that example "Sprint 8" has ID 20

jql

Sprint = 20