#SOQL13 personnes en discutent

Hi @Rakesh Goud The main difference is that SOQL is used to retrieve specific records, while SOSL is used to search for text across multiple objects.

1. SOQL (Salesforce Object Query Language)

• Used to retrieve records based on specific conditions.
• Supports WHERE, ORDER BY, and LIMIT.
• Supports querying related objects.
• Example: Retrieve Accounts where Industry is Banking.

SELECT Id, Name, Industry
FROM Account
WHERE Industry = 'Banking'

2. SOSL (Salesforce Object Search Language)

• Used to search for text across multiple objects.
• Searches searchable fields using Salesforce search indexes.
• Useful when you don't know which object contains the information.
• Example: Search for "John" in Accounts and Contacts.

FIND 'John*' IN ALL FIELDS
RETURNING Account(Id, Name),
          Contact(Id, Name, Email)

When to use each?

• SOQL: Reports, filtered Account lists, related records, and specific data retrieval.
• SOSL: Global search, customer lookup, and searching across Accounts, Contacts, and other objects.

Real-time Example:

In an LWC application, use SOQL to display Accounts filtered by Industry. Use SOSL when a user enters a customer name in a search box and you want to search both Accounts and Contacts.

Useful Salesforce Documentation:

• SOQL and SOSL Reference
• SOQL SELECT Syntax
• SOSL FIND Syntax

My suggestion: Use SOQL when you know what records you need, and SOSL when you need to search for information across multiple objects.

Hope this helps!

Hi @Rohith thammali When working with thousands of records in Apex, writing efficient SOQL queries is very important to avoid governor limits.

A few best practices I follow:

1. Avoid SOQL inside loops. Query records once and process them using collections.
2. Fetch only required fields. Avoid unnecessary fields and records.
3. Use WHERE conditions to filter records efficiently, preferably using indexed fields.
4. Use Maps and Sets to handle bulk records and avoid repeated queries.
5. Use Batch Apex when processing large data volumes.
6. Use LIMIT carefully. It's useful when you need only a specific number of records, not when you must process everything.

Also, remember that synchronous Apex generally allows 100 SOQL queries and 50,000 queried rows per transaction.

Focus on bulkification, selective queries, and proper collection usage. These make a big difference in real-time projects.

Hope this helps!

Hi @Vadde Chandu Reddy

For a Salesforce fresher, I would suggest focusing on basic SOQL first and then moving to relationship and aggregate queries. 

Here are the important topics to prepare:

1. Basic SOQL: SELECT, FROM, WHERE, ORDER BY, LIMIT.
2. Filtering: AND, OR, IN, NOT IN, LIKE, NULL.
3. Relationship Queries: Parent-to-Child and Child-to-Parent queries.
4. Aggregate Queries: COUNT(), SUM(), AVG(), MIN(), MAX(), GROUP BY.
5. Date Filters: TODAY, YESTERDAY, LAST_N_DAYS.
6. SOQL in Apex: Querying records, using bind variables, and understanding governor limits.

A few real-time interview scenarios to practice:

• Get the top 5 Opportunities by Amount.
• Fetch Contacts related to a specific Account.
• Find Accounts without Contacts.
• Count Opportunities grouped by Stage.
• Get Opportunities created in the last 30 days.

My suggestion:

 Spend 50% of your preparation on basic queries, 30% on relationship queries, and 20% on aggregate queries. 

For freshers, interviewers generally focus more on your understanding of SOQL and your ability to write queries for real-world scenarios. 

Don't just memorize syntax. Practice writing queries in the Developer Console or Salesforce Inspector.

Hope this helps! 

Thank you, 

Venkat Yadav. 

@Hitesh Sharma  

Apex Basics → Variables/Conditions/Loops → List/Set/Map → sObjects → SOQL/SOSL → DML → Classes/Methods → Constructors → Triggers → Governor Limits & Bulkification → Test Classes → Async Apex → Integrations.

Practice every topic with small programs in Developer Console/VS Code.

Start with Salesforce's Apex Basics & Database module, then move to Apex Triggers and Apex Testing. Apex Basics & Database – Trailhead Apex Developer Guide