DFF where clause :{PARAMETER.values}
Summary:
Hello,
On a Redwood Page (Locations) we have a DFF with a where clause on a date field.
The sql gives expected results in OTBI (data model) but on the page (where the DFF is used), we get different(unexpected) results.
The sql is :
select t1.POSITION_CODE, SUBSTR(t2.NAME,1,150)
FROM HR_ALL_POSITIONS_F t1 , HR_ALL_POSITIONS_F_TL t2
WHERE t1.POSITION_ID = t2.POSITION_ID
and t1.ACTIVE_STATUS = 'A'
AND( t1.EFFECTIVE_START_DATE =
(SELECT MAX(t4.EFFECTIVE_START_DATE) FROM HR_ALL_POSITIONS_F t4
WHERE t1.POSITION_ID = t4.POSITION_ID