Missing Local ID

From IMSMA Wiki
Revision as of 07:16, 12 February 2014 by Alnaucler (talk | contribs) (Created page with "'''Field report''' <pre> SELECT fieldreport.fieldreport_localid, fieldreport.dateofreport AS `Date of Information`, fieldreport.reportreceiveddate AS `Data Entry Date`, fieldr...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

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