1

I have a custom object (Registration__c) that has a lookup field (Approver__c) to the standard User object.

I'm trying to construct an SOQL query that will return the user's ID.

My assumption is that since it's a child to parent relationship, the query should be:

SELECT Id, Approver__r.Id
FROM Registration__c

However, running the above query results in "No such relation 'Approver__r' on entity 'Registration__c'."

What am I missing?

Update

Query using 'Approver__c' returns "No such column 'Approver__c' on entity 'Registration__c'."

SELECT Id, Approver__c
FROM Registration__c

Here's a couple of screenshots showing the custom object (Registration__c) and custom field (Approver__c):

Registration__c custom object enter image description here

Reference

https://developer.salesforce.com/docs/atlas.en-us.soql_sosl.meta/soql_sosl/sforce_api_calls_soql_relationships_and_custom_objects.htm

5
  • Are you sure that you don't have a typo out there somewhere? Also, you can get the Id with simply doing Approver__c, if that is the field name May 22, 2020 at 16:13
  • Thanks @SebastianKessel! I don't see anything obvious in terms of typos. I added a couple of screenshots that show the object and field. Using the Approver__c returns a similar error message. Thoughts? May 22, 2020 at 16:22
  • Does your user have access to the field? How are you doing the query? Apex or Dev Console? May 22, 2020 at 16:22
  • 1
    @SebastianKessel That was the answer! The user did not have access to the field. Changing the field accessibility settings fixed the error. Thank you so much : ) Did you want to submit your answer and I'll accept it? May 22, 2020 at 16:30
  • Done, glad to have been able to help! May 22, 2020 at 16:31

1 Answer 1

0

If the field exists, and it is spelled properly, it is likely a permissions problem with the user running the query.

Also, if you wish to just get the Id of the related record, you can just do Approver__c instead of Approver__r.Id for simplicity.

You must log in to answer this question.

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