Expand my Community achievements bar.

Join us LIVE in San Francisco on November 14th for Experience Makers The Skill Exchange. Don't miss out on this free learning event!

JIRA; Ability to report on items linked to JIRA

Avatar

Level 6

3/26/18

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 Comments

Avatar

Level 5

1/14/19

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.

Avatar

Level 6

1/14/19

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.

Avatar

Level 6

1/14/19

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?

Avatar

Level 3

1/17/19

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

Avatar

Level 5

2/20/19

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.