Hello, I am trying to use 1C:Enterprise as a backend for my project. I need to present some search results in pages.
How to split the search results into pages? (like page 1, page 2, page 3...)
When the user searches for products on my project website, I want results to be split into several pages showing around 20 results per page. The search results are the outcome of database query.
For example: If the user searches for Samsung mobiles so my query will be:
SEL ECT * FR OM PRODUCTS WHERE BRAND='SAMSUNG';
Suppose the above query returns 55 results, how to show them into pages (1,2 and 3)?
How could I use internal caching? Are there any best practices? Should I store temporarily the result during user session? Could this be done automatically?
p.s I do not want to send all results to the client. It could take some time (could be 200 pages)
The 1C:Enterprise developers forum