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 "+"

[Ravi Sagar _Sparxsys_ · Accepted solution]

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]

that worked for me ! Thanks @Ravi Sagar _Sparxsys_ 

[Sara Bibeau]

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

[Jerin Joseph]

it doesn't matter if its AND or and!

[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?