Re: Case sentive In ITSM problem management

2012-02-08 Thread Rod Harris
Thanks Jose, You've answered my questions pretty well. Rod On 8 February 2012 20:51, Jose Huerta wrote: > ** Indexes in remedy are mainly text indexes. Normally other applications > index keys (primary and foreign) and search fields. Since in Remedy keys > are text based, almost all indexes a

Re: Case sentive In ITSM problem management

2012-02-08 Thread Jose Huerta
Indexes in remedy are mainly text indexes. Normally other applications index keys (primary and foreign) and search fields. Since in Remedy keys are text based, almost all indexes are text based. With my script I duplicate only text based indexes (no date or number). But this means almost all index

Re: Case sentive In ITSM problem management

2012-02-08 Thread Rod Harris
Hi Jose, You are right in saying that Remedy defaults to case sensitive indexes for Oracle and to avoid performance issues when case insensitive you must maintain case insensitive indexes outside of Dev Studio/Remedy. Likewise I agree that performance on indexed queries will be indistinguishable

Re: Case sentive In ITSM problem management

2012-02-08 Thread Jose Huerta
In this post I cover how to turn the oracle database to case insensitive recreating all indexes. http://theremedyforit.com/2011/12/case-insensitive-in-remedy/ The result in our case, in performance term is: - Searches involving an indexed field -> Same performance as case sensitive. - Searches

Re: Case sentive In ITSM problem management

2012-02-07 Thread patchsk
Yes checking with the BMC account manager is the preferred method. Thanks Nathan for correcting it. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers

Re: Case sentive In ITSM problem management

2012-02-07 Thread Nathan Aker
(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of patchsk Sent: Tuesday, February 07, 2012 9:56 AM To: arslist@ARSLIST.ORG Subject: Re: Case sentive In ITSM problem management ** The case sensitiveness is a limitation on the database. Oracle by default is case sensitive and you need to change its

Re: Case sentive In ITSM problem management

2012-02-07 Thread Tauf Chowdhury
Just a note on changing or using Oracle case insensitivity. From what I hear, it is not usually recommended because it will significantly degrade your performance. On Tue, Feb 7, 2012 at 10:55 AM, patchsk wrote: > ** The case sensitiveness is a limitation on the database. > Oracle by default is

Re: Case sentive In ITSM problem management

2012-02-07 Thread patchsk
The case sensitiveness is a limitation on the database. Oracle by default is case sensitive and you need to change its configuration to make it case insensitive, but you need to recreate your indices. You can do a search on this forum for more information if it is workable. However MS SQL server

Re: Case sentive In ITSM problem management

2012-02-07 Thread Nathan Aker
(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

Re: Case sentive In ITSM problem management

2012-02-07 Thread Tauf Chowdhury
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 f

Re: Case sentive In ITSM problem management

2012-02-07 Thread vidyasagar kommu
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 wrote: > Can you first give your environment specifications? DB, ARS version, etc... > > On Tue, Feb 7, 2012 at 10:24 AM, vid

Re: Case sentive In ITSM problem management

2012-02-07 Thread Tauf Chowdhury
Can you first give your environment specifications? DB, ARS version, etc... On Tue, Feb 7, 2012 at 10:24 AM, vidyasagar kommu 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

Re: Case sentive In ITSM problem management

2012-02-07 Thread vidyasagar kommu
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

Re: Case sentive In ITSM problem management

2012-02-07 Thread Tauf Chowdhury
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 wrote: > Hi , > > How to make the

Case sentive In ITSM problem management

2012-02-07 Thread vidyasagar kommu
Hi , How to make the fields generic instead of Case sensitive? -- Thanks Sagar ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"