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; } } }

help me this query

Jerin Joseph

project = SIR AND issuetype = "Production Bug" AND text ~ "Contract" AND summary!~"draft" AND created >= 2019-03-02 and issue.property[development].commits > 0 and resolution=fixed

now i want to search those entries whose text does not contain "draft" or "template"

i have tried many times but it results in error

i have tried with including two words in parenthesis, adding them with OR and "+"

Accepted answers

Ravi Sagar _Sparxsys_

Try doing it in separate queries. Save each query as a filter and then write a JQL to include result from both the filters.

All comments

Ravi Sagar _Sparxsys_

Hi @Jerin Joseph

JQL looks valid to me. What is the error message? Is project name, issue type and resolution values valid for your instance?

Ravi

Jerin Joseph

@Ravi Sagar _Sparxsys_ Sorry I didn't realize to edit my question .Thank you so much for your instant response . But I want to search those entries whose text does not contain "draft" or "template".Could you help me with that?

Sara Bibeau

Hi Jerin, you have a couple of AND that are not in caps, I think this makes the query invalid

Ravi Sagar _Sparxsys_

Try doing it in separate queries. Save each query as a filter and then write a JQL to include result from both the filters.

Jerin Joseph

it doesn't matter if its AND or and!

Jerin Joseph

that worked for me ! Thanks @Ravi Sagar _Sparxsys_

Welcome!

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

Quick Links

Find more posts tagged with

jira

jql