How do i use Laravel query an object based on an attribute (accessor) condition

Question

I use Accessor for my Model

public function getStatusAttribute($value) {
   switch ($value) {
      case 1:
         return 'Active';
         break;
      default:
         return 'Nonactive';
         break;
   }
}

How can I run a whereRaw based on a value? something like this:

if

$search = 'act';

$user = User::whereRaw("status like '%$search%'");

Is there a way to do this?

I expected, i can get User Data with status by searching similar 'active' or 'nonactive' , not '0' or '1'

Does this answer your question? eloquent search/where on custom attributes — Omi Shah
– Omi Shah, Commented Aug 30, 2023 at 10:16
make a select filter for active and nonactive and avoid this weird solution. — N69S
– N69S, Commented Aug 30, 2023 at 10:22

Toby Allen · Accepted Answer · 2023-09-03 09:59:39Z

0

You wont be able to do this exactly.

The database does not know about your custom attribute so you will need to do the filtering after all the items come back from the database or do the search yourself in code first. This is what was suggested in the comments.

answered Sep 3, 2023 at 9:59

Toby Allen

11.3k12 gold badges80 silver badges132 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How do i use Laravel query an object based on an attribute (accessor) condition

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related