Key Features of Flexible Search
Flexible Search is a built-in query language using an SQL-based syntax. Let’s check out some of its basic features.
Primarily, Flexible Search is based on SQL and enables you to search for and retrieve items in the SAP Commerce domain. Note that only select operations are permissible.
Flexible search:
- Allows you to express your query using SAP Commerce types and attributes. Hence, you don’t need to manage the core database tables and their respective columns directly.
- Transforms your type-based query into an underlying table-based query, effectively separating your application logic from database storage particulars.
When you execute Flexible Search from the HAC’s Flexible Search Console, the system returns data results in a usual query format, similar to executing an SQL query. You often need joins and/or sub-queries for linked objects.