Monday, January 30, 2012
Hey guys,
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 between a start and end date.
What I'm wondering is how to go about exploding a result set. For instance, if I have one row for an event, but there are 5 dates it falls on that are 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 will 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,
Jayme
-- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To view this discussion on the web visit https://groups.google.com/d/msg/rubyonrails-talk/-/KEIOBYmJqS8J.
To post to this group, send email to rubyonrails-talk@googlegroups.com.
To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment