SOQL for Admins/ Beginner & Intermediate Developers
About Lesson
  1. Retrieve the CaseNumber & CreatedDate of all Case records created in this Week.
  2. Retrieve the CaseNumber & CreatedDate of all Case records created in Last Month.
  3. Retrieve the Case records created in the last Quarter.
  4. Retrieve the Id & CloseDate of all Opportunity records with the CloseDate in the Current Quarter.
  5. Retrieve the Opportunity records with a StageName of “Closed Won” and Lead Source as “Partner Referral”.
  6. Retrieve all the contacts associated with an account named “Acme Corporation.”
  7. Find all the opportunities related to an account with a specific industry, such as “Technology.”
  8. Retrieve all the tasks associated with an opportunity with a specific name, like “Big Deal.
  9. Find all the opportunities that have a related contact with the title “Manager.”
  10. Retrieve the names of all the opportunities that are associated with an account in a specific industry, such as “Healthcare.”
  11. Query the records based on the below criteria.
  • Query the records based on the below criteria.
Step 1: Retreive Name, Department and Title from Contacts.
Step 2: Retreive All case(Case Number, Subject) raised by a contact.
Step 3: Get Parent Account's Name, Rating for each contact.
Step 4: Make sure Account fields are the initial columns in the result.
Step 5: Retreive only those records where Account rating is Hot.
Step 6: Sort the results by contact name.
Step 7: Only retreive Open Cases.
Step 8: Add one more filter, Contact department must be equals to Technology.
0% Complete