[rt-users] Web.pm: Limit requestor email

[Roland von Herget]

after writing the last email i found a few other lines:

SELECT DISTINCT main.* FROM Tickets main, Watchers Watchers_1, Users
Users_2, Watchers Watchers_3, Users Users_4   WHERE ((Users_2.EmailAddress
LIKE '%SG%')) AND ((Watchers_3.Type = 'Requestor')) AND ((Watchers_3.Scope
= 'Ticket')) AND ((Watchers_1.Scope = 'Ticket')) AND
((Users_4.EmailAddress = '%SG%')) AND ((Watchers_1.Type =
'Requestor')) AND Watchers_1.Owner = Users_2.id AND main.id =
Watchers_1.Value AND Watchers_3.Owner = Users_4.id AND main.id =
Watchers_3.Value  ORDER BY main.id ASC



SELECT DISTINCT main.* FROM Tickets main, Watchers Watchers_1, Users
Users_2   WHERE ((Users_2.EmailAddress = '%SG%')) AND ((Watchers_1.Scope =
'Ticket')) AND ((Watchers_1.Type = 'Requestor')) AND Watchers_1.Owner =
Users_2.id AND main.id = Watchers_1.Value  ORDER BY main.id ASC


?!

Roland



On Tue, 10 Jul 2001, Jesse wrote:

> That just doesn't sound right. do you have mysql logging turned on?
> What queries is RT generating against the database?
> 
> 
> On Tue, Jul 10, 2001 at 06:22:57PM +0200, Roland von Herget wrote:
> > 
> > Hmmm,
> > 
> > ok than I have another problem, we create tickets via web UI and put
> > something like 'aaaa bbbb xy-34232' into the requestors field.
> > now I want to find this record, I know only 'bbbb'.
> > If I type 'bbbb' into search after requestors email (using 'Contains'), I
> > get no matches. (I also tried find '%bbbb%')
> > what can I do for getting this working ?
> > where do I have to start ?
> > 
> > Thanks,
> > 
> > Roland
> > 
> > 
> > On Tue, 10 Jul 2001, Jesse wrote:
> > 
> > > The debug comment got pulled because there wasn't a bug in the code.
> > > The UI was slightly misleading. That'll be fixed in 2.0.1 (It's fixed in CVS
> > > now)
> > > 
> > >         -j
> > > 
> > > On Tue, Jul 10, 2001 at 02:38:53PM +0200, Roland von Herget wrote:
> > > > Hi all,
> > > > 
> > > > I've a problem:
> > > > 
> > > > we are using rt-2.0.0 in production now and have the problem that we can't
> > > > search for requestors emails via the Web interface:
> > > > I found this in Web.pm:
> > > > 
> > > > line 215:
> > > > # {{{ Limit requestor email
> > > > #TODO this doesn't work
> > > >     
> > > > if ($args{ARGS}->{'ValueOfRequestor'} ne '') {
> > > >  my $alias=$session{'tickets'}->LimitRequestor (
> > > > 			       VALUE => $args{ARGS}->{'ValueOfRequestor'},
> > > > 			       OPERATOR => $args{ARGS}->{'RequestorOp'},
> > > > 			      );
> > > > 	
> > > > }
> > > > # }}}
> > > > 
> > > > ok the TODO: line tells all I think. 
> > > > In the current cvs version this TODO line isn't there any longer, but I
> > > > can't find any related fixes in the current cvs version.
> > > > 
> > > > Does this work in the cvs version ?
> > > > Which fixes do I have to apply to rt-2.0.0 for fixing it ?
> > > > 
> > > > 
> > > > Thanks a lot,
> > > > 
> > > > Roland
> > 
> > 
> 
> -- 
> jesse reed vincent -- root at eruditorum.org -- jesse at fsck.com 
> 70EBAC90: 2A07 FC22 7DB4 42C1 9D71 0108 41A3 3FB3 70EB AC90
> 
> Linux is like a Vorlon.  It is incredibly powerful, gives terse,
> cryptic answers and has a lot of things going on in the background.
>