Activity Forums Salesforce® Discussions How to query big objects in Salesforce?

  • Kirandeep

    Member
    October 28, 2020 at 2:03 pm
  • Shweta

    Member
    October 29, 2020 at 11:39 am

    The query on Standard and custom objects is different than the query on Big objects. When you are using SOQL queries you need to query in all fields starting from the first field and do not skip any field at the end in the query because if you will skip any field it will return wrong data.
    For example: SELECT LastName__c, FirstName__c, Phone__c FROM Phone_book__b WHERE LastName__c=’001R01110302D3′ AND FirstName__c=’PC’ AND Phone__c =’243566′

Log In to reply.

Popular Salesforce Blogs

Popular Salesforce Videos