Now that we are starting to put jobs on hold, I need to filter those jobs with active holds out of some of the queries I have in JTX. Something like an "Active jobs that aren't on hold" query. From what I can see in the tables, the only way to query if a job is on hold is to check the JOB_HOLDS table and see if that job as any hold records with no RELEASE_DATE value. Am I right? Something like this?
Select * FROM JTX_ADMIN.JOBS_HOLDS WHERE JOB_ID = <jobid> and RELEASE_DATE is NULL
My SQL expertise is pretty limited, so the query above just returns a list of related records from another table. How do I filter a job from my JTX window if it has related records(that have a RELEASE_DATE of NULL) in another table
Here's my existing WHERE clause for my "Jobs Ready to Edit" Query:
WHERE JTX_ADMIN.JTX_JOBS.STATUS = JTX_ADMIN.JTX_STATUS.ID AND JTX_ADMIN.JTX_STATUS.NAME = 'Edit Queue'
Or is there a better way?
Also, I'm in JTX 9.3.1
Thanks for any help!
-Andrew