Question

2
Replies
180
Views
 Saikat Das (SaikatD3)
Tata Consultancy Services Ltd.

Tata Consultancy Services Ltd.
MY
SaikatD3 Member since 2013 13 posts
Tata Consultancy Services Ltd.
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: 4 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.