Basically I am looking to reduce the pain of adhoc queries that I currently do via the Developer Console.
Is there such an animal?
asked May 7, 2015 at 23:47
-
The data loader offers field completion... I think that's probably the best you're going to see these days, but I'd love to be wrong.– sfdcfoxMay 7, 2015 at 23:54
-
@sfdcfox Data Loader? You mean the tool to import/export data to/from SFDC? Where is the field completion? I think I must be missing something.– AngryHackerMay 7, 2015 at 23:57
-
Workbench you can select fields you want to build your query or even in eclipse Schema you can select fields and built query .There is no autocomplete ability though .– Mohith ShrivastavaMay 8, 2015 at 0:49
-
I prefer Force.com explorer personally especially during testing when I can easily update and delete data.But auto completion for query is not available.– unidhaMay 8, 2015 at 1:12
-
Developer console will let you build queries from the object. From Dev Console, go to file > open > objects > {your object}. Select fields. Select query. Not intellisense, but maybe gets at what you're after in a different way.– powloMay 8, 2015 at 12:46
Add a comment
|
11 Answers
I prefer to Use CloudingoStudio, it' free and works very well. You can read more here: http://www.symphonicsource.com/cloudingo-studio/
It implements also a syntax similar to SQL like "Select * FROM ..." and the export to EXCEL functionality.
Read the user guide to have a complete view of what you could accomplish with it ;)
I have not seen any auto suggest feature for query building but closest i can think is workbench .
answered May 8, 2015 at 0:54
@AngryHacker, I think you will like this feature of HaoIDE, check the SOQL Fields Completion part in the demo.
Updated at 2015-05-27, See this new feature
-
This is off topic, but I'm curious how HaoIDE compares to MavensMate for Salesforce development. May 27, 2015 at 14:55
Illuminated Cloud plugin for IntelliJ IDEA can perform a true SOQL query autocompletion
answered Feb 8, 2017 at 15:40
You can also use soqlxplorer from pocketsoap!!. Especially if you have a mac machine this is a great tool too. You can save records in a snap, you can edit field values directly from the results pane, delete and many more. Worth exploring.
Force.com IDE the eclipse based IDE allows to build a query graphically.
The Schema Explorer is a tool for browsing the objects and fields in a Force.com organization. The browser presents the logged-in user’s view of the Force.com database model, including object visibility, permissions, data types, lookup values and other information that is useful in developing applications on the Force.com platform.
The Schema Explorer is depicted as a hierarchical tree view of your organization’s schema. It is read-only and does not interact with the rest of the workspace in any way.
The right hand side panel of the browser is the hierarchical tree view of all the objects in the database. You can use this to drill down to an object of interest, and select fields within that object. The query pane on the left will then automatically be filled with a SOQL query that returns those objects and fields. Or you can enter your own SOQL query right into the box. Hitting the Run Me button will execute the query and show the results in the table below.
-
This answer would be better if it explained how to access and use this feature in the IDE. Doesn't have to be complete, but at least enough to get started would be useful.– JagularMay 27, 2015 at 14:45
I use workbench for query formation and mavensmate pulgin for sublime for code editing. Workbench offers easy query formation. Mavensmate offers good code completion while coding. Have a look at ForceExplorer also in the link https://developer.salesforce.com/page/ForceExplorer
I have created open source project to automatically create SOQL. You can either use it directly or modify code and deploy on heroku.
Below are few features :
- Toggle between API name and Label Name
- Search Objects or Fileds needs to build SOQL (In my case, it was primitive. I had more than 70 Objects and many of those objects has 300+ fields)
- Checkboxes to select fields (No need to hold control button to select multiple fields) Automatic Query Builder at Right side of page
- Shows API count used by application
- Search returned records
- Sorting on Table Headers
- Pagination
You can find related blog article here, complete source code and running application here.
You may use Schema Explorer in JetForcer plugin for exploring your Salesforce data. (I participate in developing this plugin) It provides many more features than just code completion.
see docs here: https://jetforcer.com/pages/features/soql-query-editor
-
here is a good overview of all available features blog.jetforcer.com/schema-explorer Jan 13, 2020 at 14:23
I'm a part of a team that has been working on Maven Tools for Salesforce, a Google Chrome extension that offers you a collection of Salesforce developer tools and it can help you with this issue.
Maven Tools has a Query Editor that has many great features, including autocompletion while typing queries, executing and exporting queries with large amounts of records, saving your most frequent queries and accessing your recent queries and much more.
Here's a little gif where you can see how the autocomplete feature works in Maven Tools:
I use SOQL Studio from https://visualsoftwaresystems.net. It is by far the best tool I have seen for ad-hoc SOQL. Line comments, block comments, full syntax highlighting, schema browser, detailed org, sobject, and field properties and more. And I love that you are not limited to a single org or editor window and can save your SOQL for use at a later time. It also has robust export capabilities.
