Bug #2776
closedNeed some queries to help us summarize issues for contractors
0%
Description
Need a naming scheme (qa_quick)?
A simple summary by project:
SELECT project.projectName, project.entry_projectCode AS code, Count(observation.OBSERVATION_ID) AS plots
FROM project INNER JOIN observation ON project.PROJECT_ID = observation.PROJECT_ID
GROUP BY project.projectName, project.entry_projectCode;
Updated by Michael Lee over 17 years ago
Might be nice to have a query that reads out in English what the problems are and where with errors so I can more easily email them.
Updated by Michael Lee over 17 years ago
better for project summary pasting into a new document (text):
SELECT [projectName] & " (ID " & [entry_projectCode] & "): " AS proj, Count(observation.OBSERVATION_ID) AS plots, " plots" AS Expr2
FROM project INNER JOIN observation ON project.PROJECT_ID = observation.PROJECT_ID
GROUP BY [projectName] & " (ID " & [entry_projectCode] & "): ", " plots";
Updated by Michael Lee about 17 years ago
Not sure if this is where to park this comment or not, probably not. But reports from entry tool now include information about whether or not stem counts per acre are within quidelines or not.
Updated by Michael Lee about 17 years ago
milestone v206 is in the past, so moving these to v2.3
Updated by Michael Lee over 16 years ago
(In reply to comment #3)
Not sure if this is where to park this comment or not, probably not. But
reports from entry tool now include information about whether or not stem
counts per acre are within quidelines or not.
This part is now done.
Updated by Michael Lee almost 16 years ago
I think this is resolved in the excel report.