Data Sort in Nested RG

adityasinghal08 · 2023-09-18T12:26:04.056Z

Hi Bubblers !

There are 2 Repeating Groups : RG2 nested in RG1.

RG1 : List of Main Properties
RG2 : List of Rooms/Units inside a ‘Main Property’

Now, I want to SORT RG2 using ‘Floor Level’ FIELD Value. I have tried using ‘:Sorted’ with RG2 DATA SOURCE, however RG2 values dont seem to be SORTED.

1 Nested RG data not getting Sorted

2 RG-2 Data Sort expression714×566 30.1 KB

what should be done to achieve SORTED data as per ‘Floor Level’ in RG2 ?

georgecollier · 2023-09-18T12:42:41.267Z

Are there any conditionals that are modifying the data source of the RG? That’s what I’d guess is the issue.

Is Floor Level a number or have you made it a text?

adityasinghal08 · 2023-09-19T06:19:37.363Z

Thank you for your revert @georgecollier !

There are 2 conditionals for RG2 :

to control visibility of RG2 based on count.
to fetch data using ‘get data from URL’, if URL not empty.

3 conditionals for RG2345×515 13.8 KB

‘Floor Level’ is a ‘number’ type FIELD in the database.

georgecollier · 2023-09-19T08:52:02.022Z

Is the data source of that conditional causing the data to be unsorted?

Alternatively, what’s the ‘13,14,15,16’ list, because thats what it seems to be sorted by right now.

adityasinghal08 · 2023-09-19T09:31:50.909Z

@georgecollier
yes, it seems the Data Source of the conditional was causing this as its expression was not updated with ‘:SORTED’.
Thanks for pointing out & solving this !

system · 2023-11-27T12:26:25.857Z

This topic was automatically closed after 70 days. New replies are no longer allowed.