Free-text Syntax Guide
There are some basic rules when conducting a free-text search. This guide will help you correctly use free-text search in order to navigate to the right product data.
- Spaces: Spaces between words are interpreted as OR. The search term “cat dog” will find the occurrence of “cat” or “dog” within AgileXPLORER
- OR: To explicitly define a logical OR between two entries, use all CAPS “OR”. The search “cat OR dog” will find any occurrences of the words “cat” or “dog” within AgileXPLORER. Multiple items can be strung together, such as “cat OR dog OR bird”
- AND: Tell AgileXPLORER to match only occurrences where two of more match. The search “cat AND dog” will match only items where “cat” and “dog” appear. Multiple items can be strung together, such as “cat AND dog AND bird”
- Must Contain (+): If a search term has a “+” in front of it, this tells AgileXPLORER that the term must exist. This is only useful when more than one term is entered for example: “+dog cat bird” says that the result MUST HAVE “dog” in it.
- Exclude (-): If a search term has a “-“ in front of it, this tells AgileXPLORER to exclude any results that have that term.
- Therefore: “-cat dog bird” will find exclude any records that have “cat”. This is a useful operation if a result set contains many hits on a term that is of no interest.
- Grouping: When using multiple search methods, it is advised to explicitly define the order of operations with parenthesis. AgileXPLORER does follow a rigid order of operations when evaluating a search. However, it is much clearer to define the order. Simply group terms with matching parenthesis: “cat and (bird or dog)”
- NOT (!): To explicitly exclude a result the word “NOT” or the symbol “!” may be placed in front of the term.
- Fuzzy (~): This allow AgileXPLORER to find common typographical errors/misspellings. Just place the “~” (Tilde) AFTER the search term of interest, and AgileXPLORER will attempt to find close spellings.
- Wildcards(*)(?): Using a “*” will match multiple characters. However, “?” will match one character for each “?”.
- Range Searches: Range Queries allow you to match documents whose field(s) values are between the lower and upper bound specified by the Range Query. Range Queries can be inclusive or exclusive of the upper and lower bounds. Sorting is done lexicographically. “mod_date:[20020101 TO 20030101]
- Fields: AgileXPLORER structures much more than a simple free-text index. Internally, every entry is broken down into fields with specific meaning. For example, AgileXPLORER will extract the voltage rating from a free-text string and place it into an appropriately named database field. To specify a field, use the form “field_name:<value>” the part up to the colon is the field name
If you need further direction for free-text searches, click here.
You didn't find what you were looking for? Visit support.perceptionsoftware.com and open a support ticket. One of our highly trained support team members will assist you.