Missing Local ID: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| Line 13: | Line 13: | ||
WHERE | WHERE | ||
fieldreport.fieldreport_localid is null | fieldreport.fieldreport_localid is null | ||
<pre | </pre> | ||
[[Category:NoPublic]] | [[Category:NoPublic]] | ||
[[Category:SQL Queries]] | [[Category:SQL Queries]] | ||
Revision as of 07:19, 12 February 2014
Field report
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 WHERE fieldreport.fieldreport_localid is null