Offline Run Quality Database Queries

Run Quality Query (View Based)
Run Number
MUON Quality
MET Quality
JET Quality
SMT Quality
STT Quality
CFT Quality
CAL Quality
CTT Quality
GM Quality
FPD Quality
CAL1 Quality
Output Type
Number of Rows Per Page
Max Number of Rows
Run Quality Query
Run Number
Id/Detector Group
Quality Flag
Output Type
Number of Rows Per Page
Max Number of Rows
Run Quality Parameters Query
Run Number
Id/Detector Group
Param Name
Param Value
Output Type
Number of Rows Per Page
Max Number of Rows
Other Table Dumps The result of New (View Based) Run Quality Query will produce:
------------------------------------------------------------------------------------------------- 
|RUN_NUMBER | MUO_QUALITY | MET_QUALITY | JET_QUALITY | SMT_QUALITY | CFT_QUALITY | CAL_QUALITY |
-------------------------------------------------------------------------------------------------
|140248     | GOOD        | BAD         | REASONABLE  | UNKNOWN     | BAD         | SPECIAL     |
...
...

The result of Run Quality Query will produce:
------------------------------------
|RUN_NUMBER | QUAL_GROUP | QUALITY |
------------------------------------
|140248     | MUO        | GOOD    |
...
...

The result of Run Quality Query Parameters will produce:
-------------------------------------------------
|RUN_NUMBER | QUAL_GROUP | PAR_NAME | PAR_VALUE |
-------------------------------------------------
|140248     | MUO        | TEMP     | 70F       |
...
...

QUERY TIPS:

Query Tips and hints on MISWEB usage can be found here