• Модуль: tasks
  • Путь к файлу: ~/bitrix/modules/tasks/lib/update/taskchecklistconverter.php
  • Класс: BitrixTasksUpdateTaskCheckListConverter
  • Вызов: TaskCheckListConverter::getEntitiesIdsToConvert
static function getEntitiesIdsToConvert()
{
	$ids = [];

	$connection = Application::getConnection();
	$tasksRes = $connection->query("
		SELECT I.TASK_ID, IF(T.STATUS = 5 OR T.STATUS = 6, 1, 0) as SORT
		FROM b_tasks_checklist_items I
			INNER JOIN b_tasks T on T.ID = I.TASK_ID
		WHERE I.TITLE = '==='
		GROUP BY I.TASK_ID
		ORDER BY SORT, I.TASK_ID DESC
		LIMIT 10
	");

	while ($task = $tasksRes->fetch())
	{
		$ids[] = $task['TASK_ID'];
	}

	return $ids;
}