aboutsummaryrefslogtreecommitdiffstats
path: root/sql/dump_reingest_spn.sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql/dump_reingest_spn.sql')
-rw-r--r--sql/dump_reingest_spn.sql4
1 files changed, 3 insertions, 1 deletions
diff --git a/sql/dump_reingest_spn.sql b/sql/dump_reingest_spn.sql
index 65a8796..a83125c 100644
--- a/sql/dump_reingest_spn.sql
+++ b/sql/dump_reingest_spn.sql
@@ -8,7 +8,9 @@ COPY (
AND ingest_file_result.ingest_type = ingest_request.ingest_type
WHERE
(ingest_request.ingest_type = 'pdf'
- OR ingest_request.ingest_type = 'html')
+ OR ingest_request.ingest_type = 'html'
+ OR ingest_request.ingest_type = 'xml'
+ OR ingest_request.ingest_type = 'component')
AND ingest_file_result.hit = false
AND ingest_request.created < NOW() - '6 hour'::INTERVAL
AND ingest_request.created > NOW() - '180 day'::INTERVAL