Re: phone call information to contacts in ogo

Adam Tauno Williams <[email protected]> Thu, 13 Dec 2007 07:55:45 -0500
Newsgroups gmane.comp.cms.opengroupware.discuss.general
Message-ID <[email protected]>
On Thu, 2007-12-13 at 13:47 +0100, Sebastian Reitenbach wrote:
> [email protected] wrote: 
> > On 13.12.2007, at 13:22, Sebastian Reitenbach wrote:
> > > Yes, I thought about adding notes to calls, e.g. just enhancing the  
> > > database
> > > table with a comment field, but when the calls are private, what  
> > > does it
> > > make sense to allow setting different permissions to the notes. 
> > As you say, the calls are private, but if the user chooses to expose a  
> > call, he can do so by using a note (by assigning the ACL to the people  
> > he want to expose the information to).
> ah, now I see what you mean, and yes, it's a useful idea.

I don't see how an ACL can reference a record in a foreign table as the
table doesn't have an OGo sequence number as the primary key.  Unless
you mean only create a note in the instance that someone wants to share
call information.

> > > Or maybe better a separate table like the date_info table?
> > The _info tables are a historical construct to support blobs in the  
> > database, its not a design decision. It was required in old Sybase and  
> > Oracle versions which had certain limits on BLOBs.
> ok, then I'll better add a colum to the cdr table.


-- 
OpenGroupware.org Discussion [email protected]
http://mail.opengroupware.org/mailman/listinfo/discuss