[rt-users] Call Report -Help required
Hegde Manjunath
Manjunath_Hegde at syntelinc.com
Wed Nov 24 09:56:05 EST 2004
Hi,
I could build some MySQL querry which would give me a call report with all
the details i need.
Has any one got a script to generate a .xls file for such reports - please
help me
The querry is given below (incase if it helps some one )
________________
SELECT
t.id as 'Call No',
DATE_FORMAT(t.Created, "%m/%d/%Y") as 'Date',
CASE WHEN tcf.CustomField = 4 THEN tcf.Content ELSE NULL END as 'Machine
ID',
DATE_FORMAT(t.Created, "%H:%i") as 'Time Reported',
CASE WHEN tcf.CustomField = 1 THEN tcf.Content ELSE NULL END as 'Project',
t.Subject as 'Fault Description',
u.Name as 'Caller Name',
t.Priority as 'Priority',
u.Name as 'Engineer',
"" as 'Vendor',
DATE_FORMAT(t.Started, "%H:%i") as 'Time Attended',
DATE_FORMAT(t.Resolved, "%H:%i") as 'Time Completed',
DATE_FORMAT(t.Resolved, "%m/%d/%Y") as 'Date Completed',
t.Status as 'Status'
FROM
Tickets t,
TicketCustomFieldValues tcf,
Users u
WHERE
t.id = tcf.Ticket
AND (t.Creator = u.id OR t.Owner = u.id)
AND DATE_FORMAT(t.Created, "%m/%d/%Y") BETWEEN "11/20/2004" AND "11/22/2004"
_________________
I would like to use this in a .cgi file and create a .xls file - can some
one help me please ??
Thanks in advance
Manjunath Hegde
-----Original Message-----
From: Hegde Manjunath [mailto:Manjunath_Hegde at syntelinc.com]
Sent: Tuesday, November 23, 2004 10:38 AM
To: rt-users at lists.bestpractical.com
Subject: [rt-users] Call Report -Help required
Hi,
I have been using rt3 with mysql and till now, it has ben a success story.
Has any one got a html / cgi file to generate a report of the calls logged.
Thanks in advance
Manjunath hegde
____________________________________________
Confidential: This electronic message and all contents contain information
from Syntel, Inc. which may be privileged, confidential or otherwise
protected from disclosure. The information is intended to be for the
addressee only. If you are not the addressee, any disclosure, copy,
distribution or use of the contents of this message is prohibited. If you
have received this electronic message in error, please notify the sender
immediately and destroy the original message and all copies.
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Be sure to check out the RT wiki at http://wiki.bestpractical.com
____________________________________________
Confidential: This electronic message and all contents contain information
from Syntel, Inc. which may be privileged, confidential or otherwise
protected from disclosure. The information is intended to be for the
addressee only. If you are not the addressee, any disclosure, copy,
distribution or use of the contents of this message is prohibited. If you
have received this electronic message in error, please notify the sender
immediately and destroy the original message and all copies.
More information about the rt-users
mailing list