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 "+"
Try doing it in separate queries. Save each query as a filter and then write a JQL to include result from both the filters.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Jerin, you have a couple of AND that are not in caps, I think this makes the query invalid
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
JQL looks valid to me. What is the error message? Is project name, issue type and resolution values valid for your instance?
Ravi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
@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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.