Query No Pending issue's

[Niels Frederickx]

How can I set a query not showing pending issue's?

This is what I use now, but I don't know how to incorporate no pending issue's.

resolution = Unresolved AND (duedate <=    now()  or duedate is EMPTY) and assignee = me

I thought adding "AND NOT pending" would work, but it is not possible.

This is very new to me, so thanks for any advice!

[NT · Accepted solution]

I still dont understand your question.

What do you mean my "NO Pending issues" ?

Does that mean list of all  the issues which are completed?

[Niels Frederickx]

Sorry,

I want to create a query that shows all unresolved issues minus the ones that are set as pending.

Thanks!

[NT]

See there are two things one is Resolution and other one is Status.

So if Pending is your issue status you ca write query like this

Status Not In (Pending, Completed, Done) and Assignee = <your name>

Put all status in above query which you want to exclude..

You can also write query like below one

Status in (ToDo, InProgress, ReadyQA) and Assignee = <your name>

Put all the status in above query which represent unresolved status of the issue

Now in case Pending is your Resolution state 

Resolution not in (Resolved, Pending) AND Assignee = <your name>

put all resolution state you want to exclude..

Hope this helps!!!

[Niels Frederickx]

Thanks! That was exactly what I needed

My current working query:

resolution = Unresolved AND status not in (Pending) and (duedate <=    1w  or duedate is EMPTY) and assignee = me

[NT]

Great!!!!

Please accept the answer and vote it up..