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

[Roland von Herget]

Ok:

i've search for 'SG': here it is:
SELECT DISTINCT main.* FROM Tickets main, Watchers Watchers_1, Users
Users_2   WHERE ((Users_2.EmailAddress LIKE '%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

looks good, what am I doing wrong ?

Greetings,

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