Querying All Fields in SOQL

By -

We all know in SQL we use * to query all fields from database, however till now we didn't have anything similar in SOQL for developers. Hence we had to either use getDescribe() method from Apex and then use that in the Dynamic SOQL query to query all fields or we had to get all the API names of the fields and place it comma separated in the SOQL query.


However, now we can change that. We no longer need to know any API names and also don't require any unnecessary apex code to get fields in query.

The new FIELDS() function in SOQL lets you select all the fields. This function accept 3 parameters as described below.

  1. ALL: To query for all the fields (Need to add LIMIT clause)
  2. STANDARD: To query for all standard fields
  3. CUSTOM: To query for all custom fields (Need to add LIMIT clause)

Below is the example of the queries.
  1. SELECT FIELDS(ALL) FROM ACCOUNT LIMIT 200
  2. SELECT FIELDS(STANDARD) FROM ACCOUNT 
  3. SELECT FIELDS(CUSTOM) FROM ACCOUNT LIMIT 200
Note: You must put a LIMIT clause with a maximum of 200 for ALL and CUSTOM variation of FIELDS() function. Otherwise, you will get the below error:

The SOQL FIELDS function must have a LIMIT of at most 200
Please check the official salesforce documentation from here.

Comments

Post a Comment

Most Popular

Upsert with External Id in Salesforce

By -
We can use upsert operation to insert/update an existing record in one call.  Upsert statement uses the record's Id, a custom external Id field as the key to match records. Now, if we just write a simple upsert statement, it will use the record Id by default to match with other records. Look at the below examples: upsert  account;  Database.upsert(account, false); In this above example, Salesforce by default tries to match with other records using the record Id, if it doesn't find one, will create a new Account record. However, if we want Salesforce to use some other custom external Id field apart from record's Id, then we need to add extra parameters to those above methods. Suppose, you have created a new field and marked it as External Id field and the API is External_Id__c Look at the below examples for details: upsert account External_Id__c; Database.upsert(account, account.External_Id__c.getDescribe().getsObjectField(), false); These lines upsert the Account rec...
Read more

Gamification : Assigning Badges to Community Users based on user's Reputation point

By -
Image
What is Gamification?  According to Wikipedia, Gamification is the application of game-design elements and game principles in non-game contexts. Gamification commonly employs game design elements to improve user engagement. A collection of research on gamification shows that a majority of studies on gamification find it has positive effects on individuals. Salesforce has this feature for Community. If we go to Workspace->Gamification, we find these options. We can create badges by uploading images (Resolution - 128*128) and by giving it a name. Then we have Mission, where we can automate assigning badges to users based on some actions that the user performs. For example, if user posts 10 times in Community, then we can automatically assign a badge. However there are only certain set of actions where we can use Missions. Details can be found here . In this case, we are going to show how we can automatically assign badges to users when users reaches certain reputation points....
Read more

Calling an Apex Method From LWC

By -
Before thinking of using an Apex method, think about whether we can go ahead and use the wire adapter like getListUi or getRecordUi. Both of the usage are listed below. getRecordUi: import  {  LightningElement ,  wire  }  from   'lwc' ; import  {  getRecordUi  }  from   'lightning/uiRecordApi' ;       export   default   class   TestLWC   extends   LightningElement  {       @ wire ( getRecordUi , {  recordIds :   '123456789' ,  layoutTypes :   'Full' ,  modes :   'View'  })        wireProperty ;      } getListUi: import  {  LightningElement ,  wire }  from   'lwc' ; import  {  getListUi  }  from   'lightning/uiListApi' ; import   ACCOUNT_OBJECT   from   '@salesforce/schema/Account' ; export ...
Read more