Structure: Use Formula column to capture issues "mentioned in" Confluence?

[KD]

I am trying to use the Structure Formula column to visually annotate issues that are "Mentioned In" particular Confluence pages. Ultimately I am trying to display a notation where "Mentioned In" is a specific page, such as "This Confluence Page".

To start off, I am simply trying to capture any issues that have the "Mentioned In" link type at all, and it is not working for me in the same way that other link types are working.

For example, the following works correctly for me, using a more standard issue link type (issues linked to each other within Jira).

• Display a 'flag' icon on any issues with the link type "Caused By":

• IF issueLinks.FILTER($.type = "caused by"):"(flag)"

However the following does NOT work for me:

• Display a 'flag' icon on any issues with the link type "Mentioned In":

• IF issueLinks.FILTER($.type = "mentioned in"):"(flag)"

Does anyone know if there is a way to accomplish this currently?
Or if there are any related feature requests I could follow?

Thanks!

[KD · Accepted solution]

I have found one workaround, by working backwards from Confluence and using the Query column in Structure, rather than Formula. On the Confluence page there is a "Jira Links" link at the very top, which can then open up the Jira Issue Navigator with a rather long, hashed query of the exact app ids / page ids, that surfaces the issues I want to display. I can then copy/paste this query into the Query column type and get a very basic visual representation.

This is still not ideal as I can't customize anything further than what the query can surface, which I would be able to do using the Formula column. But it works in a pinch.

The query ended up something like...

issue in (issuesWithRemoteLinksByGlobalId('appId=HASHVALUE&pageId=HASHVALUE'),issuesWithRemoteLinksByGlobalId('appId=HASHVALUE&pageId=HASHVALUE'))

[David Niro]

Hello @KD ,

David from ALM Works here.

What version of Structure are you currently using?  7.0 introduced the ability to use JQL within a formula.  (you can find the version by clicking on the info button bottom right corner of your structure).

If you are on 7.0 or higher, have you tried;

IF (JQL{
issue in (issuesWithRemoteLinksByGlobalId('appId=HASHVALUE&pageId=HASHVALUE'),issuesWithRemoteLinksByGlobalId('appId=HASHVALUE&pageId=HASHVALUE'))}
;"(flag)")

I believe it should work, but have not had a chance to test it.  Please let me know if it helps!

Best,
David

[KD]

Pure genius! That worked perfectly! :D 

Thank you so much, that is super useful to know. I have been scouring the ALM Structure User's Guide and this wasn't apparent to me. 

[David Niro]

@KD very glad to hear it worked for you!!  You are very welcome!

There certainly can be a lot to digest while getting familiar with formulas.

One place I usually start when trying to come up with a new formula is our Sample Formulas page.  It gives me an idea of where to start and then I use the Function and Variable reference pages, as well as others, to identify some adjustments that are possible.

Best,
David

[KD]

Wouldja look at that... great tips. Thank you again. :) 

[KD]

-