Level 73
You can use whereIn.
1 like
Oct 12, 2019
9
Level 13
Shorter version of this query
$query->whereNotIn('id',
Animal::where([category' => 'animal', 'type' => 'dog'])
->orWhere(['category' => 'animal', 'type'=>'bear'])->pluck('animal_id')->all()
)->orWhereIn('id', Animal::where(
['category' => 'animal', 'type' => 'cat']
)->pluck('animal_id')->all())
->get();
Say i have House and Animal model and having five type of animal 'Cat','Bear','Dog','Eagle','Scorpion' in House Model i want to grab only cat and rest except dog and bear (in feature i will add more), This query works but i think it so long.
Level 122
your ->all() statements are redundant
1 like
Level 122
i want to grab only cat and rest except dog and bear
sorry but this makes no sense...
Level 13
@snapey Ok , Is there any method that i can reduce this two where clause:
Animal::where([category' => 'animal', 'type' => 'dog'])
->orWhere(['category' => 'animal', 'type'=>'bear'])
looking for something like this :
Animal::where([category' => 'animal', 'type' =>[ 'dog','bear'])
Level 122
Animal::where('category', 'animal')
->wherein('type' ,[ 'dog','bear'])
->get()
1 like
Level 13
Thanks guys i feel better right now <3
Level 122
please mark it answered (if it is)
Level 13
removing ->all() and adding wherein helped, But these are in separate replies 😆 sorry but these really helped me, i appreciated.
Level 122
removing all() was irrelevant in the end since the whole query was different
Please or to participate in this conversation.