Reporting functionalities for Salesforce & JIRA Cloud Connector

My aim is to have a report with two columns, one for case number and one for the linked JIRA issue reference.

 

Thanks

Sam

  • Sam Gatica
  • Sep 16 2016
  • Shipped
  • Apr 16, 2018

    Admin response

    Reporting BETA is out.

  • Attach files
  • Juan Recabarren commented
    15 Sep, 2017 02:47pm

    Similar request:

    We're using the Salesforce & JIRA Cloud Connector to associate Jira tickets to Salesforce accounts. Is there a way to report on Jira tickets and the associated SF accounts? Visually we can see that info in the UI, but want to view or download report of associations across all Jira tickets and SF accounts. In Jira, I can search "salesforceAssociatedIds is not null" to get all associated tickets, but it requires clicking into ticket to see associations. Any ideas on how to do this?

    Example format showing associations could be like following (1 row per association):
    Account A | Jira Ticket 100
    Account B | Jira Ticket 100
    Account B | Jira Ticket 200

    Customer: John Cunningham, VP, Software Development | QGenda

    Case reference: https://servicerocket.desk.com/web/agent/case/78270

  • Kevin Lew commented
    24 Aug, 2017 01:04am

    CASE #76435

     

    I’m looking to confirm if there is any way to report on many-to-many links using the Salesforce JIRA Cloud Connector. Our current set up is that the JIRA Key is will sync to a field on the case, but this will only help us identify 1:1 connections of Cases to JIRA Issues. If we are looking to run a report that will display all JIRA Issues connected to a Salesforce case, is there a way to accomplish that?

  • Juan Recabarren commented
    10 Jul, 2017 08:19pm

    Adding customer requesting additional reporting capabilities for the Connector:

    https://servicerocket.desk.com/web/agent/case/65896

  • Azwandi Mohd Aris commented
    8 Jun, 2017 01:51am

    There's also a need to work with external reporting tool - Looker. JQL and JIRA REST API provides this avenue.

  • Juan Recabarren commented
    29 May, 2017 04:34pm

    Another customer is requesting additional reporting capabilities for the Salesforce Connector.

    Case Reference: https://servicerocket.desk.com/web/agent/case/66881

  • Juan Recabarren commented
    29 May, 2017 03:33pm

    This customer is requesting this type of reporting capabilities for the JIRA Salesforce Cloud Connector:

    I'm trying to generate a report that lets me slice / dice my account information by my tickets in jira, for example:

    • Count of tickets by Account Tier (where tickets are associated with an account in Salesforce and Tier is a custom attribute on the Account)
    • Breakdown of ticket category by Account Stage (where account stage is a custom field in Salesforce)

    Case Reference: https://servicerocket.desk.com/web/agent/case/67555

  • Adrien Low commented
    20 Apr, 2017 06:24am

    Case #62008

    I need to be able to export Case details for groups of Jira tickets. I want Jira ticket #, count of cases for each ticket, and "Case Number"s of Salesforce cases .

    Presently, all I seem to be able to do from Jira is view details for associated Salesforce cases on a case by case basis from Jira tickets on a ticket by ticket basis. (See the attachment)

    Do you have some kind of portal or API where I can retrieve this data? Or a way to tell Jira to make it exportable from within that environment?

     

    *Not migrated customer

  • Adrien Low commented
    30 Nov, 2016 12:18am

    Case #39457

    However, we were using that detail report at the time of a Software Release to count how many Customer Cases we could close based on the number of items listed. Therefore, getting this feature available again is very important to us, as now we need to do this count in another way.

     

    *They are looking for a feature similar to the JQL functions provided in the old P2 Connector.

  • Adrien Low commented
    18 Nov, 2016 07:31am

    Case #33084 

    We've migrated to Salesforce & JIRA Cloud Connector 1.1.0-AC. The "old" version of the connector used to provide a field where it stored references to Salesforce.com cases. We used this field for reporting purposes. Now, it's gone. Any way to get it back?

    Alternatively, is there any way to automatically count the number of cases linked to a JIRA issue and then put this number to a JIRA field for further filtering?