nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

JIRA JQL query: assignee or comment not changing for 'X' days

Andrés Trujillo_yb7a0k

I'm trying to check if the assignee of a ticket hasn't changed for a specific amount of time (e.g. 3 days). As an alternative I could search for comments not being updated (which might be the better way).

As our sprints are a week long I can't go with "updated" it seems, as a ticket is updated when I finish last weeks sprint and start the new one.

This is my idea (which didn't work):

project = RS AND status in ("Warte auf Umsetzung", "In Arbeit", "Überarbeitung erforderlich", "Wieder geöffnet") AND updated <= -1d AND assignee in (EMPTY) AND Sprint in (futureSprints(), openSprints())

Best regards,

Andrés

Accepted answers

Andrés Trujillo_yb7a0k

project = RS AND assignee in (Reuter) AND assignee changed to (Reuter) before -2d AND Sprint in (futureSprints(), openSprints()) AND NOT status = Geschlossen

All comments

Alexey Matveev

Hello,

You can right a JQL query like this to check if the assignee was not changed for 3 days:

not assignee changed after 3d

But you can not do the same for the comment field out of the box.

Andrés Trujillo_yb7a0k

Hello,

it works better now, but still I don't see all tickets that have had their assignee changed (to empty).

I'm guessing that the problem comes from the fact that I am not assigning a specific user, but setting it to 'empty'.

When checking all activities I actually don't see the assignee being change to empty either.

Query looks like this now: "project = RS AND status in ("Warte auf Umsetzung", "In Arbeit", "Überarbeitung erforderlich", "Wieder geöffnet") AND assignee in (EMPTY) AND NOT assignee changed after 1d AND Sprint in (futureSprints(), openSprints())"

Alexey Matveev

Try like this:

not assignee changed after -3d

Andrés Trujillo_yb7a0k

It's still not working. The query also shows me tickets that have been changed and hour ago.

I again changed the query a bit to make sure that tickets, that have been assigned to "Reuter" for at least a day (at least that was my intention):

project = RS AND assignee in (Reuter) AND assignee changed to (Reuter) after -3d AND assignee changed to (Reuter) before 1d AND Sprint in (futureSprints(), openSprints()) AND NOT status = Geschlossen

But that doesn't works either. Not sure what I'm still making wrong.

I would have thought that this was a more common query to check wether a ticket is in someones possesion for longer than a specific amount of time.

Andrés Trujillo_yb7a0k

project = RS AND assignee in (Reuter) AND assignee changed to (Reuter) before -2d AND Sprint in (futureSprints(), openSprints()) AND NOT status = Geschlossen

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

jql

query