SQL Saved search Different Location - Revision history

Alnaucler at 14:01, 20 May 2014

2014-05-20T14:01:37Z

← Older revision		Revision as of 16:01, 20 May 2014
Line 8:		Line 8:
	WHERE accident.location_guid <> victim.location_guid		WHERE accident.location_guid <> victim.location_guid
	</pre>		</pre>
	'''Hazard and HazRed'''		'''Hazard/Land and HazRed/Activity'''
	<pre>		<pre>
	SELECT DISTINCT		SELECT DISTINCT hazard.hazard_guid
	~~hazard_localid~~		FROM hazard Inner Join link ON hazard.hazard_guid = link.from_guid Inner Join hazreduc ON link.to_guid = hazreduc.hazreduc_guid
	FROM		WHERE hazard.location_guid <> hazreduc.location_guid
	hazard
	Inner Join link ON hazard.hazard_guid = link.from_guid
	Inner Join hazreduc ON link.to_guid = hazreduc.hazreduc_guid
	~~Inner Join location AS HazLoc ON~~ hazard~~.location_guid = HazLoc.location_guid~~
	~~Inner Join location AS HazRedLoc ON hazreduc.location_guid = HazRedLoc.location_guid~~
	~~WHERE~~
	~~link.from_link_type = 'Hazard'~~
	~~AND (HazLoc~~.location_guid <> ~~HazRedLoc~~.location_guid)
	~~ORDER BY~~
	~~hazard_localid~~
	</pre>		</pre>
	'''QM and HazRed'''		'''QM and HazRed/Activty'''
	<pre>		<pre>
	SELECT DISTINCT		SELECT DISTINCT qa.qa_guid
	~~qa_localid~~		FROM qa INNER JOIN link ON qa_guid = link.from_guid INNER JOIN hazreduc ON link.to_guid = hazreduc.hazreduc_guid
	FROM		WHERE qa.location_guid <> hazreduc.location_guid
	link
	~~Inner Join~~ hazreduc ON link.to_guid = hazreduc.hazreduc_guid
	~~Inner Join location AS HazLoc~~
	~~Inner Join location AS HazRedLoc ON hazreduc.location_guid = HazRedLoc.location_guid~~
	~~Inner Join qa ON link.from_guid = qa.qa_guid AND HazLoc.location_guid =~~ qa~~.location_guid~~
	~~WHERE~~
	~~link.from_link_type = 'QA' AND~~
	~~(HazLoc~~.location_guid <> ~~HazRedLoc~~.location_guid)
	~~ORDER BY~~
	~~qa_localid~~
	</pre>		</pre>

Alnaucler at 13:56, 20 May 2014

2014-05-20T13:56:56Z

← Older revision		Revision as of 15:56, 20 May 2014
Line 2:		Line 2:
	'''Accident and Victim'''		'''Accident and Victim'''
	<pre>		<pre>
	SELECT DISTINCT		SELECT DISTINCT accident.accident_guid
	~~accident_localid~~		FROM accident
	FROM		Inner Join link ON accident.accident_guid = link.from_guid
	accident		Inner Join victim ON link.to_guid = victim.victim_guid
	Inner Join link ON accident.accident_guid = link.from_guid		WHERE accident.location_guid <> victim.location_guid
	Inner Join victim ON link.to_guid = victim.victim_guid
	~~Inner Join location AS AccLoc ON~~ accident~~.location_guid = AccLoc.location_guid~~
	~~Inner Join location AS VicLoc ON victim.location_guid = VicLoc.location_guid~~
	~~WHERE~~
	~~link.from_link_type = 'Accident'~~
	~~AND (AccLoc~~.location_guid <> ~~VicLoc~~.location_guid)
	~~ORDER BY~~
	~~accident_localid~~
	</pre>		</pre>
	'''Hazard and HazRed'''		'''Hazard and HazRed'''

Dionysia at 08:38, 13 February 2014

2014-02-13T08:38:00Z

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

			{{NavBox Upgrade}}

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

Alnaucler at 07:31, 13 February 2014

2014-02-13T07:31:12Z

← Older revision		Revision as of 09:31, 13 February 2014
Line 1:		Line 1:
	These queries finds records where the assigned locations is not the same. They are added to V6.0 as Saved searches with a syntax that works as Saved search <br />		These queries finds records where the assigned locations are not the same. They are added to V6.0 as Saved searches with a syntax that works as Saved search <br />
	'''Accident and Victim'''		'''Accident and Victim'''
	<pre>		<pre>

Alnaucler at 07:30, 13 February 2014

2014-02-13T07:30:28Z

← Older revision		Revision as of 09:30, 13 February 2014
Line 2:		Line 2:
	'''Accident and Victim'''		'''Accident and Victim'''
	<pre>		<pre>
			SELECT DISTINCT
			accident_localid
			FROM
			accident
			Inner Join link ON accident.accident_guid = link.from_guid
			Inner Join victim ON link.to_guid = victim.victim_guid
			Inner Join location AS AccLoc ON accident.location_guid = AccLoc.location_guid
			Inner Join location AS VicLoc ON victim.location_guid = VicLoc.location_guid
			WHERE
			link.from_link_type = 'Accident'
			AND (AccLoc.location_guid <> VicLoc.location_guid)
			ORDER BY
			accident_localid
	</pre>		</pre>
	'''Hazard and HazRed'''		'''Hazard and HazRed'''
Line 20:		Line 32:
	hazard_localid		hazard_localid
	</pre>		</pre>
			'''QM and HazRed'''
			<pre>
			SELECT DISTINCT
			qa_localid
			FROM
			link
			Inner Join hazreduc ON link.to_guid = hazreduc.hazreduc_guid
			Inner Join location AS HazLoc
			Inner Join location AS HazRedLoc ON hazreduc.location_guid = HazRedLoc.location_guid
			Inner Join qa ON link.from_guid = qa.qa_guid AND HazLoc.location_guid = qa.location_guid
			WHERE
			link.from_link_type = 'QA' AND
			(HazLoc.location_guid <> HazRedLoc.location_guid)
			ORDER BY
			qa_localid
			</pre>

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

Alnaucler: Created page with "These queries finds records where the assigned locations is not the same. They are added to V6.0 as Saved searches with a syntax that works as Saved search
'''Accident ..."

2014-02-13T07:26:27Z

Created page with "These queries finds records where the assigned locations is not the same. They are added to V6.0 as Saved searches with a syntax that works as Saved search <br /> '''Accident ..."

New page

These queries finds records where the assigned locations is not the same. They are added to V6.0 as Saved searches with a syntax that works as Saved search <br />
'''Accident and Victim'''
<pre>

</pre>
'''Hazard and HazRed'''
<pre>
SELECT DISTINCT
hazard_localid
FROM
hazard
Inner Join link ON hazard.hazard_guid = link.from_guid
Inner Join hazreduc ON link.to_guid = hazreduc.hazreduc_guid
Inner Join location AS HazLoc ON hazard.location_guid = HazLoc.location_guid
Inner Join location AS HazRedLoc ON hazreduc.location_guid = HazRedLoc.location_guid
WHERE
link.from_link_type = 'Hazard'
AND (HazLoc.location_guid <> HazRedLoc.location_guid)
ORDER BY
hazard_localid
</pre>

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