How can I get a list of Jobstreams with its Target Job, Name, Description field, and Business Area?
Release : 6.4.1-1
Component : AUTOMIC AUTOMATION INTELLIGENCE ENGINE
//Query based on specific TARGET_JOB//
select jj.jobName as TargetJobName, js.description as JobstreaName, js.annotation as JobStream_Description, bd.businessDomainName as BusinessArea
from JawsJob jj, JobStream js, BusinessDomain bd, BusinessDomain_JobStream bdj
where jj.jobName = 'TARGET_JOB'
and jj.jobId = js.targetJobId
and js.jobStreamId = bdj.jobStreamId
and bdj.businessDomainId = bd.businessDomainId;
//All Jobstreams
select jj.jobName as TargetJobName, js.description as JobstreaName, js.annotation as JobStream_Description, bd.businessDomainName as BusinessArea
from JawsJob jj, JobStream js, BusinessDomain bd, BusinessDomain_JobStream bdj
where jj.jobId = js.targetJobId
and js.jobStreamId = bdj.jobStreamId
and bdj.businessDomainId = bd.businessDomainId;