Adding WHERE clause to a relation

[salain]

HI,

Is there anyway to add a WHERE clause to a relation?
For example retrieve all authors details with all of their posts created in 2020.

[MGatner]

Yes. You can use all the usual Query Builder methods intermixed with Relations methods.

[salain]

Sorry, but could you give an example as I can not get it to work.
If I have this and want to filter posts on year 2020:

$author = $authorModel->with('posts')->where('year', '2020')->findAll();

I get error column year not found in where clause

[MGatner]

Maybe try 'posts.year' instead? I cannot dig into this right now but you could try the CodeIgniter forums for help.

[salain]

Adding the table name does not work as it adds the where clause to the main query.
I will try to find a workaround for this.

Thanks

[MGatner]

Ahh I see what you mean now. No, this is not currently possible, though we've had requests for handling content from join tables and this would overlap with conditional relationships. I will consider it a feature request.

[salain]

Thanks.
I have a basic workaround to suite my tests for now.