Level advancements: email limited to 31 US tunnels, report paginated and faster
Shipped 2026-11-04
Follow-ups from ops after the first week of the level advancements report and its weekly email.
The email covers 31 US iFLY tunnels
The weekly email now includes only members whose home tunnel is on ops’ list of 31 US iFLY tunnels, and names them under the intro. The admin report is unchanged and still shows every tunnel, so the two can differ for the same week. Rules are on Reports and scheduled emails.
The admin report paginates
Results are shown 50 per page (100 or 500 selectable), like other reports.
Faster queries
Migration 0023 indexes channel_logbook.approval_date. The report looks for
approvals in a date range, which without the index read all 1.3 million logbook
rows: one week took about 770ms, and 8ms with it. It is applied on deploy, and
skips if an index on that column already exists.
Also
The first email arrived on a Wednesday because it was the job’s first run after go-live and last week had not been sent. From now on it sends on Mondays.