Helma logo
helma.org » Home > docs > guide > mapping > Additional Join Conditions

Additional Join Conditions

For both object and collection mappings, it is possible to provide any number of additional restraints used to join the local with the other table to further limit the selected objects.

prop4.local.1 = FIRST_LOCAL_COLUMN 
prop4.foreign.1 = FIRST_FOREIGN_COLUMN 
prop4.local.2 = SECOND_LOCAL_COLUMN 
prop4.foreign.2 = SECOND_FOREIGN_COLUMN
Whenever one specifies more than one restraint, the use of .[Number] is mandatory.


Up: Object-Relational Mapping Guide
Previous: Collection Mappings Next: Mountpoint Mappings

... comment


Page last modified on 2002-04-23 17:29 by hns

 
maks, Monday, 6. March 2006, 08:31
can use logical operators
this post on the mailing list (http://helma.org/pipermail/helma-user/2005-August/006053.html) mentions that you can use:

collection.logicalOperator = or|xor|and

... link  


... comment