5.0

Table Of Contents
Field Searches
199
Values in Fields: Alphanumeric vs. Numeric
Some fields in a story form will always contain strictly numeric data such as the audio time (a
number of seconds) or a line count. Other standard date fields, such as Modified-By, will be
converted to strictly numeric fields by the indexer. Still other fields, such as Title or Writer, are
usually letters, but may have some combination of letters and numbers (for example, a user could
have the alphanumeric username of steve3).
There is a major difference between numbers parsed by the indexer and numbers left alone. Only
numbers parsed can be used in the numeric syntax.
Number Operator
The Number operator ( # ) expresses values the FTS server looks for.
Numeric Expressions
If a field contains multiple number operators separated by delimiters, the first complete number
read is used.
For all table entries above, query syntax requires "#" immediately following ":", and white space
may be included after the "#", as in:
Tape-ID:# == 4375
Date-Time Field Values
You can express date and time values in any format understandable by Microsoft Windows.
These include, but are not limited to, the following:
25 January 2014
8:30:00
This expression: Means this:
#!= is not equal to
#== is equal to
#<= is less than or equal to
#< is less than
#>= is greater than or equal to
#> is greater than