Level 6
you can achieve this with a closure:
$absent_users = User::whereDoesntHave('activities', function ($query) {
$query->where('date', '>=', '2022-10-01');
})->get();
1 like
Oct 4, 2022
4
Level 3
Query relationship absence after specific date
I have a users table and a activity_log table. When a user logs in/out, a record is created in the activity_log table.
How can I query users that have had no activity after a certain date? I know I can do:
$absent_users = User::whereDoesntHave('activities')->get();
How can I expand on this to say "return users with no activity logs after 2022-10-01", for example?
Level 3
@Dunsti this is exactly what I was after! Thank you so much.
Level 12
You can find more options here https://laravel.com/docs/9.x/eloquent-relationships#querying-relationship-existence
@dunsti's comment will get you what you want but If you don't like closures, you can try this
User::has('activities', '>=', '2022-10-01')->get();
Level 55
@ekpono wrrong answer. Read more by your link
I think what you're trying to suggest is https://laravel.com/docs/9.x/eloquent-relationships#inline-relationship-existence-queries
$posts = Post::whereRelation('activities', 'date', '>=', '2022-10-01')->get();
But need negative condition here, not sure if it exists
Please or to participate in this conversation.