From 848556a64d13955c2978bad352f2e2cd9edb62d0 Mon Sep 17 00:00:00 2001 From: Bryan Newbold Date: Wed, 3 Nov 2021 18:33:07 -0700 Subject: SPN reingest: 6 hour minimum, 6 month max --- sql/dump_reingest_spn.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'sql') diff --git a/sql/dump_reingest_spn.sql b/sql/dump_reingest_spn.sql index a8ed72f..6ef08c1 100644 --- a/sql/dump_reingest_spn.sql +++ b/sql/dump_reingest_spn.sql @@ -4,8 +4,8 @@ COPY ( LEFT JOIN ingest_file_result ON ingest_file_result.base_url = ingest_request.base_url WHERE ingest_request.ingest_type = 'pdf' AND ingest_file_result.hit = false - AND ingest_request.created < NOW() - '2 hour'::INTERVAL - AND ingest_request.created > NOW() - '31 day'::INTERVAL + AND ingest_request.created < NOW() - '6 hour'::INTERVAL + AND ingest_request.created > NOW() - '180 day'::INTERVAL AND ingest_request.ingest_request_source = 'savepapernow-web' AND ( ingest_file_result.status like 'spn2-%' -- cgit v1.2.3