SQL Saved search No geo data - Revision history

Dionysia at 08:37, 13 February 2014

2014-02-13T08:37:18Z

← Older revision		Revision as of 10:37, 13 February 2014
Line 88:		Line 88:
	victim.victim_localid ASC		victim.victim_localid ASC
	</pre>		</pre>

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

Alnaucler at 06:52, 13 February 2014

2014-02-13T06:52:53Z

← Older revision		Revision as of 08:52, 13 February 2014
Line 1:		Line 1:
	Note: These queries are in 5.x format <br />		These queries finds records without '''any''' geographical information. They are added to V6.0 as Saved searches with a syntax that works as Saved search. Note: These queries are in 5.x format <br />
	'''Accident'''		'''Accident'''
	<pre>		<pre>
Line 33:		Line 33:
	hazreduc.hazreduc_localid ASC		hazreduc.hazreduc_localid ASC
	</pre>		</pre>
	'''Location''		'''Location'''
	<pre>		<pre>
	SELECT		SELECT
Line 66:		Line 66:
	qa.qa_localid ASC		qa.qa_localid ASC
	</pre>		</pre>
	'''Task'''		'''Task''' (not a Saved search)
	<pre>		<pre>
	SELECT		SELECT

Alnaucler at 06:45, 13 February 2014

2014-02-13T06:45:03Z

@@ Line 1: / Line 1: @@
-Note: These queries are in 5.x format
+Note: These queries are in 5.x format <br />
 '''Accident'''
 <pre>
@@ Line 22: / Line 22: @@
 hazard.hazard_localid ASC
 </pre>
-'''Haz Red'''
+'''HazRed'''
 <pre>
 SELECT
@@ Line 32: / Line 32: @@
 ORDER BY
 hazreduc.hazreduc_localid ASC
 </pre>
 [[Category:NoPublic]]
 [[Category:SQL Queries]]

Alnaucler: Created page with "Note: These queries are in 5.x format '''Accident'''

 SELECT accident.accident_localid FROM accident WHERE accident.hasgeodata =  '0' ORDER BY accident.accident_localid A..."

2014-02-13T06:32:39Z

Created page with "Note: These queries are in 5.x format '''Accident''' <pre> SELECT accident.accident_localid FROM accident WHERE accident.hasgeodata = '0' ORDER BY accident.accident_localid A..."

New page

Note: These queries are in 5.x format
'''Accident'''
<pre>
SELECT
accident.accident_localid
FROM
accident
WHERE
accident.hasgeodata = '0'
ORDER BY
accident.accident_localid ASC
</pre>
'''Hazard'''
<pre>
SELECT
hazard.hazard_localid
FROM
hazard
WHERE
hazard.hasgeodata = '0'
ORDER BY
hazard.hazard_localid ASC
</pre>
'''Haz Red'''
<pre>
SELECT
hazreduc.hazreduc_localid
FROM
hazreduc
WHERE
hazreduc.hasgeodata = '0'
ORDER BY
hazreduc.hazreduc_localid ASC
</pre>
[[Category:NoPublic]]
[[Category:SQL Queries]]