---

SELECT
    id,
    name,
    to_portal,
    chat_idx
FROM mail.list_group_recipients
WHERE to_portal = true
  AND chat_idx IS NOT NULL;



BEGIN;

SELECT mail.api_new_message_group(
    'TEST_PORTAL_GROUP_CHECK',
    'Тест проверки настроек группы',
    <ID_ГРУППЫ>
);





SELECT
    title,
    notification_type,
    group_recipients_id,
    portal_chat_id_list,
    list_recipient,
    list_recipient_ui,
    status,
    status_email,
    status_portal
FROM mail.list_mails
WHERE title = 'TEST_PORTAL_GROUP_CHECK';




ROLLBACK;