Go to documentation repository
Documentation for Auto Intellect 5.6. Documentation for other versions of Intellect is available too.
Previous page Next page
Plates auto search in the External DB is performed by one of the following methods.
Search method | Method description | Search results displaying |
|---|---|---|
Register | The same sequence of characters in the column with vehicle plates must correspond to a sequence of characters, corresponding to the identified vehicle plate. | In the window Vehicle Tracer there are displayed table's columns, containing vehicle plates |
Partial search | At least one sequence of characters, that is partially or in full present in the plate in the external BD must correspond to identified vehicle plate. | |
Wildcard search | At least one of the plates, stored at external DB, must correspond to identified vehicle plate. Wildcards are recorded to the external BD preliminary together with vehicle plates. Wildcards in the DB are recorded according to Transact-SQL rules. Wildcards may contain usual characters and wildcards ( | |
SQL-query | SQL-query is designed for extracting the required data from the table, containing plate's numbers and also from bound tables. SQL-query is used for more flexible setting up the Auto-Intellect PC (example of such SQL-query is given in 7.6.6 part of the manual, Fig. 7.6—13) | In the window Vehicle Tracer there are displayed table's columns of the external DB, stated in the SQL-query |
Wildcards Transact_SQL are presented in the following table.
Wildcard | Wildcard description | Example of search results |
|---|---|---|
% | Any string containing 0 and above characters in length | Plates, containing elements 'а', '385' and '78', divided by any number of characters, for example 'АО38578', 'а385мк78' correspond to the wildcard 'а%385%78' |
_ (underlining) | Any single character | Plates, containing a sequence of 4 characters , the first of which is '2' and the last is '5' correspond to the wildcard '2__5', for example 'А256577', '2115ОК43' |
[] | Any single character , containing ([а-е]) in the range or ([абвгде]) in the set | Plates, containing a sequence of 4 characters correspond to the wildcard '[е-м][2-5]53' . The sequence ends in '53',the first character belongs to the range е-м, the second one belongs to the range 2-5, for example 'к453мн02', 'м253вт63' |
[^] | Any single character , that is not contained in the range ([^а-е]) or in the set ([^абвгде]) | Plates, containing a sequence of 4 characters correspond to the wildcard '[^е-м]499'. The sequence ends in '499', the first character does not belong to the range е-м, for example 'в499вк57', 'н499578' |
Note.
You can add numbers' templates through Active tracking database (see Creating the Active tracking database), or through DB editor (see official reference manual on required editor).
To select the search method of the identified plates in the external DB, do the following:
- Go to the External Plates DB object settings panel (2).
- Select the required search method of the identified plates in the external DB from the list Search method (1).
- Click Apply (2).
Selecting the search method of the identified plates in the external DB is completed.
Overview
Content Tools