Salesforce Workbench SOQL Query Screen Maximiser

Increases the size of the field selector box

您需要先安装一个扩展,例如 篡改猴Greasemonkey暴力猴,之后才能安装此脚本。

You will need to install an extension such as Tampermonkey to install this script.

您需要先安装一个扩展,例如 篡改猴暴力猴,之后才能安装此脚本。

您需要先安装一个扩展,例如 篡改猴Userscripts ,之后才能安装此脚本。

您需要先安装一款用户脚本管理器扩展,例如 Tampermonkey,才能安装此脚本。

您需要先安装用户脚本管理器扩展后才能安装此脚本。

(我已经安装了用户脚本管理器,让我安装!)

您需要先安装一款用户样式管理器扩展,比如 Stylus,才能安装此样式。

您需要先安装一款用户样式管理器扩展,比如 Stylus,才能安装此样式。

您需要先安装一款用户样式管理器扩展,比如 Stylus,才能安装此样式。

您需要先安装一款用户样式管理器扩展后才能安装此样式。

您需要先安装一款用户样式管理器扩展后才能安装此样式。

您需要先安装一款用户样式管理器扩展后才能安装此样式。

(我已经安装了用户样式管理器,让我安装!)

// ==UserScript==
// @name         Salesforce Workbench SOQL Query Screen Maximiser
// @namespace    http://tampermonkey.net/
// @version      2024-05-09
// @description  Increases the size of the field selector box
// @author       Wilsoff
// @match        https://workbench.developerforce.com/query.php*
// @icon         https://www.google.com/s2/favicons?sz=64&domain=developerforce.com
// @grant        none
// @license      MIT
// ==/UserScript==

(function() {

    'use strict';

    function _formatPage() {

        document.documentElement.style.setProperty('--scrollbar-width', (window.innerWidth - document.documentElement.clientWidth) + "px");

        const main = document.getElementById('mainBlock');
        const objSel = document.getElementById('QB_object_sel');
        const fieldSel = document.getElementById('QB_field_sel');
        const options1 = document.querySelector("#query_form > table > tbody > tr:nth-child(1) > td:nth-child(2) > table:nth-child(1) > tbody > tr");
        const options2 = document.getElementById('QB_right_sub_table');
        const tableDatas = document.getElementsByTagName('td');
        const soql = document.getElementById('soql_query_textarea');
        const info = document.getElementsByClassName('displayInfo');
        const mig = document.getElementsByClassName('migrationInfo');
        var i = 0;

        if (window.innerWidth >= 1000) {

            //Make whole page 100% width
            main.style.setProperty('width', '100%', 'important');

            //Format the object selector
            objSel.style.width = '32em';
            objSel.style.maxWidth = 'calc(100vw - 22px - var(--scrollbar-width))';

            //Make the field selector bigger
            fieldSel.size = 25;
            fieldSel.style.width = '32em';
            fieldSel.style.maxWidth = 'calc(100vw - 22px - var(--scrollbar-width))';

            //Make the elements on the right align to the left
            options1.style.setProperty('display', 'flex', 'important');
            options2.style.setProperty('display', 'flex', 'important');

            //Add spacing to make it look more like the original:
            for(i=0;i<tableDatas.length;i++){
                if(tableDatas[i].innerHTML.startsWith("Deleted and archived records")) {
                    tableDatas[i].style.setProperty('margin-left', '50px', 'important');
                    break;
                }
            }

            for(i=0;i<tableDatas.length;i++){
                if(tableDatas[i].innerHTML.startsWith("<br>Max Records")) {
                    tableDatas[i].style.setProperty('padding-left', '50px', 'important');
                    break;
                }
            }

            //Format Max Records
            document.getElementById('QB_limit_txt').style.setProperty('margin-left', '50px', 'important');

            //Increase size of SOQL query box
            soql.rows = 12;
            soql.style.width = '100%';
            soql.style.maxWidth = 'calc(100vw - 28px - var(--scrollbar-width))';

            //Hide the info box
            if (info.length == 1) {
                info[0].style.display = 'none';
            }

            //Hide the red bar
            if (mig.length == 1) {
                mig[0].style.display = 'none';
            }

        } else {
            //Make whole page 750px width again
            main.style.setProperty('width', '750px', 'important');

            //Reset the object selector
            objSel.style.width = '16em';
            objSel.style.maxWidth = 'unset';

            //Reset the field selector bigger
            fieldSel.size = 6;
            fieldSel.style.width = '16em';
            fieldSel.style.maxWidth = 'unset';

            //Reset the elements on the right align to the left
            options1.style.display = 'revert';
            options2.style.display = 'revert';

            //Reset spacing:
            for(i=0;i<tableDatas.length;i++){
                if(tableDatas[i].innerHTML.startsWith("Deleted and archived records")) {
                    tableDatas[i].style.marginLeft = 'unset';
                    break;
                }
            }

            for(i=0;i<tableDatas.length;i++){
                if(tableDatas[i].innerHTML.startsWith("<br>Max Records")) {
                    tableDatas[i].style.paddingLeft = 'unset';
                    break;
                }
            }

            //Reset the Max Records box
            document.getElementById('QB_limit_txt').style.marginLeft = 'unset';

            //Reset the SOQL query box
            soql.rows = 5;
            soql.style.width = '99%';
            soql.style.maxWidth = 'unset';

            //Reset the Info box
            if (info.length == 1) {
                info[0].style.display = 'revert';
            }

            //Reset the red bar
            if (mig.length == 1) {
                mig[0].style.display = 'revert';
            }
        }
    }

    // recalculate on resize
    window.addEventListener('resize', _formatPage, false);

    // recalculate on dom load
    document.addEventListener('DOMContentLoaded', _formatPage, false);

    // recalculate on load (assets loaded as well)
    window.addEventListener('load', _formatPage);

})();