Download Action Request System User's Guide for Windows

4
•
How to use FTS to retrieve records, especially using the accrue operator (the
LIKE operator and comma separators) to search for matches.
What is Full Text Search?
Full text search (FTS) is an important and extremely useful feature of the AR
System. The FTS option lets administrators index character and diary fields for
faster searches and matches entries from FTS-indexed fields against the search
criteria you specify. Like database indexes, an FTS index can greatly decrease
the time required for a database search.
Having FTS capability allows you to search for key words regardless of the
underlying database, whether flat-file or relational. In contrast to only
searching fields in schemas that contain numeric data (for example, ID
numbers) or names (for example, submitters of tickets), indexing character and
diary fields for FTS lets you do searches of work diaries and long descriptions
of problems which some databases do not allow you to do directly.
Who Can Perform a Full Text Search?
You must have a floating or fixed FTS license to do searches in fields indexed
for FTS. FTS licenses are separate from AR System write licenses.
If you have a fixed FTS license, you can perform a search in an FTS-indexed
field without worrying about licenses not being available or license time-outs.
If you have a floating FTS license but no floating FTS licenses are currently
available, you will get a warning the first time you perform a database
operation in the User Tool. The system will then use the search capabilities of
the underlying database (if available). When a floating license becomes
available, you will be alerted with a note and will then be able to perform a full
text search.
Note – You can tell if a field is indexed for FTS by looking in context-sensitive
help. See Figure 4-18.
120
Action Request System User’s Guide for Windows—January 1996