SQL Saved search No links - Revision history

Alnaucler at 11:37, 24 July 2014

2014-07-24T11:37:48Z

← Older revision		Revision as of 13:37, 24 July 2014
Line 26:		Line 26:
	victim_localid		victim_localid
	</pre>		</pre>
	'''Hazards without links''' This query needs to be ~~adopted~~ to the business rules of the country e.g. all ''Closed'' or all ''CHA'' should have links		'''Hazards without links''' This query needs to be adapted to the business rules of the country e.g. all ''Closed'' or all ''CHA'' should have links
	<pre>		<pre>
	SELECT DISTINCT		SELECT DISTINCT

Alnaucler at 13:58, 20 May 2014

2014-05-20T13:58:07Z

← Older revision		Revision as of 15:58, 20 May 2014
Line 2:		Line 2:
	'''Accidents without link to Victim'''		'''Accidents without link to Victim'''
	<pre>		<pre>
	SELECT DISTINCT		SELECT DISTINCT accident.accident_guid
	~~accident_localid~~		FROM accident
	FROM		WHERE accident.accident_guid NOT IN
	accident		(SELECT DISTINCT accident.accident_guid
	WHERE accident.accident_guid NOT IN (		FROM accident INNER JOIN link ON link.from_guid = accident.accident_guid
	SELECT DISTINCT		INNER JOIN victim ON link.to_guid = victim.victim_guid )
	accident.accident_guid
	FROM
	link
	~~Inner Join accident~~ ON accident.accident_guid ~~= link.from_guid~~
	~~WHERE~~
	link.~~to_link_type~~ = ~~'Victim'~~)
	~~ORDER BY~~
	~~accident_localid~~
	</pre>		</pre>
	'''Victims without link to Accident'''		'''Victims without link to Accident'''

Dionysia at 08:37, 13 February 2014

2014-02-13T08:37:39Z

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

			{{NavBox Upgrade}}
	[[Category:NoPublic]]		[[Category:NoPublic]]
	[[Category:SQL Queries]]		[[Category:SQL Queries]]

Alnaucler at 07:19, 13 February 2014

2014-02-13T07:19:57Z

@@ Line 46: / Line 46: @@
 hazard_localid
 </pre>
+'''HazRed without link''' If the country records Hazards as outcome of surveys or Clearance/Completion are done on Hazards then there should be links
 [[Category:NoPublic]]
 [[Category:SQL Queries]]

Alnaucler at 07:11, 13 February 2014

2014-02-13T07:11:08Z

@@ Line 17: / Line 17: @@
 accident_localid
 </pre>
+'''Victims without link to Accident'''
+<pre>
 [[Category:NoPublic]]
 [[Category:SQL Queries]]

Alnaucler: Created page with "These queries finds records that do not have links which might not be a data quality issue depending on the business rules in your country. They are added to V6.0 as Saved sea..."

2014-02-13T07:01:34Z

Created page with "These queries finds records that do not have links which might not be a data quality issue depending on the business rules in your country. They are added to V6.0 as Saved sea..."

New page

These queries finds records that do not have links which might not be a data quality issue depending on the business rules in your country. They are added to V6.0 as Saved searches with a syntax that works as Saved search <br />
'''Accidents without link to Victim'''
<pre>
SELECT DISTINCT
accident_localid
FROM
accident
WHERE accident.accident_guid NOT IN (
SELECT DISTINCT
accident.accident_guid
FROM
link
Inner Join accident ON accident.accident_guid = link.from_guid
WHERE
link.to_link_type = 'Victim')
ORDER BY
accident_localid
</pre>

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