in
Sent: Thursday, October 12, 2006 11:45 AM
To: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] MySQL Query from PHP
RT's database is heavily normalized.
You'll need to use "left join" in your mysql statements. Here's an
example:
select
t.id,q.Name,t.Subject,
On Thu, Oct 12, 2006 at 09:59:07AM -0700, Schultz, Eric wrote:
> > RT's database is heavily normalized.
>
> I wouldn't say "heavily" normalized, just moderately normalized. I've
> seen much, MUCH worse.
And we have a few places where we've explicitly denormalized for some
very realworld issue
> RT's database is heavily normalized.
I wouldn't say "heavily" normalized, just moderately normalized. I've
seen much, MUCH worse.
Eric Schultz
United Online, Inc.
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: h
RT's database is heavily normalized.
You'll need to use "left join" in your mysql statements. Here's an example:
select
t.id,q.Name,t.Subject,t.FinalPriority,t.Status,t.Created,t.LastUpdated,t.Resolved,u.Name,u.Name
from Tickets t left join Users u on u.id = t.Owner and u.id = t.LastUpdatedBy
I've create a small
interface in PHP that submits a ticket to RT using the
rt-mailgate.
However, I've been
trying to pull data from the MySQL database so I don't have to constantly
create/manage user accounts in RT. This cusotmized interface pulls the basic
ticket info from the Tickets ta
