“내 스레드” 링크/버튼을 없앨 수 있을까요?

지원
7

스레딩이 아직 활성화된 채팅이 있나요? 모든 DM 채팅을 확인해 보셨나요?

아래 데이터 탐색기 쿼리를 사용하면 스레딩이 활성화된 모든 채팅을 찾을 수 있습니다.

-- [params]
-- user_id      :user_id 


WITH memberships AS (
  SELECT
    uccm.user_id,
    cc.id AS chat_channel_id,
    cc.type AS channel_type,
    cc.name AS channel_name,
    cc.description,
    cc.threading_enabled
  FROM
    user_chat_channel_memberships uccm
  JOIN
    chat_channels cc ON uccm.chat_channel_id = cc.id
  WHERE
    uccm.user_id = :user_id
    AND cc.threading_enabled = TRUE
)
SELECT
  m.chat_channel_id,
  COALESCE(
    NULLIF(m.channel_name, ''),
    (
      SELECT string_agg(u.username, ', ')
      FROM user_chat_channel_memberships uccm2
      JOIN users u ON uccm2.user_id = u.id
      WHERE uccm2.chat_channel_id = m.chat_channel_id
        AND uccm2.user_id <> m.user_id
    )
  ) AS sidebar_name,
   m.channel_type,
  ('/chat/c/-/' || m.chat_channel_id) AS chat_url
FROM memberships m
ORDER BY m.channel_type, sidebar_name