Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Plates auto search in the External DB is performed by one of the following methods.

Search method

Method description

Search results displaying

Register

Exact match

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

The Vehicle Tracer

there are displayed table's columns, containing vehicle plates

window displays all table columns containing the vehicle numbers



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 (
Table 7.6—2) in

wildcards in the required combination.

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

The Vehicle Tracer

there are displayed table's

window displays the columns of the external

DB, stated

database tables specified in the SQL

-query

query

With acceptable number of errors

The recognized number must correspond to at least one sequence of characters that is partially or completely contained in the number in the external plate database. You can select the maximum number of errors (mismatches of characters) in the number.

Note. The more errors are accepted, the more the search system is loaded.

The Vehicle Tracer window displays all table columns containing the vehicle numbers

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

with a length of zero or more characters

Plates, containing elements '

а

A', '385' and '78', divided by any number of characters, for example '

АО

AO38578', '

а385мк

A385MK78' correspond to the wildcard '

а%385%78

A%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 '

А

A256577', '2115

ОК43

OK43'

[]

Any single character

, containing

contained in a range ([

а

A-

е

E])

in the range

or set ([

абвгде

ABCDE])

in the set

Plates, containing a sequence of 4 characters correspond to the wildcard '[

е

E-

м

M][2-5]53' . The sequence ends in '53',the first character belongs to the range

е

E-

м

M, the second one belongs to the range 2-5, for example '

к453мн02

K453MH02', '

м253вт63

m253BT63'

[^]

Any single character

, that is

not contained in

the

a range ([

^A-

е

E]) or

in the

set ([

^абвгде

^ABCDE])

Plates, containing a sequence of 4 characters correspond to the wildcard '[

^E-

м

M]499'. The sequence ends in '499', the first character does not belong to the range

е

E-

м

M, for example '

в499вк57

B499BK57', '

н499

H499578'


Info
titleNote.

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).

...