The Search statement is used for including or excluding fields when using the search function.
Search Include *fieldlist
Search Exclude *fieldlist
You can use several Search statements to refine your selection of fields to include. The statements are evaluated from top to bottom.
|*fieldlist||A comma separated list of the fields to include or exclude from searches. Using * as field list indicates all fields. The wildcard characters * and ? are allowed in field names. Quoting of field names may be necessary when wildcards are used.|
Search Include *;
|Include all fields in searches.|
Search Exclude '*ID';
|Exclude all fields ending with ID from searches.|
Search Include ProductID;
|Include the field ProductID in searches.|
The combined result of these three statements, in this sequence, is that all fields ending with ID except ProductID are excluded from searches.