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