Is it possible to create custom JQL functions for JIRAs Cloud installation?

So I've written and tested a custom JQL function following what I thought was cloud based tutorials but apparently they weren't!  When I attempt to include my addon on the market place (via the packaged up .jar) the "availability" is locked as "Only Server customers using products they host themselves"?  Please note, I have used Atlassian Connect to successful build other Cloud addons but I must have missed the bit of documentation re building Cloud based functions?

Has anyone out there successfully create a cloud usable function, if so - how?

4 answers

1 accepted

2 votes

Nope, Connect does not allow you to create JQL functions (yet).  You can only do them in type-2 addons, which you cannot add to Cloud.

Thanks Nic, but there must be some way to do it as I see there is a Cloud addon called JQL Pro (https://marketplace.atlassian.com/plugins/jql-pro) that promises the functionality I/we require. I'd use that but in trialing it we've found it is quite feature lite - let's say...

Ah, I see. But it's not doing what you suggest. The addon scrapes data out of JIRA and then allows you to run queries on that. It does not add a JQL function. Doing that is the only approach I think you can do with a Connect addon. You certainly can do "Issue in hasLink(blocks)" with that method - scrape the issue for its links and iterate over them for the name of the link type.

ewww - that's just nasty! I see your point but if I take that approach then anytime a tricky query is required I'd end up having to create a new ACE addon/report or simply re-invent a new Issues Navigator (like JQL Pro are doing). That really is a shame, as in this case the proposed function really is just a small change/extension to the Issues Navigator, and would allow us to use other existing features like the Bulk Change tool and Export; without the need to re-invent the wheel as they say. Thanks for your assistance Nic and Kathryn.

Yup, it is definitely not a solution I'd call "graceful" (Scraping a system to index it elsewhere when it's already got an index is never "graceful" IMHO) I'd raise the JQL function as a JIRA improvement over at https://jira.atlassian.com/browse/JRA (check to see if it's not already been raised if you can). If Atlassian accept it and implement it, Cloud will be the first to get it. (Let us know if you do that here, I'd vote for a generalised version of it)

I just searched the JIRA issue tracker and found several references to the type of issue I'm experiencing here.  i left my vote and comment on JRA-25640 :: JQL function for showing all issues linked to any issue by a given issue link type.

Please vote and encourage this body of work!

2 votes

There is another add-on at https://marketplace.atlassian.com/plugins/jql-extensions/cloud that also provides custom JQL in the Cloud. Not sure how it works though

Those functions are generally not available for JIRA Cloud due to security precautions. It's highly unlikely that your function will work in the Cloud environment. Not knowing exactly what you have done, my analysis would be no. sad

Thanks for the quick response Kathryn. My function is pretty simple, given the Name of a Linkage type as a parameter it returns a list of Issues, i.e. it determines if an issue has a specific linkage inward or outward. An example of its JQL usage is: Issue in hasLink("Blocks").

Suggest an answer

Log in or Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

3,111 views 13 19
Join discussion

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