Changes between Version 15 and Version 16 of HetProcedures/RA/monitors


Ignore:
Timestamp:
Dec 22, 2018 10:31:46 AM (5 years ago)
Author:
shetrone
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • HetProcedures/RA/monitors

    v15 v16  
    5050== working with the htopx and night report databases ==
    5151
     52There are many databases here.    some of the more useful ones are:
     53  * plandb_latest_cur (this holds the most recent update for any record in the current queue)
     54  * plandb (holds all changes and version so allows you to look at history)
     55  * plandb_latest_new (this is for the new trimester)
     56  * nightreport_ra_targets
     57  * tacs
     58  *
     59
     60
    5261It is useful to know what fields can be queried with a mysql query in these databases.   To get a list try:  {{{ esql htopx -e "describe fullqueue"  }}} or {{{ mysql -uhtopx -p... htopx -e "describe fullqueue" }}}
    5362