Searching Methods

Back | Level back

Searching

As more and more data is accumulated in the database, the necessity of finding the data is getting more important. EULANDA® ERP not only gives you the possibility to combine field using a logical AND or OR, but provides a way on how to find data.

Field search - Search in the entry screen

EULANDA® ERP allows to search any field directly from the entry mask. No specialized Search Screen with a limited selection of data fields is used, but the normal data entry screen.

Just enter the search text into any field and press Enter. EULANDA® ERP returns immediately the result and shows the amount of hits in the status bar. Furthermore the data will be ordered according to the field on which the focus lays, e.g. in case you searched for the gross sales price, the result will be shown in ascending order.

By default all fields have a useful standard search mode pre-assigned. For example in the fields Match-code and Article number the entered text will be searched from the beginning. In the name fields of the address the search text can be in the middle of the field. You can deactivate the pre-assigned search mode at any time by using one of the following special signs:

You can use different search methods - Wildcards, which refers to an assigned field, a full text search applying to all fields, an area search, a search for a term at the beginning or end of the field and many other methods.

*	Can be placed at any position. The Wildcard replaces many or none sign. It can be placed at any position in the text, e.g.: DOE* - > finds "DOE", "DOE JOHN", "DOE SMITH", "DOE Q JOHN" DOE -> finds "JOHN DOE", "DOE", "JOHN Q DOE" JDOE** -> finds "JOHN DOE", "JOHN Q DOE" JDOE -> finds additionally "JOHN DOE JR"
?	Can be placed at any position. This Wildcard replaces exactly one sign at precisely that position thru any other sign. It can be placed at any position, e.g.: M?IER -> finds MEIER, as well as MAIER. M??ER - finds MEIER, MAYER, and also MAUER
°	Has to be placed at the beginning. Area Search: Returns data rows before and after the the actual hit. Applies to sortable fields only (e.g. number fields or identifiers). Assuming you have pre assigned 100 hits as total result, you'll receive 50 rows before and 50 rows after the exact match. In case the exact match was found at the very beginning or ending of the table, it can happen that the amount of rows shown before or after the exact match may vary, e.g.: °1000 [Field Invoice no.] -> ideal case - and no vacancies - all numbers between 951 and 1050 are shown. °E [Field Matchcode] -> rows found, beginning with E , but additionally the last, beginning with D EULANDA shows - if exists - the row containing the searched value, e.g. the invoice no. 1000 or match code E. Using the arrow keys left and right, you can page fore- and backward in the result set.
##	Has to be placed at the beginning. Special Search: Your Solution Partner can establish a special search containing any valid T-SQL queries.
**	Has to be placed at the beginning. Full Text Search on all fields: The searched text can be at any position within the field and it does not matter from which field the search is initiated.
=	Has to be placed at the beginning.: Exact Search: The text to be found has to match exactly, e.g.: =D -> [Field Country] finds only Germany (=D), but not Denmark (=DK)
>	Has to be placed at the beginning.: The value sought-after has to be greater as the value entered. >100 -> finds "100,12", "105,03". "20021,00" etc. >0 -> [Field Stock in Articles] finds Articles, which currently have stock
>=	Has to be placed at the beginning.: The value sought-after has to be greater or equal as the value entered. >=100 -> finds "100,00" , "100,12", "105,03". "20021,00" etc.
<	Has to be placed at the beginning: The value sought-after has to be less as the value entered. <0 -> [Revenue-field invoice] finds only invoices with a loss (negative revenue)
<=	Has to be placed at the beginning: The value sought-after has to be less or equal as the value entered. <=0 -> [Revenue-field invoice] finds only invoices with a loss (negative revenue), and those with no revenue (Null).

*text*	Wildcards. The text can be at any position in the field.
*text	The sought-after text represents the end of the string, e.g. search all roads ending with "Lane". Entry for this search would be *Lane.
text*	The sought-after text has to represent the beginning of the string.
**text	Full Text Search over all fields. It does not matter whether the sought-after text is at the beginning, the end or on some other position within the string. All fields are examined, even the long text fields.
°text	The Area Search allows finding data near the sought-after search string. Returned result rows represent data before and after the search text. In case an exact match is found, it will show first, otherwise the next nearest. The result set can be paged using the arrow keys left and right. The Area Search only applies to integer numbers. By default this search mode is used when searching offer, order or invoice numbers and the like.
=text	Search in ambiguous fields: string found matches exactly the search text entered, e.g. Search ZIP codes for 65510. Returns all rows with ZIP Codes 65510. This mode can used as well when searching for empty fields. An equal sign alone will not find any results when the SQL value is NULL.
_	The underscore means the field has to hold data. Unlike " * " the underscore does not return empty fields e.g.: Find all addresses which do have a mobile phone number. Enter the underscore in the field "Mobil". Result returned are addresses which have a mobile phone number.
??text	This search mode is suitable for special cases. Using the question mark, you can define fixed placeholders where any sign can be found. Unlike the asterisk, where the number of signed is not defined, the question marks represent the specific position of the sign to be searched. Not suitable in long text fields.

All search options can be combined over various fields. In this case you have to select the logical AND or OR in the status bar - field zone in the lower left hand corner of the screen.

Not all methods can be used with all data types, e.g. Area Search does not work in date fields.

Search in number fields with colon (point)

If you are searching for decimals, use the point instead of the colon. That is the English equivalent of the colon, which is needed for the SQL Server. Example:

1100.12 -> finds 1100 Euro and 12 Cent
>100.50 -> finds values bigger then 100,5

Search in date fields

in date fields

dd.mm.yyyy or dd.mm.yy	Searches dates of a fixed date irrespective of the time. The entry format respects Window's national settings. The example below represents the German date: 31.01.2005 or 31.01.05 -> finds the 31. January 2005 (German schema)
dd.mm.	Short form. The date will be completed internally with the current year. Example: 14.05. -> finds the 14. May of the current year (German schema)
mmyyyy	Finds the complete month. Example: 051998 -> Finds May of year 1998
"CW"cw Version 2.7 or newer	Searches the calendar week of the current year. The letters CW have to be prepended and followed by one or two digits. Example: CW05 -> finds dates of the 5. calendar week of the current year
"CW"cwyyy oder "CW"cwyy Version 2.7 or newer	Optional you can add the year. Example: CW252006 -> finds the 25. calendar week of the year 2006 CW0904 -> finds the 9. calendar week of the year 2004
. .. ... Version 2.7 or newer	today yesterday day before yesterday
+ ++ +++ Version 2.7 or newer	Tomorrow The day after tomorrow 2 days after tomorrow
other entries	All other entries will return in unpredictable results since the searched for value are to interpreted from the SQL Server.

Search option - combined search

Field search or logical search

Here you define whether the search should be executed in the current field or in an combination of fields connected with either AND or OR. When the screen is in search mode and you hit Enter key after inputting text in a field, the search will start for that field containing the search text.
In some cases it might be necessary to combine fields. Click into the field zone an select either AND or OR. With AND the query takes all fields which ar not empty to build the query and returns only rows where all these values are present, else using OR the query returns rows with either one or another value thus presenting more data using or.

Example : Module Invoices and activated AND-search

DOE [field Matchcode]
KW12 [field Date]

It will return rows from the client Doe from the calendar week 12. Additionally returned rows for match codes "DOE SMITH", "DOE JOHN" etc. In this case it would be better to use the exact search if the match code is known exactly.

=DOE JOHN [field Matchcode]
KW12 [field Date]

Returned row is Doe John

Example: Module Addresses with activated OR-search

JOHN [field Name 1]
JOHN [field Name 2]
JOHN [field Name 3]

Returned rows with search string in either field Name1, Name2 or Name3

Specialization: SQL powered multi language ERP Software

Email | Permissions and trademarks | Privacy statement | About us

The sales of the offred products and services is only possible to business companies.