NoPublic, bureaucrat, administrator
6,632
edits
Changes
Created page with "This query lists which templates have been used: SELECT fieldreportdesc.fieldreportname, organisation.orgname, fieldreportdesc.`version`, fieldreportdesc.publisheddate, Count(..."
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]]
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]]