RE: Theory of Composite keys with From date vs Thru date?

2016-08-09 Thread Skip
8 PM To: user@ofbiz.apache.org Subject: Re: Theory of Composite keys with From date vs Thru date? Thanks Pierre and Taher for your responses, a couple of follow-ups below: On 8/9/16 01:44, Pierre Smits wrote: > The one thing is related to creating a unique key based on the fromDate in > c

Re: Theory of Composite keys with From date vs Thru date?

2016-08-09 Thread Brian Ghidinelli
Thanks Pierre and Taher for your responses, a couple of follow-ups below: On 8/9/16 01:44, Pierre Smits wrote: The one thing is related to creating a unique key based on the fromDate in combination with the other elements of the primary key. As an example, have a look at the following (excerpt)

Re: Theory of Composite keys with From date vs Thru date?

2016-08-09 Thread Pierre Smits
Hi Brian, Welcome to the OFBiz community. It seems to me that you are mixing two different things, but I might be misunderstanding you. The one thing is related to creating a unique key based on the fromDate in combination with the other elements of the primary key. As an example, have a look at

Re: Theory of Composite keys with From date vs Thru date?

2016-08-08 Thread Taher Alkhateeb
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

Theory of Composite keys with From date vs Thru date?

2016-08-08 Thread Brian Ghidinelli
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 a