--
From: Landon Stewart lstew...@iweb.com
Sent: 3/3/2014 3:02 PM
To: RT Users rt-users@lists.bestpractical.com
Subject: [rt-users] MySQL Question (joins and stuff)
Hello,
I'd never modify the database without the API but I'd like a flattened
version of the data as a snapshot
Hi Landon, below is some sql I wrote (I'm not too good at sql so some of it
could probably be optimized). It pulls a bunch of fields both system and
custom as well as the first comment on the ticket and names the columns
something friendly. Also it compensates for timezones since the db is in
Jason this is brilliant! Thank you!
On 4 March 2014 13:57, j.hubbard jason.hubb...@circles.com wrote:
Hi Landon, below is some sql I wrote (I'm not too good at sql so some of it
could probably be optimized). It pulls a bunch of fields both system and
custom as well as the first comment on
Hello,
I'd never modify the database without the API but I'd like a flattened
version of the data as a snapshot every so often for statistical purposes.
If I run the following MySQL query I basically get a line for every
CustomField Value and it duplicates all the T.* fields while writing new
Does anyone know of a tool (ideally Linux command line, and ideally
ideally with source or PowerPC binary package(s) available) that grab
a partial snapshot of a MySQL database? Trying to setup a development
server that obviously can't hit the 'live' database, but don't want
to, even
On 4 Aug 2008, at 7:05 pm, [EMAIL PROTECTED] wrote:
Does anyone know of a tool (ideally Linux command line, and ideally
ideally with source or PowerPC binary package(s) available) that grab
a partial snapshot of a MySQL database? Trying to setup a development
server that obviously can't hit