JIRA; Ability to report on items linked to JIRA

[#1]

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.

[#2]

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.

[#3]

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.

[#4]

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?

[#5]

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

[#6]

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.

[#7]

Awesome, that worked! Thank you!

-Lee

[#8]

Wonderful, thanks Hayk! Very useful.