I would like to access all the bugs created during a sprint and their total number using a query like "project=LSD and issuetype=bug AND created during sprint=14" without specifying "created >= AND created <= " as I don't have the start and end dates for the sprint. Is there a way to this ?
JIRA by default doesn't provide a way to find the issues *created during sprint* because if I understand your requirement correctly you don't want issues which have the field "sprint =14" rather you want issues "created after sprint 14 started"
Only way which comes to my mind is to use "script runner" add-on
JQL would be
For all issues on board "Sample scrum board" and sprint name "sprint 14"
issueFunction in addedAfterSprintStart("Sample Scrum Board", "Sprint 14")
for just bugs add * and type =bug* in the above JQL and that should do the trick.
The above JQL will list the sprint scope changes with what added into the scope after the sprint started, it does not address the original issue which we need to query out all bugs found during a spring, these bugs may not be assigned to any of the spring yet, it's in the backlog.
Additionally to the option suggested by Tarun, we have a feature request created to allow a JQL search based on the duration time of a Sprint in Jira Cloud:
Feel free to vote and watch the suggestion to increase its priority and also receive notifications about any updates.
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events