Contents x
    How to create SOQL from the Developer Console
    • 07 Dec 2022
    • Print
    • Dark
      Light
    • PDF
    Contents

    How to create SOQL from the Developer Console

    • Updated on 07 Dec 2022
    • Print
    • Dark
      Light
    • PDF
    Article Summary

    Note

    This is a machine-translated version of the original Japanese article.
    Please understand that some of the information contained on this page may be inaccurate.

    summary

    When specifying Salesforce as the linkage destination, you need to prepare SOQL for forwarding settings.
    This page explains how to create SOQL from the Salesforce developer console.

    1. Log in to Salesforce.
    2. Click Developer Console from the menu in the upper right corner.

    image.png

    1. Select File → Open Resource.

    image.png

    1. Select the object to be retrieved from the Open Resource screen.

    image.png

    1. Select the column to be retrieved and click Query to create SOQL. Please note that SOQL cannot use "*" due to syntax restrictions. To execute the query, click execute in the lower left.

    image.png

    Please note the following two points about SOQL.

    1. Due to Bulk API limitations, table joins are not possible because only a single object can be used.
    2. Please note that due to the limitations of Bulk API, object type columns cannot be retrieved. For example, if the Apex Type is address, it will be an object type as follows.

    image.png

    TIPS

    • If the Apex Type is datetime, it is possible to link it with trocco as a timestamp type by passing the format function.

    image.png

    Was this article helpful?
    What's Next