Using multiple where-clauses

[Brotzka]

Hi!

Is it possible to user multiple where clauses on entities using attributes? Like so:

$users = App\Product::where(
    ['color','=','black'],
    ['power', '>','200'],
    ['max_speed','>','260']
)->get();

Thanks in advance!

[IsraelOrtuno]

Yes it is, but you cannot use the where directive like that, it's a caveat. As mentioned in the docs (https://github.com/rinvex/attributes#querying-models), you should use the whereHas method. Every attribute acts as a relationship, so they can be queried that way:

$companies = Company::whereHas('Cities', function (\Illuminate\Database\Eloquent\Builder $builder) {
    $builder->where('content', 'Alexandria');
})->get();