Filtering Records

Filtering Records is one of the most important features of SOQL. Instead of retrieving every record from a Salesforce object, developers can use filtering conditions to retrieve only the records that match specific criteria. Filtering improves performance, reduces data processing, enhances application efficiency, and helps developers stay within Salesforce Governor Limits.

In real-world Salesforce applications, businesses rarely need all records. They often require specific data such as active customers, qualified leads, open opportunities, enrolled students, pending payments, or recently created records. SOQL filtering makes these requirements possible.

Understanding how to filter records effectively is essential for Salesforce Developers, Administrators, Consultants, and Platform App Builders.

What is Record Filtering?

Record Filtering is the process of retrieving only records that meet specific conditions.

Instead of:

All Records

You retrieve:

Matching Records Only

Filtering helps users find relevant information quickly.

Why Filtering Records is Important?

Organizations often store:

• Thousands of Accounts
• Thousands of Contacts
• Thousands of Opportunities
• Millions of Records

Retrieving all records can:

• Reduce performance
• Increase processing time
• Consume resources

Filtering improves efficiency and scalability.

Benefits of Filtering Records

Faster Query Execution

Retrieve only required records.

Improved Performance

Reduce unnecessary processing.

Better User Experience

Display relevant information.

Governor Limit Compliance

Process fewer records.

Enhanced Data Analysis

Focus on meaningful data.

These benefits make filtering essential in Salesforce development.

The WHERE Clause

What is WHERE?

The WHERE Clause is used to filter records in SOQL.

General Syntax:

SELECT fields
FROM ObjectName
WHERE condition

The WHERE clause specifies which records should be returned.

Basic WHERE Clause Example

SELECT Name
FROM Account
WHERE Industry = 'Software'

Result:

Only Software industry accounts are returned.

Comparison Operators

Filtering relies on comparison operators.

These operators define filtering conditions.

Equal To Operator (=)

What is Equal To?

Returns records matching an exact value.

Example:

SELECT Name
FROM Student__c
WHERE Course__c = 'Salesforce'

Result:

Only Salesforce students are returned.

Not Equal To Operator (!=)

What is Not Equal To?

Returns records that do not match a value.

Example:

SELECT Name
FROM Student__c
WHERE Course__c != 'Salesforce'

Result:

Students enrolled in other courses are returned.

Greater Than Operator (>)

What is Greater Than?

Returns values greater than the specified value.

Example:

SELECT Name,
       Fee__c
FROM Student__c
WHERE Fee__c > 10000

Only students with fees above ₹10,000 are returned.

Less Than Operator (<)

What is Less Than?

Returns values below the specified value.

Example:

SELECT Name,
       Fee__c
FROM Student__c
WHERE Fee__c < 10000

Only lower-fee records are returned.

Greater Than or Equal To (>=)

Example:

SELECT Name,
       Marks__c
FROM Student__c
WHERE Marks__c >= 75

Students scoring 75 or above are returned.

Less Than or Equal To (<=)

Example:

SELECT Name,
       Balance__c
FROM Student__c
WHERE Balance__c <= 0

Returns students with no pending balance.

Filtering Text Values

Example:

SELECT Name
FROM Account
WHERE Name = 'Groot Software'

Only matching Account records are returned.

Filtering Number Fields

Example:

SELECT Name,
       Revenue__c
FROM Account
WHERE Revenue__c > 500000

Returns high-revenue accounts.

Filtering Boolean Fields

Boolean fields store:

true

false

Example:

SELECT Name
FROM Student__c
WHERE Active__c = true

Returns active students only.

Filtering Date Fields

SOQL supports date filtering.

Example:

SELECT Name,
       CreatedDate
FROM Account
WHERE CreatedDate = TODAY

Returns records created today.

Date Literals

Salesforce provides built-in date values.

Examples:

TODAY

YESTERDAY

TOMORROW

LAST_WEEK

THIS_MONTH

LAST_YEAR

Date literals simplify date filtering.

Example: TODAY

SELECT Name
FROM Account
WHERE CreatedDate = TODAY

Returns today’s records.

Example: THIS_MONTH

SELECT Name
FROM Opportunity
WHERE CloseDate = THIS_MONTH

Returns opportunities closing this month.

Using Logical Operators

Multiple conditions can be combined.

Logical Operators:

AND

OR

NOT

These operators create advanced filters.

AND Operator

What is AND?

Both conditions must be true.

Example:

SELECT Name
FROM Student__c
WHERE Course__c = 'Salesforce'
AND Fee_Paid__c = true

Result:

Only students who meet both conditions are returned.

OR Operator

What is OR?

At least one condition must be true.

Example:

SELECT Name
FROM Student__c
WHERE Course__c = 'Salesforce'
OR Course__c = 'Python'

Returns students enrolled in either course.

NOT Operator

What is NOT?

Excludes matching records.

Example:

SELECT Name
FROM Student__c
WHERE NOT Course__c = 'Salesforce'

Returns non-Salesforce students.

Using Parentheses

Parentheses improve readability and control logic.

Example:

SELECT Name
FROM Student__c
WHERE
(
Course__c = 'Salesforce'
OR Course__c = 'Python'
)
AND Active__c = true

This creates precise filtering rules.

IN Operator

What is IN?

IN compares multiple values.

Example:

SELECT Name
FROM Student__c
WHERE Course__c IN
(
'Salesforce',
'Python',
'Java'
)

Equivalent to multiple OR conditions.

NOT IN Operator

Example:

SELECT Name
FROM Student__c
WHERE Course__c NOT IN
(
'Salesforce',
'Python'
)

Returns students enrolled in other courses.

LIKE Operator

What is LIKE?

LIKE performs partial text matching.

Example:

SELECT Name
FROM Account
WHERE Name LIKE 'Groot%'

Returns:

Groot Software

Groot Academy

Useful for text searches.

Wildcards in LIKE

%

Represents multiple characters.

Example:

WHERE Name LIKE '%Tech%'

Matches:

• ABC Tech
• Tech Solutions
• Global Technologies

Wildcards increase search flexibility.

NULL Filtering

What is NULL?

NULL means no value exists.

Example:

SELECT Name
FROM Student__c
WHERE Email__c = NULL

Returns students without email addresses.

NOT NULL Filtering

Example:

SELECT Name
FROM Student__c
WHERE Email__c != NULL

Returns students with email addresses.

Filtering Picklist Fields

Example:

SELECT Name
FROM Student__c
WHERE Status__c = 'Active'

Only active students are returned.

Filtering in Apex

SOQL filters can use Apex variables.

Example:

String courseName =
'Salesforce';

List<Student__c> students =
[
    SELECT Name
    FROM Student__c
    WHERE Course__c =
    :courseName
];

This is called Variable Binding.

Real-World Example

A software training company wants all active Salesforce students.

Query:

SELECT Name,
       Email__c
FROM Student__c
WHERE Course__c = 'Salesforce'
AND Active__c = true

Result:

Management receives only relevant student data.

Filtering Best Practices

Retrieve Only Required Records

Improve performance.

Use Indexed Fields

Optimize execution.

Avoid Broad Queries

Reduce processing.

Combine Conditions Carefully

Ensure accuracy.

Test Query Results

Verify correctness.

These practices improve query efficiency.

Common Mistakes

Missing WHERE Clause

Incorrect Field Names

Excessive Conditions

Poor Query Design

Ignoring Selectivity

Developers should avoid these mistakes.

Why Filtering Records Matters for Salesforce Professionals

Understanding Filtering Records helps professionals:

• Retrieve Relevant Data
• Improve Application Performance
• Support Automation
• Build Efficient Queries
• Reduce Governor Limit Usage
• Prepare for Salesforce Certifications

Filtering is one of the most frequently used SOQL skills.

Summary

Filtering Records allows Salesforce professionals to retrieve only the data that matches specific conditions. Through the WHERE clause, comparison operators, logical operators, IN, LIKE, NULL checks, date literals, and variable binding, SOQL provides powerful filtering capabilities. Effective filtering improves performance, scalability, and data accuracy, making it a critical skill for Salesforce development and administration.

Frequently Asked Questions (FAQs)

What is the WHERE clause in SOQL?

The WHERE clause filters records based on specified conditions.

Which operator checks equality?

The = operator checks whether values are equal.

What does the LIKE operator do?

LIKE performs partial text matching using wildcards.

What is the purpose of the IN operator?

IN compares a field against multiple values.

Can SOQL filter dates?

Yes. SOQL supports date filtering and date literals such as TODAY and THIS_MONTH.

Why is filtering important?

Filtering improves performance and retrieves only relevant records.

Internal Resources

Looking to learn more technologies and programming skills?

Click here for more free courses.