jira query for overdue tickets more 3d based on a DL (only my managers team)

REVANTH SIDDU March 20, 2023

want a jira query for :

Jira tickets passed the due date by 3 days and from people only under my manager team only (we have/ can create a DL/ORG/GRP)

 

used this query but not giving any results 

project = "projectX" AND assignee in membersOf("ORG-xxx") AND duedate < now() AND resolution = Unresolved AND assignee = currentUser() ORDER BY priority DESC

1 answer

0 votes
David Bakkers
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 20, 2023

Hello @REVANTH SIDDU 

 

You have two assignee declarations. By saying the assignee in membersOf() AND assignee = currentUser(), you are creating a paradox, as no Issue can have an Assignee which is both one AND the other.

REVANTH SIDDU March 21, 2023

yeah so dumb forgot to remove the assignee = currentUser()

I figured it out when JQL throwing me errors

 

Thank you 

Suggest an answer

Log in or Sign up to answer