General points on searches

Previous  Top  Next

In a data base, one of the most important functions is the search.

Prospect Tracking offers you 4 search types that have common characteristics.

·

Quick search,

·

Multi criteria search,

·

Calculated search.

Carry out a search
A search always carries, by default, all the records of the current table.
If you wish to do a search uniquely based on the current selection, put together beforehand, activate the 'search in the selection', found in each of the search dialogues.
To systematically activate this option by default refer to user settings of Prospect Tracking.

Search characteristics
The search engine proceeds automatically to the conversion of alphanumeric and capital letter strings.

This principle shows two aspects that are important to know:

·	There is no difference between a word entered in capital or small letters in the dialogue search,

·	The search engine makes no distinction between a letter with different accents.

Replacement letter
When you are searching in alphanumeric or text fields, you can use the sign @ (at sign) as a letter joker.

If you enter the first letters followed by @ for example Du@, you will obtain all the hits beginning with Du.

You can place the joker wherever you wish. So, depending where you place the @ you will obtain :

Du@	- all the hits in the targeted field like Dupond, DUPONT, Dupuy, Durand…….,

Du@t	- finds names starting with Du and ending in T, Dupont, Durancet …..

@t	- finds all the names ending in t,eg : Atiget, Ballet, Establishment , Dupont….,

@Dup@

- finds all the names containing dup and where to find this string, eg :

Bart & Dupont, Dupuy and son, Lerdup, …

Comparison arguments

·	Is equal to   =

Search strictly for a value equal to the given value.

·	Is different to   #

Search strictly for a value different to the given value.

·	Is superior to   >

Search strictly for a value superior to the given value.

·	Is superior or equal to   >=

Search strictly for a value superior or equal to the given value.

·	Is inferior to   <

Search strictly for a value inferior to the given value.

·	Is inferior or equal to   <=

Search strictly for a value inferior or equal to the given value.

·	Contains   ><

Search in the character strings whatever the position is in the object field of the search. This comparison argument is only available in the 'Alphanumeric' and 'text' fields.

Note : The expressions below are equivalent :

Company name contains DUPONT.

Company name is equal to @DUPONT@

·	Does not contain    <>

Search in the character strings whatever the position is in the object field of the search. All records containing this string will be excluded from the search result.

This comparison argument is only available in the 'Alphanumeric' and 'text' fields.

Note : The expressions below are equivalent:

Company name not containing DUPONT.

Company name is different to @DUPONT@