Добрый день. Я решил обычным SQL запросом.
На портале-администрирование-настройки-инструменты-SQL запрос -выполнить запрос указанный ниже.
Учтите, что в параметре запроса SEL ECT ID, 1 as DEF FR OM b_user WHERE ID IN (необходимо ввести ID пользователя)
SEL ECT
us.ID,
CONCAT( us.LAST_NAME, ' ', us.NAME) as USER_NAME,
CASE
WHEN mb.ACTIVE = 'Y' THEN 'Подключен'
WHEN mb.ACTIVE = 'N' THEN 'Отключился'
WHEN mb.ACTIVE is NULL or mb.ACTIVE = '' THEN 'Не подключен'
ELSE 'N/A'
END as STATUS_CONN,
mb.NAME as EMAIL,
CASE
WHEN user_list.DEFINITELY = '0' THEN 'Инициативно'
WHEN user_list.DEFINITELY = '1' THEN 'Обязательно'
ELSE 'N/A'
END as DEFINITELY,
us.WORK_POSITION,
us.WORK_DEPARTMENT
FROM
(SELECT ID, MAX(DEF) as DEFINITELY
FR OM (
SELECT ID, 1 as DEF FR OM b_user WH ERE ID IN (696,2756,782,1064,1057,861,1060,741,1051,1959,1730,1601,1185,1061,925,934,855,805,776,748,713,759)
UNI ON ALL
SEL ECT USER_ID as ID, 0 as DEF FR OM b_mail_mailbox WH ERE ACTIVE IN ('Y', 'N')
) tmp_user_list
GROUP BY ID
) user_list
LEFT JOIN b_user us
ON user_list.ID = us.ID
LEFT JOIN b_mail_mailbox mb
ON user_list.ID = mb.USER_ID
ORDER BY mb.ACTIVE, user_list.DEFINITELY, us.LAST_NAME