PrimEx Calibration Database Query Page

Column headings are queries. Row headings are input parameters. Table cells indicate whether the input parameter is required, ignored or optional for the query. The "Limit Choices" buttons limit pull-down menus to self-consistent choices for system and attribute. Explanations of queries and input parameters follow the table.

columns: Queries->

rows: Parameters
|
V
min run (optional)
max run (optional)
system:ignored required required required required required
attribute:ignored required required required required required
run: required ignored required ignored ignored required
const. set ID: ignored ignored ignored required ignored ignored
date: optional ignored optional ignored optional optional
run index table: optional ignored optional ignored optional optional
hostname: optional optional optional optional optional optional

The queries are:

    Sets by Run: For a given run, list all system/attributes that have valid constant sets for that run.
    Sets by Attribute: For a given system/attribute, list all constant sets in the database, including those not linked to run ranges.
    Values by Run: Display the calibration constant values for the given system/attribute and run.
    Values ID: Display the calibration constant values for the given system/attribute and constant set ID.
    Run Ranges: Shows all run ranges defined for the specified system/attribute. Optionally a run range restriction can be specified.
    Run History: Shows the history of changes of the constants for the specified system/attribute and run.
The optional input parameters are:
    date: The query will reflect the status of the database as of this date. The format is "YYYY-MM-DD". The default is "2037-01-01" which is equivalent to asking for the current time.
    run index table: The query will use this table to make the correlation between run number and calibration constants. The default is "primex_calib.RunIndex".
    hostname: The query will use this host as the database server. The default is "clasdb.jlab.org"