Bug #2776
closed
Need some queries to help us summarize issues for contractors
Added by Michael Lee almost 18 years ago.
Updated about 16 years ago.
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;
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.
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";
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.
milestone v206 is in the past, so moving these to v2.3
(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.
I think this is resolved in the excel report.
Original Bugzilla ID was 2776
Also available in: Atom
PDF