This page shows the prefixed column's that will be searched.
Search
The search vlaue is changed to during the search to support a more natural (google) search
- Text is converted to UPPER case
- All Diacritics like é,ö etc.. are replaced with the normal character e.g. Ê > E
- Duplicate spaces, tabs, newlines are removed
- All characters not in 0-9 A-Z are removed
- Words are split on spaces, the search is performed on ALL word
The search words are matched against the columns defined below
Contact
The following columns are used for the search
| Columns |
|---|
| firstname |
| lastname |
| shortname |
| company_name |
postalcode |
address |
| city |
Related data contact_communication
| Columns |
|---|
| communication_value |
Related data vehicle_role_line to vehicle
| Column |
|---|
| license_plate |
Vehicle
The following columns are used for the search
| Columns |
|---|
| license_plate |
model |
| brand |
| chassis_number |
| vehicle_version |
Related vehicle_role_line to contact
| Columns |
|---|
| firstname |
| lastname |
| shortname |
| company_name |
Orders
The following columns are used for the search
| Columns |
|---|
| order_number |
| description |
Related data order to contact
| Columns |
|---|
| firstname |
| lastname |
| shortname |
| company_name |
Related data contact_communication
| Columns |
|---|
| communication_value |
Gerelateerde artikelen