[Vtigercrm-developers] aggregating ModComments

[Prasad]

Adam,

ModComments is a mine of data, your are right direction we are interested
in the your prototype.

I take the blame of introducing the varchar field on parent_comments - it
should be integer, will add it to my list. I was planning for a simple tool
that can aid developers to detect such inconsistency let me know if you had
one.

Regards,
Prasad

On Thu, Feb 7, 2013 at 11:07 PM, Adam Heinz <amh at metricwise.net> wrote:

> I'm prototyping a feature where comments are aggregated.  For example, if
> I'm viewing comments on an Account, I might want to see all comments for
> the Contacts associated with the Account.  The reverse could also be true;
> maybe I want to see the Account comments if I'm looking at a Contact.
>
> I notice there is already a vtiger_modcomments.parent_comments column in
> the database, but it appears to be unused in 5.4.0.  What is the intended
> purpose of this field?
>
> On a somewhat related note, why are the related_to and parent_comments
> fields VARCHAR?  Shouldn't they either be INTEGER or broken out into a join
> table?  I am really not a fan of putting a bunch of database ids into a
> field separated by semicolons; SQL really doesn't handle that sort of
> shenanigans very well.
>
>
> _______________________________________________
> http://www.vtiger.com/
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20130208/f2b9b3ba/attachment.html