21 lines
532 B
SQL
21 lines
532 B
SQL
CREATE OR REPLACE FORCE VIEW user_messages_chats AS
|
|
SELECT
|
|
m.app_id,
|
|
m.user_id,
|
|
m.session_id,
|
|
--
|
|
COUNT(*) AS count_messages,
|
|
COUNT(DISTINCT m.created_by) AS count_users,
|
|
--
|
|
MIN(m.created_at) AS start_at,
|
|
MAX(m.created_at) AS end_at,
|
|
--
|
|
'OPEN_CHAT' AS action_open,
|
|
'CLOSE_CHAT' AS action_close
|
|
FROM user_messages m
|
|
WHERE m.message_type = 'CHAT'
|
|
GROUP BY m.app_id, m.user_id, m.session_id;
|
|
--
|
|
COMMENT ON TABLE user_messages_chats IS '';
|
|
|