Used DEF template SQL - Revision history

Rana at 06:58, 18 July 2014

2014-07-18T06:58:08Z

← Older revision		Revision as of 08:58, 18 July 2014
Line 3:		Line 3:
	SELECT DISTINCT		SELECT DISTINCT
	fieldreportdesc.fieldreportname,		fieldreportdesc.fieldreportname,
	fieldreportdesc."version",		fieldreportdesc.`version`,
	fieldreportdesc.isactive		fieldreportdesc.isactive
	FROM		FROM
Line 12:		Line 12:
	ORDER BY		ORDER BY
	fieldreportdesc.fieldreportname ASC,		fieldreportdesc.fieldreportname ASC,
	fieldreportdesc."version" ASC,		fieldreportdesc.`version` ASC,
	fieldreportdesc.isactive ASC		fieldreportdesc.isactive ASC
	</pre>		</pre>

Dionysia at 14:18, 7 July 2014

2014-07-07T14:18:15Z

← Older revision		Revision as of 16:18, 7 July 2014
Line 35:		Line 35:
	fieldreportdesc.publisheddate		fieldreportdesc.publisheddate
	</pre>		</pre>
	If would like to save inactive published templates as files then you need to:		If you would like to save inactive published templates as files then you need to:
	# Activate them in the Customisation menu;		# Activate them in the Customisation menu;
	# Open Template Designer;		# Open Template Designer;

Dionysia at 14:17, 7 July 2014

2014-07-07T14:17:39Z

← Older revision		Revision as of 16:17, 7 July 2014
Line 1:		Line 1:
	This query ~~list~~ which published templates have '''never''' been used		This query lists which published templates have '''never''' been used
	<pre>		<pre>
	SELECT DISTINCT		SELECT DISTINCT

Alnaucler at 20:39, 5 July 2014

2014-07-05T20:39:01Z

@@ Line 1: / Line 1: @@
-This query lists which templates have been '''used'''
+This query list which published templates have '''never''' been used
 <pre>
 SELECT
@@ Line 18: / Line 35: @@
 fieldreportdesc.publisheddate
 </pre>
-If any of them are inactive then you need to:
+If would like to save inactive published templates as files then you need to:
 # Activate them in the Customisation menu;
 # Open Template Designer;

Alnaucler at 13:00, 19 June 2014

2014-06-19T13:00:34Z

← Older revision		Revision as of 15:00, 19 June 2014
Line 23:		Line 23:
	# Drag them in and save as file;		# Drag them in and save as file;
	# Inactivate them in the Customisation menu;		# Inactivate them in the Customisation menu;
	[[NavBox Upgrade]]		{{NavBox Upgrade}}
	[[Category:NoPublic]]		[[Category:NoPublic]]
	[[Category:SQL Queries]]		[[Category:SQL Queries]]
	[[Category:NAA]]		[[Category:NAA]]

Alnaucler at 12:59, 19 June 2014

2014-06-19T12:59:12Z

← Older revision		Revision as of 14:59, 19 June 2014
Line 23:		Line 23:
	# Drag them in and save as file;		# Drag them in and save as file;
	# Inactivate them in the Customisation menu;		# Inactivate them in the Customisation menu;
			[[NavBox Upgrade]]
	[[Category:NoPublic]]		[[Category:NoPublic]]
	[[Category:SQL Queries]]		[[Category:SQL Queries]]
	[[Category:NAA]]		[[Category:NAA]]

Alnaucler at 12:52, 19 June 2014

2014-06-19T12:52:47Z

← Older revision		Revision as of 14:52, 19 June 2014
Line 1:		Line 1:
	This query lists which templates have been used:		This query lists which templates have been '''used'''
			<pre>
	SELECT		SELECT
	fieldreportdesc.fieldreportname,		fieldreportdesc.fieldreportname,
Line 16:		Line 17:
	fieldreportdesc.`version`,		fieldreportdesc.`version`,
	fieldreportdesc.publisheddate		fieldreportdesc.publisheddate
			</pre>
	If any of them are inactive then you need to:		If any of them are inactive then you need to:
	# Activate them in the Customisation menu;		# Activate them in the Customisation menu;

Alnaucler: Created page with "This query lists which templates have been used: SELECT fieldreportdesc.fieldreportname, organisation.orgname, fieldreportdesc.`version`, fieldreportdesc.publisheddate, Count(..."

2014-06-19T12:51:37Z

Created page with "This query lists which templates have been used: SELECT fieldreportdesc.fieldreportname, organisation.orgname, fieldreportdesc.`version`, fieldreportdesc.publisheddate, Count(..."

New page

This query lists which templates have been used:
SELECT
fieldreportdesc.fieldreportname,
organisation.orgname,
fieldreportdesc.`version`,
fieldreportdesc.publisheddate,
Count(fieldreport.fieldreport_guid),
fieldreportdesc.isactive
FROM
fieldreport
Inner Join fieldreportdesc ON fieldreportdesc.fieldreportdesc_guid = fieldreport.fieldreportdesc_guid
Inner Join organisation ON organisation.org_guid = fieldreportdesc.org_guid
GROUP BY
fieldreportdesc.fieldreportname,
organisation.orgname,
fieldreportdesc.`version`,
fieldreportdesc.publisheddate

If any of them are inactive then you need to:
# Activate them in the Customisation menu;
# Open Template Designer;
# Drag them in and save as file;
# Inactivate them in the Customisation menu;
[[Category:NoPublic]]
[[Category:SQL Queries]]
[[Category:NAA]]