25 Data Search

Nucleon BI Studio provides you two data search modules: Advanced Data Search and Full-Text data search engine.

25.1 Advanced Data Search

The Search Engine feature is implemented to search data in the database with advanced data search options. It allows the user to search data without using any SQL query which makes searching more easily and rich. The searches results are presented in a data view and can be exported to supported file formats.

When you create a definition 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

25.2 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.

25.2.1 Query Fields and Values

When you specify a value for a field, the value must conform to the data type of that field.

25.2.2 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.

25.2.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.

25.2.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)

25.2.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.

25.3 Full-Text Data Search

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

25.3.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.