From 8bf6ec23e9652bfb5169708d9fd8877a1b50465c Mon Sep 17 00:00:00 2001
From: Louis Jeckel <louis.jeckel@outlook.cm>
Date: Wed, 23 Sep 2020 11:58:17 +0200
Subject: [PATCH] Update AllFailedMailgun.php

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

diff --git a/app/Nova/Lenses/AllFailedMailgun.php b/app/Nova/Lenses/AllFailedMailgun.php
index 0384e42..92f707a 100644
--- a/app/Nova/Lenses/AllFailedMailgun.php
+++ b/app/Nova/Lenses/AllFailedMailgun.php
@@ -18,7 +18,11 @@ class AllFailedMailgun extends FailedMailgun
      */
     public static function query(LensRequest $request, $query)
     {
-        return $request->withOrdering($request->withFilters($query));
+        return $request->withOrdering($request->withFilters(
+            $query->whereHas('lastMailgunEvent', function($builder) {
+                $builder->where('event', 'failed');
+            })
+        ));
     }
     /**
      * Get the URI key for the lens.
-- 
2.39.5