Thursday, Aug. 17, 2017

Filter Parent BC records based on MVF value

Written By:

|

December 8, 2012

|

Posted In:

Requirement:

The requirement is to filter the Contacts (Parent BC) based on the value in the Contact’s Multivalue field called as Company.
Say for example, When the Contacts view is loaded the Contact List Applet will show only those contacts which has the MVF company set as Lufthansa Systems.

Solution:

Follow the below steps to implement this requirement.
1. In Siebel Tools, go to the applet called as Contact List Applet and add the searchspec as below:

mvf1

Note: “Customer Name” is the Mutivalue field in the Contact BC

2. Compile the applet object. Launch the application and you will see filtered contacts based on company as “Lufthansa Systems”

3. Try and spool your requirement, you will see the additional search spec generated in SQL as below:

mvf2



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