[Vtigercrm-developers] Ticket comments

[Joe Bordes]

Hi Scott,

The ticket comments are in the vtiger_ticketcomments table so you will
have to select in that table to get the comments you are looking for:

select comments, createdtime from vtiger_ticketcomments
where ticketid={yourticketid}
order by createdtime;

That should get the comments.

Let us know how it turns out.

Regards, Joe
TSolucio

El lun, 05-03-2007 a las 15:13 -0500, scott at centritechsolutions.com
escribió:
> What I need is some type of output to a table that shows comments of certain tickets.  What would my sql statment be to achieve this?
> 
> I.E
> 
> SELECT ticketid, assignedto, ticketcomments, createdtime WHERE ticket status is equal to 'Open';
> 
> If I have this sql statment then I would think I should be able to print the results out to a html table and that would be sufficent for me.  It doesn't even have to be integrated into any modules.  I could just call the url directly such as www.crmserver.com/getTicketComments.php
> 
> Thanks
> Scott
> 
> ------Original Mail------
> From: "bharath" <bharath at vtiger.com>
> To: <scott at centritechsolutions.com>
> Sent: Mon, 05 Mar 2007 16:07:27 +0530
> Subject: Re:[Vtigercrm-developers] Ticket comments
> 
> 
> 
> 
> Dear Scott Brown,
> 
> Thanks for your fruitful suggestion.
> Currently we are not supporting this feature,
> but we will take this in one of our future release.
> Please do get back to us for further details.
> 
> Thanks & Regards
> Bharath
> 
> 
> 
> 
> ----scott at centritechsolutions.com wrote ---- 
> 
>                                                                                     Is there a way to have a report ofthe ticket comments or a way to create a custom view to show all the ticketcomments on one screen? This way I can at least do a print screen.
>  
> 
> Scott Brown
> Operations Manager
> Main: 804-360-9753Ext. 400
> Fax: 1-800-851-0516
> scott at centritechsolutions.com
> http://www.CentriTechSolutions.com
>  
> 
> 
> _______________________________________________
> Reach hundreds of potential candidates - http://jobs.vtiger.com 
> 
> 
> _______________________________________________
> Reach hundreds of potential candidates - http://jobs.vtiger.com 
>