When searching by free text criteria, e.g. contact by last name; change order by summary, etc. percent sign is not automatically added, despite Options Manager setting being configured correctly.
Option web_wildcard_search is installed with value Yes.
Steps to reproduce:
Search > Contact
Fill in a few letters of last name, e.g. "john" and click Search. No results found.
Click on Show Filter. Expected to see percent sign added to the last name filter, e.g. john%, but it’s not.
Examining the NX.env and found this value present:
@NX_WEB_WILDCARD_SEARCH=yes
The above should be:
@NX_WEB_WILDCARD_SEARCH=Yes
Note the case difference between "Yes" and "yes"
Release : 17.3
Component : CA Service Management - Service Desk Manager
NX and Options value entries are case sensitive. One may need to run pdm_options_mgr to correct these values, ie, from an Admin Command Prompt on the SDM Server, run:
pdm_options_mgr -c -s WEB_WILDCARD_SEARCH -v Yes -a pdm_option.inst
pdm_options_mgr -c -s WEB_WILDCARD_SEARCH -v Yes -a pdm_option.inst -t
One can also check the setting in the Options table by running:
pdm_extract -f "Select value, sym, id, persid from Options where sym = 'WEB_WILDCARD_SEARCH'"