Overview
An Extension that helps to Execute the Large Length Where Clause Query
This extension facilitates the execution of extensive SOQL queries, addressing the constraint where the maximum query length is restricted to 4000 characters beyond the WHERE clause. In scenarios where data retrieval involves a WHERE clause containing a substantial number of names or IDs, potentially reaching up to 100,000 records, this extension proves invaluable. The syntax for utilizing this functionality involves constructing the query with the WHERE clause containing the extensive list of IDs or names without any length restrictions. An example query structure is as follows: SELECT Id FROM Account WHERE Id IN ('HERE YOU CAN HAVE AS MANY IDs AS NEEDED WITHOUT LENGTH RESTRICTIONS') Moreover, besides handling such extensive queries, this extension is versatile enough to execute standard SOQL queries. The resultant output is conveniently provided in a spreadsheet format, ensuring ease of interpretation and analysis. As this is the initial version release, subsequent updates will focus on resolving any identified bugs and enhancing overall performance and functionality.
Details
- Version1.0
- UpdatedMarch 11, 2024
- Offered byMinhaj Ameen
- Size2.37MiB
- LanguagesEnglish (United States)
- Developer
Email
minhajameen786@gmail.com - Non-traderThis developer has not identified itself as a trader. For consumers in the European Union, please note that consumer rights do not apply to contracts between you and this developer.
Privacy
This developer declares that your data is
- Not being sold to third parties, outside of the approved use cases
- Not being used or transferred for purposes that are unrelated to the item's core functionality
- Not being used or transferred to determine creditworthiness or for lending purposes
