nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

a JQL for number of completed work over the time period

Gaurav Pardeshi

Hello,

I want to measure Issue completed over a time period for my ART and for last 3 PIs

I need a JQL which does that so that I can make filter and fetch it in pie chart

I have used these JQL but not having expected results as of now

Project ="ABC"AND issuetype = Epic and labels = PI.2426 AND worklogDate >= "2024/06/24" AND worklogDate<=""

I also tried Created>="" AND created<=""

Accepted answers

Alexey Pavlenko _App Developer_

Hi @Gaurav Pardeshi ,

The correct expression you need to use in your JQL is

resolutionDate >= "%PI_START_DATE%" AND resolutionDate =< "%PI_END_DATE%"

However, it requires manual maintenance.

For an automatic solution, you can use the app I developed - Multi-team Scrum Metrics & Retrospective. Look at the Completed Scope metric for the last 3 quarters (I assume 1 PI = 1 quarter in your case).

Best regards,
Alexey

All comments

Marc -Devoteam-

Hi @Gaurav Pardeshi

Welcome to the community.

You will need to specify a dats or clause option like endOfDay on the second date option in the JQL.

example: worklogDate <= endOfDay() or worklogDate <= "2024/12/31"

You can't leave this empty like worklogDate <=""

Gaurav Pardeshi

Hi Marc, thanks for the response

I am aware about the JQL syntax, to specifics I tried the JQL like this,

the dates are clear but my question is it is not fetching the right data which i can use in the filter to show in pie chart

For eg

Project ="ABC"AND issuetype = Epic and labels = PI.2426 AND worklogDate >= "2024/06/24" AND worklogDate<="24/09/01"

project = "ABC" AND issuetype = Epic and labels = PI.2436 AND status changed to "In Progress" after '2024-09-01'

I want to capture the issuetypes from the below CFD from the date range captured in green box

Marc -Devoteam-

Hi @Gaurav Pardeshi

The green box is related to a status right?

Then add a clause related to the status to your JQL, status "Out of scope"

Gaurav Pardeshi

Hi Yes the green box

and the one of the status "out of scope" where very tiny possibility where issue travels from that.

but I try to do that as well

main thing is the statuses like in refinement, ready for planning, out of scope, committed will get counted eventually in "In proress" from birdview level

thanks

Alexey Pavlenko _App Developer_

Hi @Gaurav Pardeshi ,

The correct expression you need to use in your JQL is

resolutionDate >= "%PI_START_DATE%" AND resolutionDate =< "%PI_END_DATE%"

However, it requires manual maintenance.

Best regards,
Alexey

Gaurav Pardeshi

Hello Alexey,

This looks great.

I will check if the app you developed can be integrated with my org JIRA.

And the query with resolution date doesn't work with me.

I tried many modifications with resolutions dates

Gaurav Pardeshi

project = "ABCD" AND issuetype = Epic AND labels = PI.2426 AND resolutiondate >= "2024/06/24"

works but inadaquate data

Alexey Pavlenko _App Developer_

@Gaurav Pardeshi ,

Please describe the expected result.

Do you really need only epics with the label you specified?

  resolutiondate >= "2024/06/24" and resolutiondate <= "2024/09/01"

should definitely work. If it returns nothing, then you don't have resolved issues for this period. If the query returns an error, the search field is highlighted in red and you get an error message beneath the search field.

Best regards,
Alexey

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud