Hi Brian, As per my understanding some entities have only one relevant date and most of these dates represent the issue date (from_date). Also for relationship entities the date that matters is the fromDate because what you care about is the linking date.
Usually the way I search through the data is by finding the max fromDate where thruDate is null. I think these two conditions might be sufficient for your needs unless I missed something else in your mail. And finally I think some entities are not holding the best designs and there is always room for improving so getting more concrete examples might enrich the discussions. HTH Taher Alkhateeb On Aug 9, 2016 12:04 AM, "Brian Ghidinelli" <[email protected]> wrote: > > I'm a big fan of Silverston and his UDM books and have been studying OfBiz > extensively. I was wondering if anyone can explain why his entities with > from/thru date use the from date instead of the thru date in the composite > keys? It seems like you would want to enforce only one version is ever > active at a time by uniquely indexing the thru date as null (or a magic end > date, or infinity in Postgres). > > I'd be very appreciative of any theory explanations on the use of from > date instead of thru date? > > Brian >
