List of things transformation

Hello, Bubblers!
I have a few repeating groups with the same content type (Booking type), but with different data (each RG has its own list filtered by different criteria). Each Booking has the field DateTimeRange with a type of date range.
In each my Repeat Group I’m using Data Source as Do search for Booking:filtered each DateTimeRange
Before displaying this data I need to do the additional transformation for these DateTimeRanges - I need to split them by midnights. Example:
Search returns 2 bookings with date-time ranges:

  • Mar 25, 09:00 am - 11:00 am
  • Mar 25, 05:00 pm - Mar 26, 05:00 am

So as result I expect a list with 3 items:

  1. Mar 25, 09:00 am - 11:00 am
  2. Mar 25, 05:00 pm - 11:59 pm
  3. Mar 26, 00:00 am - 05:00 am

As you see 2 items are transformed into 3 (it might be the same amount of items in the result list or more).
I have tried API Workflow, but I can’t understand how to do this there.
How can I do this transformation?

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