Keyword search by body

RT Users
1

Hi,
I was wondering if anyone had written a function to search through the
body of the tickets by keyword.

 Regards,

 Chris Beaumont,
 Developer, AdOps, ZDNet UK
2

Hello,

Look at the list archives for the past three days for this very
discussion. I believe the subject was “Database tables”.

3

Hi,

The reason i asked is because I have written some code that will acomplish
this. If anyone would like it (keyword search by body), drop me a line and
I will publish it on the list.

Regards,

Chris Beaumont,

Developer, AdOps, ZDNet UK.

bill@daze.net
15/02/2001 18:03To: Chris Beaumont Chris_Beaumont@zdnet.com
cc: rt-users@lists.fsck.com
bcc: Chris Beaumont/CTG/LON/ZDNEUR
Subject: Re: [rt-users] [rt-users]keyword search by body

[IMAGE]
Hello,

Look at the list archives for the past three days for this very
discussion. I believe the subject was “Database tables”.

I was wondering if anyone had written a function to search through the
body of the tickets by keyword.

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

4

OK no problem! It’ll have to wait until monday though as our LAN’s gone
down this afternoon and I cant get at any of my scripts!

Regards,

Chris Beaumont,
Developer, AdOps, ZDNet UK

|--------±------------------------->
| | “Chris Beaumont”|
| | <Chris_Beaumont@|
| | zdnet.com> |
| | |
| | 16/02/01 10:28 |
| | |
|--------±------------------------->

-----------------------------------------------------------------------|
| |
| To: bill@daze.net |
| cc: rt-users@lists.fsck.com, (bcc: Chris |
| Beaumont/CTG/LON/ZDNEUR) |
| Subject: Re: [rt-users] [rt-users]keyword search by body |

5

The reason i asked is because I have written some code that will acomplish
this. If anyone would like it (keyword search by body), drop me a line and
I will publish it on the list.

I think it would be a step in the right direction to continue that very
discussion… so go ahead, post away!

Regards,
Bill

6

bill@daze.net wrote:

The reason i asked is because I have written some code that will acomplish
this. If anyone would like it (keyword search by body), drop me a line and
I will publish it on the list.

I think it would be a step in the right direction to continue that very
discussion… so go ahead, post away!

What he said

Steve Sobol, BOFH, President 888.480.4NET 866.DSL.EXPRESS 216.619.2NET
North Shore Technologies Corporation http://NorthShoreTechnologies.net
JustTheNet/JustTheNet EXPRESS DSL (ISP Services) http://JustThe.net
mailto:sjsobol@NorthShoreTechnologies.net Proud resident of Cleveland, Ohio

7

i thought i posted this on friday but it looks like it never got out there
for some reason!?!

anyway :

Right the LAN’s back up now so i cant go home =o( but on the plus side i
got the script…

I may have misled people a bit in that this isnt a search script which
integrates into RT, rather grabs the listings stored in >the
/install-path/rt/transactions/ dirs and performs a rudimentary keyword
search. It then provides a link to the RT Ticket >viewer BUT you must be
logged in to see it, otherwise you will be taken to the RT login screen. I
wrote it in an afternoon >and its one of my first efforts at Perl so
forgive me if its a little simplistic. If anyone comes up with
improvements, please >mail them back onto the list so i can integrate them.
Enjoy =o)

btw - my rt install sits in /usr/local/rt/ and therefore i installed this
script in /usr/local/rt/bin/cgi/

Comments welcome.

Chris Beaumont,
Developer, AdOps, ZDNet UK.

Steve Sobol sjsobol@NorthShoreTechnologies.net
16/02/2001 17:40To: bill@daze.net, rt-users@lists.fsck.com
cc:
bcc: Chris Beaumont/CTG/LON/ZDNEUR
Subject: Re: [rt-users] [rt-users]keyword search by body

[IMAGE]
bill@daze.net wrote:

The reason i asked is because I have written some code that will
acomplish
this. If anyone would like it (keyword search by body), drop me a line
and
I will publish it on the list.

I think it would be a step in the right direction to continue that very
discussion… so go ahead, post away!

What he said

Steve Sobol, BOFH, President 888.480.4NET 866.DSL.EXPRESS 216.619.2NET
North Shore Technologies Corporation http://NorthShoreTechnologies.net
JustTheNet/JustTheNet EXPRESS DSL (ISP Services) http://JustThe.net
mailto:sjsobol@NorthShoreTechnologies.net Proud resident of Cleveland, Ohio

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

(See attached file: search.cgi)

search.cgi (9.14 KB)

8

Hi,

The bug in this script is that you have to be logged into RT in order to go
and view the results in RT. Is there a way I can use the code in auth.pm
to send a cookie to trick RT into thinking that the request for an RT
ticket (using webrt.cgi?serial_num=xx ) is coming from a logged in user? I
was thinking that I could setup a guest user and instead of letting the
code expect an RT_PASSWORD and RT_USERNAME i could hard code them in as
un:guest pw:guest. Im not asking for a coded answer to the problem, merely
quizing as to whether this is feasable before I get into pulling auth.pm
apart.

Regards,

Chris Beaumont,

Developer, AdOps, ZDNet UK.

“Chris Beaumont” Chris_Beaumont@zdnet.com
19/02/2001 10:22To: Steve Sobol sjsobol@NorthShoreTechnologies.net
cc: bill@daze.net, rt-users@lists.fsck.com
bcc: Chris Beaumont/CTG/LON/ZDNEUR
Subject: Re: [rt-users] [rt-users]keyword search by body

[IMAGE]

i thought i posted this on friday but it looks like it never got out there
for some reason!?!

anyway :

Right the LAN’s back up now so i cant go home =o( but on the plus side i
got the script…

I may have misled people a bit in that this isnt a search script which
integrates into RT, rather grabs the listings stored in >the
/install-path/rt/transactions/ dirs and performs a rudimentary keyword
search. It then provides a link to the RT Ticket >viewer BUT you must be
logged in to see it, otherwise you will be taken to the RT login screen. I
wrote it in an afternoon >and its one of my first efforts at Perl so
forgive me if its a little simplistic. If anyone comes up with
improvements, please >mail them back onto the list so i can integrate them.
Enjoy =o)

btw - my rt install sits in /usr/local/rt/ and therefore i installed this
script in /usr/local/rt/bin/cgi/

Comments welcome.

Chris Beaumont,
Developer, AdOps, ZDNet UK.

Steve Sobol sjsobol@NorthShoreTechnologies.net
16/02/2001 17:40

To: bill@daze.net, rt-users@lists.fsck.com
cc:
bcc: Chris Beaumont/CTG/LON/ZDNEUR
Subject: Re: [rt-users] [rt-users]keyword search by body

[IMAGE]
bill@daze.net wrote:

The reason i asked is because I have written some code that will
acomplish
this. If anyone would like it (keyword search by body), drop me a line
and
I will publish it on the list.

I think it would be a step in the right direction to continue that very
discussion… so go ahead, post away!

What he said

Steve Sobol, BOFH, President 888.480.4NET 866.DSL.EXPRESS 216.619.2NET
North Shore Technologies Corporation http://NorthShoreTechnologies.net
JustTheNet/JustTheNet EXPRESS DSL (ISP Services) http://JustThe.net
mailto:sjsobol@NorthShoreTechnologies.net Proud resident of Cleveland, Ohio

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

(See attached file: search.cgi)

[IMAGE]

search.cgi (9.14 KB)