Expand my Community achievements bar.

The next phase for Workfront Community ideas is coming soon. Learn all about it in our blog!
Read now

JIRA; Ability to report on items linked to JIRA

Avatar

MatthewMa2
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

feleqyan
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

MatthewMa2
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

MatthewMa2
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

LeeLowe
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

feleqyan
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.

Reply