This SQL Query has been provided by a friend of mine Nitin Kumar. Who has been in siebel from past 2 years and is currently working as a Senior Siebel Developer in an MNC. When working with siebel Workflow policies and Workflow process are very common. This SQL can you help you to determine name of the policies that are using particluar workflow process or with slight modification you get all the details of a particular policies.
SELECT distinct
COL.name “Policy Condition”,
con.cond_operand “Policy Operand”,
con.val “Policy Value”,
acdeg.NAME “Policy Action”,
arg.DEFAULT_VALUE “Workflow Process Name”,
pol.name “Policy Name”
FROM siebel.s_escl_rule pol,
siebel.s_escl_cond con,
siebel.s_escl_link_col COL,
siebel.s_escl_col escol,
siebel.S_ESCL_ACTION ac,
siebel.S_ACTION_DEFN acdeg,
siebel.S_ACTION_ARG arg
WHERE pol.expire_dt IS NULL
AND pol.row_id = con.rule_id
AND escol.name = con.link_col_name
AND COL.cond_col_id = escol.row_id
and ac.ACTION_ID = acdeg.row_id(+)
and pol.row_id = ac.RULE_ID(+)
and acdeg.row_id = arg.ACTION_ID(+)
– Workflow Process Name
and arg.DEFAULT_VALUE like ‘%GEAE Quote Assignment Platform Email Activity%’
–AND pol.name = ‘GEAE Agreement Status doc to SD’ –Workflow Policy Name
In this SQL you can just uncomment the last line and comment second last line to get details of a particluar workflow policy.
--and arg.DEFAULT_VALUE like '%GEAE Quote Assignment Platform Email Activity%'
AND pol.name = 'GEAE Agreement Status doc to SD' --Workflow Policy Name
(No Ratings Yet)
Loading ...
O comments at "Useful SQL Queries - Workflow Process and Workflow Policies"
Comment Now!