Grass Valley K2 TX/MAM User Manual v.2.2 - Manual (Page 28)

TX/MAM User Manual - document version: 2.2 – Page 28
The example below shows the configuration of status Browse created. This status is linked to job
Browse copy. Possible values for this status are Ok, Failed and New.
The status Asset ingested? uses a procedure STATUS_ASSET_INGESTED to retrieve information
about Asset file’s status (Empty, OK or Failed). Procedures can be used to retrieve Asset status
information from the TX/MAM database.
RECREATE PROCEDURE STATUS_ASSET_INGESTED (
ID Integer
)
RETURNS (
CODE Integer,STATUSINT Integer
)
AS
BEGIN
FOR SELECT STATUS_INT FROM ASSET_ELEMENT WHERE ID = :ID INTO :STATUSINT
DO
BEGIN
IF ((STATUSINT = 3) OR (STATUSINT = 0)) THEN
CODE = 1;
ELSE IF ((STATUSINT = 1) OR (STATUSINT = 100)) THEN
CODE = 2;
ELSE
CODE = 3;
END
END
Note how the codes refer to the TX values: code 1=empty, 2=Ok and 3=failed.