What is wrong with my jql query?

[Akshay Patel]

Hello!

I am trying to search all the issues in the project that has the status of "In analysis" but has not changed statuses into "Selected for Development, In Progress, Done". 

This is what I have so far

Project = "Enterprise Collaboration Platform" AND status IS "In Analysis" AND status WAS NOT IN ("Selected for Development", "In Progress", "Done")

I am getting this error: 

PARSE ERROR: Encountered " "Project "" at line 1, column 1. Was expecting one of: "-" ... ... "(" ... "round" ... "floor" ... "ceil" ... "abs" ... "remainder" ... "sqrt" ... "cbrt" ... "random" ... "pow" ... "max" ... "min" ... "modulus" ... "log10" ... "log" ... "sin" ... "cos" ... "tan" ... "asin" ... "acos" ... "atan" ... "sinh" ... "cosh" ... "tanh" ... "toDegrees" ... "toRadians" ... "numberOfSelectedItems" ... "numberOfAvailableItems" ... "availableItems" ... "allAvailableItems" ... "length" ... ... ... ... ... ... "previousValue" ... "hasChanged" ... "filledInTransitionScreen" ... "second" ... "minute" ... "hour" ... "dayOfTheWeek" ... "dayOfTheMonth" ... "month" ... "year" ... "timePar...

Any help would be much appreciated!

[BolaC]

@Manon Soubies-Camy  Hello, please what is wrong with my query?

project = XXXX AND issuetype in (Analysis") AND >= "2020-01-01 00:00" and created <= "2020-01-31 23:59" AND component = ("Digital Content")

I need all issuetype = Analysis

With component = Digital Content

Between 01/01/2020 AND 31/01/2020

[Warren]

Hi @BolaC 

You're missing the opening quote around Analysis and the word created, plus you don't really need brackets around the component, so it should be

project = GDPSOL AND issuetype in ("Analysis") AND created >= "2020-01-01 00:00" and created <= "2020-01-31 23:59" AND component = "Digital Content"

Try that

[BolaC]

thank you!!

[Manon Soubies-Camy]

Hello @Akshay Patel,

You should write "status = "In Analysis"" instead of "status IS "In Analysis", the below query should work better:

Project = "Enterprise Collaboration Platform" AND status = "In Analysis" AND status WAS NOT IN ("Selected for Development", "In Progress", "Done")

Hope this helps,

- Manon

[Akshay Patel]

Thank you!

[Warren]

Hi @Akshay Patel

I think status IS is causing the problem. It should either be

status in ("In Analysis")

or 

status = "In Analysis"

[Akshay Patel]

Much appreciated!