NoPublic, bureaucrat, administrator
6,632
edits
Changes
no edit summary
=== UPDATE other than Location example ===__NOEDITSECTION__
The difficulty is to how to identify which link row to transform to ''NEW''. I have tried Min(fieldreport.dateofreport) and Min(hazardinfoversion.dataentrydate). It is difficult to judge which one is better by the dates themselves due to data entry might have been done quite later than Date of Information. For Afghanistan I had 234 missing Land links and then comparing the two options 211 were the same. I decided that Min(fieldreport.dateofreport) was the best options which I also used for South Sudan. But for missing Activity links the best option was Min(hazreducinfoversion.dataentrydate) for Afghanistan.
<pre>
UPDATE link
