Skip to content

Validate citation pointers after a table transformation

Ensure every retained citation still resolves to the correct permitted evidence row.

Guides

Validate citation pointers after a table transformation — what should the operator record?

A transformation can preserve every source URL yet break the connection between a statement and the evidence row supporting it. Check citation pointers after sorting, filtering or flattening. The goal is operational referential integrity, not a new judgment about whether the cited statement is substantively correct.

Practical operations check
Ensure every retained citation still resolves to the correct permitted evidence row.
Use statement_ref, evidence_row_key and input_revision in the local citation index. A spreadsheet row number is not a durable evidence pointer because sorting can move the record while leaving the number-looking reference in a copied note unchanged.
Record citation_index_revision and the unresolved pointer list alongside the derived table. A source link being clickable does not by itself establish that the linked record is the one intended by a particular local statement reference.
01 / Guides

Define the pointer contract

Use statement_ref, evidence_row_key and input_revision in the local citation index. A spreadsheet row number is not a durable evidence pointer because sorting can move the record while leaving the number-looking reference in a copied note unchanged.

02 / Guides

Inspect pointer targets

Resolve each permitted evidence_row_key against the declared input revision. Classify targets as present, withheld or unresolved rather than replacing a missing target with a similarly titled record from a newer table or another research session.

03 / Guides

Test a sorting fixture

Use labeled source rows with different keys and deliberately reorder them. The same statement_ref should still identify the intended evidence object after sorting, proving the relationship depends on explicit keys rather than its original screen position.

04 / Guides

Review broken relationships

For an orphaned pointer, inspect the transformation ledger to determine whether a key changed, a row was filtered out or access now prevents resolution. Keep the supported cause separate from guesses about the underlying publisher or source content.

05 / Guides

Release the checked index

Record citation_index_revision and the unresolved pointer list alongside the derived table. A source link being clickable does not by itself establish that the linked record is the one intended by a particular local statement reference.

Keep the boundaries clear.

  • Ensure every retained citation still resolves to the correct permitted evidence row.
  • Operational record: Define the pointer contract. Context badges do not certify access.

Start with a read-only check: ask your agent to report actual source coverage before collecting records or exporting an audience.

Primary references

Documentation reviewed 2026-11-15. Product capabilities, client availability and plans can change. Third-party marks identify their products, not an affiliation.

Know what social media shows about you.
Start with a question.

Get started
montage