Preserve the evidence behind an analysis

Keep the captures behind a topic investigation available for follow-up questions.

SQL

SELECT DISTINCT c.capture_id
FROM captures AS c
INNER JOIN search_matches('battery recycling') AS s
  ON c.capture_id = s.capture_id;

Open in SQL workspaceLoads without running

What you get

Exact capture IDs for matching documents. Use this SQL to create a pin and choose how many days to keep them.

Adapt it

Refine the topic and add source or date filters before pinning a large set. search_matches avoids the ranked search helper’s top-100 cap.

Notes

This can select several captures of the same page. Normal query and pin limits still apply. Running SQL does not keep anything; the pin runs it once when created and locks in that exact result. Captures without a pin are scheduled for deletion seven days after collection.

Create a pin