Set Filters and Sorting for Lookup Records
x`Configure filters to load specific records of the lookup object that meet defined conditions, and set sorting options to arrange the records in the desired order when the Lookup Selector screen loads.
Set Filters
Filters ensure that only records meeting the specified conditions are displayed when the Lookup Selector is loaded. The filter configuration follows the syntax of a SOQL WHERE clause.
For example, to display only active PricebookEntry records, you can write:
IsActive = true
Additionally, you can use the Query Wizard to automatically generate filters without manually writing them.

Set Sorting
Sorting ensures that the data appears in the desired order when the Lookup Selector screen loads. The sorting configuration follows the syntax of a SOQL ORDER BY clause.
For example, to sort PricebookEntry records by name in ascending order, you can write:
Name ASC

Last updated
Was this helpful?