• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

New requirement

Sheen

Member
Im a newbee for JDE development. pls help in understanding this req and how to approach the solution:

There is a table with 7 records with a unique key
Job Code : J and E.

there are 3 records with J type and 4 records of E type in this table F5509002.
J - is Job type and it has 3 mandotory training courses for that Job and
E - is for Employee the available courses are 4.

requirement is to compare both these J and E types and look for matching training courses
and display the course that is missing in a given date range(table has Job Code, effective start date and End date)

My question is how do I compare these records within the same table and get the desired result.

The report is to be run by Employee or by Company.

Sample data:
SDB JBCD(Job Code) KY(Training Code) EFT EFTE
E 100 ABE 1/1/2014 12/31/2014
E 100 ABSLS 1/1/2013 12/31/2013
E 100 ACMCL1 1/1/2014 12/31/2014
E 100 ABSLS 1/1/2013
J 100 ABE
J 100 ABSLS
J 100 AC

Based on this example the report should print
J 100 AC
as this is mandatory for Job but not available for the Employee.
Please help.
 
Top