"No such column" error occurs when accessing an existing field in a SOQL query

This error occurs when the user running the query does not have read access to the field being queried. To resolve this issue, grant Field-Level Security (Read Access) for the target field in the user's Profile or Permission Set. The following steps show how to grant permission in a Profile.

■ Steps to Grant Field-Level Security

When "Enhanced Profile User Interface" is enabled

1. Click the gear icon in the upper right corner and select [Setup].
2. In the Quick Find box, enter "Profiles" and click [Profiles] from the search results.
3. Click on the Profile assigned to the user experiencing the error.
4. On the profile settings page, click [Object Settings] and select the target object.
5. Click [Edit].
6. Find the field you are querying and check the "Read Access" checkbox.
7. Click [Save].

When "Enhanced Profile User Interface" is disabled

1. Click the gear icon in the upper right corner and select [Setup].
2. In the Quick Find box, enter "Profiles" and click [Profiles] from the search results.
3. Click on the Profile assigned to the user experiencing the error.
4. In the *[Field-Level Security] section, find the object you are querying and click [View].
5. Click [Edit].
6. Find the field you are querying and check the "Read Access" checkbox.
7. Click [Save].