Skip to content
Snippets Groups Projects

found error in metrics report query

Merged Charlotte Hausman requested to merge fix_metrics_date_range into main
1 file
+ 2
1
Compare changes
  • Side-by-side
  • Inline
@@ -46,9 +46,10 @@ OPERATIONS = Query(
JOIN capability_requests cr on cv.capability_request_id = cr.capability_request_id""",
"WHERE cr.ingested = True",
[
"AND updated_at between %(beginning)s and %(end)s",
"GROUP BY cv.capability_request_id, cv.capability_name, external_name, eb.band_code,"
" mjd_to_timestamp(eb.starttime), cr.updated_at, science_products.is_srdp,"
" cr.stage_1_reviewer, cr.stage_2_reviewer"
" cr.stage_1_reviewer, cr.stage_2_reviewer",
],
)
# OPERATIONS_COUNT = Query(
Loading