Hello,
Does anyone know how to turn off case sensitivity in IFS version 9?
Many thanks
This topic has been closed for comments
Userlevel 6
+15
Hi
I hope you are referring to the search dialog match case option?
If so you could simply change the default behavior.
1. Navigate to "System Parameters" window (Solution Manager\System Parameters).
2. Search for [Parameter: Search dialog Match case Default]
3. Change the value to "OFF".
The personal profile takes precedence, hence changes are not visible if this was modified in the personal profile.
Please note that changing this option will have a negative impact on of the overall search performance of the application.
Cheers !
Dhananjaya.
Hi
Very helpful, thank you
May I ask you what do you mean when you say “negative impact on of the overall search performance”?
Case sensitive searches are much faster than when the case is ignored. Turning it off for everyone across the board by default will mean everyone’s searches will be generally slower, not to mention they will not learn the proper format of the data.
Userlevel 6
+15
Hi
Hi
Very helpful, thank you
You are welcome and I'm happy to help 😊
May I ask you what do you mean when you say “negative impact on of the overall search performance”?
When you untick the match case option on the search dialog, it wraps each column and respective search expression with an UPPER() function.
Having function calls in a where clause reduces the performance on your queries since the standard indexes won't be considered.
Therefore, case in-sensitive searches are relatively slower than case sensitive searches.
Hence, it's recommended to keep "Search dialog Match case Default" value as "ON".
Cheers !
Dhananjaya.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.