com.ibm.commerce.member.search

Class WhereClauseJoinCondition

java.lang.Object

com.ibm.commerce.member.search.WhereClauseCondition

com.ibm.commerce.member.search.WhereClauseFreeFormCondition

com.ibm.commerce.member.search.WhereClauseJoinCondition

All Implemented Interfaces:

java.io.Serializable

public class WhereClauseJoinCondition
extends WhereClauseFreeFormCondition

These objects represent WHERE clause conditions for use by the JOIN conditions. It is a subtype of the WhereClauseFreeFormCondition class, and behaves in a very similar fashion. Like the parent class, when using this WHERE clause condition object you must manually specify the WHERE clause SQL, the FROM tables, and the query parameter values.
Usage:

        

        WhereClauseCondition cond
                new WhereClauseJoinCondition("USERREG.USERS_ID = USERS.USERS_ID");
        

This example will create a join condition for the USERREG table, specifically to join it with the USERS table. This example presumes that you are using the join from the users query object, which defines the USERS table as one of its core query tables.

See Also:

Serialized Form

Field Summary

Fields

Modifier and Type	Field and Description
static java.lang.String	COPYRIGHT IBM Copyright

Fields inherited from class com.ibm.commerce.member.search.WhereClauseFreeFormCondition

CLASSNAME

Fields inherited from class com.ibm.commerce.member.search.WhereClauseCondition

SQL_AND, SQL_CLOSE_BRACKET, SQL_EQUALS, SQL_ESCAPE, SQL_LIKE, SQL_NOT_EQUALS, SQL_OPEN_BRACKET, SQL_OR, SQL_QUOTE, SQL_SOUNDEX, SQL_TRUE_CONDITION, SQL_WILDCARD

Constructor Summary

Constructors

Constructor and Description
WhereClauseJoinCondition(java.lang.String astrFreeFormWhereClause)
WhereClauseJoinCondition(java.lang.String astrFreeFormWhereClause, java.util.Set asetFromTables, java.util.Vector avecWhereClauseParameters)

Method Summary

Methods inherited from class com.ibm.commerce.member.search.WhereClauseCondition

appendANDCondition, appendORCondition, getFromTables, getWhereClauseParameterValues, getWhereClauseSQL, isValid, toString

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, wait, wait, wait

Field Detail

COPYRIGHT

public static final java.lang.String COPYRIGHT

IBM Copyright

See Also:

Constant Field Values

Constructor Detail

WhereClauseJoinCondition

public WhereClauseJoinCondition(java.lang.String astrFreeFormWhereClause)

Parameters:

astrFreeFormWhereClause -

WhereClauseJoinCondition

public WhereClauseJoinCondition(java.lang.String astrFreeFormWhereClause,
                                java.util.Set asetFromTables,
                                java.util.Vector avecWhereClauseParameters)

Parameters:

astrFreeFormWhereClause -

asetFromTables -

avecWhereClauseParameters -