Guide to Creating MVGs

This article provides a guide to creating MVGs in

Siebel. Most Siebel developers create MVGs on a regular basis, this information will not be too useful. I have been a manager for a while now which means that I dont get to do Siebel build much any more. I cant remember the process of creating an MVG off the top of my head any longer so I wanted to get it down here. MVGs can be created with a shuttle applet where you associate records to the MVG from an existing list of records (association applet). MVGs can also be created without an association applet a new button will create new records in the MVG applet. I will attempt to describe the process of creating an MVG: 1. If the child BC does not exist, create it with all required fields in the MVG. 2. Create the MVG applet based on the child BC. Ensure that Type = MVG. If the MVG is to have an association applet, create the association applet with Type = Association List and then set the Association Applet = [the association applet] on the MVG applet. 3. Create the Link. This links the parent BC to the MVG child BC. If the MVG is a M:M then the link would have an intersection table. 4. Create a Multi Value Link (MVL) on the parent BC based on the Link created in the step above. 5. For performance reasons, it is usually best to set a primary id field for the MVG. On the parent BC's table, create a new column for the primary id field. Then on the parent BC, create a new field based on this column for the Primary Id Field. 6. On the MVL set the Primary Id Field to the field created in the step above. 7. For any fields on the MVG that you want to be a picklist, you need to create these fields on the parent as mutli value fields (MVF) and include the same picklist as on the child field. You also need to ensure to include a pickmap on the parent mvf. The picklist on the MVG applet will not work unless you do this. 8. For the MVF on the parent applet that you want to invoke the MVG applet from (through a glyph) you need to create a MVF on the parent BC, add this MVF on the parent BC applet and on this control/list column set the following properties: MVG Applet: [The name of the MVG applet to be invoked] Runtime: Y Read Only: Y 9. For any other MVF that you want to display on the parent BC applet, create a MVF for each field and add these to the parent BC applet. Set these as Read Only on the parent BC applet.