Need a filter which calculates time from last action

[Martin Koisser]

Hello,
I need a filter for a queue for JIRA Servicedesk, which calculates a time of 7 days since the last action. All issues that have not been changed longer than 7 days since the last action should be displayed in the queue.
Unfortunately I can't handle the syntax.
Thanks a lot :-)

[Martin Koisser · Accepted solution]

Ah, OK

Now i have a result, but i think something is going wrong.

The entries are all within 7 days, not longer then 7 days

[Jens]

Just flip > to <

[Martin Koisser]

yep, thats it, thanks a lot for the hints :-)

[Martin Koisser · Accepted solution]

Thanks, i tried to adapt it for my needs, but don't work

issuetype = "Helpdesk Task" AND status = "Warte auf Kunden" and updatedDate > 7

I have a status "Warte auf Kunden", This is set when we need more information from the customer. If the customer don't react in 7 days we close the call.

In this filtered queue i have to identify which tasks are longer than 7 days on the status "warte auf Kunden". I think the statement have to calculate the day from now to last action on the task?

[Jens]

issuetype = "Helpdesk Task" AND status = "Warte auf Kunden" and updatedDate > -7d

The updatedDate is calculated in relation to current date, so -7d means 7 days before today.

[Jack Brickey · Accepted solution]

@Martin Koisser, here is an example but you will want to tweak to meet your precise needs.

status !=resolved and updatedDate <=-7d

if your 'done' status is something other than "resolved" then change it in the above. I'm assuming you wish to exclude completed issues.