WonLostAmount::prepareEntityListFilter

public function prepareEntityListFilter($requestParameters)
{
	$filterParameters = $this->getFilterParameters();

	$query = DealTable::query();
	$query->addSelect('ID');
	$this->addToQueryFilterCase($query, $filterParameters);
	$this->addTimePeriodToQuery($query, $filterParameters['TIME_PERIOD']);
	//$this->addPermissionsCheck($query);

	foreach ($requestParameters as $parameter => $value)
	{
		switch ($parameter)
		{
			case 'ASSIGNED_BY_ID':
			case 'IS_RETURN_CUSTOMER':
			case 'STAGE_SEMANTIC_ID':
				$query->where($parameter, $value);
				break;
		}
	}

	return [
		'__JOINS' => [
			[
				'TYPE' => 'INNER',
				'SQL' => 'INNER JOIN('.$query->getQuery().') REP ON REP.ID = L.ID'
			]
		]
	];
}