Categories
Uncategorized

Maintenance MySQL – Asset Report Android: asset_report_damaged

CREATE VIEW asset_report_damaged AS
SELECT
a.ar_id,
a.ar_barcode,
x.al_description,
x.al_asset_group,
x.al_priloc,
x.al_secloc,
x.al_terloc,
a.ar_scandt,
a.ar_itemstatus,
a.ar_actiontaken,
a.ar_actionleft,
a.ar_datedue,
a.ar_userid,
a.ar_ts
FROM asset_report_last a
LEFT JOIN asset_list x
ON a.ar_barcode=x.al_barcode
WHERE a.ar_itemstatus NOT LIKE “%1%”;