NoPublic, bureaucrat, administrator
6,632
edits
Changes
no edit summary
fieldreport.dateofreport IS NULL AND
hazardinfoversion.link_only = '0'
ORDER BY
fieldreport.fieldreport_localid ASC
</pre>
'''Hazard reduction'''
With this result set you can show the country which Hazard Reductions are affected and figure out a solution e.g. use End date if NOT NULL
<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`,
hazreducinfoversion.startdate,
hazreducinfoversion.enddate,
hazreducinfoversion.hazreduc_localid
FROM
fieldreport
Inner Join hazreducinfoversion ON fieldreport.fieldreport_guid = hazreducinfoversion.fieldreport_guid
WHERE
fieldreport.dateofreport IS NULL AND
hazreducinfoversion.link_only = '0'
ORDER BY
fieldreport.fieldreport_localid ASC
