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

Roland von Herget rherget at xebec.de
Wed Jul 11 04:02:26 EDT 2001


Thanks a lot,

we will test it during the weekend...

Greetings,

Roland

On Tue, 10 Jul 2001, Jesse wrote:

> This should be fixed in RT 2.0.1-test3, which was released about 20 minutes
> ago.
> 
>         -j
> 
> 
> On Tue, Jul 10, 2001 at 12:58:56PM -0400, Jesse wrote:
> > 
> > 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
> > 
> > _______________________________________________
> > rt-users mailing list
> > rt-users at lists.fsck.com
> > http://lists.fsck.com/mailman/listinfo/rt-users
> > 
> 
> -- 
> jesse reed vincent -- root at eruditorum.org -- jesse at fsck.com 
> 70EBAC90: 2A07 FC22 7DB4 42C1 9D71 0108 41A3 3FB3 70EB AC90
> 
> There are no supercomputer applications that are solvable that cannot be solved
> in finite time using a fucking TRS-80 with approprite disk/tape drives.  Zero.
> 									-Tanj
> 





More information about the RT-Users mailing list