How do I specify an IN clause in laravel backpack?

Question

How do I add an IN clause in laravel with backpack?

This is what I am looking for:

$this->crud->addClause('where', 'customer_id', 'in', [1,3,5,6,7]);`

Should translate into something like this:

select * from customer where customer_id in (1,3,5,6,7);

Welcome to Stack Overflow! I edited the title to specify exactly what you are looking for, and so others can find it easily. I also indented your code by 4 spaces so that it is rendered as code. You can read [here](https://stackoverflow.com/editing-help) for more information on formatting. — ldam, Oct 15 '18 at 14:18

score 2 · Answer 1 · answered Oct 18 '18 at 23:45

2

Just use whereIn instead of where, backpack-for-laravel is ready for that:

$this->crud->addClause('whereIn', 'customer_id', [1,3,5,6,7]);

answered Oct 18 '18 at 23:45

António Almeida

How can you do `whereIn, 'field1'` or `whereIn, 'field2'` ? – Pierre Aug 24 '23 at 15:51

score 0 · Answer 2 · answered Oct 16 '18 at 08:13

0

select * from customer whereIn (customer_id ,$array);

answered Oct 16 '18 at 08:13

bing

No, its not that case, iam using a package called backpack, and inside the controller crud I have to use his features to filter data. its not only laravel. – Guilherme Schmidt Oct 18 '18 at 13:42

2 Answers2