Skip to main content
Contact a Moderator

Question

2
Replies
219
Views
 Saikat Das (SaikatD3)
HCL Technologies BV

HCL Technologies BV
NL
SaikatD3 Member since 2013 13 posts
HCL Technologies BV
Posted: November 16, 2016
Last activity: November 16, 2016
Posted: 16 Nov 2016 6:01 EST
Last activity: 16 Nov 2016 8:03 EST
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***

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.
Posted: 5 years ago
Posted: 16 Nov 2016 8:03 EST
Swati Damele (dames)
Tetrasoft India Private Limited
Module Lead
Tetrasoft India Private Limited
IN

This is expected behaviour.


If we use a function in RHS of a filter condition, the filter operand is treated as equal.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice