TABLE rawImfile
TITLE Burntool States
FILE  rawBurntoolState.php
MENU  ipp.load.dat

# if no query restrictions are supplied, we want to limit the query or it is extremely long running:
RESTRICT_COUNT WHERE dateobs >= CURDATE()
# UNRESTRICTED WHERE exp_id = 0
UNRESTRICTED WHERE dateobs >= CURDATE()

#        field        size format  name           show          link to   extras
FIELD    exp_id,      	      5,  %d,     Exp ID,        value
FIELD    exp_name,    	     10,  %s,     Exp Name
FIELD    dateobs,            19, %T,      Date/Time
FIELD    exp_type,            8,  %s,     Type    
FIELD    obs_mode,            8,  %s,     obs mode
FIELD    burntool_state,     10,  %s,     Burntool State
FIELD    fault,               5,  %d,     Fault
FIELD    count(exp_id) as n,  7,  %d,     count

MODE  summary
GROUP exp_id
GROUP burntool_state
GROUP fault
