
The percent sign (%) is the character used for fuzzy searches. Fuzzy searching may be useful when querying documents that contain misspelled terms, typographical errors, or have been scanned with Optical Character Recognition (OCR). Fuzzy Searching: Using the dtSearch engine, you can perform fuzzy searches, which return documents containing spelling variations of a specified term. Note: The operator "Not" can be used in conjunction with all dtSearch proximity searches.
Apple w/5 xlastword - Returns documents where "Apple" appears in the last 5 words of a document. Apple w/5 xfirstword - Returns documents where "Apple" appears in the first 5 words of a document. Apple pre/5 Pear - Returns documents where "Apple" appears first, within 5 words of "Pear".
Apple not w/5 Pear - Returns documents where the word "Apple" appears, but not within 5 words of "Pear".*. Apple w/5 Pear - Returns documents where the word "Apple" appears within 5 words of "Pear". Here are some examples of proximity search syntax: Another example is if you're looking for the title of a report which occurs only at the top of the document. Proximity Searching: You can use the terms xfirstword or xlastword to limit a search to the beginning or end of a file, respectively. Using them by themselves will produce a syntax error. Note: When filtering for dates, ensure that you're using the greater than or less than sign along with an equal sign. % (to filter for NOT null) Note: While filtering on multiple columns, each filter is treated as an AND operator. You can enter multiple terms connected by any of the following operators: Textbox: Used to search on specific terms, numbers, and dates. Popup Pickers: Contains values for multiple or single choice fields, as well as multiple or single choice objects.
You can connect the conditions with the OR or AND operator. MultiList: Uses multiple conditions from a drop-down menu.
Conditions vary by the type and purpose of the field associated with it. List: Usually associated with fields used for coding documents. CustomOnly: Uses filtering criteria from advanced and Boolean operators. Conditions display a drop-down list similar to list filters. Boolean: Available for Yes/No field types.