NoPublic, bureaucrat, administrator
6,632
edits
Changes
no edit summary
It is '''really''' important that the approval information is set. '''NOTE''' How to fix it is different for each country so the UPDATE query below is '''only''' inspiration.<pre>SELECT
fieldreport.fieldreport_localid,
fieldreport.dateofreport AS `Date of Information`,
fieldreport.reportreceiveddate AS `Data Entry Date`,
fieldreport.reportcompleteddate AS `Submitted Date`,
fieldreport.reportverifieddate AS `Approved Date`,
fieldreport.dataenterer AS `Data enterer`,
fieldreport.verifiedby AS `Approved by`
FROM
fieldreport
Inner Join imsmaenum AS workbench_status ON (workbench_status.imsmaenum_guid = fieldreport.workbenchstatusenum_guid)
WHERE
workbench_status.enumvalue = 'Approved' AND
(fieldreport.reportverifieddate IS NULL OR
fieldreport.verifiedby IS NULL )
ORDER BY
fieldreport.fieldreport_localid ASC
UPDATE fieldreport
Inner Join imsmaenum AS workbench_status ON (workbench_status.imsmaenum_guid = fieldreport.workbenchstatusenum_guid)
SET fieldreport.reportverifieddate = reportreceiveddate,
fieldreport.verifiedby = fieldreport.dataenterer
WHERE
workbench_status.enumvalue = 'Approved' AND
(fieldreport.reportverifieddate IS NULL OR
fieldreport.verifiedby IS NULL )</pre>
[[Category:NoPublic]]
[[Category:SQL Queries]]