JIRA; Ability to report on items linked to JIRA | Community
Skip to main content
Level 5
March 26, 2018
New

JIRA; Ability to report on items linked to JIRA

  • March 26, 2018
  • 7 replies
  • 1037 views

Now that we have dozens of tasks and issues linked to JIRA, it is very hard to find out which ones are linked and which are not.

We need to be able to filter to these, or add a column in reports, or drive conditional formatting.

7 replies

Level 4
January 14, 2019

Hi Matt. You can have a Task/Issue report that will show only the items linked to Jira. To do so, create a task or issue report in Workfront, and make sure this line is included in the text mode of the report: objectIntegrations:integrationType=JIRA

I hope this help.

Level 5
January 14, 2019

Thanks for Sharing Hayk. I was able to get the filter approach to work. Any idea if this can be reported as data in a column? I tried

valueexpression=IF({objectIntegrations}.{integrationType}=JIRA,"JIRA","")

but no luck.

Level 5
January 14, 2019

Hi Hayk, I also tried

valuefield=objectIntegrations:integrationType

to see if it would just show any integrations without having any IF logic. No luck again. I'm not sure exactly how this info is associated with the Issue itself, but maybe a "collection" column is needed?

LeeLowe
Level 2
January 17, 2019

We've had issues getting the integration with JIRA working and now that it is I need to see which WorkFront tasks did not get automatically created in JIRA. Is there a way to see Workfront tasks that are NOT linked to JIRA?

I would love to be able to do a report or view where I can see the linked JIRA number in a column...

thanks!

Lee

Level 4
February 20, 2019

Matt, you can totally have the Jira tickets' links show up in a column in Workfront. To do so,

  1. Edit your report and add a new column.
  2. Switch to text mode for that column and paste the following:

    displayname=Jira Link
    listedlimiter=<p>
    listmethod=nested(objectIntegrations).lists
    textmode=true
    type=iterate
    valueexpression={URL}
    valueformat=HTML

Lee, the same applies for your question. Just create any report in Workfront to see your tasks and add the same column as described above. If the column is empty, it means that the task or issue is not linked to any Jira ticket.

LeeLowe
Level 2
February 20, 2019

Awesome, that worked! Thank you!

-Lee

Level 5
February 20, 2019

Wonderful, thanks Hayk! Very useful.