Loading
Salesforce now sends email only from verified domains. Read More
Set Up and Maintain Your Salesforce Organization
Table of Contents
Filter by (0)Add
Select Filters

          No results
          No results
          Here are some search tips

          Check the spelling of your keywords.
          Use more general search terms.
          Select fewer filters to broaden your search.

            Search all of Salesforce Help
            Search all of Salesforce Help
            Create a SOQL Query

            You are here:

            1. Salesforce Help
            2. Docs
            3. Set Up and Maintain Your Salesforce Organization

            Create a SOQL Query

            To gather details about locale use, like user count by locale, create a SOQL query

            Required Editions

            Available in: both Salesforce Classic and Lightning Experience
            Available in: all editions
            User Permissions Needed
            To use the Developer Console: API Enabled AND View All Data
            To use code search and run SOQL or SOSL on the query tab: API Enabled
            To create, edit, and delete reports in private folders: Create and Customize Reports
            To create, edit, and delete reports in public and private folders:

            Report Builder

            OR

            Report Builder (Lightning Experience)
            1. Click the gear icon (A gray gear icon with a lightning bolt in the center.). Using Classic? Click your name in the upper right corner.
            2. Click Developer Console.

              The developer console opens in a new window.

              The Developer Console with the Query editor in focus.
            3. To open the Query Editor panel, click Query Editor (1).
            4. In the Query Editor panel (2), enter this query.
              SELECT toLabel(LocaleSidKey) LocaleName, LocaleSidKey, Count(id) UserCount FROM User where IsActive=true GROUP BY LocaleSidKey
            5. Click Execute (3).

              Your results display in the Query Results grid in the Developer Console workspace.

              The Developer Console displays results of users across four locales.

              In this example, there are 4 locales in use across 10 users: 2 users with bn_BD, 5 users with en_US, 1 user with it_IT, and 2 users with en_HN.

             
            Loading
            Salesforce Help | Article