Question
8
Replies
1499
Views

CYBG
GB
Posted: September 19, 2016
Last activity: October 6, 2016
Last activity: 6 Oct 2016 10:13 EDT
Closed
Solved
Report Definition filter incorrectly changed to equals
I have built a Report Definition rule. In it there is a filter on surname. The business requirement is for the surname to a) be matched by "Starts with" to allow for partial searches, and b) that it is case-insensitive.
- When I set the filter to be "Cust.Surname Starts with Param.Surname" it works fine.
- When I set the filter to be "Upper case version of [Cust.Surname] Is equal Upper case version of [Param.Surname]" it works fine.
- When I set the filter to be "Upper case version of [Cust.Surname] Starts with Upper case version of [Param.Surname]" it builds the SQL to use "=" instead of "LIKE", i.e.:
...AND UPPER("Cust".SURNAME) = UPPER(? ) AND...
Please can someone confirm if there is a work around for this, or a hotfix? Or is this functionality not currently supported?
Many thanks,
Mike.