Text, Numeric and Date Fields
- A blank entry signifies all characters.
- Example: Leaving the ID field blank refers to all objects
- Ranges refer to characters according to alphabetical order.
Example:
>document
refers to characters that follow the word document in alphabetical order.- If there is more than one condition in a field, enter the text strings in quotation marks.
Example:
>"d"&<"m"
means that the string must begin with a letter that comes after the letterd
and before the letterm
in the alphabet.- An asterisk * signifies that the word must begin with the letter shown before the asterisk and end with the letter shown after the asterisk.
Example:
"A*F"
means that the word must begin with letter A and end with letter F.Note: The wildcard * can only be used in a Text field.
- A question mark ? signifies a single character in a word.
Example: "A?F" means that the word must begin with letter A and end with letter F in the alphabet with only one letter in between.
- A backslash \ turns a wildcard into a real character.
Example: "C\?D" means that the text must contain the characters c?d
- You can only enter = (equal to) or <> (not equal to) before an asterisk * or a question mark ?
- You can enter more than one value within a field to specify a range of values that will be included in a search result.
Example: In the ID field, you can specify a range of 22..45 to search for all ID numbers between 22 and 45, or you can enter >10&<=18 to search for all ID numbers that are greater than 10 and less than or equal to 18.
Note: When entering information in two or more fields, the search locates only those documents that satisfy both or all requirements.
Note: For date fields, the rules mentioned here are applicable for all searches (New Search, Advanced Search and Quick Search). By using the date picker, you can select a single date. The result of the date picker selection will replace the entire expression that was entered in the Date field.
The following table summarizes the SmarTeam - Web Editor search attributes in different types of files:
Blank = all entries