How to get the last entry of a Laravel model which is not NULL on a certain column (Laravel 11)

Question

I would like to get back within a with() the last entry of a modal which is not null on a certain column.

I know that it is possible to simply get the last entry with the following function in the model, but I have not found a way to add a condition.

public function firstCheckedChecklistItem() { return $this->hasOne('App\Models\CheckedChecklistItem')->latestOfMany(); }

This can for example be used like this: $groupMachines = Machine::where('group_id', $group_id)->with('machineType.checklistGroup.currentChecklists.checklistItem.firstCheckedChecklistItem')->get();

With the function described above I only get the last entry, but what I expect would be that I get the last entry which is not NULL in the column done_by

Important is, that i need the last entry in a with()

UnderIdentityCrisis · Accepted Answer · 2024-10-16 07:31:06Z

0

but I have not found a way to add a condition.

You can add the condition in you model function firstCheckedChecklistItem() or inside with function itself

public function firstCheckedChecklistItem() { 
    return $this->hasOne('App\Models\CheckedChecklistItem')
         ->whereNotNull('done_by')
         ->latestOfMany(); 
}

  ->with(['machineType.checklistGroup.currentChecklists.checklistItem.firstCheckedChecklistItem' => function($query) {
       $query->whereNotNull('done_by');
  }])

Reference: How to access model hasMany Relation with where condition?

answered Oct 16, 2024 at 7:31

UnderIdentityCrisis

866 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to get the last entry of a Laravel model which is not NULL on a certain column (Laravel 11)

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related