search help issue

[Former Member]

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

[Former Member]

Yes.

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

Regards,

Atish

[Former Member]

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.