SAP Knowledge Base Article - Preview

2441288 - how to select productModel with couple of versions


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());


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

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




hybris platform version


SAP Hybris Commerce 6.2


query on two catalog versions active catalog version , KBA , CEC-COM-CPS , SAP Commerce , 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.