SYMPTOM
Users may want to apply multiple conditions on a filter using the 'Contains' or 'Does not contain' operators in Strategy Developer 10.x. The intuitive approach is to separate each criterion with commas ',' but this will create a string that qualifies on all characters at the same time.
For example, qualifying on a,e,i,o,u qualifies on 'a,e,i,o,u' and not for each character individually, as shown in the image below, where the results include all vowels but excludes 'a comma e comma i comma o comma u'.
ACTION
Enclose all characters in brackets and separate each character with commas, e.g..
See the image below for an example where a user wanted to exclude all elements containing vowels:
This results in the correct SQL as shown in the image below, where the results exclude all vowels:
