Flexible search query to read records from 10 to 20

[Former Member]

Hello -

Product table has many records and need to read each time 100 records from DB and display to the user.

1s time get the 100 records, 2nd time get the records from 100 to 200, 3rd time get 200 to 300 etc. The number of records counter varies based what the user selects. User can select I want only 50 records or 100 records etc.

In oracle we use row num between X and Y. How do we write Flexible query to get the records each time based on the number of records displayed previously.

Any help would be appreciated.

[arvind-kumar_avinash · Accepted solution]

You have to set on FlexibleSearchQuery the setNeedTotal to true . If this parameter is set to true , the FlexibleSearch framework splits the number of returned search results into pages. Using the stnd range parameters, you can retrieve pages of search results. Please check https://wiki.hybris.com/display/release5/FlexibleSearch#FlexibleSearch-PagingofSearchResults for more information.

[Former Member]

Thanks for your quick reply.

[arvind-kumar_avinash]

You are most welcome . Please click the Accept link below my answer which will help other s to use this Q&A as a reference.