Web.pm: Limit requestor email

RT Users
1

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

2

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)

    -jOn 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

rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

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

Gur SOV jnagf gb znxr guvf fvt vyyrtny.

3

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,

RolandOn 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

4

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@eruditorum.org – jesse@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.

5

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,

RolandOn 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

6

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

?!

RolandOn 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@eruditorum.org – jesse@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.

7

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@eruditorum.org – jesse@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

8

This should be fixed in RT 2.0.1-test3, which was released about 20 minutes
ago.

    -jOn 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@eruditorum.org – jesse@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@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

jesse reed vincent – root@eruditorum.org – jesse@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

9

Thanks a lot,

we will test it during the weekend…

Greetings,

RolandOn 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@eruditorum.org – jesse@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@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

–
jesse reed vincent – root@eruditorum.org – jesse@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