- Модуль: mail
- Путь к файлу: ~/bitrix/modules/mail/lib/helper/mailbox/sharedmailboxesmanager.php
- Класс: BitrixMailHelperMailboxSharedMailboxesManager
- Вызов: SharedMailboxesManager::getBaseQueryForSharedMailboxes
static function getBaseQueryForSharedMailboxes()
{
$helper = MailboxAccessTable::getEntity()->getConnection()->getSqlHelper();
return MailboxAccessTable::query()
->registerRuntimeField('', new ReferenceField('ref', MailboxTable::class, ['=this.MAILBOX_ID' => 'ref.ID'], ['join_type' => 'INNER']))
->where(new ExpressionField(
'ac',
$helper->getConcatFunction("'U'", '%s'),
'ref.USER_ID'), '!=', new Column('ACCESS_CODE'))
->where('ref.ACTIVE', 'Y')
->where('ref.LID', SITE_ID);
}