Search remote links in a structure formula

[Paul Doman]

Hello,

We've recently upgraded to Structure 7.3 and adopting many of the new "formula" capabilities. One of the areas I need to use it is Remote Links for issues.

In ordinary JQL I can use: 

issuefunction in linkedIssuesOfRemote("relationship", "adhoc") 

to identify those issues which have this particular remote link injected. If I try

IF JQL (issuefunction in linkedIssuesOfRemote("relationship", "adhoc")) ; "found"

in my FORMULA, Structure returns "Please fix the formula to edit variables." with the red highlight starting at "in" and onwards.

I welcome suggestions.

Many thanks

Paul

[David Niro · Accepted solution]

Hello @Paul Doman ,

David from ALM Works here.  

issuefunction in linkedissuesOfRemote... is actually a Script JQL Function from Scriptrunner.   I mention this because it may not work after correcting the syntax issue or ,if it does work, could cause the structure to load slowly.  There is some documentation from Adaptavist that highlights how to troubleshoot and optimize a slow query here.

Disclaimer out of the way, for the JQL function, we need to use the curly bracket option JQL{}.  And for the end of the IF conditional statement, we need to use a colon rather than a semicolon.  These two adjustments should get rid of the error you received.

IF JQL {issuefunction in linkedIssuesOfRemote("relationship", "adhoc")} : 
  "found"

Please let me know if this helps!

Best,

David

[Paul Doman]

Thankyou David for your prompt reply-

This works perfectly. I had misread the bracket type required.

I have read the information on performance guidelines and can immediately think of several filters which would benefit from refinement.

Kind regards

[David Niro]

You are very welcome!  Glad to hear it is working now!!

[Becky Yu]

Hi @David Nirothank you for the solution! This is helpful for our team too.

Do you know how can I return the list of the name of the matching remote links? Thanks!

[Stepan Kholodov _Tempo_]

Hello @Becky Yu 

At this time, Structure doesn't have full access to remote links. You can only show all links in an issue - both internal and external - by adding the Linked Issues column. The ability to filter that list is not yet released.

If you have more questions about Structure, please reach out to us directly at our support portal.

Best regards,
Stepan
Tempo (the Structure app vendor)

[Becky Yu]

Got it. Thank you Stepan for the prompt response!