Flexible Search in SAP Commerce [Hybris]
In this article, I have explained in details about Flexible Search in SAP Commerce Cloud [SAP Hybris] with some real time examples. What is Flexible Search in SAP Hybris? Flexible Search is a Hybris built-in query langua g e based on SQL syntax and it enables us to search records from the database using item types. In flexible search queries we never use database table names directly, instead we use item types which are mapped to corresponding tables in the items.xml file. In flexible search query we must specify item type code and its attributes in curly braces: e.g. Select {code}, {name} from {Product}. When we execute the flexible search query in Hybris, it has 2 phases: Pre-parsing phase: ...