Apex Code Development You need to sign in to do that
Don't have an account?
SELECT * FROM ACCOUNT
Hi,
I am a beginner to Salesforce, I understand that salesforce query works only with particular field name,
I am curious to know, is there any option to use a wildcard character or keyword to list all the fields in the object as similar to a SQL query.
Say for sample: SELECT * FROM ACCOUNT
Instead of: SELECT ID FROM ACCOUNT
I am a beginner to Salesforce, I understand that salesforce query works only with particular field name,
I am curious to know, is there any option to use a wildcard character or keyword to list all the fields in the object as similar to a SQL query.
Say for sample: SELECT * FROM ACCOUNT
Instead of: SELECT ID FROM ACCOUNT
Reference: https://developer.salesforce.com/docs/atlas.en-us.soql_sosl.meta/soql_sosl/sforce_api_calls_soql_select.htm
Specifies a list of one or more fields, separated by commas, that you want to retrieve from the specified object. The bold elements in the following examples are field list:
SELECT Id, Name, BillingCity FROM Account
SELECT count() FROM Contact
SELECT Contact.Firstname, Contact.Account.Name FROM Contact
Solution:
You must specify valid field names and must have read-level permissions to each specified field. The fieldList defines the ordering of fields in the query results.
fieldList can include a subquery if the query traverses a relationship. For example:
All Answers
That is not possible with the standard SOQL without pre-processing reading the metadata.
Cloudingo Studio offers "all fields" with "*" ( extended SOQL in SOQL+) but there is a pre-processing reading all the fields of the object from the metadata by the studio: https://www.symphonicsource.com/cloudingo-studio/
SOQL+ is not a language of request of Salesforce.
Reference: https://developer.salesforce.com/docs/atlas.en-us.soql_sosl.meta/soql_sosl/sforce_api_calls_soql_select.htm
Specifies a list of one or more fields, separated by commas, that you want to retrieve from the specified object. The bold elements in the following examples are field list:
SELECT Id, Name, BillingCity FROM Account
SELECT count() FROM Contact
SELECT Contact.Firstname, Contact.Account.Name FROM Contact
Solution:
You must specify valid field names and must have read-level permissions to each specified field. The fieldList defines the ordering of fields in the query results.
fieldList can include a subquery if the query traverses a relationship. For example: