Also, depending on your licensing... you may be able to use Full Text Search to index key fields such as the person First/Last name thus making it case insensitive even on an Oracle platform. Nate.
Nathan Aker ITSM Solution Architect McAfee, Inc. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Tauf Chowdhury Sent: Tuesday, February 07, 2012 9:40 AM To: arslist@ARSLIST.ORG Subject: Re: Case sentive In ITSM problem management ** OK, so what you would have to do is on the field that you are submitting on, you would need an active link that, on submit, performs an UPPER($field$) to submit the data as upper case. Then, when you are searching, you have to do the same using an active link to convert the search string for that field to upper case. This way, no matter what case the user types the data in for searching, it always gets submitted as upper case. Does that make sense? On Tue, Feb 7, 2012 at 10:35 AM, vidyasagar kommu <kommuvidyasa...@gmail.com<mailto:kommuvidyasa...@gmail.com>> wrote: Server Version: 7.1.00 Build 200708221849 Operating Sytem: Linux 2.6.18-53.1.14.el5 Data Base Version:10.2.0.4.0 - 64bi Data Base Type: Oracle On 2/7/12, Tauf Chowdhury <taufc...@gmail.com<mailto:taufc...@gmail.com>> wrote: > Can you first give your environment specifications? DB, ARS version, etc... > > On Tue, Feb 7, 2012 at 10:24 AM, vidyasagar kommu > <kommuvidyasa...@gmail.com<mailto:kommuvidyasa...@gmail.com> >> wrote: > >> My question Is like I have form with field FirstName when i am going >> to save the form i have given the field value "Test" and when i am >> searching for record i have given filed value "test" it is showing >> warring like no request match error but My requirmrment is it should >> display . >> >> Please help how to do . >> >> 2/7/12, Tauf Chowdhury <taufc...@gmail.com<mailto:taufc...@gmail.com>> >> wrote: >> > Assuming you're talking about a system sitting on an Oracle DB, you >> > would >> > have to create active links that perform an UPPER conversion (also >> assuming >> > that the data in the DB is upper case as well) on each field. >> > >> > On Tue, Feb 7, 2012 at 10:11 AM, vidyasagar kommu < >> kommuvidyasa...@gmail.com<mailto:kommuvidyasa...@gmail.com> >> >> wrote: >> > >> >> Hi , >> >> >> >> How to make the fields generic instead of Case sensitive? >> >> >> >> -- Thanks >> >> Sagar >> >> >> >> >> >> >> _______________________________________________________________________________ >> >> UNSUBSCRIBE or access ARSlist Archives at >> >> www.arslist.org<http://www.arslist.org> >> >> attend wwrug12 www.wwrug12.com<http://www.wwrug12.com> ARSList: "Where >> >> the Answers Are" >> >> >> > >> > >> > >> > -- >> > *Tauf Chowdhury >> > >> > * >> > >> > >> _______________________________________________________________________________ >> > UNSUBSCRIBE or access ARSlist Archives at >> > www.arslist.org<http://www.arslist.org> >> > attend wwrug12 www.wwrug12.com<http://www.wwrug12.com> ARSList: "Where the >> > Answers Are" >> > >> >> >> -- >> Sagar >> >> >> _______________________________________________________________________________ >> UNSUBSCRIBE or access ARSlist Archives at >> www.arslist.org<http://www.arslist.org> >> attend wwrug12 www.wwrug12.com<http://www.wwrug12.com> ARSList: "Where the >> Answers Are" >> > > > > -- > *Tauf Chowdhury > > * > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at > www.arslist.org<http://www.arslist.org> > attend wwrug12 www.wwrug12.com<http://www.wwrug12.com> ARSList: "Where the > Answers Are" > -- Sagar _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org<http://www.arslist.org> attend wwrug12 www.wwrug12.com<http://www.wwrug12.com> ARSList: "Where the Answers Are" -- Tauf Chowdhury _attend WWRUG12 www.wwrug.com<http://www.wwrug.com> ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"