SQL Templates: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| 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]] | |||
Revision as of 11:23, 12 February 2014
This query checks which templates that have been used for data entry
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
This query shows all existing templates
SELECT fieldreportname, publisheddate, `version` FROM fieldreportdesc ORDER BY fieldreportname ASC, publisheddate ASC, `version` ASC