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.

[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

[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?

[Bill Sheboy]

Hi @Samuel Prathipaty 

I do not know as I do not use that app / plugin.  Perhaps check with the vendor's documentation to learn if it will help.

Kind regards,
Bill

[Valerie Knapp]

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

[Valerie Knapp]

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