How to search ticket which were created in Opensprint()

[凌宝万 Vant Ling (ENG - QA - CN)]

we want to collect ticket which were created in Opensprint(), but we only can search ticket which in Opensprint(), we can not search which created in Opensprint().

can you provide some resolution(JQL) to help me resolve this issue?

actual, I want to use JQL such as "created in Opensprint(time) and issuetype is Story"

[Bill Sheboy]

Hi @凌宝万 Vant Ling (ENG - QA - CN) 

If you only want to track additions to the sprint, you may see that on the Sprint Report.  If you also want to query that later with JQL, such as by adding a label for scope change, you could use an automation rule like this:

• trigger: field value changes for Sprint
• condition: JQL condition for sprint IN openSprints()
• action: add a label

For your other concern, I would recommend not automatically adding issues to an in-progress sprint.  Instead ask your product owner to discuss the situation with the team to decide when to add issues.

Kind regards,
Bill

[abhishek_sharma03]

Hi @凌宝万 Vant Ling (ENG - QA - CN) - OpenSprint is just about the timeframe, however creating an issue is a Jira functionality which is cannot be governed/influenced by what's happening in a sprint (which is specific to one project). However this info can be gathered through Burndown chart (using story points). Addition of new stories to the sprint can be identified by the spike in the trend.

Also the best possible JQL solution is through dates while the sprint was active -

PROJECT = ABCD AND Issuetype= Story AND Sprint = 1002 AND Created > (sprint start date) AND Created < (Sprint end date)

BR

Abhishek

[凌宝万 Vant Ling (ENG - QA - CN)]

Hi @abhishek_sharma03 , yes, I know this JQL for search ticket. but it is not meet my needs. I want to config automation rule to run this rules.

for example: When we have already started sprint, but some other colleague creates a ticket during sprint, we want to be able to set the label to insert-ticket with the automation rule.

[abhishek_sharma03]

Hi @凌宝万 Vant Ling (ENG - QA - CN) - If I understand you correctly, you want to update the sprint field with the value of Active Sprint if a new issue is created during an ongoing sprint ? But what if your product owner is adding new issues to your backlog which have to be a part of future sprints. Won't that create confusion ? 

Sorry if I got the context wrong here 

BR

Abhishek

[凌宝万 Vant Ling (ENG - QA - CN)]

Yes, there's nothing wrong with your understanding. Yes, your problem is that I overlooked that there will indeed be product owners creating issues inside the backlog, and that does cause a gap in our collection of insertion requirements.
OK, I need to think about changing the way I collect.

thx @abhishek_sharma03