Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

How do I reference a project with spaces and special characters in the JQL of an escalation service?

Andy Hurley
Contributor
February 28, 2020

I have a project called "Scheduling & Listing" and have a query that runs just fine in JIRA but when I try to use that same query in an escalation service I get the message:

Error in the JQL Query: The quoted string 'Scheduling ' has not been completed. (line 1, character 11)

Presumably I need to escape the ampersand in some way but I have tried all the methods I know of without success. 

If I leave the project selection out of the JQL then the escalation runs ok but I need to restrict this service to just one project.

Any clues?

3 answers

1 accepted

0 votes
Answer accepted
Payne
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 28, 2020

Try using its ID rather than its name (e.g. project = 10800). One way to find that value: go into the project's settings (cog icon in the lower left) and then hover over the Details link in the left sidebar.

jira.png

Andy Hurley
Contributor
March 2, 2020

Thanks, using the id works which gets round my immediate problem so I have accepted this answer. I'm sure there must be a way to escape the ampersand but this is an acceptable workaround, thanks. As I guess would be writing a saved filter and using 'filter = 123' which I had considered but did not want to do for ease of maintenance reasons.

1 vote
Payne
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 2, 2020

Ah, here we go - use the Unicode representation of the ampersand character:

project = "Scheduling \u0026 Listing"

0 votes
Jack Nolddor _Sweet Bananas_
Atlassian Partner
February 28, 2020

Hi all, this should work as is:

project = "Scheduling & Listing"

 

Simply use double quotes within the name of your project,

Regards

Andy Hurley
Contributor
March 2, 2020

I was using double quotes - it still fails when used in the query of an escalation service.

Suggest an answer

Log in or Sign up to answer