Escape Character

[Ramkumar A]

I am trying to use the query in JQL but getting the following error

=JIRA("project = B2B AND issuetype=QA Task OR issuetype=Dev")

Error in the JQL Query: Expecting either 'OR' or 'AND' but got 'Task'. (line 1, character 34)

How do i solve the escape chararcter issue for QA Task?

[Pramodh M · Accepted solution]

@Ramkumar A 

Welcome to the Community!!

Use this

project = B2B AND issuetype="QA Task" OR issuetype="Dev"

[Ramkumar A]

I am using this JQL in Google sheets with JIRA() function and it does not work...

When i tried to use some escape characters, its saying

Error in the JQL Query: '\Q' is an illegal JQL escape sequence. The valid escape sequences are \', \", \t, \n, \r, \\, '\ ' and \uXXXX. (line 1, character 32)

[Pramodh M]

@Ramkumar A 

JIRA("project = B2B AND issuetype='QA Task' OR issuetype=Dev")

Try the above

[Ramkumar A]

This works. Thanks