17         Data Search Engine

17.1Advanced Search

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

 

17.1.1    And / Or Operators

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.

17.1.2    Query Fields and Values

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.

17.1.3    Text (String) Operators

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.

 

17.1.4    Mathematical Operators

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)

 

17.1.5    Date and Time Operators

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.

 

17.2Full-Text Search

Full-Text search allows you to search your text (words, sentences, numbers etc.) in your database tables.

 

17.2.1    Fuzzy Searching

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.

 


powered by Nucleon Software