Question
2
Replies
171
Views
Posted: November 16, 2016
Last activity: November 16, 2016
Closed
Issue With Report Definition
I am using one Report Definition (V 7.1.9) to pull data from DB. In one of the filter condition in bothe the Column Source and Value fields I am using UpperCase Function and given the relationship as "contains". But the query is going like Upper(ColumnName) = Upper(?) although it should be Upper(ColumnName) LIKE Upper(?). Why this is happening?
***Updated by moderator: Lochan to add Categories***
Moderation Team has archived post,
Close popover
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.
Posted: 4 years ago
This is expected behaviour.
If we use a function in RHS of a filter condition, the filter operand is treated as equal.
Please let me know if below article helps.
https://pdn.pega.com/support-articles/function-not-working-properly-report-definition-filter