Query linked tables with filter in second table

[danbolinson]

I’ll just throw this here in case anyone wants to +1 this feature request…

Allow for nested subqueries in Data Tables query API

Hi! I often find myself trying to search the data tables based on the value of a linked row. It would be great to be able to do this using the Anvil query API. For example, say I have an app with a Users table and another Comments table with a single row reference to that Users table. Now (for some reason) I want to search my Comments table for all users that have a gmail address. I’d like to be able to: comments = app_tables.comments.search(users = q.any_of({'email': q.i_like('%@gmail.com')}…