Page Comparison

Source Type

In this option, you can select various sources from which you want to query records. It allows to choose from Object, Model and Variable.

Object

In this option, you can select object from which you want to query records.

How many records to store?

In this option, you can select amount of records to query. Either you can choose Single or Multi-record.

Fields

In this option, you can see fields from object you selected which you can query for.

Selected Fields

In this option, you can see selected fields by you which are querying for.

Filters

It enables to filter out the data for object using AND OR logical operators.

Order By

It enables to perform order by and sort records on basis of fields, either ascending or descending.

Limit

It is used to specify the number of records to be queried in single query.

Offset

To efficiently manage large result sets in a SOQL query, use the OFFSET clause to paginate through records. For example, you can display records 51–75, then jump to records 301–350. This approach allows you to retrieve and display specific subsets of data without processing the entire result set at once.