AutoSchedule

(if available) The schedule from the AutoSchedule table as planned by the autoscheduler (makeschedule).

Schedule

The schedule as available in the Schedule table after the night.

RunInfo

The schedule as executed, taken from the RunInfo table. Only data runs are counted.

QLA

This row is only displayed if different from RunInfo. It shows all runs which have been processed by the QLA already.

Note that the two schedules will never perfectly coincide with the runs taken because finite Measurements scheduled together with a source in one observation are counted to be part of the source. Also automatic calibration runs are obviously not accounted for in the schedule.

---

Keyboard interaction

LEFT: Move to the previous day.

RIGHT: Move to the next day.

UP: Move to the previous week.

DOWN: Move the next week.

While the datepicker is open, the following key commands are available:

• PAGE UP: Move to the previous month.
• PAGE DOWN: Move to the next month.
• CTRL + PAGE UP: Move to the previous year.
• CTRL + PAGE DOWN: Move to the next year.
• CTRL + HOME: Open the datepicker if closed.
• CTRL/COMMAND + HOME: Move to the current month.
• CTRL/COMMAND + LEFT: Move to the previous day.
• CTRL/COMMAND + RIGHT: Move to the next day.
• CTRL/COMMAND + UP: Move to the previous week.
• CTRL/COMMAND + DOWN: Move the next week.
• ENTER: Select the focused date.
• CTRL/COMMAND + END: Close the datepicker and erase the date.
• ESCAPE: Close the datepicker without selection.

---

---

[empty:]

[empty:]

SELECT
   fStart, fSourceName, fUser, fMeasurementTypeName
FROM AutoSchedule
LEFT JOIN Source USING (fSourceKey)
LEFT JOIN MeasurementType USING (fMeasurementTypeKey)
WHERE fStart
   BETWEEN ADDDATE('2024-11-21', INTERVAL +12 HOUR)
   AND ADDDATE('2024-11-21', INTERVAL +36 HOUR)
ORDER BY fStart

SELECT
   fStart, fSourceName, fUser, fMeasurementTypeName
FROM Schedule
LEFT JOIN Source USING (fSourceKey)
LEFT JOIN MeasurementType USING (fMeasurementTypeKey)
WHERE fStart
   BETWEEN ADDDATE('2024-11-21', INTERVAL +12 HOUR)
   AND ADDDATE('2024-11-21', INTERVAL +36 HOUR)
ORDER BY fStart

SELECT
   fRunID,
   fSourceName,
   fRunStart,
   fRunStop
FROM RunInfo
LEFT JOIN Source USING(fSourceKey)
LEFT JOIN AnalysisResultsRunLP USING (fNight, fRunID)
WHERE fNight=20241121
   AND NOT fRunStart='0000-00-00 00:00:00'
   AND NOT fRunStop='0000-00-00 00:00:00'
   AND fRunTypeKEY=1
   
ORDER BY fRunID

SELECT
   fRunID,
   fSourceName,
   fRunStart,
   fRunStop
FROM RunInfo
LEFT JOIN Source USING(fSourceKey)
LEFT JOIN AnalysisResultsRunLP USING (fNight, fRunID)
WHERE fNight=20241121
   AND NOT fRunStart='0000-00-00 00:00:00'
   AND NOT fRunStop='0000-00-00 00:00:00'
   AND fRunTypeKEY=1
   AND NOT ISNULL(fNumExcEvts)
ORDER BY fRunID