Skip to Content
0
Former Member
Nov 05, 2015 at 02:38 AM

Problem with Flexible Search Query (with exists clausule)

1485 Views

Hi,

I'm trying to execute a query

SELECT {Product:PK} FROM {Product AS Product } WHERE (
EXISTS
(
{ { SELECT {feat.pk} FROM {ProductFeature AS feat}
WHERE {feat.classificationAttributeAssignment}= ?paramClassAssign AND {feat.product}={Product.pk}
AND {feat.language} IS NULL AND {feat.numberValue} = ?paramValue
}
}
) AND {Product:catalogVersion} = ?catalogVersion )

but the console is giving me an error:

cannot find (visible) type for alias { SELECT {feat within [Product:Product]

Anyone knows what I'm doing wrong here?

Thanks,

Luiz.