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

[Gaurav]

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 · Accepted solution]

@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

[Gaurav]

great  -- that worked -- Many Thanks..

[Mario Carabelli]

My pleasure.

With kind regards

Mario

[Sreenivasaraju P]

You can correct your query as shown below. Both the queries work. Recommend the second query

1. project  in  ("Portal" , "Tasks") AND assignee  = [my user name]
2. project in  ("Portal" , "Tasks") AND assignee = currentUser()

[Jack Brickey]

If you want only issues currently assigned to you ...

...AND assignee = currentuser()...