Skip to Content
author's profile photo Former Member
Former Member

AET Field case sensitive issue

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?



Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Posted on Mar 27, 2015 at 11:55 AM

    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.



    case.PNG (16.0 kB)
    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Mar 27, 2015 at 11:57 AM

    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.



    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Mar 27, 2015 at 12:25 PM

    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.



    Add a comment
    10|10000 characters needed characters exceeded

    • 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.

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.