Salesforce Query Editor

"Flow puts real power in the hands of regular users. The Object, ObjectFilter or Statement parameters are available for setup in the data flow properties list. Hopefully Microsoft will enable this by default if it will be an issue for other Salesforce user. January 14, 2013 Answer. A case study for integrating Salesforce. This extension pack includes tools for developing on the Salesforce platform in the lightweight, extensible VS Code editor. Preview pane. To ease query creation, you can drag a Salesforce object from the Salesforce Objects tree to the Edit Query box, and the query to the corresponding Salesforce object will be built automatically. automatically exports form data from your website to your Salesforce account database by mapping Episerver form fields to Salesforce database fields. I load them into tables in two different sheets, and then create a third worksheet and table using Data > Get external Data > From other sources > From MS Query > From Excel referencing the workbook itself. Salesforce Query Builder Node. The Salesforce Edition of the Online SQL Editor of Invantive provides you with benefits such as: Interactive and online access to your company information via any modern web browser. Here is a collection of sample Comma Separated Value (CSV) files used throughout Schoolwires that you can download. com login credentials. Users can run SQL commands manually or with a click of the mouse. For information on enabling this feature, contact Salesforce. Select the "sForce table Query Wizard"on the drop-down menu. You can return to this summary page by finding its operation name under Jitterbit Connect in the Project Items panel. Salesforce Cloud9 IDE. The load event is sent to an element when it and all sub-elements have been completely loaded. Salesforce Translators. Once your object is selected, a query is created in the text box below. Enable wiki users to query records in Salesforce by entering their own SOQL syntax query statement. Microsoft has not released a server version of Power Query that you can install in your "on premises" (or even private cloud) environment. Microsoft Power Query for Excel requires Internet Explorer 9 or greater. I have no knowledge of the format used in OData filter and OData query and have already spent several hours trying to get this to work but no luck so far. Auto completion and auto lookup for tables and columns is provided. What happens to the notes that are pinned to a lead when it gets converted to an opportunity?. How to show the a,b buttons in the place of edit and delete links Delete Link Edit Link List Button Salesforce Custom Object Salesforce Lightning Salesforce Opportunity. with Skyvia Query - web-based SQL editor for cloud apps & databases. The developer console remembers up to the last 10 SOQL queries ran. Login to your Salesforce Customer Account. The Salesforce Single Sign-on (SSO) Integration lets your users log in to Salesforce with Auth0 identity providers, and provides SSO to configured applications. In Menu bar we File, Edit, Debug, Workspace and Help. We added "Data Type" column to both Salesforce Source Editor and Salesforce Destination Editor. Lead your team with quick and natural collaboration using Live Share to edit and debug together in real time, no matter the language or platform. In the Chart Editor, you can choose the most relevant chart type for your report. I'm reusing the same parser/editor/etc. Power Query generates a query with the following code in the editor (see Figure 2). To ease query creation, you can drag a Salesforce object from the Salesforce Objects tree to the Edit Query box, and the query to the corresponding Salesforce object will be built automatically. I got it to work again by following these instructions to enable TLS 1. Select the row to delete and click Delete Row. Using Power Query, I pull in two reports from Salesforce using Power Query > Get external Data > From Online Services. The Salesforce SQL editor allows users to write SQL select, update, insert, and delete statements against Salesforce. With Salesforce’s custom data models and interfaces, every company’s setup is unique. This can happen if the query exceeds the 10,000 character limit that Salesforce. For full SOQL Syntax, see this link. TL:DR - Needing to pull a lead history report from salesforce into excel via power query, but the query "LEAD HISTORY" option only allows me to choose a few objects. If you just want to get your feet wet with regular expressions, take a look at the one-page regular expressions quick start. Open the files with your prefered text editor; Check if everything looks good, and add these classes to your Salesforce org as new classes. Step 0: Connect your Sandbox and Production orgs. 1 Open the WSDL in the Text editor and change the data type to. Add-ons are available from the Episerver Add-on Store inside Episerver. name} expression makes a call to the getRecord() method in the standard Contact controller to returns the record that is currently in context, based on the value of the id query string parameter in the Visualforce page URL. com databases. It's very similar to maintaining other records in Salesforce. The updated SOQL query will look like below. In the trace files (I see 2 Mashup files that get generated), one includes a SQL. com from your mobile browser, Salesforce will recognize that you’re working. The account will be connected through the provided environment loginUrl. Salesforce development is simplified with ASIDE's code editor. I'm reusing the same parser/editor/etc. Login to your Salesforce Customer Account. One of the biggest differences is that SOQL does not support wildcard in SELECT statements to query all fields from an object. Use Python and R for advanced analysis. com is open and available for the InsightIDR Collector. Console Data Export Developer Console Import Export Salesforce Query. Lightning Component. Salesforce CLI Integration for Visual Studio Code. This includes deleted and archived records. With the new Query All Files permission, View All Data users can query ContentDocument and ContentVersion and retrieve all files in the org, including files in non-member libraries and files in unlisted groups. 7 Output Panel. In this query we only want the public ones and will order the Attachments by LastModifiedDate 'desc' which pust the newest one first. The query editor doesn’t use Apex Code– it executes directly as a REST query API call. Query Settings task pane. You can use it to query, insert, update, upsert, or delete a large number of records asynchronously by submitting batches which are processed in the background by Salesforce. There's no way to query deleted records from the developer console's query editor. Follow these steps to set up an expression: Right-click on the data flow canvas and select Properties from the menu. from simple_salesforce import Salesforce sf = Salesforce(username = ' [email protected] com failed with the following message - com. Introduction to Documill Dynamo; The structure of a Document Template; How to map Salesforce fields to template; Create span and editable span; Create group and editable group; Work with tables. SOQL returns a list while SOSL returns list of lists. Use the most popular data loader for Salesforce to quickly and securely import, export and delete unlimited amounts of data for your enterprise. 2 in the Windows Registry. A PushTopic is a special object in Salesforce that binds a name (the topic's name) and Salesforce Object Query Language (SOQL) query together. HubSpot's Blog for marketing, sales, agency, and customer success content, which has more than 400,000 subscribers and attracts over 4. Salesforce developer console has a menu bar, Workspace and Logs tab which contains several items like logs, Tests, Checkpoints, Query editor, Progress and problem. CloverDX Designer. Ans - SOQL- salesforce object query language, SOSL - salesforce object search language. I load them into tables in two different sheets, and then create a third worksheet and table using Data > Get external Data > From other sources > From MS Query > From Excel referencing the workbook itself. Visual Studio Code is free and available on your favorite platform - Linux, macOS, and Windows. SAP Crystal reports 4. Under the SoapBinding list, expand login and choose Show Request Editor. Please read our Authenticating with OAuth 2. Introduction to Documill Dynamo; The structure of a Document Template; How to map Salesforce fields to template; Create span and editable span; Create group and editable group; Work with tables. Once completed, you will be taken to the summary screen for the new Salesforce Query. To include Salesforce Object Query Language queries within your Apex code, wrap the SOQL statement within square brackets and assign the return value to an array of. Salesforce SOQL Query -Session 1. Install the complete Salesforce Extension Pack instead. The Salesforce Edition of the Online SQL Editor of Invantive provides you with benefits such as: Interactive and online access to your company information via any modern web browser. If the field where you want to store the selection is a picklist then ther is no problem we can do that by using. Next I found that my copy of SOQLExplorer doesn't support these queries at all. The component offers both a Basic and Advanced mode (see below) for generating the Salesforce API query. DocuSign APIs give you the flexibility and control you need to scale from simple electronic signature integrations to complex enterprise applications. 1 Open the WSDL in the Text editor and change the data type to. "Flow puts real power in the hands of regular users. on( "load", handler ). At the top, click Add-ons Data connector for Salesforce Open. Click the App Launcher drop-down menu and choose Mailchimp for Salesforce. name} expression makes a call to the getRecord() method in the standard Contact controller to returns the record that is currently in context, based on the value of the id query string parameter in the Visualforce page URL. Salesforce CLI: The Salesforce CLI is a powerful command line interface that simplifies development and build automation when working with your Salesforce organization. com account. Click Current Database, and then click OK. API Best. For more information about SOQL, see Salesforce Object Query Language (SOQL). Salesforce DX Benefits – Salesforce Developer Experience (DX) is a brand new way to develop and manage apps on the Lightning Platform across the entire life cycle. What's new in this update? SQL Server Analysis Services connector. Save queries for re-execution later. Salesforce has introducted Queueable interface supersede the old @future annotation in Apex. After you've setup your custom settings and added your fields, you can select the Manage link on the Custom Settings page to add add/edit/delete values. SOQL is the query language of the App Cloud. Or, users can simply drag items around the navigation bar to where they want them to quickly adjust the order. It combines the best of the Lightning Platform to enable source-driven development, team collaboration with governance, and new levels of agility for custom app development on. Your users can get back to work in no time with an enhanced user interface. It is very similar to the widely used language SQL (Structured Query Language), to query databases. SOQL is the query language of the App Cloud. Using DirectQuery in Power BI. DbSchema is managing its own internal copy of the schema, distinct from the database. To view segments for a Mailchimp audience in Salesforce when you build a query, click Sync Audience next to Mailchimp list name in Salesforce. The Salesforce database query tool provided by RazorSQL includes a Salesforce SQL editor with Salesforce specific SQL support that allows users to write select, insert, update, and delete queries against Salesforce tables, a custom Salesforce database browser, a Salesforce table data editor, and Salesforce import and export tools. You'll also find these samples files on the How Do I tab. Create Re-Usable Custom Lookup In Salesforce… (45,902) How to create custom Lookup in lightning component (45,003) How to Add Lightning Component as a Quick Action in… (42,934) 3 Ways to Use CSS In Lightning Component. To check app visible and set to default for a user, go to the User Profile, and looks for Custom App Settings. A page can't be manipulated safely until the document is "ready. Restrict users' access to view and edit fields. One of the most frequently asked questions in SQL Server forums is how to format a datetime value or column into a specific date format. Just use the fields in your code and trust that Salesforce will take care of the rest. Just a quick note that I found sub-query is not supported by DataSense Query Language. TL:DR - Needing to pull a lead history report from salesforce into excel via power query, but the query "LEAD HISTORY" option only allows me to choose a few objects. After opening the request. Viewed that way, Salesforce isn’t just a CRM — it’s a platform for building CRM-like apps, but with sane defaults. How to create a 3D Terrain with Google Maps and height maps in Photoshop - 3D Map Generator Terrain - Duration: 20:32. Execute SOQL. rr_recommendationHeaderLabel}} {{trainingrecommendationsServicesScope. Enter the filter value. Use the Mailchimp for Salesforce Query Builder to add leads and contacts to your Mailchimp audience, so you can target them with email or ad campaigns. Salesforce does a bit of magic when it compiles your trigger by looking at the fields that you are referencing and making sure that data is available at runtime. Salesforce users can run SQL-like queries for data management, and Cloudingo Studio translates them into API calls for fast inserts, updates, or deletions. Query Settings task pane. If you login with a Non-Admin user, make sure “API Enabled” in profile has been checked. Module 5: Accessing Data using SOQL and DML. Click this button to append only the filter part of the query generated by the query builder controls to the end of the existing query. Query Studio for Marketing Cloud - Salesforce Labs - AppExchange. Your feedback is appreciated. Power Query is available with all levels of Office 365 subscriptions. If you want you can vote for this idea on the ability to edit standard fields. To include Salesforce Object Query Language queries within your Apex code, wrap the SOQL statement within square brackets and assign the return value to an array of. If you just want to get your feet wet with regular expressions, take a look at the one-page regular expressions quick start. We will begin with a brief introduction to the query language SOQL, followed by an overview of the Salesforce REST API. Custom Query: If you prefer Querying Salesforce using SOQL, you can use the Customer Query to write out SOQL statements. This utility lets admins and developers run SOSL Queries from a VisualForce page. Click + NEW GOAL or Import from Gallery to create a new goal, or click an existing goal to edit its configuration. I have searched and found that one should use “Schema. 0 - May 1, 2012. This is the property containing the statement. Salesforce provides the Salesforce Object Query Language or SOQL in short, that you can use to read saved records. Experts like you can vote on posts, so the most helpful answers are easy to find. In Microsoft Query, inner joins are the default join type (for more information, see page 105 in the "Microsoft Query User's Guide," version 1. Once completed, you will be taken to the summary screen for the new Salesforce Query. com object that is used to retrieve data from your SalesForce. When you build a Salesforce query in the Query Builder, Toad generates a SOQL query in the Query tab. Australia; België; Botswana; Brasil; Canada; Deutschland; Dubai; España; France; Hong Kong. If you want to be a Salesforce developer, then you must know both of these query languages. Custom Query: If you prefer Querying Salesforce using SOQL, you can use the Customer Query to write out SOQL statements. Translation Find a translation for Salesforce Object Query Language in other languages:. Salesforce Database Query Tool Features. Delete Rows. We added one new license management feature so that you can move license from one server to another. Query Studio for Marketing Cloud - Salesforce Labs - AppExchange. SOQL is Salesforce's object query language. Make sure that the Use the Query Wizard to Create/Edit Queries check box is selected, and then click OK. Thank you for contacting us. Salesforce API Version Support salesforce. Documentation. Module 5: Accessing Data using SOQL and DML. tabs methods and events without declaring any permissions in the extension's manifest file. Integrate Salesforce. Custom Query: If you prefer Querying Salesforce using SOQL, you can use the Customer Query to write out SOQL statements. Whether the transformation is a connection to a data source, removing a column, a merge, or a data type change, Query Editor tracks each operation in the Applied Steps section of the Query Settings pane. I have searched and found that one should use “Schema. Create SOQL Query to retrieve data. We give users control over what and when they share. Salesforce SQL Editor. Add or Edit a Salesforce Source. Query your connected data sources with SQL. Under Build , click the arrow next to Customize. Using Microsoft Query in Excel to Connect to Salesforce This article uses the CData ODBC driver for Salesforce to import data in Excel with Microsoft Query Query. This session is intended for Apex developers who are having trouble understanding SOQL syntax. I have no knowledge of the format used in OData filter and OData query and have already spent several hours trying to get this to work but no luck so far. SOQL returns a list while SOSL returns list of lists. When you use the Query Editor, you need to supply only the SOQL statement without the Apex code that surrounds it. The default value is login. The problem is i cant merge accounts and calls because there is no identifier to match for calls and accounts. Salesforce made it easier for users to personalize their navigation in Lightning apps. Cook Book to create SFDC Configuration Project in Mule 3. To ease query creation, you can drag a Salesforce object from the Salesforce Objects tree to the Edit Query box, and the query to the corresponding Salesforce object will be built automatically. Query Editor records and labels each transformation, or step, you apply to the data. Choose your object from the drop down list after connecting to SalesForce. Then click Connect to open the Salesforce Connection dialog. The is a salesforce server side timeout. On its own, the View All Data permission only allows you to query files you own or have access to. Customize SharePoint Online, use PowerApps with Microsoft Teams, and build apps on Dynamics 365. It looks like the getInstance() and getValues() method returns the same object. That means it’s lightning fast, more secure, easier to use, and more seamlessly integrated into the system that your teams depend on everyday. Custom Query: If you prefer Querying Salesforce using SOQL, you can use the Customer Query to write out SOQL statements. Connect people, products, and data with Microsoft Dynamics 365—a collection of business applications that help transform the way you do business. If the query does not function in Salesforce, it will not function in ProntoForms. A database query can be either a select query or an action query. In the Query Editor, I am filtering out both columns and rows from the Object. Click on the Query editor option in Developer console. Before you can receive events for Salesforce changes that are associated with a topic, you must first create a topic (a PushTopic). For example, while developing Apex code, write a SOQL query and verify that the results are what you expect. Execute SOQL. In this blog post we will discuss how to call Salesforce's APIs to operate on its data. Notes are synced and updated every time you open or edit a note inside Evernote for Salesforce and Evernote Web. Salesforce Apex is the world's first on demand strongly typed programming language developed by Salesforce. All structured data from the main, Property, Lexeme, and EntitySchema namespaces is available under the Creative Commons CC0 License; text in the other namespaces is available under the Creative Commons Attribution-ShareAlike License; additional terms may apply. Now, when you navigate to login. Click the App Launcher drop-down menu and choose Mailchimp for Salesforce. I can query the report in excel and it works perfectly, with the exception that it is limited to 2000 rows. Remove 2000 row limit for Salesforce Power Queries and allow passing of parameters to Salesforce In Power Query in Excel and in the Designer, the current implementation of "From Salesforce Report" is useless due to the Salesforce 2000 row limitation. Click on the + icon to add the filter. Available as SaaS or on-premise, download for free today!. Example edit This example prints all the Salesforce Opportunities to standard out. com from your existing Google Spreadsheets using the Insert command. Pre-Requisites Salesforce account Security Token Creating Simple SFDC project Force Explorer-SOQL Query Editor Contents 3. Salesforce Reporting in a nutshell. The Salesforce Edition of the Online SQL Editor of Invantive provides you with benefits such as: Interactive and online access to your company information via any modern web browser. Usable from any location and any platform, such as Windows, Mac, Linux, iPhone, iPad etc. In child query context, query construction call is applied to the child query. Formulas in salesforce can be made up of two Parts. By default this data is displayed in a flat tabular report with an individual row for each record. SOQL Aggregate functions have special set of limits than a normal SOQL query. This method is a shortcut for. Support your customers before and after the sale with a collection of digital experience software that works together to grow the customer relationship. I think if I remember correctly not even Salesforce internal members can see your data until you authorize them to do so. protocols=TLSv1. ini file available in C:\Program Files\SAP Lumira\Desktop\ and add the below entry:-Dhttps. Log in to your Salesforce account. Salesforce Lightning is a platform where an organization can investigate creative courses for associating with customers. We'll use a few data connections to complete these tasks. It is very similar to the widely used language SQL (Structured Query Language), to query databases. The data loader for Salesforce. The {!contact. Apex code generator 3. You use the Query Editor to edit your data prior to completing the import process with Power Query. After posting my previous blog post Display Google Map using Salesforce Lightning Web Components leveraging modern JavaScript at Linkedin , there are few community members asked me if that component could be available in Salesforce Communities, which drives me to do one more proof-of-concept on how that component can be available at Communities. I load them into tables in two different sheets, and then create a third worksheet and table using Data > Get external Data > From other sources > From MS Query > From Excel referencing the workbook itself. Your users can get back to work in no time with an enhanced user interface. g Opportunities) you want to report on. To view segments for a Mailchimp audience in Salesforce when you build a query, click Sync Audience next to Mailchimp list name in Salesforce. Choose your object from the drop down list after connecting to SalesForce. Use Python and R for advanced analysis. Use the Mailchimp for Salesforce Query Builder to add leads and contacts to your Mailchimp audience, so you can target them with email or ad campaigns. Add to My List Edit this Entry Rate it: (4. If you want to be a Salesforce developer, then you must know both of these query languages. The component offers both a Basic and Advanced mode (see below) for generating the Salesforce API query. Edit Salesforce Data Like Usual Excel Spreadsheets To edit Salesforce data in Excel you need just to click the Edit Mode button on the ribbon before editing, and then you can edit data just like you usually do it - add or delete rows, modify cell values, etc. In this example, it is talendlena__Contact_Talend_ID__c like '201801%' and all Salesforce Contact records whose talendlena__Contact_Talend_ID__c field begins with 201801 will be retrieved. Hi, I'm working on the following Integration scenario: ECC (Proxy) <-> PI <-> Salesforce to query Opportunity and Forecast data from Salesforce. Cloudingo Studio uses IntelliSense to display available objects and functions for fast and easy query building. SFDC QCP: View active QCP record in Salesforce. Download instructions. I can query the report in excel and it works perfectly, with the exception that it is limited to 2000 rows. com driver based on Java. Powerful database management & design tool for Win, macOS & Linux. Click Page Layouts. It is easy because the field definition will define that,the page. Includes all Power Query features, except the following ones: Corporate Power BI Data Catalog, Azure-based data sources, Active Directory, HDFS, SharePoint Lists, Oracle, DB2, MySQL, PostgreSQL, Sybase, Teradata, Exchange, Dynamics CRM, SAP BusinessObjects, Salesforce. In this blog post we will discuss how to call Salesforce’s APIs to operate on its data. 4 Visual Explain Plan 7. ini file available in C:\Program Files\SAP Lumira\Desktop\ and add the below entry:-Dhttps. Here is the link, Difference between Standard Fields and Custom Fields in Salesforce. The Salesforce database query tool provided by RazorSQL includes a Salesforce SQL editor with Salesforce specific SQL support that allows users to write select, insert, update, and delete queries against Salesforce tables, a custom Salesforce database browser, a Salesforce table data editor, and Salesforce import and export tools. com databases. com is a world's no one CRM cloud application. Save query results to CSV. With more advanced versions of the application, Admins can control if a user can update their Salesforce data from Excel or just retrieve it. Salesforce Reporting in a nutshell. TeamDesk is an online database software for easy web apps design. SOQL returns a list while SOSL returns list of lists. An optional record parameter, options, may be provided to specify additional properties. Salesforce DISTANCE query using the map centerPoint: Loop over the records returned by the distance query and add graphics to the graphics layer. Click Finish to return your Salesforce. Salesforce Query ALL: Going back to the Salesforce connector, select Query as Operation. com uses core calls to the Apex Web Services API and the Sforce Object Query Language (SOQL) SELECT statement to query and extract data from Salesforce. In this article, we see how to use Salesforce Analytics Query Language effectively. Create Salesforce SOQL Queries. Apex code generator 3. Enter the filter value. Efficiency is vital to keeping your sanity and enabling your company to prosper. Translation Find a translation for Salesforce Object Query Language in other languages:. In the toolbar at the top of Management Studio, click New Query. To create a query manually, follow these steps. How to run a query: 1. Introduction to Documill Dynamo; The structure of a Document Template; How to map Salesforce fields to template; Create span and editable span; Create group and editable group; Work with tables. If the field where you want to store the selection is a picklist then ther is no problem we can do that by using. There is an issue with your Salesforce. The login to Salesforce. Query Studio for Marketing Cloud - Salesforce Labs - AppExchange. Salesforce users can run SQL-like queries for data management, and Cloudingo Studio translates them into API calls for fast inserts, updates, or deletions. Install the complete Salesforce Extension Pack instead. SOQL returns a list while SOSL returns list of lists. com will depend on your salesforce instance. Choose your object from the drop down list after connecting to SalesForce. Create a Query. Cloud apps are developed differently than server apps. How To Use jQuery DataTable Plugin In Salesforce Lightning Component -: Sample. Module 5: Accessing Data using SOQL and DML. The approach is very much aligned with Cloud delivery model where you build your application on the cloud and run it with no deployment steps necessary. Thank you for contacting us. ini file available in C:\Program Files\SAP Lumira\Desktop\ and add the below entry:-Dhttps. In the toolbar at the top of Management Studio, click New Query. The AWS Service Delivery Program recognizes APN Partners with a verified track record of delivering specific AWS services and workloads to AWS customers, including Amazon Redshift. For instance, consider that you need to limit the API usage of Salesforce so that 10% of daily API requests is left for other routes. Ashley's comment above is correct. Experts like you can vote on posts, so the most helpful answers are easy to find. To create a query manually, follow these steps. After you've setup your custom settings and added your fields, you can select the Manage link on the Custom Settings page to add add/edit/delete values. When you use the Query Editor, you need to supply only the SOQL statement without the Apex code that surrounds it. Select a field. Browse the top apps, add-ons, plugins & integrations for Jira, Confluence, Bitbucket, Hipchat & other Atlassian products. back}} {{relatedresourcesrecommendationsServicesScope. When you create a bucket field, you define multiple categories (buckets) that are used to group report values. Logging In. Once completed, you will be taken to the summary screen for the new Salesforce Query. The Object, ObjectFilter or Statement parameters are available for setup in the data flow properties list. I have provided you with a detailed explanation of these languages below: SOQL stands for Salesforce Object Query Language. In the editor window that appears, type the following statement for creating the linked server, where [LinkedServerName] is the name of the linked server:. Log into your Salesforce account. Click on the + icon to add the filter. As a valued partner and proud supporter of MetaCPAN, StickerYou is happy to offer a 10% discount on all Custom Stickers, Business Labels, Roll Labels, Vinyl Lettering or Custom Decals. The translator, known by the type name salesforce, provides Salesforce API 22. It's very similar to maintaining other records in Salesforce. For full SOQL Syntax, see this link. Build apps to integrate with Atlassian's cloud products. If you want to be a Salesforce developer, then you must know both of these query languages. No database experience required - the tool is visual. 2 versions) Also there is no enterprise or any other editions after Crystal Reports XI R2. If I am pasting SOQL in the Query Text, I better choose Native Query Language. DocuSign APIs give you the flexibility and control you need to scale from simple electronic signature integrations to complex enterprise applications. To build a SOQL query from scratch in Advanced Query Mode: In Klipfolio, on the Configure Data Source page for Salesforce, at Retrieval Method, select SOQL. SOQL is syntactically similar to SQL (Structured Query Language). To build and execute a new query, just select (by clicking) the necessary fields in the list you would like to receive the data about.