Text search

Use to search for documents that contain a specified word or phrase. The search takes place on the server. Any document that matches the criteria specified for the other query fields is searched for the specified word or phrase. For example, if the other query fields are date and account number, only documents that match the specified date and account number are searched for the specified word or phrase. Then, if a document contains the specified word or phrase, the document is added to the document list.

Note: When the user opens a document that contains the specified word or phrase, the client moves to the first line in the document that contains the word or phrase. The user can use the Find Next command to move to subsequent lines that contain the word or phrase.

A typical use of a text search field is to provide users a search field without database overhead. For example, assume a report is indexed on date and account number. A text search field could be used to allow users to optionally type the name of a store or city or any other word or phrase contained in the document or documents that the user needs to retrieve (the word or phrase is not stored in the database).

You can define one text search field per folder.

The only valid search operator for a text search field is EQUAL.

The mapping type of a text search folder field is always Single. However, you do not have to map the field to a database field on the Field Mapping page (typically you do not). If you do map a text search folder field to a database field, you can map the field to only one database field.

Important: The number of documents that must be searched for the specified word or phrase has a direct impact on the generation of the document list. To limit the number of documents that are searched, users should specify criteria for all of the other query fields.

Note: A match occurs and a document is added to the document list when one or more lines in a document contain the entire word or phrase. Wildcards and pattern matching are not supported in a text search field. The case of the specified word or phrase is ignored. (For example, the phrase 'customer xyz' matches customer xyz, Customer Xyz, and CUSTOMER XYZ.)