Filter Parent BC records based on MVF value
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.
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:
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: