Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Jira -new JQL query to find the % of work completed for components in Jira

Raghu Kitu June 4, 2023

I have created the Backend and frontend teams for each user story. Now i need to JQL extract the report with % of work done by each team. Can you please me with the query.

JQL query required.

1 answer

0 votes
Craig Nodwell
Community Champion
June 4, 2023

Hi @Raghu Kitu welcome to the community.  Please provide a bit more detail on what you're trying to accomplish here.  I would suggest if you're looking for % of work complete based on parameters that you have a look at Dashboards and the Dashboard Gadgets to achieve what you are looking for.

Raghu Kitu June 4, 2023

For example one Jira story have efforts estimated for 4 days and 2 teams example a and b working on the story and I have divided by 2 teams by component A and B in Jira.

In Jira we can see total % completed but from the above example i need Team A and Team B efforts individually from the JQL query.

Can you help me with the JQL or other way.

Craig Nodwell
Community Champion
June 4, 2023

I can do better than that, I can give you what you need to do it for yourself :)

Searching for Issues and filtering

Searching In Jira

Advanced Search

Working with Search Results

Raghu Kitu June 4, 2023

Yes, this really works

Like Craig Nodwell likes this
Raghu Kitu June 4, 2023

I means it really helps 

Like Craig Nodwell likes this
Raghu Kitu June 4, 2023

Craig can you provide me the solution 

Craig Nodwell
Community Champion
June 4, 2023

Have you tried?
If yes what have you tried?  And what are your results?

Raghu Kitu June 4, 2023

I have tried this JQL query and basic search but i will not able to get the % of Work completed for each component in Jira assigned to 2 teams working on same stroy

Craig Nodwell
Community Champion
June 4, 2023

It's the same story, how is Jira supposed to know how to break that down? Have you broken the work down into sub-tasks by component?? If not you sliced the work by team using the component field, but there is no actual work breakdown.  As far as the components are concerned they both have a single Jira issue associated to them.  One component is not going to take into consideration the other component and it's work effort it's only going to care about the Jira tickets progress.  As far as the Jira ticket itself it doesn't see two teams it sees two components associated to the work.  What version of Jira are you using?  There are ways to address what you are trying to achieve, but not in a base design (meaning no customfields and scripting to handle the breakdown, or plugins)as you've described above.  At least none that I'm aware of.  Depending on your Jira instance you may have Advanced Roadmaps that will allow for Team assignment instead of trying to use Components for that.  

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events