nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

JQL help for advanced search

Sierra_f2eqyc

project = SL AND status in (Done, "Resolved")AND assignee in (609c1a6a47ba02006facea20, 5cbdc4c8e494c810153acce8) AND "Request Type" = "Report Netsuite Incident (SL)" OR "Request Type" = "Request Netsuite Support (SL)"

I need to add to this query , I only want to see tickets that were resolved for the request types in the last 7 days.

adding AND resolved>= -7d ,takes my results from 435 to 25 , but , it's still capturing tickets that were resolved from September .. not sure why. Thoughts ?

Accepted answers

Nic Brough -Adaptavist-

This is probably because using a mix of and and or without specifying it carefully leads to Jira not running the query you think you have written, It reads left to right through your query, and so what your query is saying is:

(Project, status, assignee and Report Netsuite Incident) or (request Netsuite support and resolved >= -7d

You could drop the or out, or use parenthesis to explain the question to Jira:

project = SL AND status in (Done, "Resolved")AND assignee in (609c1a6a47ba02006facea20, 5cbdc4c8e494c810153acce8) AND "Request Type" in ( "Report Netsuite Incident (SL)", "Request Netsuite Support (SL)") and resolved >= -7d

project = SL AND status in (Done, "Resolved")AND assignee in (609c1a6a47ba02006facea20, 5cbdc4c8e494c810153acce8) AND ("Request Type" = "Report Netsuite Incident (SL)" OR "Request Type" = "Request Netsuite Support (SL)") and resolved >= -7d

All comments

Nic Brough -Adaptavist-

(Project, status, assignee and Report Netsuite Incident) or (request Netsuite support and resolved >= -7d

You could drop the or out, or use parenthesis to explain the question to Jira:

Rilwan Ahmed

@Sierra

Try this

project = SL
AND status in (Done, "Resolved")
AND assignee in (609c1a6a47ba02006facea20, 5cbdc4c8e494c810153acce8)
AND ("Request Type" = "Report Netsuite Incident (SL)" OR "Request Type" = "Request Netsuite Support (SL)" )
and resolved >= -7d

Please share the screenshot if still it has wrong results

Nic Brough -Adaptavist-

I don't think a screenshot is going to help - the text of the query is telling us all we need to know

Sierra_f2eqyc

I see, thank you !!!

Rilwan Ahmed

@Nic Brough -Adaptavist- Modified JQL

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

jql

jira-service-management-cloud

jira-service-management