How to get an existing Rule Set(s) on Siebel by querying a Validation Message in DB

As you all know the biggest problem in Siebel is of course performance. To handle this issue, (maybe as first) do not coding so much on Siebel tools. One of great example is “Rule Set” and also “Validation Messages“. With this properties, you can do everything that you can do with “Server Script” & “Browser Script” of “Business Components” & “Applets“. Anyway if we focus on the subject, what we can do is finding the message with quriying the message on DB. As an example we can get “Black list”. Here is the code:

SELECT e.obj_type_cd AS object_type, e.obj_name AS object_name,

e.evt_name AS event, e.evt_sub_name AS sub_event,

e.actn_cond_expr AS conditional_expr, s.NAME AS action_set,

a.NAME AS action, rs.NAME AS rule_set, r.NAME AS RULE, l.msg_text

FROM S_CT_ACTION_SET s,

S_CT_ACTION a,

S_VALDN_RL_SET rs,

S_VALDN_RULE r,

S_ISS_VALDN_MSG m,

S_ISS_VMSG_LANG l,

S_CT_EVENT e

WHERE a.ct_actn_set_id = s.row_id

AND a.svc_context LIKE

‘”Rule Set Name”, “‘ || rs.NAME || ‘”, “Enable Log”, “Y”‘

AND rs.status_cd = ‘Active’

AND r.rule_set_id = rs.row_id

AND r.valdn_msg_id = m.row_id

AND l.par_row_id = m.row_id

AND e.ct_actn_set_id = s.row_id

AND l.lang_id = ‘ENU’

AND l.msg_text LIKE ‘%Black%List%’;

Advertisements