In day-to-day activities, we’ve faced some challenges that can solve by querying the data rather than using the report, list views, etc. For example,
1. Send me a list of Opportunities created last year that don’t have open tasks.
2. Users who have Lightning Experience User permission.
In the above situation, it is better to query the data rather than create unwanted reports or list views.
Before processing ahead, if you haven’t gotten a chance to read my last blog on Dynamic Forms, please do so now. It will help you maintain a cleaner implementation by applying a rule to each field or section; no need to create multiple page layouts or record types.
Let’s start with a real-time use case.
Use Case
Carol Brook is working as a System Administrator at Appiuss Softwares. She is getting the below error message when trying to open the developer console. She has View All Data system permission.

Carol is interested in finding out the users have Lightning Access permissions.
Solution
- Click Setup. In the Quick Find box, type Profiles.
- Select Profiles, then click on the Profile Name you want to give them access to execute the SOQL in the developer console.
- Click on the Edit button and select the API Enabled check box.
- Click on the Save button.




API Enabled administrative permissions assigned to Carol Brook; now, she will be able to execute the query in the developer console.




Points to Remember
User Permissions needed:




You are Done!!!
I would love to hear about your experience with Developer Console to execute SOQL, Apex code. How do you use it?