AET Field case sensitive issue

[Former Member]

Hi ,

using the AET we added a new field from type CHAR20 to CRMD_ORDERADM_H.

We also marked this in AET as relevant for search.

After we added the field to the UI configuration of the searchview this works.

But this search is now case sensitive. Other standard searches are not case sensitive.

Does one of you experts know what we have to change to have this own ZField also not case sensitive in the search?

Regards,

Vishwa

[dharmakasi]

Hi Vishwanath,

Have you given direct char20 while creating the field? system is storing the values in DB in upper case. What you can do is inside search event you can take value entered for the field and convert it into upper case and then continue with seach.

Br,

Kasi.

[Former Member]

Hi Dharmakasi Deepika Chandrasekar

Please see below screen this field is lowercase enabled...

My issue is its work for the exact word only

For Example I have 2 entries with  TEST123(uppercase) and test123(Lowercase) but i will search for the creteria test123 then it should give two entries. In my case its works for the only exact word not like standard.

I saw one blog they havent mentioned solution but they told some thing is not availble for the cutsom fields in system

Regards,

Vishwanatha

[former_member214667]

Hi Vishwanatha,

As already mentioned, a case insensitive search is generally achieved by storing data in two different fields in the table - once in its actual case and next time in all uppercase. When such field is used for searching, the search criteria is also converted into all uppercase, and then it is used to search from the field in which data was stored in all uppercase.

So you need to implement something similar for your new field, if the search needs to be case insensitive.

[faisal_pc]

Hi Vishwanatha,

If you check the table BUT000, you will see the corresponding text fields for name 1 and name 2( or first name and last ) as MC_NAME1, MC_NAME2. These are the fields which makes the searching with any case even it's lower case or upper case. But if you check the domain of field First name which is BU_NAME, it allows lower case.  But for MC_NAME1 it won't allow and it stores the data as upper case only always.You can take some examples and see.

In order to make your field search relevant in all cases is, create one more field where the same value of your field will be saved with upper case. While searching, use this field to compare. Issue will be resolved.

Thanks,

Faisal

[deepika_chandrasekar]

Hi Vishwanatha,

You have to create the domain with lower case checked and create data type with that domain instead of CHAR20. than it will behave case sensitive.

Regards,

Deepika.