how to find tasks added to sprint after it started & bugs added to an EPIC

i am running 6.0.8 version and I want do two tasks:

1)  How to find items (everyday) which are being added to sprint, run a report or something

2) Trying to gather a list of all the bugs which are associated to an EPIC

I tried bunch of diff options, looked through the our JIRA admin page (i just took over the role) we have the scriptrunner plugin installed but i cant only see few functions been added there.

I am new at this(complex queries) any help would be appreciated.

 

thanks

3 answers

For 1) you can look at the Sprint Report where you'll see all stories added after the sprint started.

For 2) all bugs associated with an Epic are shown in the "Issue In Epic" panel when you open the epic. You can also write a filter using Script Runner's linkedIssuesOf function - see here. Let me know if you need more help with that.

If you want a better separation and visualization of bugs and stories in an epic than what is provided out of the box by the "Issues in Epic" panel, you can use the Issue Matrix add-on. Check out the Epic mode.

hey Petar

Thanks for your answers:

1) For this we want to get a warning or alert when people add items after the sprint already started so I want to run a query and add a subscription to it or add it to my dashboard. I wrote this 

project in (XX, "YY") AND created > -1d AND sprint = openSprints() AND Team in (bla,bla,bla) 

But this would only give me stuff which got created day-1 and then added to the sprint.

2) for this one too need to query to run a report on all the bugs being logged for an epic for a particular release

I tried a lot of diff ways to run this query, cant really get what I want. I would really appreciate your help.

 

Thanks

Megha

OK, so you need JQL.

For 1) You can't do this out of the box with JIRA, but you can use Script Runner's JQL function addedAfterSprintStart. So your query would look something like:

issueFunction in addedAfterSprintStart("Board name") AND Team in (bla,bla,bla)

You don't need to filter on the project, as the function is board-centric.

For 2) Again the best approach is to use the Script Runner built-in function linkedIssuesOf:

issueFunction in linkedIssuesOf("issue = <issue key>", "is Epic of") and type = Bug

Replace <issue key> with the key of the given epic. You can modify the subquery (the first argument to the linkedIssuesOf function) if you want to include more epics, or epics from a specific sprint. You can further extend the JQL and add more conditions on fixVersion for example.

Thanks a lot Peter, after doing lot of googling turns out Scriptrunner is my friend so i looked in our add-ons, we do have the scriptrunner installed(i think paid one) but it only has like 10 functions in it(which I am assuming came with the plugin), functions which you suggested are not on the list. So do I have to manually write them or add them first i think?

 

Megha

Which version do you have installed? How did you know which functions are there? I suggest you upgrade to the latest version - these functions should definitely be there. I suggest you actually try them with JQL.

Are these functions for Scriptrunner available on the cloud version for the cloud version of Jira?

Suggest an answer

Log in or Join to answer
Community showcase
Emilee Spencer
Published Friday in Marketplace Apps

Marketplace Spotlight: DeepAffects

Hello Atlassian Community! My name is Emilee, and I’m a Product Marketing Manager for the Marketplace team. Starting with this post, I'm kicking off a monthly series of Spotlights to highlight Ma...

63 views 0 3
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot