Issue: I’m randomly missing data that should be in a repeating group
Details: I have 33 order entries that fit my constraints of a “Do a Search for” source for a repeating group. The problem is that only 28 entries are showing up. This happens when the source data is sorted by a value that is also used as a constraint for the search.
Example: Repeating Group
Source: Search for: Order Entries
Constraint 1: “Scheduled Date 1 isn’t empty” (data type for Date 1 is date)
Constraint 2: "Value 2 <> “Yes” (data type for Value 2 is yes/no)
Sorted by: Scheduled Date 1, descending: No
The problem goes away and all 33 entries show if I remove the Sort By Scheduled Date 1, but the whole point of this repeating group is to be a heads up display of the order entries sorted by their value of Scheduled Date 1.
Interesting! I’m pretty sure this is a bug. I added a text which displays the count of entires that should be shown (that always displays 33), as well as text within the repeating group which shows the index of each Order cell on the left-hand side.
It looks like layout may have something to do with this as well. When I selected vertical scrolling or ext. vertical scrolling for the repeating group, the vertical scroll only went up to 28 records (as you said) for either of those when the sort filter was applied. When I selected “full list” it did show all 33 records correctly (with the sort filter there as well).
(I also removed all of the privacy roles temporarily to see if that may have something to do with this, and that also didn’t make a difference in displaying all of the results.)
I am also experiencing a similar issue : my repeating group is not displaying some data (randomly as well, even for the same search), while calling “Repeating group’s List of items:count” does return the good number.
I will also fill a bug report, I think it could impact more users
PS : using full list does not resolve the issue for me. Did you double checked that it was not ok by chance ? (sometime it displays all data, sometimes not)
Edit :I was also sorting on a field used as a constrain and changing the sorting on another field resulting in displaying all the data
Hmm, it sounds like you have everything set up correctly! Can you temporarily set the app to public and share a link to the editor?
Hope it gets sorted out quickly for you!