SOQL Extractor and Analyzer for SalesForce

Extract SOQL queries with their execution counts from Debug Logs of Salesforce. Helps you analyze the 'Too Many SOQLs' error.

什麼是SOQL Extractor and Analyzer for SalesForce?

SOQL Extractor and Analyzer for SalesForce是由Rajiv Bhatt開發的Chrome擴展程式,該擴展的主要功能是“Extract SOQL queries with their execution counts from Debug Logs of Salesforce. Helps you analyze the 'Too Many SOQLs' error.”。

擴展截圖

screenshot
screenshot

下載SOQL Extractor and Analyzer for SalesForce擴展crx文件

下載SOQL Extractor and Analyzer for SalesForce擴展crx格式的文件,手動將Chrome擴充功能安裝到瀏覽器中,也可以將crx文件分享給朋友,輕鬆安裝Chrome擴充功能。

擴展使用說明

                        Update 2.0.0.0: 
Works only with Classic mode of Salesforce. Users complained about not being able to install the extension. Updated manifest.json file so this should be resolved. 

Update 0.0.0.9: 
Manifest.json permissions were updated to enable the extension for lightning

Update 0.0.0.8: 
Uploading the same package to make the extension available on the new version of webstore. No changes in functionality.

Update 0.0.0.5: Added two new features 
1. Added an option to view nested method calls and the ability to expand and collapse them. Please note that it would display only user debug and soql statements between the method entry exits. This is a Beta release of this feature and I am looking forward for some feedback as to what are the other details that would be helpful to developers.
2. Ability to filter the log files. When the "Filter Log Type" is checked, it would show you further checkboxes which you can use to filter the contents of the log file. It would show you only those statements. 


Update 0.0.0.3: The extension icon will now be visible only after you open a debug log. This is based on the best practice (memory optimization) recommended by chrome docs.

This extension helps you extract and analyze the SOQL queries from the debug logs of Salesforce. Open up any Debug Log on Salesforce and then on just "One-Click" of the extension it would display the following information: 

1. All the SOQL queries along with their execution count. 

2. The extension would also display all the Objects (Standard/Custom) on which these SOQL queries are executed. 
For ex: If you have got queries that hit the Account object 5 times, you might want to have a relook at the code and optimize the code in a way that you get all the data from the Account object in single SOQL query (instead of querying it 5 times).

- These statistics usually help in debugging the error "Too Many SOQLs". 
- They would also help you to optimize the performance of your application. 

Do recommend the extension with you friends and colleagues if you like it.

Also, if you like the extension, please don't forget to Rate it on the Chrome Extension Webstore.

Currently Working on Future Enhancements: 
1. Extracting specific category of statements (debug/approvals etc) from the log file.

Feedback/Suggestions/Ideas/Comments most welcome.

Thanks again and I hope this extension saves your time and makes you more productive!

For any queries: [email protected]                    

擴展基本資訊

名稱 SOQL Extractor and Analyzer for SalesForce SOQL Extractor and Analyzer for SalesForce
ID deihalhihjdilndoidoclmhmgllebkfj
官方網址 https://chromewebstore.google.com/detail/soql-extractor-and-analyz/deihalhihjdilndoidoclmhmgllebkfj
簡介 Extract SOQL queries with their execution counts from Debug Logs of Salesforce. Helps you analyze the 'Too Many SOQLs' error.
檔案大小 56.25 KB
安裝次數 6,054
目前版本 2.0.0.0
更新時間 2019-04-15
上架時間 2019-04-15
評分 4.88/5 共 16 次評分
開發者 Rajiv Bhatt
付費類型 free
支援的語言 en
manifest.json
{
    "update_url": "https:\/\/clients2.google.com\/service\/update2\/crx",
    "name": "SOQL Extractor and Analyzer for SalesForce",
    "short_name": "Extract SOQL",
    "version": "2.0.0.0",
    "manifest_version": 2,
    "description": "Extract SOQL queries with their execution counts from Debug Logs of Salesforce. Helps you analyze the 'Too Many SOQLs' error.",
    "background": {
        "scripts": [
            "background.js"
        ],
        "persistent": false
    },
    "permissions": [
        "https:\/\/*.salesforce.com\/",
        "https:\/\/*.force.com\/*"
    ],
    "content_scripts": [
        {
            "matches": [
                "https:\/\/*\/*",
                "https:\/\/*.salesforce.com\/*",
                "https:\/\/*.visual.force.com\/*",
                "https:\/\/*.lightning.force.com\/*"
            ],
            "js": [
                "jquery-1.4.2.min.js",
                "content_script.js",
                "CollapsibleLists.compressed.js"
            ],
            "css": [
                "collapse.css"
            ]
        }
    ],
    "web_accessible_resources": [
        "img\/*.png",
        "content_script.js",
        "jquery-1.4.2.min.js",
        "CollapsibleLists.compressed.js"
    ],
    "page_action": {
        "default_icon": "sfglass19x19.png",
        "default_popup": "popup.html"
    },
    "icons": {
        "16": "sfglass16x16.png",
        "48": "sfglass48x48.png",
        "128": "sfglass128x128.png"
    }
}