# Bug 3039: Filter-by-Subquery

- Status: closed
- Project: Zero
- Creator: @aboodman
- Labels: alpha-blocker, zero
- Created: 2024-10-10T00:47:25Z
- Modified: 2024-11-18T20:31:06Z
- URL: https://bugs.rocicorp.dev/p/zero/issue/3039

## Description

You can select by subquery now, but can't filter by subquery. 

This is very often needed for read auth, and for all kinds real apps. For example zbugs needs this to properly implement filter-by-label. Right now filter-by-label works in zbugs by denormalizing the data.

## Comments (0)