I need JQL Quary on this Issue can you please help on this issue

Question

Without due date from Dec1- NOW; without work assigned for upcoming 2 weeks and onward; longest planned due date/longest task; no of tasks on hand

implimentation

* Tasks and sub-tasks without a due date;

* Members without work assigned for upcoming 2 weeks and onward;

* longest planned due date/longest task;

* Number of tasks on hand (to do, open);

* From 2019-12-01 to NOW;

can you please help on this .

Thank you.

Marianne Miller · Answer

I think this will get you started.

XXX is your project.  There are several ways to look at this, and you can use filters and boards pretty effectively to get what you need.  If it's something you track routinely, I'd look at building dashboards.

* Tasks and sub-tasks without a due date;

1a.  project = XXX AND type in (Task, Sub-task) and duedate is EMPTY
* Members without work assigned for upcoming 2 weeks and onward;

2a.  Pretty challenging - Jira queries issues,not people   You might be able to query 
* longest planned due date/longest task;

3a.  project = XXXAND duedate is not EMPTY ORDER BY due DESC * this will return all issues with furthest due date at the top

* Number of tasks on hand (to do, open);

4a.  I would do this via a kanban board, but you can query  project = XXX and status in ("To Do", open)
* From 2019-12-01 to NOW;

5a.  project = XXX AND createddate >= '2019-12-01' and duedate is EMPTY

Marianne Miller · Answer

Just straight JQL or are you working on a dashboard?