New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Using OR and AND at the same query #42

Open

pedrommone opened this issue May 23, 2018 · 1 comment

pedrommone commented May 23, 2018

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 commented May 24, 2018

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

lloy0076 mentioned this issue

Feature/allow separate and parameters & Fix Relation with Or #49

Open

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment