'Fail Parent If This Task Fails'

[Tom Nats]

Guys,

Here is a query that shows any task in a workflow that does not have the 'Fail Parent If This Task Fails'.  Use it at your own risk.

select
DISTINCT  
SUBJ.SUBJ_NAME FOLDER_NAME,
WFLOW.TASK_NAME WORKFLOW_NAME,
SESS.TASK_NAME SESSION_NAME,
TINST.INSTANCE_NAME SESSION_INSTANCE_NAME,
decode(TINST.BIT_OPTIONS,
17,'Fail Parent If This Task Fails, And',
18,'Fail Parent If Task Fails,Or',
49,'Fail Parent If This Task Fails With,And,Fail Parent if this task does not run',
50,'Fail Parent If This Task Fails With,Or,Fail Parent if this task does not run','None') GENERAL_OPTION
from
OPB_SUBJECT SUBJ,
(select TASK_ID,TASK_NAME, VERSION_NUMBER
from OPB_TASK
where
TASK_TYPE = 71 and
IS_VISIBLE = 1)WFLOW,
(select WORKFLOW_ID, TASK_ID, INSTANCE_NAME, BIT_OPTIONS, VERSION_NUMBER
from OPB_TASK_INST
where
task_type=68 )TINST,
(select SUBJECT_ID,TASK_ID,TASK_NAME
from OPB_TASK
where
TASK_TYPE = 68 )SESS
where
WFLOW.TASK_ID = TINST.WORKFLOW_ID and
WFLOW.VERSION_NUMBER = TINST.VERSION_NUMBER and
TINST.TASK_ID = SESS.TASK_ID and
SESS.SUBJECT_ID = SUBJ.SUBJ_ID
and TINST.BIT_OPTIONS not in (17,18) and
SUBJ.SUBJ_NAME not like ('dev%')
order by 1,2,3

-- exclude anyone's dev folders.