How is it possible to strucutre a query first providing with all open jobs, released, with the max of lastlabordate from joboper.
I want to identify quickly on a tracker all jobs currently opened, one line per job and their last work date being the max of joboper lastlabordate. I don't need several lines per job for all operations.
I know we could do it in Crystal, but we want to take advantage of the trackers.
Many thanks for your help!
I want to identify quickly on a tracker all jobs currently opened, one line per job and their last work date being the max of joboper lastlabordate. I don't need several lines per job for all operations.
I know we could do it in Crystal, but we want to take advantage of the trackers.
Many thanks for your help!