why can't we fetch table data using the deploymet table name in hybris HSQL DB

[Hari_prasad]

1) As seen in the screen-shot, deployment table name="Products".

2)But when do flexible search, i have to mention the itemType code name. (i.e., Product).

When i tried to search using the name ="Products" it will through Exception why.

My question is, While i check the table's list in the HSQL DB the table name shown is "products".

What is the reason? Behind this?

Thanks and Regards

Sunil.p

[arvind-kumar_avinash · Accepted solution]

Hello Hari Prasad - You need to understand the concept of ORM (https://en.wikipedia.org/wiki/Object-relational_mapping) first. ORM is a concept of a virtual object database where you just need to deal with objects, and not with actual database tables.

The hybris-specific pages for this concept are under the following headings:

1. https://help.sap.com/viewer/d0224eca81e249cb821f2cdf45a82ace/1905/en-US/8c755da8866910149c27ec908fc5...
2. https://help.sap.com/viewer/d0224eca81e249cb821f2cdf45a82ace/1905/en-US/8bc399c186691014b8fce25e9661...
3. The specifics of deployment tables is at https://help.sap.com/viewer/d0224eca81e249cb821f2cdf45a82ace/1905/en-US/8c6254f086691014b095a08a61d1...

In summary, the recommended practice is to use Flexible Search query instead of SQL query. When you use the Flexible Search query, the syntax is to use itemtype code and attribute qualifier instead of actual table name and column name.

[Hari_prasad · Accepted solution]

okay.

thank you Arvind

[arvind-kumar_avinash · Accepted solution]

You are most welcome.