Question

8
Replies
1336
Views
Michael Finlay (MichaelF1903)
CYBG

CYBG
GB
MichaelF1903 Member since 2012 26 posts
CYBG
Posted: September 19, 2016
Last activity: October 6, 2016
Posted: 19 Sep 2016 8:53 EDT
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.

Reporting
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.