rt3 at floorverschure
May 9, 2008, 11:15 AM
Post #1 of 1
(38 views)
Permalink
|
|
Fwd: Re: creating export of tickets with comments
|
|
----- Forwarded message from mail[at]floorverschure.com -----
Date: Fri, 09 May 2008 19:54:16 +0200
From: Floor Verschure <mail[at]floorverschure.com>
Reply-To: Floor Verschure <mail[at]floorverschure.com>
Subject: Re: [rt-users] creating export of tickets with comments
To: Kenneth Crocker <KFCrocker[at]lbl.gov>
Cc: rt-users[at]lists.bestpractical.com
Hi Kenn,
Thanks for your reply.
All tickes are indeed in an RT queue. The reason why i am using an
sql
query is that i need to be able to export all records of that
specific
queue to a .csv or excell format. In the export I need to include
all
relevant ticket infrmation and thus also the comments. If there is
another way than with an sql query than that's also fine.
Greetins, Floor
----- Message from KFCrocker[at]lbl.gov ---------
Date: Fri, 09 May 2008 09:55:32 -0700
From: Kenneth Crocker <KFCrocker[at]lbl.gov>
Reply-To: Kenneth Crocker <KFCrocker[at]lbl.gov>
Subject: Re: [rt-users] creating export of tickets with comments
To: Floor Verschure <rt3[at]floorverschure.com>
Cc: rt-users[at]lists.bestpractical.com
> Floor,
>
>
> Are these tickets already in a queue in RT? If so, why
are you using
> SQL-Query when you could use the RT-Search/Bulk Update option? Just
> curious.
>
>
> Kenn
> LBNL
>
> On 5/9/2008 4:28 AM, Floor Verschure wrote:
>> Hello,
>>
>> I am trying to make an export of all tickets in a queue using an
>> SQL-query. I've succeeded in creating a query including all custom
>> fields (see below).
>>
>> In addition I also need all the comments with the tickets. Is
there
>> a way to do this and put them in a .csv or excell?
>>
>> Greetings, Floor Verschure
>>
>>
////////////////////////////////////////////////////////////////////////
>>
>> SELECT t.id, t.subject, t.priority, t.created, t.status,
>> t.resolved, c37.content AS 'Eneco Ref. Nr.',c40.content AS
'Aspective
>> Ref. Nr.' , c38.content AS 'Downtime',c39.content AS 'Workaround'
>>
>> FROM Tickets t
>>
>> LEFT JOIN TicketCustomFieldValues c38 ON (t.id = c38.ticket AND
>> c38.customfield = 38)
>> LEFT JOIN TicketCustomFieldValues c37 ON (t.id = c37.ticket AND
>> c37.customfield = 37)
>> LEFT JOIN TicketCustomFieldValues c39 ON (t.id = c39.ticket AND
>> c39.customfield = 39)
>> LEFT JOIN TicketCustomFieldValues c40 ON (t.id = c40.ticket AND
>> c40.customfield = 40)
>>
>> WHERE t.Queue=44
>>
>>
///////////////////////////////////////////////////////////////////////
>>
>> _______________________________________________
>> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>>
>> Community help: http://wiki.bestpractical.com
>> Commercial support: sales[at]bestpractical.com
>>
>>
>> Discover RT's hidden secrets with RT Essentials from O'Reilly
>> Media. Buy a copy at http://rtbook.bestpractical.com
>>
----- End message from KFCrocker[at]lbl.gov -----
----------------------------------
Floor Verschure
Vlaardingerdijk 202
3117 ZP Schiedam
Tel: +31 10 4261201
Mobiel: +31 6 18134816
www: http://floorverschure.com
----------------------------------
----- End forwarded message -----
----------------------------------
Floor Verschure
Vlaardingerdijk 202
3117 ZP Schiedam
Tel: +31 10 4261201
Mobiel: +31 6 18134816
www: http://floorverschure.com
----------------------------------
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: sales[at]bestpractical.com
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
|
