Skip to Content
0
Sep 03, 2018 at 06:45 PM

flexible search query

449 Views

HI, i have error with the following query, could any one help me out.

query :

SELECT {item:pk} FROM {CategoryProductRelation* AS rel JOIN Category AS item ON {rel:source}={item:pk} } WHERE {rel:qualifier} = ?quali AND {rel:target} = ?item AND {rel:language} IS NULL ORDER BY {rel:pk} ASC' ( item='8796261679105',quali='CategoryProductRelation',lang='null')

Exception: missing values for [item, quali], got {13=8796112257106, 11=8796111405138, 14=8796111863890, 10=8796112158802, 12=8796112224338}