Problem with Flexible Search Query (with exists clausule)

[Former Member]

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.

[cieslo · Accepted solution]

Hi Luiz,

the problem is with space between the 2 curly braces starting the subquery in EXISTS clause. You have

...EXISTS ( { { SELECT...

and this should look like this

...EXISTS ( {{ SELECT...

also the closing curly braces should be kept together, not

}
}

but

}}

[Former Member · Accepted solution]

it worked! thank you!

[Former Member]

same error with the following: {p.PK} from {Product as p JOIN Product2TargetOnlineCatalogs as pt ON {p.PK}={pt.source} JOIN TargetOnlineCatalogEnum as t ON {pt.target}={t.PK}} WHERE {t.code}='CODE'