- Модуль: ui
- Путь к файлу: ~/bitrix/modules/ui/lib/entityselector/dialog.php
- Класс: BitrixUIEntitySelectorDialog
- Вызов: Dialog::getGlobalUsages
private function getGlobalUsages(array $entities, int $limit = 200)
{
$query = EntityUsageTable::query();
$query->setSelect(['ENTITY_ID', 'ITEM_ID', 'MAX_LAST_USE_DATE']);
$query->setGroup(['ENTITY_ID', 'ITEM_ID']);
$query->where('USER_ID', $this->getCurrentUserId());
$query->whereIn('ENTITY_ID', $entities);
if ($this->getContext() !== null)
{
$query->whereNot('CONTEXT', $this->getContext());
}
$query->registerRuntimeField(new ExpressionField('MAX_LAST_USE_DATE', 'MAX(%s)', 'LAST_USE_DATE'));
$query->setOrder(['MAX_LAST_USE_DATE' => 'desc']);
$query->setLimit($limit);
return $query->exec();
}