NoPublic, bureaucrat, administrator
6,632
edits
Changes
no edit summary
If Date of Information is missing it has to be set depending on type of item.<pre>SELECT
fieldreport.fieldreport_localid,
fieldreport.dateofreportAS `Date of Information`,fieldreport.reportreceiveddateAS `Data Entry Date`,fieldreport.reportcompleteddate AS `Submitted Date`,fieldreport.reportverifieddateAS `Approved Date`,fieldreport.reportcompleteddatedataenterer AS `Data enterer`,fieldreport.dataentrydateverifiedby AS `Approved by`
FROM
fieldreport
WHERE
fieldreport.dateofreport IS NULL
ORDER BY
fieldreport.fieldreport_localid ASC
</pre>
[[Category:NoPublic]]
[[Category:SQL Queries]]
