How to query for associations in the Connector for Salesforce & Jira (Data Center)
This article provides an SQL query to list all the associations query by Jira Issue Key and the association IDs on your Data Center/Server instance Postgres Database. You can export this file and use it alongside scripting migration or for reporting purposes.
Instructions
Please find the query below:
select concat(jp.pkey, '-', ji.issuenum) as PKEY, ep.json_value
from project jp, jiraissue ji, entity_property ep
where jp.id = ji.project
and ep.entity_id = ji.id
and ep.property_key = 'com.servicerocket.jira.cloud.issue.salesforce.associations'
and ep.json_value like '%ids%'
order by jp.pkey, ji.issuenum;This query is catered towards Postgres DB, so you may need to modify it based on the DB that you are using.