topic Re: search help issue in Application Development and Automation Discussions

search help issue

Former Member — Thu, 24 May 2007 08:25:18 GMT

When searching for a contract certain fields are case sensitive and will not provide results if the lower case is used. For instance, when search in the Contract Name field in "Active Contracts", if you enter abc no values will come up. If you enter "ABC* several locations will come up.

Is there a way for this to either be corrected to accept and recognize both upper or lower case or at a minimum provide a warning to use only capital letters? It is frustrating getting "no values" for a location that we know exists.

Thank you

Re: search help issue

Former Member — Thu, 24 May 2007 08:28:04 GMT

Yes.

It can be done, but for that you need to modify your standard search.

Regards,

Atish

Re: search help issue

Former Member — Thu, 24 May 2007 08:33:31 GMT

Hi Shewta,

Try the addition LOWERCASE with the parameter or Select-options Statement. This will allow the fields to accept any case.

Ex : parameters name like zemp-name lowercase.

If you want to display the message for enter Capital Letters means Try this,

Message 'Enter Capital Letters Only' type 'I'.

Thanks.

Reward If helpful.