Home Information PDF Documents EULANDA Handbooks Training Book's corner Download Contact us Table of Contents About us

Glossary

Password needed Newsgroup

Remote Support system

Data Selection

Back | Level back

 

Based on properties you can create data selections to use in mail merge etc. You can combine various properties using logical operators like AND, OR or NOT. The resulting query enhances the flexibility of the program.
The word processor and the interfaces from Outlook and Excel do use this kind of data selection.

 

Data selection

All properties defined are shown in the selection box. As soon as one property is selected, and is shown in one of the areas (AND, OR, NOT) EULANDAŽ ERP calculates the number of records corresponding to the query. The number of records are shown in the upper right corner.


For example addresses can be provided for mail merge using the Selection box.

 

Areas

Properties can be combined using logical operators.

AND  This area holds all properties which have to be found at the same time. As more you add, the less data will be returned. AND therefore means every item listed in the area has to present in the data.
OR  This area holds the properties which can occur but not need to. A record therefore must contain at least one of the mentioned properties. In case you entered a property in the before mentioned area, those conditions have a higher priority and must occur before the properties from this area will be searched for.
NOT All listed properties in this area must NOT be found in a data record. This can be used to exclude - black list - data.

 

Sorting

A result set can be sorted in 3 levels. Avoid sorting to obtain the data quicker from the server. Sorting is supported only with mail merge.

 

Sorting the result set.

The sorting can ascending or descending separately for each level.

 

SQL

EULANDAŽ ERP creates a T-SQL query from the inputs of the prior dialogue. Under certain circumstances it will be wiser to create a more complex query, thus limiting the number of found data records.

 

Resulting SQL query

You may modify and / or add your own conditions to the existing WHERE clause.
To control the amount of data found, click on the button "Count Hits".

A combination of properties using AND, OR and NOT, can become very complex. If you plan to use this selection more often, simply copy the SQL WHERE clause and add an SQL property in the address's property tree. For cut and past, use the standard Windows short cuts.