JQL assignee gives all past issues also which aren't currently mapped to me.. how to omit those?

Gaurav_igeax9

JQL Query = project  = "Portal" OR project = "Tasks" AND assignee  = [my user name]

above query gives result where in Assignee currently is other than [my user name]. all issues some time in past were assigned to [my user name] for some time.

how to extract data only for [my user name]

 

Mario Carabelli

@Sreenivasaraju Paanswer will help you.

The problem with your query is that jql executes and-statements vefore or-statements. This means you query is equal to:

project  = "Portal" OR (project = "Tasks" AND assignee  = [my user name])

It gives you issues which are either in project Portal (and assigned to anyone) or in project task and assigned to you.

What would also work to fix your jql is the use of parenthesis :

(project = "Portal" OR project = "Tasks") AND assignee = [my user name]

@Sreenivasaraju Pjjql is a short version withe the IN operator but means exactly the same.

With kind regards

Mario