I have write the same code that Jeffrey wrote but when I add the both search and category it retrieves all the posts that include the search word even if they are not in the category that I add it's slug to the search

the code is

$query->when($filters['search'] ?? false, fn ($query,$search)=>
            $query->where('title','like','%'. $search.'%')
                ->orWhere('body','like','%'. $search.'%'));

$query->when($filters['category'] ?? false, fn ($query,$category)=>
        $query->whereHas('category', fn ($query) => $query->where('slug', $category))
        );

	-- SQL statement generated by Laravel
SELECT
    *
FROM
    `posts`
WHERE
    (
        `title` like '%est%'
        or `body` like '%est%'
        and exists (
            SELECT
                *
            FROM
                `categories`
            WHERE
                `posts`.`category_id` = `categories`.`id`
                and `slug` = 'repudiandae-tenetur-nobis-excepturi-quae'
        )
    ) -- it must not be placed here
ORDER BY
    `created_at` DESC

The problem is that the parentheses must be closed between the OR it is including the exists in the same parentheses. The following sql statement is the correct one but how can I implement it in Laravel?

SELECT
    *
FROM
    `posts`
WHERE
    (
        `title` like '%est%'
        or `body` like '%est%') -- it must be placed here
        and exists (
            SELECT
                *
            FROM
                `categories`
            WHERE
                `posts`.`category_id` = `categories`.`id`
                and `slug` = 'repudiandae-tenetur-nobis-excepturi-quae'
        )
    
ORDER BY
    `created_at` DESC

Advanced Eloquent Query Constraints

Updated Series Available