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

What is wrong with my jql query?

Akshay Patel_dq3jks

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!

Accepted answers

All comments

Warren_mz9b4z

Hi @Akshay Patel

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

status in ("In Analysis")

status = "In Analysis"

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_dq3jks

Thank you!

Akshay Patel_dq3jks

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_mz9b4z

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!!

Welcome!

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

Quick Links

Find more posts tagged with

jira