From a18663058fef7f73593d134d110f88cde9a5dfe0 Mon Sep 17 00:00:00 2001
From: Louis Jeckel <louis.jeckel@outlook.cm>
Date: Tue, 15 Sep 2020 16:53:43 +0200
Subject: [PATCH] Update FailedMailgun.php

---
 app/Nova/Lenses/FailedMailgun.php | 6 +++++-
 1 file changed, 5 insertions(+), 1 deletion(-)

diff --git a/app/Nova/Lenses/FailedMailgun.php b/app/Nova/Lenses/FailedMailgun.php
index ad3522c..674e770 100644
--- a/app/Nova/Lenses/FailedMailgun.php
+++ b/app/Nova/Lenses/FailedMailgun.php
@@ -2,6 +2,7 @@
 
 namespace App\Nova\Lenses;
 
+use App\EmailBatch;
 use Illuminate\Http\Request;
 use Illuminate\Support\Arr;
 use Laravel\Nova\Fields\DateTime;
@@ -23,7 +24,10 @@ class FailedMailgun extends Lens
     {
         return $request->withOrdering($request->withFilters(
             $query->whereHas('lastMailgunEvent', function($builder) {
-                $builder->where('event', 'failed');
+                $builder->where('event', 'failed')->where(
+                    'email_batch_id',
+                    EmailBatch::query()->orderByDesc('id')->firstOrFail()->id
+                );
             })
         ));
     }
-- 
2.39.5