Search for issues/tasks with a duedate in the next week/month/overdue on NextGenBoard?

brage

Hi! I am trying to search for issues/tasks based on due date in the NextGen template. Tested stuff like this:

duedate <=1w (trying to find all task that are due within a week)
duedate <=30d (trying to find all task that are due within a month)

But it is not working. What do i do wrong? 

Avinash Bhagawati _Appfire_

Hi @brage ,

You can use below quires.

For Next Week ( from today to next week day),

project = "New Testing Project" AND due<=1w AND due>= now() AND issuetype = Task

For next week ( from Sunday to Saturday) ,

project = "New Testing Project" AND due<=endOfWeek(1) AND duedate>=startOfWeek(1)

For Next 30 days ( from today to next 30 days)

project = "New Testing Project" AND due<=30d AND due>= now() AND issuetype = Task

For current month:( Due dates are within current month. eg for Nov month)

project = "New Testing Project" AND due<=endOfMonth() AND duedate>=startOfMonth()

For overdue:

project = "New Testing Project" AND due<=now() AND resolution is EMPTY

Thanks,

Avinash