QUERY

When retrieving list data, SOQL can be written in advance to filter and sort the data. Filters correspond to the WHERE clause in SOQL, while sorting is done using the ORDER BY clause. Although users can manually write the query, the Query Wizard allows for easy application of filters without requiring knowledge of SOQL.

The WHERE clause specifies the conditions for the records that will appear in the data table. Users can either manually input the WHERE clause or use the Query Wizard to configure it.

The ORDER BY clause determines how the records in the data table will be sorted based on specific fields. Users can manually input the ORDER BY clause or use the Field API Name Finder to set it up.

---

🔸 Steps to Configure Query

1. In the WHERE clause, click the Query Wizard button in the bottom-right corner.

   

   Datatable Setup

   

   Query Wizard
2. Configure the field and value for the condition, then click the Apply button.

3. In the ORDER BY clause, click the Field API Name Finder button in the bottom-right corner.

   

   Field API Name Screen
4. Select the field you want to sort by.

5. In the Result field, add ASC(ascending) or DESC(descending) after the field’s API name and click the Save button to finalize your query.