DealIdle::prepareHistoryQuery

static function prepareHistoryQuery($startDate, $endDate, $typeID, $ownerFieldReference = '%s', $postfix = '')
{
	$query = new Query(DealStageHistoryTable::getEntity());
	if($postfix !== '')
	{
		$query->setTableAliasPostfix($postfix);
	}
	$query->addFilter('=TYPE_ID', $typeID);
	$query->addFilter('>=CREATED_DATE', $startDate);
	$query->addFilter('<=CREATED_DATE', $endDate);
	$query->addFilter('=OWNER_ID', new SqlExpression($ownerFieldReference));
	if(!(Main\Application::getConnection() instanceof Main\DB\OracleConnection))
	{
		$query->setLimit(1);
	}

	return $query;
}