Query: custom field not completed after a period of time

[Pablo Aschieri]

I can´t solve this query:

•  A certain field isn´t completed after 7 days of the creation of the ticket. Thanks!

[Ligia Merciu · Accepted solution]

Hi Pablo,

Usually, you can't compare with a date field, but with a certain date, like in

assignee is EMPTY AND not (assignee changed AFTER 2019-05-01)

But, as your questions refers to changes after a period of time, probably something like

assignee is EMPTY AND not (assignee changed AFTER -7d)

should be closer.

Otherwise, you'd need some plugin to create more customized queries.

[Pablo Aschieri]

Thank you!