multiple-filter-on-same-field-with-alternative.php

<?php

declare(strict_types=1);

// all posts whose title contains "foo" and "bar", or whose title contains "baz"
return [
    'SELECT post1 FROM GraphQLTests\Doctrine\Blog\Model\Post post1 WHERE (post1.title LIKE :filter1 AND post1.title LIKE :filter2) OR post1.title LIKE :filter3',
    \GraphQLTests\Doctrine\Blog\Model\Post::class,
    [
        'groups' => [
            [
                'groupLogic' => 'OR',
                'conditionsLogic' => 'AND',
                'conditions' => [
                    [
                        'title' => [
                            'like' => [
                                'value' => '%foo%',
                                'not' => false,
                            ],
                        ],
                    ],
                    [
                        'title' => [
                            'like' => [
                                'value' => '%bar%',
                                'not' => false,
                            ],
                        ],
                    ],
                ],
            ],
            [
                'groupLogic' => 'OR',
                'conditionsLogic' => 'AND',
                'conditions' => [
                    [
                        'title' => [
                            'like' => [
                                'value' => '%baz%',
                                'not' => false,
                            ],
                        ],
                    ],
                ],
            ],
        ],
    ],
    [],
];