I’d like to use the Data Explorer plugin to identify whether users are interacting with each other. I wrote a query to return the sender, recipient and a count for a provided date range, however it seems to be returning responses for topics. Any idea what I might be doing wrong? -- [params] -- int …

I added a notification_type of 6 (private_message) to get this to work: AND n.notification_type = 6

ユーザー間のプライベートメッセージのやり取りを特定する

sonicb (Pete Black) 2020 年 10 月 13 日午後 4:47 2

これを機能させるために、notification_type を 6（private_message）に追加しました：

AND n.notification_type = 6

「いいね！」 1

トピック		返信	表示
Tracking who sent private messages Data & reporting sql-query	2	3016	2018 年 8 月 25 日
Dashboard Report - User-to-User Data & reporting dashboard-reports , sql-query , dashboard-sql	0	532	2023 年 12 月 13 日
Who messaged the most? Data & reporting sql-query	10	3010	2022 年 11 月 20 日
Dashboard Report - Notify User Data & reporting dashboard-reports , sql-query , dashboard-sql	0	282	2024 年 1 月 17 日
Polling specific users for their activity Data & reporting sql-query	3	540	2020 年 4 月 15 日