"Error in the JQL Query: Expecting either 'OR' or 'AND' but got ','

Anuja Lad

Hi! I am newbie here!
I am trying to get issues by passing some parameters using JQL.
First, I am building normal string for jql 

e.g jqlExpr:::::::: project=Jira&fields=id,key,project,assignee,description,summary,status,priority,reporter,created,updated,issuetype,subtasks&maxResults=-1&assignee=abc

After encoding it with java method : #[java.net.URLEncoder.encode(flowVars.jqlExpr)]

also  i am setting the encoding as 'ISO 10646/Unicode(UTF-8)'
I am passing it the request call as: 

https://<host>/rest/api/2/search?jql=project=Jira&fields=id,key,project,assignee,description,summary,status,priority,reporter,created,updated,issuetype,subtasks&maxResults=-1&assignee=abc


Error message i am getting :
Error: {
 "errorMessages": [
 "Error in the JQL Query: Expecting either 'OR' or 'AND' but got ','. (line 1, character 21)"
 ],
 "errors": {}
}

 

I am not able to understand what's going wrong and how can I resolve?

I appreciate your response.Thanks! 

Warren_mz9b4z

Hi Anuja

assignee=abc is part of the jql, but you've got it as a parameter being passed to the API. Try

jql=project=Jira AND assignee=abc&fields=id,key,project,assignee,description,summary,status,priority,reporter,created,updated,issuetype,subtasks&maxResults=-1

If you still get an error, try copying just the JQL bit (i.e. everything after jql= up to and excluding the first &) into a Jira query and see if there are any errors