Query eff dt criteria in 9.2 doesn't pull all rows
edited Oct 20, 2015 7:27AM in PeopleTools and Lifecycle Management - PSFT (MOSC) 1 commentAnswered ✓
Using query tool in 9.2. When I select EFFDT with the criteria of Eff Dt => or Eff Dt > a constant, the results do not return all rows. The SQL should not be looking at MIN EFFDT. Has anyone experienced this in 9.2?
Example:
EE has 3 rows in Job.
4/13/2015 XFR action
8/1/2015 DTA action
9/1/205 RWP action
Query criteria EFFDT where Eff Dt => constant "01/01/2015"
SQL is writing as follows:SELECT A.EMPLID, A.EMPL_RCD, A.EFFDT, A.ACTION, A.EMPL_STATUS, A.LASTUPDDTTM
FROM PS_JOB A
WHERE ( A.EMPLID = '02824'
AND A.EFFDT =
(SELECT MIN(A_ED.EFFDT) FROM PS_JOB A_ED
Tagged:
0