This query is returning jobs that have not been released. Any idea why?
for each JobHead no-lock where JobHead.JobComplete = 0 And JobHead.JobReleased = 1
This query is returning jobs that have not been released. Any idea why?
for each JobHead no-lock where JobHead.JobComplete = 0 And JobHead.JobReleased = 1
as in, the query is returning results where JobReleased=0?
It’s returning only Planned Jobs no matter if it’s 0 or 1
turns out in v9.04 you need this:
JobHead.JobReleased <> “1”
Strange. It’s not that way in later versions.