KEMBAR78
SOQL Queries Checklist | PDF
Scribd
Upload
43 views1 page

SOQL Queries Checklist

The document lists various SOQL queries related to Salesforce data retrieval, indicating their completion status. Out of 20 queries, only one has been completed, while the rest remain incomplete. The queries cover a range of entities including Accounts, Contacts, Opportunities, and Cases.

Uploaded by

Zuber Khan
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
43 views1 page

SOQL Queries Checklist

The document lists various SOQL queries related to Salesforce data retrieval, indicating their completion status. Out of 20 queries, only one has been completed, while the rest remain incomplete. The queries cover a range of entities including Accounts, Contacts, Opportunities, and Cases.

Uploaded by

Zuber Khan
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 1

Query No.

SOQL Description Completed


1 Fetch all Accounts done
2 Get all Contacts whose FirstName is ‘John’ ❌
3 Retrieve all Opportunities with StageName = ‘Closed Won’ ❌
4 List all Leads created in the last 7 days ❌
5 Find all Cases where Status = ‘New’ ❌
6 Fetch the Contacts related to a specific Account Id ❌
7 Get all Accounts created this year ❌
8 Fetch all fields of a specific Contact using Contact Id ❌
9 Get Opportunities with Amount greater than 1,00,000 ❌
10 Find Accounts whose Name starts with ‘Tech’ ❌
11 List all Contacts along with their Account Names ❌
12 Get Opportunities and their Owner’s Name ❌
13 Fetch all Opportunities with related Account Industry ❌
14 Retrieve Contacts that don’t have an email address ❌
15 Find Accounts with more than 5 related Contacts ❌
16 Get total number of Opportunities grouped by StageName ❌
17 List the maximum Opportunity Amount per Account ❌
18 Find the number of Contacts grouped by Account ❌
19 Fetch all Accounts that do NOT have any related Opportunities ❌
20 Write a query using a subquery to fetch Accounts with their related C ❌

You might also like