NoPublic, bureaucrat, administrator
6,632
edits
Changes
no edit summary
UPDATE fieldreport
Inner Join imsmaenum AS workbench_status ON (workbench_status.imsmaenum_guid = fieldreport.workbenchstatusenum_guid)
SETfieldreport.reportverifieddate = reportreceiveddate,
fieldreport.verifiedby = fieldreport.dataenterer
WHERE
workbench_status.enumvalue = 'Approved' AND
(fieldreport.reportverifieddate IS NULL OR
fieldreport.verifiedby IS NULL )
[[Category:NoPublic]]