How to fetch linked record key based on JQL Search

[Moogambigai G R]

Hi Guys,

I have a question on how to get the linked record key based on dependent linked record customfield value in columns.

This should work whenever i use in JQL search.

Scenario: 

Issuetype: Defect,Requested Release
Here we are linking 'Requested Release' record to defect record.
In JQL, We are searching the defect record must have linked "Requested Release" record and "Customer Release"(In Linked record field) have "D8.0" value.

In customfield I want to display the key and status of "Requested Release" record have D8.0.

Note: In Defect record, multiple 'Requested Release' can be linked. But in JQL, if i search one "customer Release" value, that record key and status alone need to be displayed.

Project = "Discovery-Based Programs" AND type = Defect AND "RR Cust Releases" = D8.0 AND issueFunction in linkedIssuesOfAll("issuetype = 'Requested Release' AND 'Customer Release' = 'D8.0'")

Regards,
Moogambigai

[Sergei Troshin]

Hi @Moogambigai G R 

Unfortunately, JQL does not provide this feature out of the box. The fact is that the columns in the JQL-search represent the values of the fields in the issues. And the values of the fields in the issues are independent of the JQL.

I think an option for you would be to create a custom report using ScriptRunner.
Or you can also pay attention to the Structure plugin, it allows you to display values calculated using formulas in columns.