NoPublic, bureaucrat, administrator
6,632
edits
Changes
no edit summary
{{TOC right}}
{{Note | The Summary item/window calculation is '''depending''' on that ''Date of Information'' is filled in and the rules for if a DEF is Unapprovable are also depending on ''Date of Information''.}}
==Missing Date of Information ==__NOEDITSECTION__
[[Image:Missing date info.png|1000px|center]]
InfoVerDate ASC,
`Form ID` ASC
</pre>
==Example UPDATE query==__NOEDITSECTION__
<pre>
update fieldreport
Inner Join hazardinfoversion ON fieldreport.fieldreport_guid = hazardinfoversion.fieldreport_guid
SET
fieldreport.dateofreport = hazardinfoversion.dataentrydate
WHERE
fieldreport.dateofreport IS NULL
AND
hazardinfoversion.link_only = '0' AND
hazardinfoversion.dataentrydate IS NOT NULL
</pre>