I have a junction object called "JIRA_Data" and its linked/ related to Accounts. How do I query to fetch data from this relationship. I am trying to extract id,type from Account object and Name from JIRA_Data junction object.

Could anyone assist. Thanks

  • Can you please elaborate more on your question? You want all those accounts having records in Junction object JIRA_Data. Is it correct?
    – sfdc_sk
    Jul 13, 2018 at 10:27
  • @sfdc_sk, yes I am trying to have a column that would tell whether the account has value in JIRA_Data. If so, display that corresponding value from JIRA_Data for that Account..
    – dark horse
    Jul 13, 2018 at 10:29

2 Answers 2


You can use this query with proper relationship name.

SELECT id,type, 
       (SELECT Name FROM JIRA_DATA__r)
FROM Account
WHERE Id IN:<AccountIds>

You will get all Accounts having data in your Junction Object JIRA_Data in below way :

List<Account> accList = [SELECT id,type, (SELECT id, Name FROM JIRA_DATA__r) FROM Account];

Here, JIRA_DATA__r is the relationship name. Enter the correct relationship name of your Account and JIRA_Data objects

You can access records of JIRA_DATA__r as:

for(Account a : accList){
for(JIRA_DATA__c test : a.JIRA_DATA__r){
  • Thanks one more novice question. I am trying to pull these records in Python. If I normally pull Accounts data, I would use sf_data_cursor.bulk.Account.query("""SQL code here""") How do I query in the above case where I am querying in the junction object. Thanks..
    – dark horse
    Jul 13, 2018 at 10:40
  • @darkhorse, I have updated my answer. Please check if it provides the result you want.
    – sfdc_sk
    Jul 13, 2018 at 11:25

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .