Pipeline Orgs

Org names that have content, for the filter dropdown.

Its own endpoint, fetched once when the tab mounts, rather than a fifth query inside every summary call — the old dashboard re-ran this unbounded scan on each of its 30-second auto-refreshes.

EXISTS rather than a join: it short-circuits on the first matching row per org and can use the org-leading partial index ix_content_org_created_id, instead of scanning every live content row and then de-duplicating.

DISTINCT is still required. organizations.name carries no unique constraint, so two orgs can share a name; without it the dropdown renders the name twice with duplicate React keys. (Both entries would filter identically, since the queries below match on o.name.)