Missing approval information

From IMSMA Wiki
Revision as of 17:51, 6 February 2014 by Alnaucler (talk | contribs) (Created page with "SELECT fieldreport.fieldreport_localid, fieldreport.dateofreport AS `Date of Information`, fieldreport.reportreceiveddate AS `Data Entry Date`, fieldreport.reportcompleteddate...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

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