Associations IDs for Remote System Reference are appended with a 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, 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; |
Info |
---|
Please note that this This query is built for the Postgres database, please ; modify it as needed. |
Result may be as follows:Example results
Code Block |
---|
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 |
\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" |
---|
|