[Vtigercrm-developers] Ticket comments

[Brian Laughlin]

We don't use Ticket's but based on what I can tell this query might put
you on the right path on getting what you what.

Select * from vtiger_troubletickets tt
join vtiger_crmentity ce on ce.crmid = tt.ticketid 
where tt.status = 'Open'

Good luck,

Brian Laughlin 

-----Original Message-----
From: vtigercrm-developers-bounces at lists.vtigercrm.com
[mailto:vtigercrm-developers-bounces at lists.vtigercrm.com] On Behalf Of
scott at centritechsolutions.com
Sent: Monday, March 05, 2007 12:14 PM
To: bharath at vtiger.com
Cc: vtigercrm-developers at lists.vtigercrm.com
Subject: Re: [Vtigercrm-developers] Ticket comments

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