Salesforce SOQL Booster is a Visual Studio Code extension designed to enhance the efficiency of Salesforce developers when writing static SOQL (Salesforce Object Query Language) queries within Apex classes. This plugin offers intelligent field suggestions, dynamic object recognition, and cache management features, making SOQL query writing faster and more accurate.
Demo
Key Features
Static SOQL Support: Currently optimized for static SOQL queries within Apex classes.
Intelligent Field Suggestions: Automatically suggests available fields based on the current Salesforce object.
Dynamic Object Recognition: Identifies objects in static SOQL queries and provides relevant field suggestions.
Cache Management: Caches field data for improved performance with an option for manual refresh.
Cross-Relationship Query Support: Provides field suggestions in relationship queries.
Prerequisites
A Salesforce project authenticated with an org.
Salesforce CLI installed and configured.
Visual Studio Code (version 1.60.0 or higher).
Installation
Open Visual Studio Code.
Go to the Extensions view (Ctrl+Shift+X / Cmd+Shift+X).
Search for "Salesforce SOQL Booster".
Click the "Install" button.
Usage
Open an Apex class file in your authenticated Salesforce project.
Start writing a static SOQL query (within the [SELECT ... FROM ...] format).
The plugin will automatically identify the object based on the current cursor position and provide corresponding field suggestions.
Use Tab or Enter to accept suggestions.
Note: The plugin currently supports static SOQL queries within Apex classes only.
Clearing the Cache
To refresh field data:
Select "Clear Salesforce Field Cache" from the suggestion list.
The cache will be cleared, and subsequent suggestions will use the latest field data.
Configuration
Currently, the plugin does not require additional configuration. It automatically uses your Salesforce CLI configuration to connect to your org.
Limitations
The plugin is currently optimized for static SOQL queries within Apex classes.
Dynamic SOQL or queries outside of Apex classes may not be fully supported.
Troubleshooting
If you encounter issues:
Ensure your Salesforce CLI is correctly configured and can connect to your org.
Check that you're writing static SOQL queries within an Apex class.
Press Ctrl/Command + Shift + P and search for 'SOQL Booster: Clear Salesforce Field Cache' to clear the cache.
Contact
For any questions, suggestions, or to report issues with VS Code extension support, please create an issue or contact us.
