NoPublic, bureaucrat, administrator
6,632
edits
Changes
no edit summary
This query list which published templates have '''never''' been used<pre>SELECT DISTINCTfieldreportdesc.fieldreportname,fieldreportdesc."version",fieldreportdesc.isactiveFROMfieldreportdescLEFT JOIN fieldreport ON fieldreport.fieldreportdesc_guid = fieldreportdesc.fieldreportdesc_guidWHEREfieldreport.fieldreportdesc_guid IS NULLORDER BYfieldreportdesc.fieldreportname ASC,fieldreportdesc."version" ASC,fieldreportdesc.isactive ASC</pre> This query lists which published templates have been '''used'''
<pre>
SELECT
fieldreportdesc.publisheddate
</pre>
If any of them are would like to save inactive published templates as files then you need to:
# Activate them in the Customisation menu;
# Open Template Designer;
