In clause in Query

Question

When I am trying to use jql like below

createdDate >= "2022-08-01" and issuetype = "Bug" AND project in ("project1" , "Project2") AND "Change Type" = New

then I am getting below error.

Caused by: com.atlassian.jira.rest.client.api.RestClientException: [ErrorCollection{status=400, errors={}, errorMessages=[Error in the JQL Query: Expecting ')' before the end of the query.]}]

When I change jql to below :

createdDate >= "2022-08-01" and issuetype = "Bug" AND project in ("project1") AND "Change Type" = New

or

createdDate >= "2022-08-01" and issuetype = "Bug" AND "Change Type" = New

it works fine.

So something in "IN" clause with spaces not working correctly for me. Could you please guide me how JQL should be provided in above case?

Trudy P Claspill · Answer

From research I did yesterday it appears that you are using the Jira Java REST Client. Unfortunately I don't have any experience with that or Java.

I am suspicious of how the query string is getting assigned to the "jql" variable that is getting passed into the API call. The query string contains several characters that may need to be escaped to pass through correctly into a string variable in other languages. I'm not familiar with the string manipulation rules for Java.

Can you output the value of the "jql" variable to see if it matches what you expect?

Can you put the query string in to the API call rather than using the "jql" variable and see what the result is?

Harshal Gaikwad_arrnei · Answer

it is loaded from external config file

jql=createdDate >= "2022-08-01" and issuetype = "Request Change" AND project in ("project1", "project2") AND "Change Type" = Evolutive

Trudy P Claspill · Answer

Can you show us the code where you are assigning the text to the "jql" variable that you use in the above code?