[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.