Missing approval information: Difference between revisions
Jump to navigation
Jump to search
Created page with "SELECT fieldreport.fieldreport_localid, fieldreport.dateofreport AS `Date of Information`, fieldreport.reportreceiveddate AS `Data Entry Date`, fieldreport.reportcompleteddate..." |
No edit summary |
||
| Line 1: | Line 1: | ||
SELECT | SELECT | ||
fieldreport.fieldreport_localid, | fieldreport.fieldreport_localid, | ||
fieldreport.dateofreport AS `Date of Information`, | fieldreport.dateofreport AS `Date of Information`, | ||
fieldreport.reportreceiveddate AS `Data Entry Date`, | fieldreport.reportreceiveddate AS `Data Entry Date`, | ||
fieldreport.reportcompleteddate AS `Submitted Date`, | fieldreport.reportcompleteddate AS `Submitted Date`, | ||
fieldreport.reportverifieddate AS `Approved Date`, | fieldreport.reportverifieddate AS `Approved Date`, | ||
fieldreport.dataenterer AS `Data enterer`, | fieldreport.dataenterer AS `Data enterer`, | ||
fieldreport.verifiedby AS `Approved by` | fieldreport.verifiedby AS `Approved by` | ||
| Line 14: | Line 20: | ||
WHERE | WHERE | ||
workbench_status.enumvalue = 'Approved' AND | workbench_status.enumvalue = 'Approved' AND | ||
(fieldreport.reportverifieddate IS NULL OR | (fieldreport.reportverifieddate IS NULL OR | ||
fieldreport.verifiedby IS NULL ) | fieldreport.verifiedby IS NULL ) | ||
Revision as of 17:54, 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