search order by number of linked JIRAs

[Andrzej Tokarski]

Hello, I have two projects: project's X bugfixes are linked to project Y's customer issues. I want to create a filter that would give me a list of X stories ordered (DESC) by a number of linked Y stories.

For now I am ordering by update date:

issueFunction in linkedIssuesOf("resolution = 'Bug in Product'", "solved by") AND project = "X" AND status != closed ORDER BY updatedDate DESC

How to modify this search to include aggregation by number of linked Y issues? something like: "ORDER BY numberOfLinkedIssues DESC"

Do you think JQL Tricks might help here? If so, I'd recommend installing it in my organisation since we need this badly.

Thanks,

Andy Tokarski

[Andrzej Tokarski]

I thought JQL Tricks might improve it. We'll implement your suggestion most probably then. Thanks! Andy

[Jobin Kuruvilla [Adaptavist]]

You won't be able to order by number of linked issues because that is not an attribute on the issue (links are but not the number of linked issues). You can do that only if you capture the number of linked issues in a scripted field or calculated field.