Skip to Content

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.

Last updated on