Search

The Search statement is used for including or excluding fields when using the search function.

Syntax:  

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.

Arguments:  

Argument Description
*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.

Example:  

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.

Did this information help you?

Thanks for letting us know. Is there anything you'd like to tell us about this topic?

Can you tell us why it did not help you and how we can improve it?