Nested Repeating Group - Newest Record

Need help App Organization
1

Hi all

Hopefully this is a dumb question with an easy answer.

I have a repeating group RG1 with a nested repeating group RG2 whic retrieves records with a one to many relationship between 2 data types. In RG2 I only want to show the last record created. At the moment I am retrieving all records into RG2 and I don’t seem to be able to find a way ojust displaying the last one created.

Any advice please?

2

why you use RG when you want to show only one record (last record)?
you may use the basic group and search for the records and use :last item

3

Of course…thank you.

4

I have a similar problem Id like to solve. Im using this thread instead of creating a new one because I think it`ll be more organized. Please advise if I rather create a new one.

I have a couple of table I need to consolidate.

“extrato_iot” : brings the daily reading of a list of IoT devices. It brings date/time it was recorded (another field for the month), the device ID and the reading itself (among several other information).

I need to create a RG with these device IDs and its last reading recorded each month.

Exemple:

  1. DeviceID
  2. Date/time when the reading was recorded
  3. Month (it’s date #2 converted to d=01, h=01, m=01, s=01 so I’ll readings refer to 01/month - 01:00:00)

image
image576×821 21.3 KB

image
image1365×292 41.5 KB

Highlighted in yellow you can see the same device recording Feb, 4 and Feb, 5 and if we gol further down We’ll find recordings almost every day. I need a RG with the latest record from mes_ref = Feb, 2024 and the last from Jan, 2024 and so on…

Could anyone help me out on this?

Thank you very much!