The search engine feature is implemented to search data in the database. It allows the user to search data without using any SQL query which makes searching more comfortable. The searches results are presented in a data view and can be exported to supported file formats.
When you create a query to search, you can define one or more clauses that will look for what you want to find. For each clause, you can specify a field, an operator, and a value or variable. For example, you can search for all column data in a particular table by specifying the table column.
A sample search clause:
|
And/Or |
Field |
Operator |
Value |
|
City |
Equals |
Afyon |
|
|
And |
Code |
= |
03500 |
|
OR |
MyDate |
DateTimeEqual |
01.01.2010 |
You can use this column to specify how clauses are tested. You can specify “AND” if you want to find work items that meet the criteria in both this clause and the previous one. You can specify “OR” if you want to find work items that meet the criteria in either this clause or the previous one.
When you specify a value for a field, the value must conform to the data type of that field.
Data Search Operators
You can use search operators in following operator table to specify how each value in a clause must relate to the corresponding value in the table column.
The search engine provides the following text (string) operators:
|
Operator |
Description |
|
Equals |
Compares whether the specified text matches the string in the database. |
|
NotEquals |
Compares whether the specified text does not matches the string in the database. |
|
EqualsIgnoreCase |
Case In-Sensitive: Compares whether the specified text matches the row data and ignores case. |
|
EqualsMatchCase |
Case Sensitive: Compares whether the specified text matches the row data match the case. |
|
EndsWith |
Determines whether the end of this string instance matches the specified string. |
|
StartsWith |
Compares whether the beginning of string instance matches the specified string. |
|
Contains |
Returns a value indicating whether the specified text object occurs within this string. |
|
IndexOfAny |
Searches the index of the first occurrence in this instance of any Character in a specified array of Unicode characters. This method performs an ordinal (culture-insensitive) search, where a character is Considered equivalent to another character only if their Unicode scalar values are the same. |
|
Fuzzy Search |
Search with fuzzy (approximate) matching. The matching score is 50%. |
|
Regular Expression |
Searches with regular expression. |
The search engine provides the following number operators:
|
Operator |
Description |
|
= |
Equals (Matches the value in the database) |
|
< |
Smaller (Is less than the value in the database) |
|
> |
Bigger (Is bigger than the value in the database) |
|
>= |
Equals or Bigger (Is bigger than or equal to the value in the database) |
|
<= |
Equals or Smaller (Is less than or equal to the value in the database) |
|
<> |
Not Equals (Does not match the value in the database) |
The search engine provides the following date and time search operators:
|
Operator |
Description |
|
DateTimeEqual |
Compares whether the specified date time matches the date time. |
|
DateTimeEarlier |
Compares whether the specified date time earlier than the date time in the database. |
|
DateTimeLater |
Compares whether the specified date time later than the date time in the database |
|
DateTimeNotEqual |
Compares whether the specified date time is not equal to the date time in the database. |
Full-Text search allows you to search your text (words, sentences, numbers etc.) in your database tables.
Fuzzy searching will find a word even if it is misspelled. For example, a fuzzy search for apple will find appple. Fuzzy searching can be useful when you are searching text that may contain typographical errors (such as emails), or for text that has been scanned using optical character recognition (OCR). There are two ways to add fuzziness to your searches:
1. Check Fuzzy searching in the search dialog box to enable fuzzy searching for all of the words in your search request. You can adjust the level of fuzziness from 1 to 10. (Usually values from 2 to 5 are best for moderate levels of error tolerance.)
2. Add
fuzziness selectively using the % character. The number
of % characters you add determines the number of differences search
engine will ignore when searching for a word. The
position of the % characters determines how many letters at the
start of the word have to match exactly. Examples:
ba%nana: Word must begin with ba and have at most one difference between
it and banana.
b%%anana: Word must begin with b and have at most two
differences between it and banana.