SYMPTOM:
An administrator would like to use Strategy Command Manager 9.x to create a filter based on an EXPRESSION when qualifying on the DESC form. In Strategy Tutorial, the following script returns the error 'Searching for 'Canada' resulted in no matches':
ACTION:
The characters ^” must be placed before and after every value entered when the field is of type text; even Text ID fields require the ^”. The new script is shown below:
This script returns the following results:
Refer to the following Strategy Knowledge Base technical note for more information:
KB9964 (KB6600-72X-0052): After modifying the expression of a filter using the ALTER FILTER statement in Strategy Command Manager 9.x the SQL generated for the report does not include quotes around the elements in the Between operator.
