Notifications query

[Jaya Santosh Kumar Patchipulusu]

Under Home --> Organizer --> Notifications tab.

I'm trying to use the below query to get the data which is shown in Notifications tab, but i'm missing something.

SELECT
notif.*
FROM clb_notifications notif
JOIN clb_notification_prefs pref ON pref.user_id = notif.receiver_id
WHERE 1=1

This table clb_notifications  is enough to pull Functional area, Message, Senton, Sender, but the number of records are not matching.

Please help.

[Karl Shlayfman]

Hi Jaya, If you like to know exact query for Under Home --> Organizer --> Notifications tab I would suggest to set SQL Trace and then navigate to that page so you can see query which is executed behind to get that data. Hope this helps.