DFF where clause :{PARAMETER.values} — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!