Skip to end of banner
Go to start of banner

Using JQL to report on Jira issues with associations

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 6 Next »

Associations made with Salesforce from Jira are recorded in the issue's fields. This guide will help you to understand how those fields can be viewed and used as Jira Query Language (JQL) filters for reporting purposes.

This feature uses the following Jira fields when the application is installed:

  • Associations - displays a list of associated Salesforce Objects. 
  • Association Count - displays the amount of associated Salesforce Objects. 

In order for the application to be able to populate and update the Associations and Associations Count fields, they should be added to Edit Issue Screen. An administrator is required to configure the fields in the project settings. 

    1. If the fields are not added to the Edit Issue Screen, they cannot be updated.
    2. If the fields are added to View Issue Screen, they will be editable and can be edited manually. We would recommend removing these fields from View Issue Screen and avoiding updating them manually.
    3. If the fields are being updated manually, the application will sync them again when the next association-related action occurs.

For more information on screen configuration refer to Configure the issue detail view.

These fields can also search Jira issues through the issue navigator. For example, to search issues associated with a specific Salesforce object, or issues with a specific number of associations.


Version difference

Jira Cloud

By default the fields will be empty, they will be populated on the following association-related actions (eg: issue being associated):

Jira

Salesforce

A Salesforce object is created for the issue.

A Jira issue is created for the object.

A Salesforce object is associated with the issue.

A Jira issue is associated with the object.

The issue is unassociated (unlinked) from a Salesforce object.

The object is unassociated (unlinked) from a Jira issue.

A Salesforce object is created (and associated with the issue) through workflow post-function.


Jira Server

  • If the Associations and Associations Count custom fields are not created, disable and enable the app.
  • Configure the field configuration and update renderers for Associations field to Wiki Style Renderer to avoid the field context looking broken. 

By default the fields will be empty, they will be populated when the Jira Issue is updated and if there is an association for the issue:

Jira

Salesforce

A Jira issue is updated.


Creating an association

  1. Open a Jira issue from a project that is bound with Salesforce. You can see the Associations and Associations Count fields are empty. 


  2. If they are already populated, go to the next step. Else, to populate those fields, check out Configuring an association on how to create an association between Jira issues and Salesforce.

    In the case, that the association has been created before this feature, the Associations and Associations Count fields will still be empty despite having an association. You will have to Create a Salesforce Object from Jira or Configure a new association with a Salesforce Object.

    We recommend unlinking the existing association and linking it back again to trigger the update for the Associations and Associations Count fields.




Using JQL to filter association fields

  1. In Jira, select Filters > select Advanced issue search
  2. Next, select More > check Associations and Association Count options. Filter the other fields relevant to your report. 
  3. Search for issues associated with a Salesforce Object with a specific Object ID.
  4. Search for issues with specific counts of association. 

Related information

  • No labels