How to query for association in Remote System Reference

Owned by
Siti Alewi
, created
Last updated: Jul 01, 2024 by
Kevin Lew [Appfire]
1 min read

Associations IDs for Remote System Reference are appended with a comma in the TEXTVALUE field.

 Instructions

Example query

select concat(jp.pkey, '-', ji.issuenum) as PKEY, cfv.textvalue, cfv.stringvalue, cf.id, cf.cfname, cf.customfieldtypekey from project jp, jiraissue ji, customfield cf, customfieldvalue cfv where jp.id = ji.project and cfv.issue = ji.id and cf.id = cfv.customfield and (cf.customfieldtypekey = 'net.customware.plugins.connector.atlassian.jira-connector-plugin:remotesystem-id-customfield') order by jp.pkey, ji.issuenum;

This query is built for the Postgres database; modify it as needed.

Example results

pkey|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