Skip to main content
Topics#Ask An Experthoward zien의 질문
howard zien (Business Logic) 님이 #Ask An Expert에 질문했습니다
2015년 9월 29일 오후 4:22

Using workbench, I am trying to join an invoice__c table with the user table

this query

 

Select name , ownerid   from invoice__c

 

yields this.

 

  Name OwnerId

 

1 INV-0001 005j000000BCqsYAAT

 

2 INV-0000 005j000000BCqsYAAT

 

3 INV-0002 005j000000BCqsYAAT

 

4 INV-0003 005j000000BCqsYAAT

 

5 INV-0004 005j000000BEVxqAAH

 

but i want to join the query to the user table.

 

i tried this, but i get query errors.

 

Select name , ownerid , user__r.name  from invoice__c

 

i also tried

 

Select name , ownerid , user.name  from invoice__c

 

[ERROR:]INVALID_FIELD:

 

Select name , ownerid , user__r.name from invoice__c

 

^

 

ERROR at Row:1:Column:25

 

Didn't understand relationship 'user__r' in field path. If you are attempting to use a custom relationship, be sure to append the '__r' after the custom relationship name. Please reference your WSDL or the describe call for the appropriate names.

 

 
답변 3개
  1. Abhishek Sivasubramanian (Milestone Technologies Inc)
    2015년 9월 29일 오후 5:11
    You can write an SOQL query like:

     

    select name, ownerid, owner.name from invoice__c

     

    This should yield you the output:

     

    INV-0001 005j000000BCqsYAAT Phyllis Cotton

     

    Hope this helps.
답변을 작성하세요...
0/9000