Works fine on Oracle. You need Full Text Search (FTS), though. It's pretty well-documented, but essentially you need to purchase FTS licenses, allocate them to appropriate users (Full Text License Type), and index desired fields for FTS (field Properties, Database page, note checkbox - Index For FTS).
Also noteworthy, contents of diary fields that have been indexed for FTS
are "visible" to workflow. This can be a good or bad thing.
Mike White
Office: 813-978-2192
E-mail: [EMAIL PROTECTED]
"Shibu Samuel"
<[EMAIL PROTECTED] To: [email protected]
COM> cc:
Sent by: "Action Subject: Re: Search on diary
field
Request System
discussion
list(ARSList)"
<[EMAIL PROTECTED]
ORG>
08/15/2006 10:08
Please respond to
arslist
We are on Unix and using Oracle
-----Original Message-----
From: Action Request System discussion list(ARSList) on behalf
of Frank Caruso
Sent: Tue 8/15/2006 2:58 PM
To: [email protected]
Cc:
Subject: Re: Search on diary field
** It depends on your database. What database and OS are you
using?
I can speak for Sybase 12.5 and that it is possible to search
a diary field.
On 8/15/06, Shibu Samuel <[EMAIL PROTECTED]> wrote:
Hi,
Is it possible to perform a search for a keyword
on Diary Field ?
If possible pleae let me know, how i can achieve
this.
Sam
--
Frank Caruso
Specific Integration, Inc.
Senior Remedy Engineer
www.specificintegration.com
703-376-1249 __20060125_______________________This posting was
submitted with HTML in it___
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
