{"flag":true,"single":true,"pageTitle":"Add where conditions in subquery laravel","post":{"id":311,"user_id":"1","slug":"laravel-query-and-sub-query-j2pt","title":"Add where conditions in subquery laravel","body":"<pre class=\"language-markup\"><code>$orders = \\App\\Models\\Woocommerce_orders::select('woocommerce_orders')\r\n            -&gt;with('tasks')\r\n            -&gt;orderByDesc('woo_id');\r\n\r\n$orders = $orders-&gt;whereDoesntHave('tasks', function ($q) {     \/\/ Exclude rows having ANY pending status in sub table\r\n        $q-&gt;where('status', 'pending');\r\n    })\r\n    -&gt;whereDoesntHave('tasks', function ($q) {     \/\/ Exclude rows having ANY NULL statuses\r\n        $q-&gt;whereNull('status');\r\n    })\r\n    -&gt;with(['tasks' =&gt; function ($q) {     \/\/ Eager load the tasks (all clean ones since bad ones are excluded already)\r\n        $q-&gt;latest('updated_at');\r\n    }]);\r\n<\/code><\/pre>","category_id":"2","is_private":"0","created_at":"2025-09-10T22:57:39.000000Z","updated_at":"2025-09-10T22:58:05.000000Z","category":{"id":2,"user_id":"1","name":"Laravel Core","slug":"laravel-nhyt","parent_id":"1","created_at":"2023-03-14T03:58:27.000000Z","updated_at":"2023-03-20T11:30:50.000000Z"},"user":{"id":1,"name":"R GONDAL","email":"rizikmw@gmail.com","email_verified_at":null,"two_factor_confirmed_at":null,"current_team_id":"1","profile_photo_path":null,"created_at":"2023-03-12T10:49:33.000000Z","updated_at":"2025-01-10T12:59:00.000000Z","profile_photo_url":"https:\/\/ui-avatars.com\/api\/?name=R+G&color=7F9CF5&background=EBF4FF"}},"pageDesc":"$orders = \\App\\Models\\Woocommerce_orders::select('woocommerce_orders')             -&gt;with('tasks')             -&gt;orderByDesc('woo_id') - Add where conditions in subquery laravel (Updated: September 10, 2025) - Read more about Add where conditions in subquery laravel at my programming site [SITE]","categories":[]}