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