Documentation for Auto Intellect 5.6. Documentation for other versions of Intellect is available too.

Previous page Assigning names to table's columns containing vehicle plates  Setting up the number of search results to be displayed Next page


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

Search method

Method description

Search results displaying

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.

The Vehicle Tracer 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 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 (see Setting up SQL-query for plates search in the external database).

The Vehicle Tracer window displays the columns of the external database tables specified in the SQL 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 with a length of zero or more characters

Plates, containing elements 'A', '385' and '78', divided by any number of characters, for example 'AO38578', 'A385MK78' correspond to the wildcard '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', '2115OK43'

[]

Any single character contained in a range ([A-E]) or set ([ABCDE])

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 'K453MH02', 'm253BT63'

[^]

Any single character not contained in a range ([^A-E]) or 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 'B499BK57', 'H499578'

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:

  1. Go to the External Plates DB object settings panel (2).
  2. Select the required search method of the identified plates in the external DB from the list Search method (1).
  3. Click Apply (2).

Selecting the search method of the identified plates in the external DB is completed.

  • No labels