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; } } }

I need help with JQL

Samuel Prathipaty

Hi,

How to find issues that are created in the last 2 months and are resolved with in their due dates, as well as issues resolved after their respective due dates.

Accepted answers

All comments

Annu Satpute

I am trying to answer somehow its not accepting my inputs, trying again -

Hi Samuel,

You may want to try this -

created >= startOfMonth(-2) AND created <= endOfMonth(-1) AND status = Resolved AND ((resolved <= due) OR (resolved > due))

I hope this will help, let me know.

Best,

Annu | CSM | Amoeboids

Valerie Knapp_dpp5c6

Hi @Samuel Prathipaty , thanks for your post.

Please can you share what you have so far and where you are getting stuck? Here is the documentation on how to work with advanced searches in JQL to give you a hand - https://support.atlassian.com/jira-software-cloud/docs/what-is-advanced-search-in-jira-cloud/#Construct-JQL-queries

Best wishes

Bill Sheboy

Hi @Annu Satpute

What you show will not work with Jira Cloud's, built-in JQL features: a JQL statement cannot compare fields in the issue to one another. It is not a SQL.

There might be marketplace apps to support such comparisons, and they are likely not in the syntax you show.

What is the source of your information for that expression?

Kind regards,
Bill

Samuel Prathipaty

Hi @Annu Satpute,

Thank you for your response. However, it's not working; it throwing an error.

Error - Date value 'due' for field 'resolved' is invalid. Valid formats include: 'yyyy/MM/dd HH:mm', 'yyyy-MM-dd HH:mm', 'yyyy/MM/dd', 'yyyy-MM-dd', or a period format e.g. '-5d', '4w 2d'.

Samuel Prathipaty

Hi @Bill Sheboy

Right. Is this achievable through the Enhanced Search plugin?

Valerie Knapp_dpp5c6

Hey @Samuel Prathipaty , you could try this

created >= -60d AND resolution != Unresolved and duedate IS NOT EMPTY

^ just to get you started, so this is the list issues created in the last 2 months, where the resolution isn't empty (so they are resolved) and the Due date is also not empty.

If you have this column configuration, including the Resolved (which is the Resolved date) and the Due date, you could do a visual confrontation or export the data to Excel to analyse them.

Hope this helps you.

Cheers

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

jql