---
title: "How to query for association in Remote System Reference"
canonical: "https://support.appfire.com/space/SUPPORT/1086160996/How%20to%20query%20for%20association%20in%20Remote%20System%20Reference"
format: markdown
---
Associations IDs for [Remote System Reference](https://appfire.atlassian.net/wiki/spaces/CFSJ/pages/470622586/Adding+a+Remote+System+Reference?search_id=47a1e5bf-2aee-41ae-aaf9-01005a0519fd) are appended with a comma in the **TEXTVALUE** field. 

## \uD83D\uDCD8 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
```

## \uD83D\uDCCB Related articles



> Macro (contentbylabel)