Filter by one argument with both field and callback

[stefanozoffoli]

Hi,

I have a table with this searchConfiguration:

    public function searchConfiguration() {
        $search = new Manager($this);

        $search
            ->like('q', [
                'before' => true,
                'after' => true,
                'field' => [
                    $this->aliasField('code'),
                    $this->aliasField('company_name'),
                    $this->aliasField('first_name'),
                    $this->aliasField('last_name'),
                ],
            ])
            ->callback('q', [
                'callback' => function ($query, $args, $manager) {
                    $query
                        ->orWhere([
                            'Clients.id IN' => $this->Contacts->find('search', $this->Contacts->filterParams($args))
                                ->select([
                                    'Contacts.foreign_id',
                                ]),
                        ]);
                }
            ]);

        return $search;
    }

The second filter callback('q') overwrites the first filter like('q').
Is it possible to have both working at the same time?

[burzum]

I don't think so, AFAIK they don't stack. I like the idea but now sure how easy and quick it can be done. As a workaround you could simply just do your own LIKE query inside your callback()'s query.

[dereuromark]

Can we have a test here to proof this is currently working or not working as expected?
Then we can figure out how to solve it.

[dereuromark]

Yeah, a custom one is needed here (or different keys) as the key is the one deciding which filter will be used, so must be unique.