Options configurations are not functioning correctly.

Products

• CA Service Desk Manager
• CA Service Management - Service Desk Manager

Issue/Introduction

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.

Environment

Release : 17.3

Component : CA Service Management - Service Desk Manager

Cause

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"

Resolution

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'"