You need to sign in to do that
Don't have an account?
howard zien hpzien
i am trying to use workbench.
i have a custom object university__c. I have another related custom object lkupmajor_c.
when i put this select statement in workbench:
select university__c , name from lkupmajor__c
I get the record id for university instead of the university name.
Can you help? I expected to see teh university name
i get
university__c Name
1 a01j000000ArpvKAAR philosophy
2 a01j000000ArpvKAAR mathematics
3 a01j000000ArrRHAAZ greek
4 a01j000000ArpvKAAR russian
5 a01j000000ArrRHAAZ sociology
when i put this select statement in workbench:
select university__c , name from lkupmajor__c
I get the record id for university instead of the university name.
Can you help? I expected to see teh university name
i get
university__c Name
1 a01j000000ArpvKAAR philosophy
2 a01j000000ArpvKAAR mathematics
3 a01j000000ArrRHAAZ greek
4 a01j000000ArpvKAAR russian
5 a01j000000ArrRHAAZ sociology
select university__r.Name , name from lkupmajor__c
As a common practice, if your question is answered, please choose 1 best answer.
But you can give every answer a thumb up if that answer is helpful to you.
Thanks
Parent relationship queries are disabled in Workbench: university__r.Name
Due to issues rendering query results, parent relationship queries are disabled by default. If you understand these limitations, parent relationship queries can be enabled under Settings. Alternatively, parent relationship queries can be run with REST Explorer under the Utilities menu without issue.
Click on the Workbench logo in the upper left hand corner, select "Settings". Under the Query & Search Options heading, select: "Allows SOQL Parent Relationship Queries"
Thx
Thx