Changes

Missing approval information

631 bytes added, 00:37, 14 November 2016

no edit summary

{{TOC right}}[[Image:Missing approval info.png|800px|center]]<div align="center">'' How it should NOT look like''</div>Depending on the reason why the approval information is missing there are different combinations:* only Approval date missing* only Approved by missing* both missing. The solution is of course depending on what is missing. It is '''important''' that the approval information is set. and '''only'' rows with workbench status = '''NOTEApproved''' How to fix it is different for each country are included.  ==Missing approval information ==__NOEDITSECTION__

<pre>

SELECT

fieldreport.fieldreport_localidAS `Form ID`,

fieldreport.dateofreport AS `Date of Information`,

fieldreport.reportreceiveddate AS `Data Entry Date`,

fieldreport.reportcompleteddate AS `Submitted Date`,

fieldreport.reportverifieddate AS `Approved Date`,

fieldreport.verifiedby AS `Approved by`,

fieldreport.dataenterer AS `Data enterer`,

fieldreportworkbench_status.verifiedby AS `Approved by`enumvalue

FROM

fieldreport

fieldreport.fieldreport_localid ASC

</pre>

{{NavBox Upgrade}}If you have any output here you need to take action. The queries below help you to identify for which item(s) the rows in the table ''fieldreport'' need to be updated.

[[Category:NoPublic]]

[[Category:SQL Queries]]

{{NavBox Upgrade}}

• ← Older edit
• Newer edit →

Alnaucler

NoPublic, bureaucrat, administrator

6,632

edits