Knowledge quiz

It is expressed in terms of database tables and columns in SAP Commerce

Its query will not go through the cache

It allows nearly every feature of SQL SELECT statements

It is an out-of-the-box query language using an SQL-based syntax

For one-to-many relation, you should know the column name of the 'many' side table

For many-to-many relation, you don’t need to mention the relation in your flexible search query

For many-to-many relation, you must determine which related type is the sourceElement and which one is the targetElement

For one-to-many relation, you don’t need to mention the relation in your flexible search query

ASC

DISTINCTED

LIKE

COMBINE

When comparing date values, truncate them to use caching of flexible search results

Directly use model attribute names and type names in flexible search queries

It’s better to select PK to query 'whole items', rather than arbitrary attributes

Use pagination via API to improve security