filter notifications from 'notifications' table 'data' field - Laravel

Question

This is the default laravel notifications data field

{
  "type":"Update Appointment",
  "appointment_id":"379",
  "date":null,
  "updated_by":"Mahir",
  "status":"2"
}

In controller i want to get all notifications with status = 2 and mark as read

Laravel 5.3 doc shows

$user = App\User::find(1);

foreach ($user->unreadNotifications as $notification) {
    $notification->markAsRead();
}

How do i modify this to get all notifications with status = 2

Update : looking for something like this

$noti = $user->unreadNotifications->where('data->status',"2");

Note : my database doesn't support json data type.

seriously, know one answered :(

Ja22
– Ja22

2017-08-30 08:25:40 +00:00
Commented Aug 30, 2017 at 8:25 — Ja22
– Ja22, Commented Aug 30, 2017 at 8:25

Hamed Yarandi · Accepted Answer · 2018-07-23 13:20:03Z

5

According to laravel 5.6: JSON Where Clauses

and work with MySQL 5.7

I hope this answer help you

answered Jul 23, 2018 at 13:20

Hamed Yarandi

1,2291 gold badge14 silver badges21 bronze badges

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

Comments

Suraj Rao · Accepted Answer · 2021-01-30 12:56:21Z

2

$user = $user->unreadNotifications->where('data.complaint_id',1);

Its work fine for me, I hope it's helpful for you.

edited Jan 30, 2021 at 12:56

Suraj Rao

29.7k11 gold badges96 silver badges104 bronze badges

answered Jan 30, 2021 at 12:49

Nadeem Ahmed

365 bronze badges

Comments

Yuriy Piskunov · Accepted Answer · 2017-10-23 07:53:37Z

1

I think, you can create your own channel, (see also Illuminate\Notifications\Channels\DatabaseChannel), where you can override send() method, for saving your notifications. Before that, you can write your migration to update "notifications" table to add your custom filtering field. See: https://laravel.com/docs/5.5/notifications#custom-channels

Sorry for my English. Hope, you'll understand.

answered Oct 23, 2017 at 7:53

Yuriy Piskunov

1,2249 silver badges12 bronze badges

Collectives™ on Stack Overflow

filter notifications from 'notifications' table 'data' field - Laravel

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related