[rt-devel] When is a row in the User table created?

[Matthew Watson]

ok, what about when a privilaged user creates an RT, but changes the
requesters address? Is RT meant to creawted a user object for the requester.

Eg, A customer calls up the helpdesk, the helpdesk creates a trouble ticket
for the customer, with the customer as the requester?

I've tested this on the RT install I have (2.0.8) and RT doesn't seem to
create a user object, does it in the newever versions of RT?

Mat.


> -----Original Message-----
> From: Jesse Vincent [mailto:jesse at bestpractical.com]
> Sent: Friday, 11 January 2002 12:20 PM
> To: Matthew Watson
> Cc: rt-devel at lists.fsck.com
> Subject: Re: [rt-devel] When is a row in the User table created?
>
>
> Actually, in recent releases, RT always creates a user object and links
> to that from the relevant watcher object. The fact that it didn't do this
> before was somewhat of a normalization violation.  Basically the
> email address
> style watchers are only for watchers without RT accounts. (All requestors
> have non-privileged accounts automatically created)
>
>
> On Fri, Jan 11, 2002 at 11:41:36AM +1100, Matthew Watson wrote:
> > Heya ppls.
> >
> >  I'm trying to see if I can optimise the query the find all the tickets
> > requested
> > by a certain person.
> >
> > SELECT DISTINCT main.* FROM Tickets main,
> >    Watchers Watchers_1  LEFT JOIN Users as Users_2
> >    ON  Watchers_1.Owner = Users_2.id
> > WHERE ((Watchers_1.Scope = 'Ticket')) AND ((Watchers_1.Type =
> 'Requestor'))
> > AND ((Watchers_1.Email LIKE '%mwatson%')OR(Users_2.EmailAddress LIKE
> > '%mwatson%'))
> > AND main.id = Watchers_1.Value
> > ORDER BY main.id ASC LIMIT 50
> >
> > the "OR" really slows down the query alot, and it currently
> takes over 10
> > seconds on my
> > database to run (after tuning my database). Dropping the OR
> speeds up the
> > request, however it
> > doesn't pick up all the tickets by that user, as they dont seem
> to always
> > have an entry in Users table.
> >
> > So the question is, when are new users created? and when is the
> Email field
> > on the Watchers table filled in?
> >
> > If the Email field on the Watchers table was always filled in, then this
> > query could be cleaned up a little bit I think.
> >
> > Any thoughts?
> >
> > ----------------------------------------------
> > Matthew Watson
> > Development, Netspace Online Systems
> > mwatson at netspace.net.au
> >
> >
> > _______________________________________________
> > rt-devel mailing list
> > rt-devel at lists.fsck.com
> > http://lists.fsck.com/mailman/listinfo/rt-devel
> >
>
> --
> http://www.bestpractical.com/products/rt  -- Trouble Ticketing. Free.