Xporter for JIRA - Hyperlink escape character


Using JIRA 7.1.7 server + Xporter for JIRA 4.3.0.

Does anyone know if there's an escape character for hyperlinks referencing JQL?

I'm currently writing an Xporter document (output to Word) and am trying to output a hyperlink with the text/title as the JQL count value (working fine), and with the hyperlink taking me to the results of a search query.

For example, given the JQL status = "In Progress", I tried

@{title=${jqlcount:status = "In Progress"|href=${BaseURL}/issues/?jql=status = "In Progress"}

That failed (the output URL was https://jiraserver/issues/?jql=status = ), so I tried:

@{title=${jqlcount:status = "In Progress"|href=${BaseURL}/issues/?jql=status%20%3D%20"In Progress"}

^^ Replace spaces with %20 and = with %3D (resulting in same output, everything after the space after = is truncated)


@{title=${jqlcount:status = "In Progress"|href=${BaseURL}/issues/?jql=status%20%3D%20\"In Progress\"}

This output everything in the URL, but my query still didn't work.

image2016-10-20 13:13:39.png

Does anyone have any suggestions? Should I be trying single/double quotation marks, and escaping/not escaping those?

I've been very careful to make sure that MS Word is using straight quotes and not the stylised ones (as far as I can tell).


PS Would be awesome if there was a feature that allowed templates to do something like this:

${jqlcountlink:status = Open and created > -14d}

Something like that, where the JQL count is returned, and it automatically converts into a hyperlink taking a user to ${BaseURL}/issues/?jql=query

I can only see a few scenarios where that would be annoying, and where it might break a few things for people using ${jqlcount:query}, so suggesting an entirely new function.

1 answer

1 accepted

Hi @Jimmy Van,

You have 2 problems here:

@{title=${jqlcount:status = "In Progress"|href=${BaseURL}/issues/?jql=status = "In Progress"}

A } before |, this is to close the jqlcount function: ${jqlcount:<jql>}.

The other problem is on href definition, you should encode the "In Progress" due to quotes(").

Here is what you need:

@{title=${jqlcount:status = "In Progress"}|href=${BaseURL}/issues/?jql=status = %22In%20Progress%22}


I hope this helps you.



Rui Rodrigues.

Great, thanks Rui. Worked like a charm.

Suggest an answer

Log in or Join to answer
Community showcase
Teodora [Botron]
Published Feb 15, 2018 in Marketplace Apps

Jira Inferno: The Nine Circles of Jira Administration Hell

If you spend enough time as a Jira admin - whether you are managing a single, mid-sized instance, a large enterprise one or juggling multiple instances at once - you will eventually find yourself in ...

1,032 views 6 18
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot