:Item from#X :items until#Y - Search loads all the results until Y

[aalubiryani]

Hi
I am using “:Item from#” and “:items until#” to load paginate results for a repeating group. However, the search is returning results from 1 to :items until#. So basically, it’s ignoring the :items from# constraint at all.

For example, if I run the following search:
Search for News Articles :items from#90 :items until#100
Then the search returns 100 results. Now I have my RG limited to 10 rows for pagination purpose, but if I inspect the RG in the debugger it shows 100 results have been loaded into the RG’s built-in list (not custom state or list).
Please see the attached images below:

This greatly slows down the app to the point of freezing as I move forward in to my database of 4000 items. I would like to do a sever search each time load only the required 10 items into the RG. Any solution for this?

Thank you

[adamhholmes]

Can you share some screenshots of your RG setup?

[reger-alexander]

It seems counterintuitive, but what worked for me is to use it the other way round:
First “:items until#” and then “:items from#”

[aalubiryani]

Sure.

I have tried with the data source in the RG settings well. But nothing made a difference. Right now I am clearing the RG list and calculating a new upper limit and lower limit (:items from# and :items until#) and using “display list in RG” action.

[aalubiryani]

That definitely seems counterintuitive, but thank you. let me try this

[aalubiryani]

That did the trick. Worked like a charm. Thank you so much. I have wasted a week on this stupid issue already…lol

Thank you!