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

Question

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 Answer

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

Cael Metcalfe · Accepted Answer

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