Skip to Content
0
Former Member
May 08, 2018 at 09:32 AM

Unable to create Flexible Search Query

1708 Views

Hi All ,

I want to create flexible search query to fetch all the supercategories of product "XYZ" of particular product catalog like defalut:stage

Below is the query I generate.

SELECT {p:code}, {c:code} FROM { Product as p JOIN CategoryProductRelation as rel ON {p:PK} = {rel:target} JOIN Category AS c ON {rel:source} = {c:PK} } where {p:code} = "XYZ" and {p:catalogVersion} = "8796093252185"

How I can compare catalog using id and version instead of its PK, because I want to use it on multiple system?

Thanks, Rasika