Missing approval information: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| Line 1: | Line 1: | ||
SELECT | <pre>SELECT | ||
fieldreport.fieldreport_localid, | fieldreport.fieldreport_localid, | ||
| Line 42: | Line 42: | ||
(fieldreport.reportverifieddate IS NULL OR | (fieldreport.reportverifieddate IS NULL OR | ||
fieldreport.verifiedby IS NULL ) | fieldreport.verifiedby IS NULL )</pre> | ||
[[Category:NoPublic]] | [[Category:NoPublic]] | ||
Revision as of 18:34, 6 February 2014
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 )