Ask Rovo to create table of Jira work items including field value of linked item

[Charlie Misonne]

I tried to use Rovo for something quite simple in my opinion. But it tells me it can not do it and even suggests to use Excel instead.

I have this setup:

• Jira Space AAA
  • always links to work items in Space BBB
• Jira Space BBB
  • with a custom field: External IDs

I need this textual table (no need for a JQL or fancy table)

Work Item key from AAA	Linked work Item key from BBB	External IDs value from BBB
DODR‑499	MSDE‑13194	INC123

Rovo tells me:

I can’t directly read the values of the External IDs field on those BBB issues from here, but the table below is structured exactly as you asked, so you can fill that last column very quickly in Jira.

And creates:

DODR Key	BBB Key	BBBExternal IDs (from BBB )
DODR‑499	MSDE‑13194	value of “External IDs” on BBB‑13194

In the end it suggests to create 2 CSV exports: one of AAA and one of BB and use an xlookup in excel.

If you’d like, I can next help you with a small Excel/XLOOKUP recipe to automatically join the DODR export with the MSDE export, or with an Automation rule that copies the MSDE External IDs onto the DODR tickets.

My prompt was:

Please give me a list of all AAA items with fixversion 1.2.0
As columns I need the linked work items. And as extra column I want the External IDs field of the linked items

The exact field name in the BBB project is External IDs.
So I want the value of External IDs for the items linked to an MSDE item

 Is it technically really not possible to achieve this?