[rt-users] full text search, including custom fields?

[Ruslan Zakirov]

Hi,

Not a good idea. It's gonna be slow quickly. Extract all phones
mentioned in into a custom field. You can do it with a scrip.

On Wed, Jun 15, 2011 at 6:51 PM, Michael W. Lucas
<mwlucas at blackhelicopters.org> wrote:
> Hi,
>
> My users need to be able to search by phone number. That is, they need
> to be able to search for, say, 301-555-1212, and see all tickets where
> that number appears.  Most of our queues have a custom field for phone
> numbers, but phone numbers can also appear in message bodies.
>
> It appears that a simple search with fulltext: searches only the
> ticket comments and replies.  I'd like to have the fulltext search
> also check my custom fields.  Is there a simple way to achieve this?
>
> Running RT 3.8.6 on pgsql and FreeBSD.
>
> Thanks for any suggestions,
> ==ml
>
> --
> Michael W. Lucas
> http://www.MichaelWLucas.com/, http://blather.MichaelWLucas.com/
> Latest book: Network Flow Analysis http://www.networkflowanalysis.com/
> mwlucas at BlackHelicopters.org, Twitter @mwlauthor
>



-- 
Best regards, Ruslan.