That's exactly what happened. There's over 100 words on the ignore list for
FTS that we have to watch out for. Luckily, these are only test accounts so
I'm just going to educate the customer and not update the ignore list.
Thanks!
Lisa
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of William Rentfrow
Sent: Saturday, August 29, 2015 9:10 PM
To: arslist@ARSLIST.ORG
Subject: Re: FTS and Character Fields (with less than 3 characters)
Is "Ar" in the ignore words list?
William Rentfrow
wrentf...@stratacominc.com
Office: 715-204-3061 or 701-232-5697x25
Cell: 715-498-5056
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Kemes, Lisa A DLA CTR INFORMATION
OPERATIONS
Sent: Thursday, August 27, 2015 3:45 PM
To: arslist@ARSLIST.ORG
Subject: FTS and Character Fields (with less than 3 characters)
We are using ARS 8.1 SP2, have an Oracle Database and turned on FTS. I also
enabled FTS on the First and Last Name character fields on the CTM:People form.
Before we enabled FTS and added the FTS property to these two fields, I was
able to do a search on First Name = "Ar" and get back many records that have
the characters ar in the first name INCLUDING the one record that I really need
returned that the first name IS only "Ar".
But when I added the FTS property to the First Name field, I get back all
records with ar in the first name EXCEPT the first name that's actually Ar.
Is there something with FTS that does not allow character fields with less than
three characters get indexed or something? Why does this not return the record
that I actually need?
I've tested this with many other First Names that were less than three
characters: Go, No, Ar, but I was able to create a person with a first name of
Le and it found this person when doing a search.
Maybe Go, No and Ar are reserved words???
Anyone else experience this?
Lisa
Lisa Kemes
Remedy Consultant
Dev Technology Group
DLA Office: (717) 770-6437
Cell Phone: (717) 602-9460
lisa.ke...@devtechnology.com
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers
Are, and have been for 20 years"
-
No virus found in this message.
Checked by AVG - www.avg.com
Version: 2014.0.4830 / Virus Database: 4365/10537 - Release Date: 08/29/15
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers
Are, and have been for 20 years"
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"