The Workflow Policy Monitor must use object definitions that are contained in the workflow policy object, workflow policy components, and workflow policy columns. If your configuration uses a workflow policy program, and if this configuration references Siebel tables, then you must use SQL code to explicitly join the base table. The following example SQL statement joins four tables. These joins allow Siebel CRM to access the data that resides in these tables: SELECT MGRPOS.PR_EMP_ID FROM &TABLE_OWNER.S_POSTN POS, &TABLE_OWNER.S_EMPLOYEE EMP, &TABLE_OWNER.S_POSTN MGRPOS, &TABLE_OWNER.S_SRV_REQ SR WHERE SR.ROW_ID = ? AND SR.OWNER_EMP_ID = EMP.ROW_ID AND EMP.PR_POSTN_ID = POS.ROW_ID AND POS.PAR_POSTN_ID = MGRPOS.ROW_ID
This SQL gets only one field. This SQL uses the following question mark as a placeholder to input the value of the Primary ID. Siebel CRM replaces the question mark with the Primary ID: SR.ROW_ID = ?
|