Sprint where a field is updated

[Selva Praveen Elango]

I am currently working on a JIRA project where we utilize a custom Yes/No field. I need to generate a list of stories that were marked as "Yes" during a specific sprint. Additionally, if any of these stories were moved to a subsequent sprint, I would like to identify the original sprint in which the field was marked as "Yes."

Could you please advise on the best approach to accomplish this? Are there any JIRA filters, queries that could assist in retrieving this information?

[Jack Brickey]

Hi @Selva Praveen Elango , you won't be able to use native JQL for this at least dynamically. You could create a query for a specific sprint by using the actual start and end dates. If this an ongoing need you might consider creating an automation rule that adds a label for the sprint where the field is set to yes. Of course this won't address historical scenarios.

[Selva Praveen Elango]

@Jack Brickey now i have created a custom field and an automation to copy the current sprint to this field.

how can i query this custom field and get all the issues that have the current sprint name is the custom field 

[Jack Brickey]

Hi @Selva Praveen Elango , how is the custom field populated? Can you share a screenshot of your rule? Also can you state the condition you want to test for, e.g. check if custom field = current active sprint. 

[Selva Praveen Elango]

@Jack Brickey 

I am populating the short text custom filed as below 

{{#issue.sprint}}{{#if(equals(state,"active"))}}{{name}}{{/}}{{/}}

this gives me the active sprint

The custom field i am using is a short text field . 

My idea is to compare the sprint = custom field and display when they are equal 

[Jack Brickey]

You can create a variable and the compare to your custom field