function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Alx MrAlx Mr 

run insert/update/upsert queries in the query editor.

Good day,
Is it possible to run insert/update/upsert queries in the query editor.

Thank you
Mahesh DMahesh D
Hi Alx,

Query Editor

You can use the Query Editor in the Developer Console to execute a SOQL query or SOSL search on the data in your organization. The History pane displays your last 10 queries for quick reuse. Results are displayed in a Query Results grid, in which you can open, create, update, and delete records. For SOSL search results with multiple objects, each object is displayed on a separate tab.

Execute a SOQL Query or SOSL Search
Execute SOQL queries or SOSL searches in the Query Editor panel of the Developer Console.

Retrieve Query Plans
Use the Query Plan tool to optimize and speed up queries done over large numbers of records. View query plans for SOQLqueries, SOSL searches, reports, and list views. If custom indexes are available for your organization, use query plans to help you decide when to request a custom index from Salesforce Support.

Query Results Grid
The Query Results grid displays each record as a row. You can create, update, and delete records without leaving the Developer Console. For SOSL search results with multiple objects, each object is displayed on a separate tab.

Also look into the below link:

https://help.salesforce.com/apex/HTViewHelpDoc?id=code_dev_console_tab_query_editor.htm&language=en

Please do let me know if it helps you.

Regards,
Mahesh
Alx MrAlx Mr
Thank you Mahesh.
I have a need to perfrom frequent maintenance changes in the tables, including adding reccrds, updating them, adding/modifying fields. Is it possible to perform these kind of queries?

Thanks.
Mahesh DMahesh D
Hi Alx,

I would recommend to use Apex Data Loader to perform regular insert / update / delete records to and from Salesforce.

Please follow the below links for more information.

https://www.youtube.com/watch?v=8azP1kuf9IQ

https://help.salesforce.com/apex/HTViewHelpDoc?id=installing_the_data_loader.htm

https://help.salesforce.com/apex/HTViewHelpDoc?id=data_loader.htm&language=en

https://developer.salesforce.com/page/Data_Loader

Please do let me know if it helps you.
​
Regards,
Mahesh