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 ONE Support launchpad (Login required).

Search for additional results

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