Can't figure out how to exclude archived tasks from custom view

[stacy.baca]

I'm trying to create a custom view that includes all status except for archived where I am the reporter and/or the assignee. 

Currently I have it set up like this, but archived tickets are showing up. Can anyone see what I'm doing incorrectly?

project = ADOPS AND status in(LIVE, "Order Prep", Trafficking) AND REPORTER in (stacy.baca) OR assignee in (stacy.baca)ORDER BY Rank ASC

[Petter Gonçalves · Accepted solution]

Hello Stacy,

Welcome to Atlassian Community!

The problem of your query is at:

AND REPORTER in (stacy.baca) OR assignee in (stacy.baca) ORDER BY Rank ASC

the OR parameter that you are using does not apply to the statuses you mentioned in the query. 

That been said, you must use Brackets to put together the JQL REPORTER in (stacy.baca) OR assignee in (stacy.baca)ORDER BY Rank ASC, so you will be able to apply both sentences together with the specified statuses. There you go:

project = ADOPS AND status in (LIVE, "Order Prep", Trafficking) AND (REPORTER in (stacy.baca) OR assignee in (stacy.baca)) ORDER BY Rank ASC

We will be waiting for your answer to know if it worked as you expected.

[stacy.baca]

Hello @Petter Gonçalves,

Thank you for your help, it worked perfectly!!!

All the best,

Stacy 

[Petter Gonçalves]

You are welcome, Stacy.

Have a nice day!