Friday, July 17, 2009

CaseSensitive settings

Searchs in enovia are by default Case Sensitive.
Imagine the pain of the end user when trying to search for a person's userid if the users are named in mixed case eg: username "Mike Smith" and userid "mSmith".
Same goes for trying to find a person with last name "O'Connell", you never know if the name was entered as "o'Connell" or "O'connell" or "o'connell".

Thankfully, we can enable and disable "case sensitivity" in enovia according to our needs.

Below are the MQL statements to enable and disable case sensitivity.

set system CaseSensitive On;
set system CaseSensitive Off;

Please be aware that this is a system level settings, and the decision to enable or disable should be taken in the initially stages of the implementation.

if you have any questions regarding this post, Please let me know.

No comments:

Post a Comment