To obtain meta data from VIT LPR database, use the following functions: itv_plate_attr_get_ex() and itv_plate_attr_get().

itv_plate_attr_get_ex()

This function searches records by the specified time range. It does not change the exported records. 

Syntax

SELECT * FROM dbo.itv_plate_attr_get_ex (
@plate NVARCHAR(16),
@from_ts DATETIME,
@to_ts DATETIME,
@image nvarchar(8)
);

Input arguments

Returned data

Example

To get images (binary data), use their IDs in the following query:

SELECT [dbo].[bo_get_node_data] (@uid NVARCHAR(450));

itv_plate_attr_get()

In the database, this function marks selected LPR records as already exported and does not return them again. The function can not be used when having multiple export clients. 

Syntax

SELECT * FROM dbo.itv_plate_attr_get(
@plate NVARCHAR(16),
@image nvarchar(8)
);

Input arguments

Returned data

UPDATE dbo.PLATE_NUMBERS SET sent_st = 1 WHERE GUID = '{LPR_event_GUID}'