NoPublic, bureaucrat, administrator
6,632
edits
Changes
no edit summary
</pre>
This query checks for which inactive templates have not been used for data entry
<pre>
SELECT
fieldreportdesc.fieldreportname,
organisation.orgname,
fieldreportdesc.publisheddate,
fieldreportdesc.`version`,
fieldreportdesc.isactive
FROM
fieldreport
Right Join fieldreportdesc ON fieldreport.fieldreportdesc_guid = fieldreportdesc.fieldreportdesc_guid
Inner Join organisation ON fieldreportdesc.org_guid = organisation.org_guid
WHERE
fieldreport.fieldreportdesc_guid IS NULL AND
fieldreportdesc.isactive = 0
GROUP BY
fieldreportdesc.fieldreportname,
organisation.orgname,
publisheddate,
`version`
ORDER BY
fieldreportdesc.publisheddate DESC
</pre>
{{NavBox Upgrade}}
[[Category:NoPublic]]
[[Category:SQL Queries]]
