MissedReaction::getQueryForReport

public function getQueryForReport($startDate, $finishDate, $previousStartDate, $previousFinishDate, $filterParameters): Query
{
	$subQuery = $this->getBaseQuery($previousStartDate, $previousFinishDate, $filterParameters);
	$query = $this->getBaseQuery($startDate, $finishDate, $filterParameters);

	$query->registerRuntimeField(new ReferenceField(
		'previous',
		BitrixMainEntityBase::getInstanceByQuery($subQuery),
		Join::on('this.PORTAL_USER_ID', 'ref.PORTAL_USER_ID')
	));

	$query->addSelect('AVG_RESPONSE_TIME_COMPARE');
	$query->registerRuntimeField(new ExpressionField(
		'AVG_RESPONSE_TIME_COMPARE',
		'%s - %s',
		['AVG_RESPONSE_TIME', 'previous.AVG_RESPONSE_TIME']
	));

	$query->addOrder('CALL_MISSED', 'DESC');

	return $query;
}