NoPublic, bureaucrat, administrator
6,632
edits
Changes
Created page with "These queries are about Tasks. They are added to V6.0 as Saved searches with a syntax that works as Saved search <br /> '''Hazards not included in any Task''' This query would..."
These queries are about Tasks. They are added to V6.0 as Saved searches with a syntax that works as Saved search <br />
'''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
<pre>
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
</pre>
[[Category:NoPublic]]
[[Category:SQL Queries]]
'''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
<pre>
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
</pre>
[[Category:NoPublic]]
[[Category:SQL Queries]]
