Saturday, Jun. 24, 2017

Implement Carriage Return in Workflows

Written By:

|

July 17, 2012

|

Posted In:

Requirement:

The requirement is to perform an update on a text field in Siebel database for a bulk of activity records. Later, this text field will be extracted from Siebel database and sent accross through real time interface to external system.

Solution:

Challenge was to implement a scriptless solution. Therefore, a workflow was created with 4 simple steps as attached “WF_Record“. A brief description of significant steps is as follows:

A Custom Process Property was created of Type String as: “Expr_Val”

1. Create Expression:
Based on vanilla business service called “Workflow Utilities” to set Custom Process Property ‘Expr_Val’

2. Update Expression:
Update the value of Custom Process Property ‘Expr_Val’ in the NAME column of S_EVT_ACT table.

Set the Custom Process Property ‘Expr_Val’ to introduce carriage return by pressing the Enter key. Press the enter key after a double quote in the expression:

http://www.siebelnova.com

On simulating this workflow, we can see that this workfow did not yield effective results as a carriage return was not introduced when queried via SQL Developer on S_EVT_ACT table.

http://www.siebelnova.com

Adding “\n” and “\r” via any combination did not work as well.
The trick that helped to achieve this requirement is the use of calculated field in the workflow.

The above workflow was modified to introduce a “Query” Siebel operation step as attached “WF_Record_Modif“. It also includes a new custom process property called as “Add_Enter_Key” of type String.

Create a calculated field as below in your BC:

Set Calculated value as – type double quotes twice and separate them by pressing the Enter Key.
Compile your BC and import this modified workflow. Simulate this workflow and you will see the carriage return introduced in the table columns in Siebel database:

http://www.siebelnova.com



Share This Article

About Author

Gurdeep

Hi, I am sharing my experience to alleviate beginners with open UI and HI version of Siebel CRM. I work in Sun Life Financials and can be reached via IT Tool box as well. Thanks.

Comments are closed.

Leave A Reply