Skip to content
Snippets Groups Projects

fix metrics tagging limiting by total check dates

Merged Audrey Hamelers requested to merge dev into master
1 file
+ 1
1
Compare changes
  • Side-by-side
  • Inline
@@ -125,7 +125,7 @@ with audits as (
from (
select aa.manuscript_id, aa.manuscript_version, ab.sent, aa.created, generate_series(ab.sent, aa.created - '1 day'::interval, '1 day'::interval) as date_range
from (
select * from tag_audits at
select at.manuscript_id, at.manuscript_version, at.created from tag_audits at
where at.created between date_trunc('month', current_date AT TIME ZONE 'Europe/London' - '${endMonth} month'::interval) and date_trunc('month', current_date AT TIME ZONE 'Europe/London' - '${startMonth -
1} month'::interval)
union