Missing Date of Information: Difference between revisions
Jump to navigation
Jump to search
Created page with "SELECT fieldreport.fieldreport_localid, fieldreport.dateofreport, fieldreport.reportreceiveddate, fieldreport.reportverifieddate, fieldreport.reportcompleteddate, fieldreport...." |
No edit summary |
||
| Line 1: | Line 1: | ||
SELECT | <pre>SELECT | ||
fieldreport.fieldreport_localid, | fieldreport.fieldreport_localid, | ||
fieldreport.dateofreport, | fieldreport.dateofreport, | ||
| Line 6: | Line 6: | ||
fieldreport.reportcompleteddate, | fieldreport.reportcompleteddate, | ||
fieldreport.dataentrydate | fieldreport.dataentrydate | ||
FROM | FROM | ||
fieldreport | fieldreport | ||
WHERE | WHERE | ||
fieldreport.dateofreport IS NULL | fieldreport.dateofreport IS NULL | ||
</pre> | |||
[[Category:NoPublic]] | [[Category:NoPublic]] | ||
Revision as of 16:38, 10 February 2014
SELECT fieldreport.fieldreport_localid, fieldreport.dateofreport, fieldreport.reportreceiveddate, fieldreport.reportverifieddate, fieldreport.reportcompleteddate, fieldreport.dataentrydate FROM fieldreport WHERE fieldreport.dateofreport IS NULL