Skip to content

Data Export

Select all fields in a query

This functionality already exists in the legacy version but since many users don't know about it, I would like to document it. When on the export page, put the cursor between SELECT and FROM and press Ctrl + space for inserting all fields (if you don't have the rights for a particular field, it wont' be added). If you want to insert only custom fields, enter __c between SELECT and FROM.

2024-04-16_08-53-32 (1)

Disable query input autofocus

Option available in Data Export tab

Disable query input

Add custom query templates

Enter value in "Query Templates" option with your custom queries separated by "//" character. Example:

SELECT Id FROM// SELECT Id FROM WHERE//SELECT Id FROM WHERE IN//SELECT Id FROM WHERE LIKE//SELECT Id FROM ORDER BY//SELECT ID FROM MYTEST__c//SELECT ID WHERE

image

Customize Select all fields in a query shortcut

If the default Ctrl + space shortcut is already used by another extension or app, you can customize it in chrome://extensions/shortcuts and choose the one you prefer.

Customize Select all fields in a query shortcut

Exclude formula fields from data export autocomplete

You can exclude formula fields to be included in the autocomplete by disable the toogle

Exclude formula fields from autocomplete

Convert times from data export to local time

You can configure Data Export to convert times to local time. Navigate to Options -> Data Export and enable "Show local time".

Show local time in data export checkbox option

Display query performance in Data Export

To enable performance metrics for queries on the data export page, open the Options screen and select the Data Export tab, then set "Display Query Execution Time" to enabled. Total time for the query to process and, when applicable, batch stats (Total Number of Batches, Min/Max/Avg Batch Time) are displayed.

Hide additional columns in query results

After running a query in the "Data Export" page, you can hide additional columns in the query results. These columns represent the name of the objects included in your query. They are useful to automatically map the fields to the correct object in the "Data Import" page. The columns are hidden in the exported files (CSV or Excel) as well. You can set a default value, using the 'Hide additionnal Object Name Columns by default on Data Export' option ("Options" -> "Data Export" tab).

2024-05-16_17-54-24 (1)

Download Event Log Files

To make your life easier and avoid third party tools or login to ELF website, we implemented the download option from the data export page. When quering EventLogFile, add the "LogFile" field in the query and click on the value to download corresponding log.

2023-11-15_14-32-44 (1)

Hide some buttons in Data Export

Since the extension offers more features, the number of button is increasing. Some of the users may don't need some of those, to make the UI lighter some of the buttons can be hidden: - Delete Records - Export Query - AgentForce icon

Generate SOQL queries with AgentForce

Prerequisite Agentforce needs to be enabled. The prompt GenerateSOQL needs to be deployed in the org.

You can use AgentForce to generate SOQL queries directly from the Data Export page. This feature leverages Salesforce's Prompt Templates to help you write queries more efficiently.

Note The standard Salesforce 'Prompt Template User' permission is required to use this feature.

By default, the AgentForce button is hidden. To enable it: 1. Go to Options -> Data Export 2. Enable "Show AgentForce button" 3. Optionally, you can customize the prompt template name that will be used for generating queries

AgentForce SOQL builder

GenerateSOQL.genAiPromptTemplate meta content:

<?xml version="1.0" encoding="UTF-8"?>
<GenAiPromptTemplate xmlns="http://soap.sforce.com/2006/04/metadata">
    <activeVersionIdentifier>anEjRSM7QudV59rn+lQuKa5VlLkCpKFNWwKc0odntGw=_1</activeVersionIdentifier>
    <description>Prompt used to generate a SOQL query based on a description.</description>
    <developerName>GenerateSOQL</developerName>
    <masterLabel>Generate SOQL</masterLabel>
    <templateVersions>
        <content>As a Salesforce expert in SOQL, return a SOQL query based on this description : {!$Input:Description}.

Instructions:** 
1. Based on the description, construct a Salesforce SOQL that adheres to the specified SObject and make sure this object exists and is queryable. 
2. Ensure the SOQL is syntactically correct, keep in mind the query plan statement and use a maximum of indexed fields for the filters if needed.
3. Output the generated Salesforce SOQL query clearly enclosed within `&lt;soql&gt;` tags.
4. Output if the tooling api needs to be used for this query  `&lt;toolingApi&gt;true&lt;/toolingApi&gt;` 
</content>
        <inputs>
            <apiName>Description</apiName>
            <definition>primitive://String</definition>
            <masterLabel>Description</masterLabel>
            <referenceName>Input:Description</referenceName>
            <required>true</required>
        </inputs>
        <primaryModel>sfdc_ai__DefaultOpenAIGPT4</primaryModel>
        <status>Published</status>
        <versionIdentifier>anEjRSM7QudV59rn+lQuKa5VlLkCpKFNWwKc0odntGw=_1</versionIdentifier>
    </templateVersions>
    <type>einstein_gpt__flex</type>
    <visibility>Global</visibility>
</GenAiPromptTemplate>