Sort issues in one project by a field from another project jira

MGMKLML

I have the following use case:

1. I have two company-managed projects, let's call them `AA` and `BB`
2. Let's suppose that the project `BB` has a custom field called `Total sum`. 
3. Let's suppose that some of the issues from the `AA` project are linked with some issues from the `BB` project.

I would like to build the following JQL:

Find all issues in the project AA that are linked with issues BB and sort these issues from AA in the descending/ascending order of the "Total sum" field from the BB project. If there are multiple links to one issue from AA then take the highest value of the "Total sum" field from the links.

---

Example:

1. Links:
   1. Issue AA-2 is linked with BB-5 and BB-6
   2. Issue AA-4 is linked with BB-4
   3. Issue AA-8 is linked with BB-5 and BB-7
2. "Total sum" values:
   1. BB-4 -> 25
   2. BB-5 -> 20
   3. BB-6 -> 38
   4. BB-7 -> 31
3. Suppose I want to list AA issues in the descending order. So the expected result of the search query should be issues from AA in the following order:
   1. AA-2
   2. AA-8
   3. AA-4

---

P.S. If it is achievable through some extensions/plugins apart from leveraging the Jira's API manually to build the sorting mechanism, feel free to recommend such extensions.

Clark Everson

Hi @MGMKLML 

Welcome to community!

I don’t believe natively this is possible.

however this can be achieved via scriptrunner as you would need to make some scripted fields and also use scriptrunners advanced JQL to do this

https://scriptrunner.adaptavist.com/latest/jira/jql-functions.html

best,

clark