[rt-users] help translating RT query to mysql

[Ruslan U. Zakirov]

Dave Dennis wrote:
> Dear List,
> 
> Asking humbly for some mysql help;
> 
> I have a query in a queue in RT that has these conditions:
> 
> Requestor LIKE Companyname
> Subject LIKE Internal
> Status = resolved
> Queue = Main
> Created > 2004-06-01 07:00:00 GMT
> 
> I need a translation of that into mysql command-line client syntax ..
> 
> Which would be pretty easy if I were mysql fluent... so am asking for
> someone to show me with one example.
You can do it yourself:
http://wiki.bestpractical.com/index.cgi?Debug
turn on full sql log then do search and look into log for
'SELECT main.* from Tickets ...'

				Best regards.
> 
> Thanks!
> 
> Kind regards,
> 
> Dave D
> 
> +-------------------------
> + Dave Dennis
> + Seattle, WA
> + dmd at speakeasy.org
> + http://www.dmdennis.com
> +-------------------------
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> 
> RT Developer and Administrator training is coming to LA, DC and Frankfurt this spring and summer.
> http://bestpractical.com/services/training.html
> 
> Sign up early, as class space is limited.