on 03-27-2015 11:46 AM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
5 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.