SAP Knowledge Base Article - Preview

2441288 - how to select productModel with couple of versions

Symptom

There is a product with online version and staged version I want to select product with staged version , when  i used below FlexibleSearch ,but the result only have online version 

public List<ProductModel> findProductByCode(final String code)

{

final HashMap attr = new HashMap(1);

attr.put("code", code);

final StringBuilder sql = new StringBuilder();

sql.append("SELECT {p:pk} FROM {Product AS p} WHERE {code} = ?code");

final FlexibleSearchQuery query = new FlexibleSearchQuery(sql.toString());

query.getQueryParameters().putAll(attr);

final SearchResult result = this.getFlexibleSearchService().search(query);

final List<ProductModel> products = result.getResult(); return products;

}


Read more...

Environment

hybris platform version 6.2.0.0

Product

SAP Hybris Commerce 6.2

Keywords

query on two catalog versions active catalog version , KBA , CEC-SCC-PLA-PL , Platform , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.