NoPublic, bureaucrat, administrator
6,632
edits
Changes
Created page with "{{Under construction | still MySQL queries.}} It is '''important''' that the approval information is set. '''NOTE''' How to fix it is different for each country <pre> SELECT..."
{{Under construction | still MySQL queries.}}
It is '''important''' that the approval information is set. '''NOTE''' How to fix it is different for each country
<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
Inner Join imsmaenum AS workbench_status ON (workbench_status.imsmaenum_guid = fieldreport.workbenchstatusenum_guid)
WHERE
workbench_status.enumvalue = 'Approved' AND
(fieldreport.reportverifieddate IS NULL OR
fieldreport.verifiedby IS NULL )
ORDER BY
fieldreport.fieldreport_localid ASC
</pre>
{{NavBox Hub}}
[[Category:NoPublic]]
[[Category:SQL Queries]]
It is '''important''' that the approval information is set. '''NOTE''' How to fix it is different for each country
<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
Inner Join imsmaenum AS workbench_status ON (workbench_status.imsmaenum_guid = fieldreport.workbenchstatusenum_guid)
WHERE
workbench_status.enumvalue = 'Approved' AND
(fieldreport.reportverifieddate IS NULL OR
fieldreport.verifiedby IS NULL )
ORDER BY
fieldreport.fieldreport_localid ASC
</pre>
{{NavBox Hub}}
[[Category:NoPublic]]
[[Category:SQL Queries]]