Search Funtionality

I am fairly new in the RT arena, but I am having some difficulties. I have
created some sample tickets to do some testing. Everything seems to work
well except the search functionality. I try to search from something within
the ticket (ie the body of the ticket) and I get zero returned results.
However, I am able to search for something within the ticket subject and get
a returned result. Is RT able to search through the ticket body to return
results? Or do I have to modify it is some what to where the results will
return when I search for something within the ticket body.

I have researched this problem in the wiki and through google, without any
luck. Hopefully someone will be able to shed some light on this subject.

Thanks,

Kyle

Are you using the Advanced or Simple Search? I’ve had success searching
within the body using the Simple Search but, of course, you don’t have
much control of the function of it.

If we don’t protect freedom of speech, how will we know who the assholes
are?
http://theillien.blogspot.com

Kyle Sharp wrote:

I have tried both the simple search and the advanced search. Under the
advanced search, I have selected “Content LIKE [Insert Word]” with the
results still returned zero. Maybe I have set something up incorrectly, but
I’m not sure.

Thanks for the responseFrom: Mathew [mailto:theillien@yahoo.com]
Sent: Friday, January 05, 2007 10:46 AM
To: Kyle Sharp
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Search Funtionality

Are you using the Advanced or Simple Search? I’ve had success searching
within the body using the Simple Search but, of course, you don’t have
much control of the function of it.

If we don’t protect freedom of speech, how will we know who the assholes
are?
http://theillien.blogspot.com

Kyle Sharp wrote:

I am fairly new in the RT arena, but I am having some difficulties. I
have
created some sample tickets to do some testing. Everything seems to work
well except the search functionality. I try to search from something
within
the ticket (ie the body of the ticket) and I get zero returned results.
However, I am able to search for something within the ticket subject and
get
a returned result. Is RT able to search through the ticket body to return
results? Or do I have to modify it is some what to where the results will
return when I search for something within the ticket body.

I have researched this problem in the wiki and through google, without any
luck. Hopefully someone will be able to shed some light on this subject.

Thanks,

Kyle


The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

I have tried both the simple search and the advanced search. Under the
advanced search, I have selected “Content LIKE [Insert Word]” with the
results still returned zero. Maybe I have set something up incorrectly, but
I’m not sure.

Hi Kyle,

I am able to search the content of correspondence by using just the phrase
you mention in the advanced search: “Content LIKE ‘computer’”.

Also, you can simulate this in the simple search by using the modifier
"fulltext:" If you type “fulltext:computer” (unquoted) into the simple
search, it produces a TicketSQL of “( Content LIKE 'computer )”.

And both of these return tickets (quite a few of them, as a matter of fact).

Maybe it’s a permissions issue. Are you logged in as a “superuser”? Might
try that to just see if it is a permissions issue. BTW, mine works using
3.6.3rc4 I can’t speak to other versions… Looks like Fulltext was added
back to simple search in 3.6.0, but that’s all I could find about it.

Hope that helps,
Erik

Erik Peterson
Education Development Center, Inc.

I have actually performed that function within the search function
(selecting content, enter the word I am searching for, adding it to the
search), still have a returned result of zero. The setup that I am using is
RT ver. 3.4.5, ActivePerl ver. 5.8.8, Apache server 2.2.3, and MySQL Server
5.0. This is on a windows XP machine. I have also attempted to use the RT
ver 3.6.1 on a linux box using the same Apache and MySQL, but am still
having the same problem.From: Scott Golby [mailto:sgolby@freshdirect.com]
Sent: Friday, January 05, 2007 11:22 AM
To: Kyle Sharp
Subject: RE: [rt-users] Search Funtionality

I haven’t tested it to death, because its appeared to work fine for me.

I go to the Tickets, New Search on the left.
Pull down the ‘Subject’ and change that to ‘Content’ - matches - and
enter in what ever word I’m looking for in the box to the right.
Hit the little tiny Add button in the middle, and it puts
Content LIKE ‘whatever’ in the box at the top right. (nice to see what
its doing first before moving on)
Then I hit the Add and Search button.

I’m definitely getting words from within the ticket which aren’t in the
subject line.

I’m running Postgres 7.4 as the database, RT 3.6.1 and have previously
run RT 3.4 on MySQL 4.0 and that worked too.

Hope you can get it working, it’s a really useful feature once you have
a bunch of tickets in RT and you need to find the last time you fixed
‘whatever’.

  • Scott

From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Kyle
Sharp
Sent: Friday, January 05, 2007 1:55 PM
To: rt-users@lists.bestpractical.com
Subject: RE: [rt-users] Search Funtionality

I have tried both the simple search and the advanced search. Under the
advanced search, I have selected “Content LIKE [Insert Word]” with the
results still returned zero. Maybe I have set something up incorrectly,
but
I’m not sure.

Thanks for the response

From: Mathew [mailto:theillien@yahoo.com]
Sent: Friday, January 05, 2007 10:46 AM
To: Kyle Sharp
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Search Funtionality

Are you using the Advanced or Simple Search? I’ve had success searching
within the body using the Simple Search but, of course, you don’t have
much control of the function of it.

If we don’t protect freedom of speech, how will we know who the assholes
are?
http://theillien.blogspot.com

Kyle Sharp wrote:

I am fairly new in the RT arena, but I am having some difficulties. I
have
created some sample tickets to do some testing. Everything seems to
work
well except the search functionality. I try to search from something
within
the ticket (ie the body of the ticket) and I get zero returned
results.
However, I am able to search for something within the ticket subject
and
get
a returned result. Is RT able to search through the ticket body to
return
results? Or do I have to modify it is some what to where the results
will
return when I search for something within the ticket body.

I have researched this problem in the wiki and through google, without
any
luck. Hopefully someone will be able to shed some light on this
subject.

Thanks,

Kyle


The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

I just attempted the “fulltext:(word)” method and have not returned any
results. This is all being performed under root.From: Peterson, Erik [mailto:epeterson@edc.org]
Sent: Friday, January 05, 2007 12:26 PM
To: Kyle Sharp; rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Search Funtionality

I have tried both the simple search and the advanced search. Under the
advanced search, I have selected “Content LIKE [Insert Word]” with the
results still returned zero. Maybe I have set something up incorrectly,
but
I’m not sure.

Hi Kyle,

I am able to search the content of correspondence by using just the phrase
you mention in the advanced search: “Content LIKE ‘computer’”.

Also, you can simulate this in the simple search by using the modifier
“fulltext:” If you type “fulltext:computer” (unquoted) into the simple
search, it produces a TicketSQL of “( Content LIKE 'computer )”.

And both of these return tickets (quite a few of them, as a matter of fact).

Maybe it’s a permissions issue. Are you logged in as a “superuser”? Might
try that to just see if it is a permissions issue. BTW, mine works using
3.6.3rc4 I can’t speak to other versions… Looks like Fulltext was added
back to simple search in 3.6.0, but that’s all I could find about it.

Hope that helps,
Erik

Erik Peterson
Education Development Center, Inc.