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

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
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: