EULANDA® ERP System Head Start thru Technology
Home Information PDF Documents EULANDA Handbooks Training Book's corner Download Contact us Table of Contents About us
Password needed Newsgroup
Properties Tree
General
Properties are additional sort criteria which you can add to your data. They can be nested without any limit and you can attach these properties in any variety to any quantity of data records - confused, let us explain in more detail.
The sum of all nested properties are called the properties tree, since the nesting is similar to the structure of a tree.
Service and assign properties
Besides the already introduced possibilities of the various search
criteria EULANDA® ERP offers additional multi level sort criteria using a
hierarchical properties pool. Every record can have multiple properties
attached. To better structure these properties, they can be nested.
The original data record - for example an address exists only once, but can
point to various of these properties.
Properties replace the former selection notes from the older product EURO
and are a much, much more powerful tool to additionally sort data. These
properties are supported by all tables, as far as possible, e.g. in
articles, addresses, letters, picture databases etc.
Show properties tree
To show the properties tree click on the module title e.g. Addresses.
This section is called the action path.
Click on the pin sign to stick the windows as additional field as shown
above.
"Glue" the tree on to the left side of your screen
The properties tree can have any number of criteria and levels nested. Assign as many properties to one data recorded as is needed. An address for example can be assigned to properties like "Wholesaler", "Merchant", "Purveyor", "Client", "Press" and much on top be assigned to a country schema. and a field of interest.
Pre-select property
To show data from a property, check the property and hit ENTER. In the
action path, the selected property is shown.
Properties are the primary search criteria and all other criteria are
subordinated. Properties are some sort of filter. When paging thru your
data, attached properties are shown in bold letters.
Assign Properties
To assign properties to data records, select the data record and press ENTER. While in edit mode, mark the desired property (properties) and then safe the record with CTRL+ENTER.
Right mouse menu of the properties
Add new properties using the right mouse menu.
Add a description to your property
Add remarks to you properties. This will simplify the identification of the individual properties in large trees. This is an optional feature and is not mandatory but recommended. In the next dialog box 3 different selections are possible.
Schema options dialog a property
Folder
Comparable to file folders. Used to create new tree structures. In these folders, the real properties reside.
Properties catalogue
This is the real place where the properties are saved. When a data record is edit mode, a checkbox left to the property name becomes visible. Check or uncheck this box and save the record with CTRL+ENTER.
Another very useful feature are the SQL properties which allow automate the process of assigning data records to properties. These are called dynamic properties. Their program name is SQL Query.
SQL - Query
This category of properties is by far the most flexible and when used wisely the most effective. We call them dynamical properties, since the result set may vary without changing the actual data. In reality, this property is a SQL based query which does not need to be limited to one table only, but can access information, stored in any table in the database, thus reflecting highly complex interrelation. All data found thru the query can be handled the very same way as it were with a static property.
This option is meant specially for Solution-Partner, who want to customize the database according to their client's specification. The property can be used by all of you, having sufficient knowledge of T-SQL. This section will not discuss the query language T-SQL but rather describe the functionality of this option.
The possibility to store an SQL query - more specifically the WHERE clause of such a query - allows to set filters, which could not be created, by using the normal static property. A SQL query can simultaneously access any number fields and connected tables.
A SQL property can for example filter all addresses where a certain term is found in the notes field and with a specific revenue.
This property has a question mark as icon attached to its name, instead of a folder and can be selected. like any other property.
The real advantage of these properties is the fact, that they are self-contained. Normal properties have to be attached manually with every new data record, where that filter is supposed to be applied. SQL properties always return actual data, specially when complex query are needed frequently.
Create SQL properties
This is a small example as to how to build an valid condition. This example is meant for all, who have knowledge in writing T-SQL statements. We will need only the WHERE clause - the filtering part - of the statement. No sorting, no grouping, etc. since EULANDA® ERP adds the rest of the command internally and automatically. The base table is always referred as THIS. The internal alias allows connecting to other tables in the database.
(FibuKonto>=10000) AND (FibuKonto<70000) and ( (fax="''" or fax is null) and (email="''" or email is null) )< />
The example selects all addresses having assigned an account number between 10000 and 69999 and not having a fax number nor an Email address. Aside an empty text the clauses as well checks for NULL values. SQL NULL represents an empty field opposed to zero and a string containing blanks.
Show properties in bold letters
This option will show the property in bold letters, when the record matches the condition. Only activate this option with small queries, since at the time of the query sends parallel request to the server and many queries may slow down the server.
Replaces other search criteria
This option disables the search criteria entered in any of the fields. This is specially useful to show information like "show the last altered record" etc.
Set Syntax highlights
This represents the way the SQL Query analyzer show the syntax (Syntax Highlight). Commands, notes ,remarks etc are colored, thus allowing a quick overview of the code. Additionally line number will show to the left of each line, allowing in case of errors to debug the code much quicker.
Change the options of the properties
Via the right mouse menu you can call the settings dialog of the respective property.
Applying TAG's
A TAG is an option for every static property. It allows to assign the same property very quickly to many records. Remember, only one property at the time may be declared as TAG property.
Mark TAG
Using CTRL+T allows to assign a property to a record while paging the data, without the need of entering the edit mode.
In case you have to assign more than one property to your data, enter the edit mode of the record, check the properties as required and save the record.
The TAG property is marked with a red "T" to the left of its symbol.
UNTAG
CTRL+U removes the record from the corresponding property.
Assign the entire result set to a TAG property.
Using SHIFT+CTRL+T assigns the entire result set to the property. It does not matter on how you selected the data, using a combined search, other properties or a combination of all. The current result set will be assigned to the property.
UNTAG the entire result set
Using SHIFT+CTRL+U removes all found data from a property.
To delete the property from your data, left click on the property and hit the ENTER key. All corresponding data will be listed. Press SHIFT+CTRL+U and all records will be removed from this property.