How to set schema for generating the simple query
This section demonstrates how to set the module name and schema columns for generating
the simple query.
The following two simple query examples will be used for demonstration purpose in the
following steps.
-
SELECT Id, Name, BillingCity FROM Account, a simple query with
standard object and fields, and -
SELECT Name__c, LastName__c FROM Mother__c, a simple query with
custom object and fields.
-
Set the module name with the name of the object specified in the
FROMclause,Accountand
Mother__cfor above examples. -
Create a column for each field in the field list (separated by commas) after
SELECTin the schema dialog box and set the column name
with the field name.For the first example, you need to create three columns
Id,
Name, andBillingCityfor the three
fields.For the second example, you need to create two columns
Name__candLastName__cfor the two
fields.