[BUG]: `where` property not available for `with`

[alexturpin]

[BUG]: `where` property not available for `with`

[Angelelz]

This is expected behavior if the relation is to-one, which seems to be your case. You don't need to filter the results if you know there's only one related card. Please confirm so we can close the issue

[alexturpin]

Ah my apologies, I misunderstood how this is meant to behave. I thought this would filter on the transactions with such a card, like if they were inner joined.

[Angelelz]

For now there's no first class support for filters on nested relations. But you can work around that by using a subquery in the outside where condition.

[alexturpin]

Ah interesting! For now I used a standard select with inner joins but I appreciate the tip.

[jeremyjacob]

I think there is a use case here for where: filters on one-to-one relationships: Verifying that the joined record matches the parent record's tenant id or test/live mode status.

An example would be if multiple customers' data were stored in a single database. It might be helpful to have that additional level of assurance that an incorrect ID would not send the wrong customer's data in the response.