ananya

• Nov 30th, 2006

 

Implicit joins is joins created using extension and intersection tables are called as implicit joins,fields populated using implicit joins are editable.

Explicit joins are joins created using siebel tools,fields populated by explicit joins are not editable howerver they can be edited by implimenting DPL

Amit

• Dec 7th, 2006

 

Implicit Joins : Mostly the Name ends with _X as based on extension tables

Explicit Joins : Can give table name or alias name. Alias name is used if there are 2 joins on the same table used with different fields in BC.

anupsadhwani60

 Profile Answers by anupsadhwani60 

• Sep 16th, 2007

 

Implicit joins are always directed along many-to-one or one-to-one associations and it allows to write query much shorter compared to SQL.

For e.g. If there are multiple bids for a Item, we can write as below in HQL.

from Bid bid where bid.item.description like '%gc%'

Hope this helps..

ahujahbti

 Profile Answers by ahujahbti 

• Jan 18th, 2010

 

There are two type of commonly used joinsImplicit Join Explicit Join Implicit Join: 

Implicit Join: Implicit Join are those which are already define in Siebel and which are internally use by the Siebel to pull the values from the other than base table.
Example: Join between base table and extension table like S_OPTY and S_OPTY_X and join between S_PARTY and S_ORG_EXT

Explicit Join: Explicit Joins are those which are define by the developer to create the relationship between two tables. You have to follow the following five steps to have joined field on UI in Siebel
1. Identify the column to be used as foreign key. (Source Field will have rowid of joined Table)
2. Configure field which will store the primary key of join table.
3. Configure a join.
4. Configure join specification.(Destination Column, Source Field)
5. Add a field which will be used at Applet.