Project

General

Profile

Bug #2776

Need some queries to help us summarize issues for contractors

Added by Michael Lee over 12 years ago. Updated over 10 years ago.

Status:
Resolved
Priority:
Normal
Assignee:
Category:
EntryDB
Target version:
Start date:
02/14/2007
Due date:
% Done:

0%

Estimated time:
Bugzilla-Id:
2776

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;

History

#1 Updated by Michael Lee over 12 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.

#2 Updated by Michael Lee over 12 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";

#3 Updated by Michael Lee almost 12 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.

#4 Updated by Michael Lee almost 12 years ago

milestone v206 is in the past, so moving these to v2.3

#5 Updated by Michael Lee about 11 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.

#6 Updated by Michael Lee over 10 years ago

I think this is resolved in the excel report.

#7 Updated by Redmine Admin about 6 years ago

Original Bugzilla ID was 2776

Also available in: Atom PDF