[rt-users] De-normalized RT Views

[Kenneth Marshall]

On Thu, Mar 05, 2009 at 02:50:09PM -0800, Kenneth Crocker wrote:
> To all,
> 
> 
> 	We have found that the RT Query tool doesn't allow certain type of 
> searches we would like to have. SO we created some de-normalized views 
> that allow us to use SQL Plus or SQL Navigator, etc. as a tool to access 
> our RT ticket data. We are on Oracle, so I'm not sure if the code to 
> create these views will be helpful to anyone else, but I'll share them 
> with anyone interested. Also, I'd like to put them in the wiki for RT, 
> but I've never been there and would need some instruction on how to do that.
> 	Also, for those who have been looking for ways to convert from one 
> ticketing system to RT, we have written a program in Perl to do just 
> that. It uses the API, so that all relevant table records are updated in 
> RT. Again, we use Oracle, so this may not work for you, but the logic 
> and process should. All you would have to do is change the syntax and 
> any environmental setups so the program would work for you and you've 
> got it. Anyone interested in that?
> 
> 
> Kenn
> LBNL
> 
Yes, please add these to the wiki. We have had similar needs and
having some samples to look at can really speed up implementation
even on different DB platforms.

Cheers,
Ken