Re: FTS and Character Fields (with less than 3 characters)
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"
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"
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"