Question

8
Replies
1234
Views
MichaelF1903 Member since 2012 26 posts
CYBG
Posted: 4 years ago
Last activity: 4 years ago
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
Share this page LinkedIn