Shulou(Shulou.com)06/01 Report--

How to understand ABAP's OPEN SQL and Hybris Commerce's Flexible Search, many novices are not very clear about this, in order to help you solve this problem, the following editor will explain for you in detail, people with this need can come to learn, I hope you can get something.

In ABAP applications, we application developer uses Open SQL to access database, and these Open SQL are converted by Database interface into database provider specific SQL and then executed.

Enterprise search / simple search is also supported in CRM and C4C

In fact, the principle of implementation is that a RFC of application call gets the query results on TREX server.

There is a similar function in Hybris: FlexibleSearch service

FlexibleSearch service uses a set of language based on SQL syntax invented by Hybris himself, similar to ABAP's open SQL.

Look at an example:

Select * from {Product} where {code} = 'cris03'

The flexible search language is precompiled into query statements that are similar to the syntax of SQL statements:

SELECT * FROM products item_t0 WHERE (item_t0.p_code = 'cris03') AND (item_t0.TypePkString IN)

The values of the variables represented by the seven question marks in the above statement can be found in execution statistics:

There are actually seven catalog:

Search results, corresponding to two records:

These two records can also be searched in backoffice:

Is it helpful for you to read the above content? If you want to know more about the relevant knowledge or read more related articles, please follow the industry information channel, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.