http://siebel-crm.net Something about Siebel Tue, 08 Dec 2009 15:31:34 +0000 http://backend.userland.com/rss092 en 1. in simulator create new script with method Service_PreInvoke 2. in methods create new one ActAll 3. in simulator run new script with method ActAll by button Run function Service_PreInvokeMethod (MethodName, Inputs, Outputs) { if (MethodName=="ActAll") { var sErr="" var bo=TheApplication().GetBusObject("Front Office Workflow"); var bc=bo.GetBusComp("Repository Workflow Process Read Only"); ... http://siebel-crm.net/activate-all-workflows/ VIEW UPDATE siebel.s_view bc SET bc.obj_locked_flg = 'N', bc.obj_locked_date = NULL, bc.obj_locked_by = null, bc.obj_locked_lang = null WHERE bc.row_id = '1-A4LQ-DX3R'; commit; TABLE UPDATE siebel.s_table tab SET tab.obj_locked_flg = 'N', tab.obj_locked_date = null, tab.obj_locked_by = null, tab.obj_locked_lang = null WHERE tab.name = 'CX_RD_MATRIX' and tab.row_id = '1NQ-5HY'; commit; BUSCOMP UPDATE siebel.s_buscomp bc SET bc.obj_locked_flg = 'N', bc.obj_locked_date = NULL, bc.obj_locked_by = null, bc.obj_locked_lang ... http://siebel-crm.net/unlock-repository-objects/ select ' OR "' || w.name || '"' from siebel.S_VIEW_WTMPL_IT wti, siebel.S_VIEW_WEB_TMPL wt, siebel.S_VIEW w where wti.applet_name in ('IOM Account Entry Applet', 'IOM Account Entry Applet RO', 'IOM Account Entry Applet ZIU') ... http://siebel-crm.net/select-views-by-applet-name/ SELECT lov.created, usr_crt.login created_login, lov.last_upd, usr_upd.login updated_login, lov.TYPE, lov.NAME, lov.val, lov.sub_type, lov.par_row_id, par_lov.TYPE par_lov_type, par_lov.NAME par_lov_name FROM siebel.s_lst_of_val lov, ... http://siebel-crm.net/summary-of-modified-lovs/ SELECT wdd.created, usr_crt.login created_login, wdd.last_upd, usr_upd.login updated_login, wdd.NAME, wdd.VERSION, wdd.deploy_status_cd FROM siebel.s_wfa_dploy_def wdd, siebel.s_user usr_crt, ... http://siebel-crm.net/summary-of-deployed-workflows/ var boActSet = TheApplication().GetBusObject("ABO Bulk Request"); var bcActSet = boActSet.GetBusComp("ABO Bulk Request Action Set"); var IsRecord; with (bcActSet) { ClearToQuery(); ActivateField("Due Date"); SetSearchSpec("Bulk Request Id", '12345'); ExecuteQuery(ForwardOnly); IsRecord = FirstRecord(); while(IsRecord) { SetFieldValue("Due Date", 'xx'); WriteRecord(); IsRecord = NextRecord(); } } http://siebel-crm.net/while-cycle/ uc se a budes chytrejsi http://siebel-crm.net/tip/ escript var sStatusCompleted = TheApplication().InvokeMethod("LookupValue", "FS_ORDER_STATUS", "Completed"); searchspec [Order Type] <> LookupValue ("FS_ORDER_TYPE", "Bulk Request Template Order") Field predefault value Expr: 'LookupValue("LS_MED_AE_TYPE", "Product Problem Device")' workflow condition (ABO Bulk Request Action Set All Must Match (Ignore Case)('[&Action Set Type] = LookupValue('ABO_BR_ACTSET_TYPE','MNP Port In') OR [&Action Set Type] = LookupValue('ABO_BR_ACTSET_TYPE','MNP Port In ... http://siebel-crm.net/lookupvalues/ -- Siebel 7.8 -- Gives you a list of responsibilities with count of assigned users to that responsibility SELECT resp.row_id, resp.NAME, COUNT (*) AS users_count FROM siebel.s_per_resp per_resp, siebel.s_resp resp WHERE resp.row_id = per_resp.resp_id(+) GROUP BY resp.row_id, per_resp.resp_id, resp.NAME ORDER BY COUNT (*) DESC -- Siebel 7.8 -- gives ... http://siebel-crm.net/sql-select-responsibilities-views-bo-bcs/ Oracle database version: select * from v$version Oracle characterset: select value from v$nls_parameters where parameter='NLS_CHARACTERSET' http://siebel-crm.net/useful-selects/