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?

[Dr Valeri Colon _Connect Centric_]

Hey @Charlie Misonne Partly a prompting issue, but also a product limitation. Rovo’s support for Jira custom fields was improved, but field retrieval is still inconsistent in practice—especially when you need a custom field from a linked issue rather than the source issue itself. Atlassian has acknowledged custom-field gaps, and support has also called similar cases a product limitation. 

So: yes, it may fail today even though it sounds simple. If this must be reliable, use Jira Automation or API/export.

[Rebekka Heilmann (viadee)]

Hi @Charlie Misonne 

could you try something like:

I have this setup:

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

Create a table with the following columns
AAA Key | BBB Key | BBB External ID

Where BBB Key is the linked work item from AAA key.

Get a list of all AAA work items with fixversion 1.2.0 and find the linked work item from Space BBB. Fill those in the table columns 1 and 2.

Then go over all BBB work items and read each "External IDs" field and add those to column 3.