Introduction to ABAP’s OPEN SQL and Hybris Commerce’s Flexible Search

In the ABAP application, We use Application Developer to access the database with Open SQL, which is converted by the Database Interface into Database Provider-specific SQL and then executed.

CRM and C4C also support Enterprise Search/Simple Search,

Application calls an RFC to the TREX server to retrieve query results.

Hybris has a similar feature: FlexibleSearch Service

FlexibleSearch Service uses Hybris’s own set of SQL Syntax-based language, similar to ABAP’s Open SQL.

Here’s an example:

Select * from {Product} where {code} = ‘cris03’

The Flexible Search language is precompiled into query statements that have similar syntax to SQL statements: SELECT * FROM products ITEM_t0 WHERE (item_t0.p_code = ‘cris03’) AND (item_t0.typepkString IN (? ,? ,? ,? ,? ,? ,?) )

The value of the variable represented by the seven question marks in the above statement can be found in execution Statistics:

There are seven catalogs:

Search results, corresponding to two records:

These two records can also be searched in Backoffice:

For more of Jerry’s original articles, please follow the public account “Wang Zixi “: