Text Search
You can search for the records in a Collection that contain specific keywords by using text searching. Text search is not case sensitive. To perform a text search follow these steps:
- Click on the text search textbox located just below the Action buttons.
- Enter the keyword or phrase you wish to search for.
- Hit the Enter key on your keyboard, to perform your search. Any records found should appear in the Search Results view. If no records match your search criteria, the Search Results view will display zero records.
To clear the text search textbox, click on the X inside the textbox.
In addition to searching for terms, the text search also supports the advanced search features listed in the table below:
| Expression | Description | Example |
| "" | Quotations can be used to group words together for a search. | "North Pole" will find all the records with the string North Pole. (Where searching for North Pole will result in all the records with North and all the records with Pole) |
| : | Used to specify the name of a field to search. | Name:Bob will find all of the records with Bob in the Name field of the form. (The field name is case sensitive). |
| ? | Used to represent any character. | d?g will return dog, dig, dug, etc. (You can't start a search with ?). |
| * | Used to represent zero or more of any characters. | jump* will return jump, jumping, jumped, etc. (You can't start a search with *). |
| ~ | Used to match records that are closed to the word but not exact. (You can specify a number between 0 and 1 to determine how close the match will be, 1 being the strictest). | cow~ will return cow, cows, crow and other similar words. |
| [x TO y] | Used to find all of the records that fall between x and y, including x and y. (This can be used for numbers or letters). | Number:[1 TO 5] will return all of the records that contain a digit between 1 and 5 in the field called Number. (ex: 1, 2, 3, 4, 5, 19 and 27). Be sure to capitalize TO or the search will not work. |
| {x TO y} | Used to find all of the records that fall between x and y, excluding x and y. (This can be used for numbers or letters). | Number:{1 TO 5} will return all of the records that contain a digit between 1 and 5 in the field called Number, but does not count the two limits. (ex: 2, 3, 4, 29 and 38). Be sure to capitalize TO or the search will not work. |
| AND | Used to specify multiple words as criteria. | Dog AND Cat will return all records that have both Dog and Cat in them. These two values do not have to appear in the same field of the record. Be sure to capitalize AND or the search will not work. |
| OR | Used to specify more than one separate search criteria. (This works the same as if you entered two words separated by a space). | Dog OR Cat will return all records that have either Dog or Cat in them. Be sure to capitalize AND or the search will not work. |
| NOT | Used to specify records that do not contain a specific word. The NOT expression must be combined with another word. | This NOT That will return all of the records that have the word This in them but do not contain the word That. |
| ( ) | Parentheses are used to group search criteria together. | (Dog OR Cat) AND Pet will return all records with either the word Dog or Cat as long as that record also contains the word Pet. |
For more information about the Query Parser syntax which is used for text search, please see the Apache Lucene website.