JQL not statment not working

[Max Williams]

Im trying to show a set of results which is looking for a specific set of part numbers in all statuses except closed. 

I can do it without the part numbers but as soon as I put them in it showes me closed records, which makes me think specifying part numbers superseeds the status filter.

Without part numbers works fine.

project = Projectname AND issuetype = "Repair " AND status in (Preparation, Shipping, "At Supplier", Returning)

With part numbers returns closed tickets

project = ASATSS AND issuetype = "Repair " AND status in (Open, "In Progress", Triage, On-Going, Waiting, "Being repaired", Preparation, Shipping, "At Supplier", Returning) AND "Projectname Part Number" ~ J76100004-403 OR "projectname Part Number" ~ J76100004-401 OR "projectname Part Number" ~ J76100004-405 OR "projectname Part Number" ~  J-76100004-403

I feel I need to add a not statement in i.e. NOT (Status = closed) but im not sure where.

if anyone can help it would be great.

[Joseph Chung Yin]

@Max Williams -

Welcome to the community.  Give this a try

project = ASATSS AND issuetype = "Repair " AND status in (Open, "In Progress", Triage, On-Going, Waiting, "Being repaired", Preparation, Shipping, "At Supplier", Returning) AND ("Projectname Part Number" ~ 'J76100004-403' OR "projectname Part Number" ~ 'J76100004-401' OR "projectname Part Number" ~ 'J76100004-405' OR "projectname Part Number" ~  'J-76100004-403')

I have added ( and ) for the part number portion of your JQL + added ' and ' to enclosed your search value - part number for the like operator.

Hope this helps.

Best, Joseph Chung Yin

Jira/JSM Functional Lead, Global Infrastructure Applications Team

Viasat Inc.

[Max Williams]

Hi @Joseph Chung Yin It is so close!

The only thing wrong is that for some reason it is not showing me requests in the results and i know there are some requests that are not closed, now it is only showing repairs, I guess because this is the only issuetype that is specified.

I appreciate your help.

[Joseph Chung Yin]

It sounds like you are good to go.  If you removed the issuetyupe = "Repair" check, then you will get all the issues from your project that matches your JQL.

Please click on "Accept Answer" when you have a chance if you think my assistance helped you.

Best, Joseph

[Max Williams]

Entered in error