Improve Operations grimoire old content query
ClosedPublic
Actions

Authored by dereckson on Sep 19 2025, 21:51.

Details

Reviewers

dereckson

Commits

rRPRT1e344a8558d4: Improve Operations grimoire old content query

Summary

The last Rhyne-Wyse diff showed two issues with the current query:

report content NetBox and Netbox, one the page, one the redirect
order of pages for a same age isn't deterministic

Ignore redirects and sort first by the age, then by title.

This is a follow-up for 3c94fd688d3e.

Test Plan

run-report agora-operations-grimoire-older-pages

Diff Detail

Repository

rRPRT Nasqueron internal reports

Lint

Lint Not Applicable

Unit

Tests Not Applicable

Event Timeline

dereckson requested review of this revision.Sep 19 2025, 21:51

dereckson created this revision.

Harbormaster completed remote builds in B5918: Diff 9556.Sep 19 2025, 21:51

dereckson accepted this revision.Sep 19 2025, 21:52

This revision is now accepted and ready to land.Sep 19 2025, 21:52

Closed by commit rRPRT1e344a8558d4: Improve Operations grimoire old content query (authored by dereckson). · Explain WhySep 19 2025, 21:53

This revision was automatically updated to reflect the committed changes.

dereckson added a commit: rRPRT1e344a8558d4: Improve Operations grimoire old content query.

Revision Contents
Changeset List

Path

Size

sql/

db-B/

agora/

operations-grimoire-older-pages.sql

3 lines

Diff 9557

View Options

sql/db-B/agora/operations-grimoire-older-pages.sql

Improve Operations grimoire old content queryClosedPublicActions