Limit the result rows in flexible search

Sometimes, we want to limit the no. of rows in results while we testing the flexible search query from the HAC. Flexible search query supports most of the SQL clauses. So we can use LIMIT or TOP in your query but it's database specific. it might not work with Oracle.

SELECT * FROM {Product} LIMIT 100
SELECT TOP 100 * FROM {Product}
For Oracle
SELECT * FROM {Product} WHERE rownum <= 100

Though API
final FlexibleSearchQuery query = new FlexibleSearchQuery("SELECT * FROM {Product}");
Author Image

Ankitkumar Patel

Sr. SAP Hybris consultant, having 15+ years experience in SAP Commerce Cloud (Hybris), SAP Spartacus. Extensive experience in SAP Hybris development, third-party integrations, project architecture and design... Read more


Popular posts from this blog

Hybris flexible search query examples

How to remove or update all data records in Hybris?

How to Install temporary Hybris license?