How to write a JQL query that will return all pending tasks in a project with the key "PROJ"

[Bruno Jimenez]

Dear community need your HELP. I have two questions, appreciate your support.

1. How to write a JQL query that will return all pending tasks in a project with the key "PROJ"?

2. how to write a JQL query that finds all issues that do not have an owner specified and that have a status of "Open" or "New" but were updated in the last month.

[Florian Bonniec · Accepted solution]

Hi @Bruno Jimenez 

Welcome to the community

1- project = PROJ and status = pending

2- Owner is empty and status in (Open, New) and updated < startOfMonth()

Regards

[Bruno Jimenez]

Hi @Florian Bonniec  thanks a lot for help! Appreciate it!

[Cael Metcalfe · Accepted solution]

1. Assuming issue type is "Task" and "Pending" is the target status:

project = PROJ AND type = Task AND Status = Pending

2. Assuming "Owner" is the name of your custom field, and you mean the calendar month before the current:

Owner IS EMPTY AND Status IN (Open, New) AND updated < endOfMonth(-1) AND updated >= startOfMonth(-1)

Else just date back one month, change end to: updated > -1m

[Marc - Devoteam]

Hi @Bruno Jimenez 

Welcome to the community.

JQL: project = "PROJ" and type = Task and status = Pending

This should help you to find the JQL for option 2 as well.

JQL: status in (Open, New) and .....