[OGo-Developer] FYI: time constrained company_value attributes
Adam Tauno Williams
developer@opengroupware.org
Tue, 13 May 2008 08:40:11 -0400
> >> JFYI: in my 5.4 DB changes I have extended company_value with a
> >> timerange, that is, a startdate/enddate. Now you can basically have
> >> multiple, time constrained values. (eg key="membership",
> >> value="live",
> >> from=2001-03-10, to=null)
> > Are schema changes going to be committed soon? Having the companyId
> > added to the notes table would be useful for us at this point.
> I'm reluctant to commit it because I would like to avoid continous
> database upgrades with trunk users. Also I might still change details.
Understood, but it is "trunk" after all. :)
> Well, maybe thats a non-issue and I should just commit incremental
> changes. I'll think about it.
We could compromise and just commit the parts you are reasonably
confident won't change.
> >> Not sure how the current UI deals with all that, we'll see :-)
> > I'm guessing - badly! :)
> Could be that the keys are merged in a single hashmap in the Document-
> Layer. Need to check.
Unless there is some magic in the gdl layer I'm unaware of, looking at
Logic's LSFetchExtendedAttributesCommand command I'd wager a beer it
won't be happy seeing multiple records for the same companyId
+attribute. :) Or maybe I haven't had enough caffeine yet.