SQL Saved search MA quality - Revision history

Alnaucler at 13:59, 20 May 2014

2014-05-20T13:59:53Z

← Older revision		Revision as of 15:59, 20 May 2014
Line 25:		Line 25:
	'''CR without polygon/polyline'''		'''CR without polygon/polyline'''
	<pre>		<pre>
	SELECT ~~hazreduc~~.~~hazreduc_localid~~		SELECT DISTINCT hazard.hazard_guid
	FROM ~~hazreduc~~ Inner Join imsmaenum ON ~~hazreduc~~.~~hazreductypeenum_guid~~ = imsmaenum.imsmaenum_guid		FROM hazard Inner Join imsmaenum ON hazard.maareatype_guid = imsmaenum.imsmaenum_guid
	WHERE imsmaenum.enumvalue = '~~CompletionReport~~' AND		WHERE imsmaenum.enumvalue = 'CHA' AND
	( ~~hazreduc~~.hasgeodata = FALSE OR ~~hazreduc~~.~~hazreduc_guid~~ NOT IN		(hazard.hasgeodata = FALSE OR hazard.hazard_guid NOT IN
	(SELECT DISTINCT ~~hazreduc~~.~~hazreduc_guid~~		(SELECT DISTINCT hazard.hazard_guid
	FROM ~~hazreduc~~ Inner Join ~~hazreduc_has_geospatialinfo~~ ON ~~hazreduc~~.~~hazreduc_guid~~ = ~~hazreduc_has_geospatialinfo~~.~~hazreduc_guid~~		FROM hazard Inner Join hazard_has_geospatialinfo ON hazard.hazard_guid = hazard_has_geospatialinfo.hazard_guid
	Inner Join geospatialinfo ON ~~hazreduc_has_geospatialinfo~~.geospatialinfo_guid = geospatialinfo.geospatialinfo_guid		Inner Join geospatialinfo ON hazard_has_geospatialinfo.geospatialinfo_guid = geospatialinfo.geospatialinfo_guid
	Inner Join imsmaenum ON geospatialinfo.shapeenum_guid = imsmaenum.imsmaenum_guid		Inner Join imsmaenum ON geospatialinfo.shapeenum_guid = imsmaenum.imsmaenum_guid
	WHERE imsmaenum.enumvalue LIKE 'Poly%'))		WHERE imsmaenum.enumvalue LIKE 'Poly%' ))</pre>
	~~ORDER BY~~
	~~hazreduc.hazreduc_localid~~
	</pre>
	'''Open Hazards with links to HazRed or QM'''		'''Open Hazards with links to HazRed or QM'''
	<pre>		<pre>

Dionysia at 08:38, 13 February 2014

2014-02-13T08:38:45Z

← Older revision		Revision as of 10:38, 13 February 2014
Line 46:		Line 46:
	hazard_localid		hazard_localid
	</pre>		</pre>

			{{NavBox Upgrade}}

	[[Category:NoPublic]]		[[Category:NoPublic]]
	[[Category:SQL Queries]]		[[Category:SQL Queries]]

Alnaucler at 08:22, 13 February 2014

2014-02-13T08:22:46Z

← Older revision		Revision as of 10:22, 13 February 2014
Line 37:		Line 37:
	hazreduc.hazreduc_localid		hazreduc.hazreduc_localid
	</pre>		</pre>
			'''Open Hazards with links to HazRed or QM'''
			<pre>
			SELECT DISTINCT hazard_localid
			FROM hazard Inner Join imsmaenum ON hazard.status_guid = imsmaenum.imsmaenum_guid
			Inner Join link ON hazard.hazard_guid = link.from_guid
			WHERE imsmaenum.enumvalue = 'Active' AND (link.to_link_type = 'HAZARD_REDUCTION' OR link.to_link_type = 'QA' )
			ORDER BY
			hazard_localid
			</pre>

	[[Category:NoPublic]]		[[Category:NoPublic]]
	[[Category:SQL Queries]]		[[Category:SQL Queries]]

Alnaucler at 08:18, 13 February 2014

2014-02-13T08:18:46Z

@@ Line 1: / Line 1: @@
 These queries depends on the business rules in the country. More queries than the ones below are added to V6.0 as Saved searches with a syntax that works as Saved search <br />
 '''CR without polygon/polyline'''
 <pre>

Alnaucler: Created page with "These queries depends on the business rules in the country. More queries than the ones below are added to V6.0 as Saved searches with a syntax that works as Saved search

2014-02-13T07:59:30Z

Created page with "These queries depends on the business rules in the country. More queries than the ones below are added to V6.0 as Saved searches with a syntax that works as Saved search <br /..."

New page
These queries depends on the business rules in the country. More queries than the ones below are added to V6.0 as Saved searches with a syntax that works as Saved search <br />
'''CR without polygon/polyline'''
<pre>
SELECT hazreduc.hazreduc_localid
FROM hazreduc Inner Join imsmaenum ON hazreduc.hazreductypeenum_guid = imsmaenum.imsmaenum_guid
WHERE imsmaenum.enumvalue = 'CompletionReport' AND
( hazreduc.hasgeodata = FALSE OR hazreduc.hazreduc_guid NOT IN
(SELECT DISTINCT hazreduc.hazreduc_guid
FROM hazreduc Inner Join hazreduc_has_geospatialinfo ON hazreduc.hazreduc_guid = hazreduc_has_geospatialinfo.hazreduc_guid
Inner Join geospatialinfo ON hazreduc_has_geospatialinfo.geospatialinfo_guid = geospatialinfo.geospatialinfo_guid
Inner Join imsmaenum ON geospatialinfo.shapeenum_guid = imsmaenum.imsmaenum_guid
WHERE imsmaenum.enumvalue LIKE 'Poly%'))
ORDER BY
hazreduc.hazreduc_localid
</pre>

[[Category:NoPublic]]
[[Category:SQL Queries]]