The connector's associations are stored within the “entity_property” table.
\uD83D\uDCD8 Instructions
Example of query can be found as follows:
select concat(jp.pkey, '-', ji.issuenum) as PKEY, ep.entity_id, jp.pkey, ji.issuenum, ep.property_key, 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' order by jp.pkey, ji.issuenum;
Please note that this query is built for Postgres database, please modify as needed.
Result will be as follows:
pkey | entity_id | pkey | issuenum | property_key | json_value -------+-----------+------+----------+------------------------------------------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------- TAB-1 | 10000 | TAB | 1 | com.servicerocket.jira.cloud.issue.salesforce.associations | {"associations":{"5004x00000i3Wu9AAE":{"son":"Case","viewOnly":false,"autoPush":true,"autoPull":true}},"ids":"5004x00000i3Wu9AAE","types":"Case"} TAB-2 | 10001 | TAB | 2 | com.servicerocket.jira.cloud.issue.salesforce.associations | {"associations":{"5004x00000i3WvVAAU":{"son":"Case","viewOnly":false,"autoPush":false,"autoPull":false}},"ids":"5004x00000i3WvVAAU","types":"Case"} TAB-3 | 10002 | TAB | 3 | com.servicerocket.jira.cloud.issue.salesforce.associations | {"associations":{"5004x00000i3WZMAA2":{"s