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

Jesse jesse at fsck.com
Tue Jul 10 12:58:56 EDT 2001


Ok. it looks like it's only searching for users who are watchers, as opposed
to strings who are watchers.  hrm. I'll have to think about the right way
to fix that.


On Tue, Jul 10, 2001 at 06:54:42PM +0200, Roland von Herget wrote:
> 
> 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
> 
> 

-- 
jesse reed vincent -- root at eruditorum.org -- jesse at fsck.com 
70EBAC90: 2A07 FC22 7DB4 42C1 9D71 0108 41A3 3FB3 70EB AC90

A REAL sysadmin challenge is "resurrect five dead mailserver while so ripped
to the gills on mdma that you can't focus on any given line of text for more 
than 10 seconds continuously."
					-Nathan Mehl




More information about the rt-users mailing list