SQL Saved search Task

These queries are about Tasks. They are added to V6.0 as Saved searches with a syntax that works as Saved search
Hazards not included in any Task This query would need to be adopted together with Ops e.g. all CHA in flat areas should have been tasked

SELECT hazard_localid
FROM hazard 
WHERE hazard.hazard_guid NOT IN 
(SELECT task_has_objective.hazard_guid FROM task_has_objective)
ORDER BY
hazard_localid