This is an SQL version of the Dashboard Report for System. This dashboard report provides a daily count of the number of personal messages sent automatically by the system. -- [params] -- date :start_date = 2024-01-01 -- date :end_date = 2025-01-01 SELECT DATE(created_at) AS day, COUNT(*) AS …

Can this be tied to a specific PM, like the welcome PM? I’d like to know how many of those go out daily. Thoughts?

[صورة] Jumanji: Can this be tied to a specific PM, like the welcome PM? Yes, the best way to add this in would be to add a section to the WHERE statement in the query, filtering by topic title. For example: WHERE archetype = 'private_message' AND subtype = 'system_message' AND created_a…

Oh this is awesome. Thanks so much! I’ll give this a try!

تقرير لوحة التحكم - النظام

مجتمع البيانات والتقارير

Jumanji 12 مارس 2024، 11:31م 2

هل يمكن ربط هذا بـ PM محدد، مثل PM الترحيب؟

أود أن أعرف عدد هذه التي يتم إرسالها يوميًا.

أفكار؟

الموضوع		الردود	مرات العرض
Dashboard Report - Notify User Data & reporting sql-query , dashboard-reports , dashboard-sql	0	344	17 يناير 2024
Dashboard Report - User-to-User Data & reporting sql-query , dashboard-reports , dashboard-sql	0	580	13 ديسمبر 2023
Dashboard Report - Notify Moderators Data & reporting sql-query , dashboard-reports , dashboard-sql	0	352	17 يناير 2024
SQL query to get the queue of all the PMs in the system Support	2	2094	27 يناير 2016
Identify private message interactions between users Data & reporting sql-query	1	904	13 أكتوبر 2020

تقرير لوحة التحكم - النظام

الموضوعات ذات الصلة