[rt-users] sql query for exporting all tickets in a queue including comments

2008-05-15 Thread Floor Verschure
Hello, Did anyone even built an SQL-query to display all tickets in a queue including all the comments with them? If so can you share the SQL statements with me? Greetings, Floor Verschure ___ http://lists.bestpractical.com/cgi-bin/mailman

[rt-users] Fwd: Re: creating export of tickets with comments

2008-05-09 Thread Floor Verschure
- Forwarded message from [EMAIL PROTECTED] - Date: Fri, 09 May 2008 19:54:16 +0200 From: Floor Verschure <[EMAIL PROTECTED]> Reply-To: Floor Verschure <[EMAIL PROTECTED]> Subject: Re: [rt-users] creating export of tickets with comments To: Kenneth Cro

[rt-users] creating export of tickets with comments

2008-05-09 Thread Floor Verschure
tings, 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.cont

[rt-users] Fwd: db upgrade rt 3.0.7 ->rt 3.6.5

2007-12-08 Thread Floor Verschure
7 rc1 The first update scheme I see is 3.1.0 Does this mean that there is no upgrade possible? Can anybody tell me if there were changes between the 3.0.7. rc 1 scheme and 3.1.0? And can anybody please point me in the right direction? Greetings,