I’ve got a table that stores events with a recurrence pattern. I found a
stored procedure that will generate occurrence dates for an event
start and end date.
What I’m wondering is how to go about exploding a result set. For
if I have one row for an event, but there are 5 dates it falls on that
calculated on demand (not stored), how can I query with AREL to return 5
events, with the same data for each field plus a new field “date” that
contain the date of the occurrence?
For instance, if the original table contained fields a, b, and c - the
result of this method/query would be 5 objects with fields a, b, and c -
but also one that stores the date.
Thanks in advance,