I don’t see Person or EventBook in this model, but it’s mentioned in your code. Seems like you’re leaving out something important.On Feb 11, 2015, at 2:15 PM, Theodore Petrosky < email@hidden> wrote: what I am trying to accomplish is assign to the entity Event all the Books that are assigned to the show.
so Event toOne Show toMany Book
When I create a new Event, I assign the Show and a Date. Person current() is a boolean and true means he gets assigned to a book? Can there be more than one Person who is current() for a show/event/book/the whole person table?? What is in EventBook? I think what’s happening here is D2W builds an app based on your model, but your model doesn’t properly reflect what you are trying to capture.
Perhaps you should have a schema like
Event ->Show ->>EventDetail -Date
EventDetail ->Person ->Book ->Event
Then your report is just listing this detail table grouped by event date. When you create an event, that is the Master object and these are the details. So your D2W layout could look like
QueryEvent: D2WQuery so you can query by date ranges SelectEvent: D2WSelect (D2WPick for multiple events) so you can choose which event(s) are reported EventDetail: D2WGroupingList grouped by event.date
Or just query and list events grouped by date, then have a nested list for Person and/or Book in that table.
Or something else.
TL;DR, if you’re fighting D2W, your model probably stinks :-)
|