SQL Templates - Revision history

Alnaucler at 17:07, 7 April 2015

2015-04-07T17:07:11Z

@@ Line 36: / Line 36: @@
 </pre>
 {{NavBox Upgrade}}
 [[Category:NoPublic]]
 [[Category:SQL Queries]]

Dionysia at 08:31, 13 February 2014

2014-02-13T08:31:23Z

← Older revision		Revision as of 10:31, 13 February 2014
Line 35:		Line 35:
	fieldreportdesc.isactive ASC		fieldreportdesc.isactive ASC
	</pre>		</pre>

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

Alnaucler at 10:33, 12 February 2014

2014-02-12T10:33:52Z

← Older revision		Revision as of 12:33, 12 February 2014
Line 23:		Line 23:
	</pre>		</pre>

	This query ~~shows~~ all existing templates		This query counts all existing templates by Active
	<pre>		<pre>
	SELECT		SELECT
	~~fieldreportname~~,		fieldreportdesc.isactive,
	~~publisheddate,~~		Count(fieldreportdesc.fieldreportdesc_guid)
	~~`version`~~
	FROM		FROM
	fieldreportdesc		fieldreportdesc
			GROUP BY
			fieldreportdesc.isactive
	ORDER BY		ORDER BY
	~~fieldreportname~~ ASC,		fieldreportdesc.isactive ASC
	~~publisheddate ASC,~~
	~~`version` ASC~~

	</pre>		</pre>
	[[Category:NoPublic]]		[[Category:NoPublic]]
	[[Category:SQL Queries]]		[[Category:SQL Queries]]

Alnaucler at 10:23, 12 February 2014

2014-02-12T10:23:36Z

← Older revision		Revision as of 12:23, 12 February 2014
Line 1:		Line 1:
	<pre>SELECT		This query checks which templates that have been used for data entry
			<pre>
			SELECT
	fieldreportname,		fieldreportname,
	orgname,		orgname,
Line 19:		Line 21:
	publisheddate ASC,		publisheddate ASC,
	`version` ASC		`version` ASC
			</pre>

	~~----------------------------------------------------------------------------------------------------------~~		This query shows all existing templates
			<pre>
	SELECT		SELECT
	fieldreportname,		fieldreportname,
Line 35:		Line 38:
	</pre>		</pre>
	[[Category:NoPublic]]		[[Category:NoPublic]]
			[[Category:SQL Queries]]

Alnaucler at 12:42, 11 February 2014

2014-02-11T12:42:25Z

@@ Line 17: / Line 17: @@
 fieldreportname ASC,
 orgname ASC,
 publisheddate ASC,
 `version` ASC

Alnaucler: Created page with "

SELECT fieldreportname, orgname, publisheddate, `version`, Count(fieldreport_guid) FROM fieldreport INNER JOIN fieldreportdesc ON fieldreport.fieldreportdesc_guid = field..."

2014-02-11T12:26:36Z

Created page with "<pre>SELECT fieldreportname, orgname, publisheddate, `version`, Count(fieldreport_guid) FROM fieldreport INNER JOIN fieldreportdesc ON fieldreport.fieldreportdesc_guid = field..."

New page

<pre>SELECT
fieldreportname,
orgname,
publisheddate,
`version`,
Count(fieldreport_guid)
FROM
fieldreport
INNER JOIN fieldreportdesc ON fieldreport.fieldreportdesc_guid = fieldreportdesc.fieldreportdesc_guid
INNER JOIN organisation ON fieldreportdesc.org_guid = organisation.org_guid
GROUP BY
fieldreportdesc.fieldreportname,
organisation.orgname,
publisheddate,
`version`
ORDER BY
fieldreportname ASC,
orgname ASC,
publisheddate ASC,
`version` ASC

</pre>
[[Category:NoPublic]]