The connector's associations are stored within the “entity_property” tableAssociations IDs for Remote System Reference are appended with comma in the TEXTVALUE field.
\uD83D\uDCD8 Instructions
Example of query can be found as follows:
| Code Block |
|---|
select concat(jp.pkey, '-', ji.issuenum) as PKEY, epcfv.entity_idtextvalue, jpcfv.pkeystringvalue, jicf.issuenumid, epcf.property_keycfname, epcf.json_valuecustomfieldtypekey
from project jp, jiraissue ji, customfield cf, entity_propertycustomfieldvalue epcfv
where jp.id = ji.project
and epcfv.entity_idissue = ji.id
and ep.property_keycf.id = cfv.customfield
and (cf.customfieldtypekey = 'comnet.servicerocketcustomware.jiraplugins.cloudconnector.issue.salesforce.associations'atlassian.jira-connector-plugin:remotesystem-id-customfield')
order by jp.pkey, ji.issuenum; |
| Info |
|---|
Please note that this query is built for Postgres database, please modify as needed. |
Result will may be as follows:
| Code Block |
|---|
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":{"spkey|textvalue|stringvalue|id|cfname|customfieldtypekey
SRAP-25|5005j00000TmIDiAAN|NULL|10700|Classic Case Reference|net.customware.plugins.connector.atlassian.jira-connector-plugin:remotesystem-id-customfield
SRAP-26|5005j00000TnMmFAAV|NULL|10700|Classic Case Reference|net.customware.plugins.connector.atlassian.jira-connector-plugin:remotesystem-id-customfield
SRAP-27|5005j00000TnMndAAF|NULL|10700|Classic Case Reference|net.customware.plugins.connector.atlassian.jira-connector-plugin:remotesystem-id-customfield
TFBSD-2|5005j000008wRh7AAE,5005j000008wRCnAAM|NULL|10700|Classic Case Reference|net.customware.plugins.connector.atlassian.jira-connector-plugin:remotesystem-id-customfield
TFBSD-3|5005j000008wRhHAAU|NULL|10700|Classic Case Reference|net.customware.plugins.connector.atlassian.jira-connector-plugin:remotesystem-id-customfield |
\uD83D\uDCCB Related articles
| Filter by label (Content by label) |
|---|
| showLabels | false |
|---|
| max | 5 |
|---|
| spaces | com.atlassian.confluence.content.render.xhtml.model.resource.identifiers.SpaceResourceIdentifier@bc3e0baf |
|---|
| sort | modified |
|---|
| showSpace | false |
|---|
| reverse | true |
|---|
| type | page |
|---|
| labels | kb-how-to-article |
|---|
| cql | label = "kb-how-to-article" and type = "page" and space = "SUPPORT" |
|---|
|