Helper::createExpressionMultiField

static function createExpressionMultiField($entityName, $multiFieldTypeId)
{
	$sqlHelper = Application::getConnection()->getSqlHelper();
	return new Orm\Fields\ExpressionField(
		$multiFieldTypeId,
		'(' . $sqlHelper->getTopSql(
			"
					SELECT FM.VALUE							
					FROM b_crm_field_multi FM 
					WHERE FM.ENTITY_ID = '$entityName' 
						AND FM.ELEMENT_ID = %s 
						AND FM.TYPE_ID = '$multiFieldTypeId' 
					ORDER BY
						CASE FM.VALUE_TYPE 
							WHEN 'MAILING' THEN 0 
							WHEN 'HOME' THEN 1
							WHEN 'MOBILE' THEN 1
							ELSE 2
						END,
						FM.ID
				",
			1
		) . ')',
		'ID'
	);
}