on 09-03-2018 7:45 PM
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}
Did you provide values for the "?quali" and "?item" parameters? If not, then that's what you are missing. You need to replace them with values.
Check "FlexibleSearch Samples": https://help.hybris.com/6.3.0/hcd/8bc33bb28669101481ccfb446695e9de.html
Excerpt:
...LIKE ?name; query.addQueryParameter("name", "%h%")
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
7 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.