XF 2.1 Filter by 2 different fields

[Cupara]

On an admin page, I have 2 fields that I need the filter to search through and return any results.

I have this:

$finder->where('home_team', 'LIKE', $finder->escapeLike($filter['text'], $filter['prefix'] ? '?%' : '%?%'));

It works perfect but if I do the following:

$finder->where(['home_team', 'away_team'], 'LIKE', $finder->escapeLike($filter['text'], $filter['prefix'] ? '?%' : '%?%'));

The above returns an error of using an array instead of string.

Or:

$finder->where('home_team', 'LIKE', $finder->escapeLike($filter['text'], $filter['prefix'] ? '?%' : '%?%'))->where('away_team', 'LIKE', $finder->escapeLike($filter['text'], $filter['prefix'] ? '?%' : '%?%'));

The above returns 0 matches which I know there are matches.

 

[Bespoke]

The above returns 0 matches which I know there are matches.

Are you after results where both home_team and away_team match the search or are you after results where either one have a match?
I'm wondering if you are after a whereOr rathet than two where clauses?

Entities, finders and repositories | XenForo

There are a number of ways to interact with data within XF2. In XF1 this was mostly geared towards writing out raw SQL statements inside Model files. The approach in XF2 has moved away from this, and we have added a number of new ways in its place. We'll first look at the preferred method for...

xenforo.com

 

[Cupara]

I'm after results where either one have matches

 

[Jeremy P]

Then you'd need to use whereOr() as @Bespoke suggested, otherwise it will only return results where both have matches. Something like:

$finder->whereOr([
    ['home_team', 'LIKE', $finder->escapeLike($filter['text'], $filter['prefix'] ? '?%' : '%?%')],
    ['away_team', 'LIKE', $finder->escapeLike($filter['text'], $filter['prefix'] ? '?%' : '%?%')]
]);

 

[Cupara]

Then you'd need to use whereOr() as @Bespoke suggested, otherwise it will only return results where both have matches. Something like:

$finder->whereOr([
    ['home_team', 'LIKE', $finder->escapeLike($filter['text'], $filter['prefix'] ? '?%' : '%?%')],
    ['away_team', 'LIKE', $finder->escapeLike($filter['text'], $filter['prefix'] ? '?%' : '%?%')]
]);

I've tried that but got an error. I'll try it again, maybe I did something wrong the first time. I'll post back results.

 

[Cupara]

Yep, that worked. Thanks @Jeremy P and @Bespoke

I must have done the whereOr improperly which is why it didn't work for me originally.