How to constraint a join

Requirement:-
We have the Opportunity as the parent of Quote. And a Oppotunity can have multiple Quote that is 1:M relation. But the Opportunity can have only one representative quote. Client want to see the representative quote in opportunity Form Applet.

So let me tell you how we have configure it.

you can configure join as usually you do it.

1. Configure the Source Field.
2. Create Join (Give the Name of table)
3. Specify the Join Specification
for details refer to How to configure join

Just one more additional step you need to configure join constraint.

Configure Join Constraint

1. Go to Join> Join Constraint
2. Specifity the Destination Column and Value
In our example we have X_REPRESENTATIVE_FLG as the Destination column
3. Specify the Value


It is just like specifying where clause in SQL
select * from siebel.S_OPTY t1, siebel.S_DOC_QUOTE t2
where
t1.ROW_ID = t2.OPTY_ID
t2.X_REPRESENTATIVE_FLG = 'Y'

After this it will return only those record which will satify constraint condition