I am getting error when I enter the following search query. Could you help me debug it?

Shyam Ganesh kandasamy

project = WECONNECT

AND (status was not “in Approval” AND status was not “Released” AND status was not “Done”) AND status changed to "in qa" during (startOfWeek(1d), endOfWeek(1d))

OR (status was not “in qa” AND status was not “Released” AND status was not “Done”) and status changed to "in approval" during (startOfWeek(1d), endOfWeek(1d)) 

OR (status was not “in approval” AND status was not “Released” AND status was not “in qa”) and status changed to “done” during (startOfWeek(1d), endOfWeek(1d)) 

OR (status was not “in approval” AND status was not “done” AND status was not “in qa”) and status changed to “released” during (startOfWeek(1d), endOfWeek(1d)) )

 

I am getting the following error

"Error in the JQL Query: Expecting either 'OR' or 'AND' but got 'Approval”'. (line 1, character 46)"

Note: I have included extra spaces for better readability.

Walter Buggenhout

Hi @Shyam Ganesh kandasamy ,

It is not easy to debug without the actual error message nor access to the results, but 2 recommendations:

First, you could shorten your syntax a bit. I would re-write e.g the first status part as follows:

AND (status was not in (“in Approval”, “Released”, “Done”) AND status changed to "in qa" during (startOfWeek(1d), endOfWeek(1d))

Second, assuming that all your status clauses refer to the same project, add brackets around those parts as well to make sure all clauses are applied to your project. I mean the following:

Project = WECONNECT AND ((clause 1) OR (clause 2) OR (clause 3))