FieldRepository::getHasProducts

public function getHasProducts(int $entityTypeId, string $fieldName = 'HAS_PRODUCTS'): ExpressionField
{
	$productTable = ProductRowTable::getTableName();
	$ownerType = \CCrmOwnerTypeAbbr::ResolveByTypeID($entityTypeId);

	return
		(new ExpressionField(
			$fieldName,
			"CASE WHEN EXISTS (SELECT ID FROM {$productTable} WHERE OWNER_ID = %s AND OWNER_TYPE = '{$ownerType}')"
			. ' THEN 1 ELSE 0 END',
			'ID',
		))
			->configureValueType(BooleanField::class)
	;
}