Using OR and AND at the same query

[pedrommone]

For example, we have a small service for blog posts management and a blog itself.

At our search, we want to do the following query:

            'query' => [
                'mode' => 'or',
                'city' => "%$query%",
                'state' => "%$query%",
                'store_name' => "%$query%",
                'title' => "%$query%",
            ],

Thats nice, it will search for everything we need but we want to filter by published posts also. But, Its not possible since we're using OR mode.

Is there a way to make something like?

            'query' => [
                'mode' => 'and',
                'status' => 'published',
                [
                    'mode' => 'or',
                    'city' => "%$query%",
                    'state' => "%$query%",
                    'store_name' => "%$query%",
                    'title' => "%$query%",
                ],
            ],

[fahjan]

good idea @pedrommone . i think the developer can add this trick 👍