NoPublic, bureaucrat, administrator
6,632
edits
Changes
no edit summary
== Example update query==__NOEDITSECTION__
<pre>
UPDATE fieldreport
INNER JOIN imsmaenum AS workbench_status ON (workbench_status.imsmaenum_guid = fieldreport.workbenchstatusenum_guid)
INNER JOIN hazardinfoversion ON hazardinfoversion.fieldreport_guid = fieldreport.fieldreport_guid
SET
fieldreport.reportverifieddate = fieldreport.reportreceiveddate
WHERE
workbench_status.enumvalue = 'Approved' AND
fieldreport.reportverifieddate IS NULL AND
fieldreport.verifiedby IS NOT NULL AND
hazardinfoversion.link_only = 0 AND
fieldreport.dateofreport IS NULL AND
fieldreport.reportreceiveddate > hazardinfoversion.dataentrydate
UPDATE fieldreport
Inner Join imsmaenum AS workbench_status ON (workbench_status.imsmaenum_guid = fieldreport.workbenchstatusenum_guid)
SET
fieldreport.verifiedby = fieldreport.dataenterer
WHERE
workbench_status.enumvalue = 'Approved' AND
fieldreport.dataenterer IS NOT NULL AND
fieldreport.verifiedby IS NULL
</pre>
[[Category:NoPublic]]
[[Category:SQL Queries]]
{{NavBox Upgrade}}