NoPublic, bureaucrat, administrator
6,632
edits
Changes
Created page with "'''Field report''' <pre> SELECT fieldreport.fieldreport_localid, fieldreport.dateofreport AS `Date of Information`, fieldreport.reportreceiveddate AS `Data Entry Date`, fieldr..."
'''Field report'''
<pre>
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
<pre/>
[[Category:NoPublic]]
[[Category:SQL Queries]]
<pre>
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
<pre/>
[[Category:NoPublic]]
[[Category:SQL Queries]]