nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Adding a link to a JQL with a variable

James K_

Hello,

I'm attempting to set up an automation that adds a link to a custom field "LINK" when another custom field "CustomOrg" is updated. The link would only be visible internally to customer support members and provide a link to a JQL query that would search "CustomOrg[Dropdown]" = "VARIABLE", where variable would be the field selected from the dropdown. The field CustomOrg contains characters such as # and [] so these need escaped if I'm to pass in the link.

Essentially I'm trying to make it easier for agents to be able to quickly see all tickets created by a particular organization, so there may be a more straightforward way to do this that I haven't encountered or thought of.

I've found https://confluence.atlassian.com/jirakb/use-automation-to-edit-link-formatting-on-paragraph-fields-1157182190.html, and attempted to set up something similar, but I'm not seeing my custom field (set up as a Text Field (multi-line), after trying hyperlink).

I don't necessarily want to link all tickets from a customer using the linked ticket option, but rather have the link to the JQL query so an agent can then click on a ticket and then use the forward and back buttons to advance or regress through the JQL results.

Thank you for any assistance.
-James

Accepted answers

Kai Becker

Hi @James K_ ,

could you post a screenshot of the automation you've got so far?

As an alternative, I would suggest the following addon: https://marketplace.atlassian.com/apps/1212709/issue-matrix-for-jira?hosting=cloud&tab=overview

It adds an contextual issue view with issues matching a certain JQL query

All comments

Kai Becker

Hi @James K_ ,

could you post a screenshot of the automation you've got so far?

As an alternative, I would suggest the following addon: https://marketplace.atlassian.com/apps/1212709/issue-matrix-for-jira?hosting=cloud&tab=overview

It adds an contextual issue view with issues matching a certain JQL query

James K_

I've managed to automate pulling the field value and building the URL for the JQL query, and storing that into a SmartVariable:

Next I'm running a replace on that SmartVariable to encode " ", "/" and "-", as those are present in my customfield_12312 values:

Next I'm formatting the full link with our Jira domain:

Now the only issue I'm having is having the link in my field actually represent the whole link.

Currently, I'm passing in a variable (FormatURL), and I've tried:

{{FormatURL.replaceAll("(?<=\|)(.*?)(?=(\]|\|))","$1|smart-link")}}
[{{FormatURL}}|Click here]
<a href="{{FormatURL}}">Click Here</a>

but to no avail.

I've configured my custom field I'm passing the variable into to use the 'Wiki Style Renderer', but I'm ending up with only a partial link where "https://vardomain.atlassian.net/issues/?jql=" is formatted as a link, but the actual JQL bit isn't included:

In the above I'm just passing in {{FormatURL}}, and if I copy that into my address bar, I can navigate to the correct query. I'm not entirely sure why my link is being split.

James K_

I've done some tinkering and have managed to fix the split URL by using {{CreateURL.encodeURL}} in my second step:

Resulting in a complete link:

However, I'd like to be able present a simpler link and

{{FormatURL.replaceAll("(?<=\|)(.*?)(?=(\]|\|))","$1|smart-link")}}
[{{FormatURL}}|Click here]
<a href="{{FormatURL}}">Click Here</a>

still don't seem to work.

James K_

Fixed, [Click here for all tickets from this customer|{{FormatURL}}] works.

Tomasz Rogawski

Easiest but not prettiest solution for me was to add a sample URL with JQL query from Jira in the template and then replace values with the variables that will change. See an example:

URL Confluence variables and JQL query.png

A user will have to provide these two variables in one place only, resulting in all URLs being updated, and pointing to different Jira items (Story, Tasks, Tests, Bugs).

FYI: The issue I haven't resolved yet is converting URL to Jira table inside Confluence page before/after it is published. Most probably I will have to use a source editor to modify structured macro HTML parameter.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

automation

jira-service-management-cloud

jira-service-management