[Vtigercrm-developers] Ticket comments

[scott at centritechsolutions.com]

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