It’s helpful to know that 3Play’s search engine performs a logical OR operation using the criteria you supply. Thus an exact match of every element of the search criteria is not required. Your search criteria can include, for example, multiple words, or consecutive character strings, including numbers or common symbols.
When a SEARCH operation is executed, event rows with are listed in the Search Result pane (CLIP LIST) whenever of their cells contains elements matching any search criteria item tab.
Let’s consider some simple examples. Suppose you have made the following into Memo entries (Figure 151):
The table below illustrates which events will be added to the Search Results tab for a SEARCH operation based on the criteria shown at left:
First, we can see that a ‘perfect match’ is not necessary. The first two SEARCH operations produce identical results regardless of whether the criteria entered is “Home” or “Hom”.
Next, take a look at the example in row d. Notice that including “visitors” in the criteria did not suffice to exclude Event # 0-2 from the result. Let’s consider how SEARCH processing produced this result to see why not:
- First, the SEARCH process checked to see whether the leading element in the criteria (i.e., “visitors”, without quotes) was found in any Memo field. This cause the inclusion of Events # 0-2 and 0-5 in the Search Result.
- Next, the second element of the criteria (22) was evaluated. This resulted in Event # 0-4 being included along with prior matches in the result.
We can see that 3Play’s OR type search processing included matches for any element included in the criteria. It’s useful to observe, too, that quotation marks can be used to force the search to treat multiple elements in the criteria as an inseparable unit.
For example, in the last two rows of the table above the criteria are identical, save for one thing: in the second instance, quotation marks surround the two elements (i.e., “visitors 22”). The search treats the enclosed items as a single object, and produces a corresponding result.
Numbers are treated like any other character when included in the criteria for a SEARCH, but play different roles when used with GO TO, discussed next.