Caching does not work if offset and limit are used in a query

[Rishi Agr <ri...@gmail.com>]

Hi, I have created a view and the query on it has the pagination
implementation. The search on this view returns more than one page of data
and I would like to cache this. I've observed that the cache does not work
as expected if I have the offset and limit in the query. Also, if I change
the page size the previous selected size is not overridden. Let me know if
I need to add some other stuff in the query to make it work. Thank you.

Re: Caching does not work if offset and limit are used in a query

[Nicolas Malin <ni...@nereide.fr>]

Hello Rishi,

Check with an EntityListIterator instead of a List, like it already done
with performFind service and Form list.

You extract from the data base only the segment needed through a
database pointer.

Nicolas

On 08/07/2022 08:30, Rishi Agr wrote:
> Hi, I have created a view and the query on it has the pagination
> implementation. The search on this view returns more than one page of data
> and I would like to cache this. I've observed that the cache does not work
> as expected if I have the offset and limit in the query. Also, if I change
> the page size the previous selected size is not overridden. Let me know if
> I need to add some other stuff in the query to make it work. Thank you.
>