• Модуль: 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);
}