public class ECReturnQuery extends ECQuery
ECReturnQuery query = new ECReturnQuery(); WhereClauseSearchCondition whereClause = new WhereClauseSearchCondition( new TableField("USERREG", "LOGONID"), WhereClauseSearchCondition.SEARCHTYPE_CASEINSENSITIVE_CONTAINS, "myLogon"); query.setWhereClause(whereClause); Vector vecResults = (new OrderManagementJDBCHelperAccessBean()).executeCustomizableReturnSearch( query);The Vector of results contains Vectors, each of which has one entry -- for the USERS.USERS_ID of the user found. Tables that can be used as query parameters for user queries are:
RMA -- The return's RMA record. STOREENT -- The return's storeent record. USERS -- The return's user record. USERREG -- The return's user registry record. PARENTORG -- The return's user's parent organization (ORGENTITY table). ANCESTORORG -- The return's user's ancestor organization (ORGENTITY table). ADDRESS -- The return's user's selfaddress. MBRREL -- The return's ancestors. MEMBER -- The return's MEMBER table entry.
Modifier and Type | Field and Description |
---|---|
static java.lang.String | CLASSNAME
The class name.
|
static java.lang.String | COPYRIGHT
IBM Copyright
|
static java.lang.String | JOIN_ADDRESS
Join condition for the ADDRESS table.
|
static java.lang.String | JOIN_ANCESTORORG
Join condition for any ancestor organization from the ORGENTITY table.
|
static java.lang.String | JOIN_CONTRACT
Join condition for the CONTRACT table.
|
static java.lang.String | JOIN_MBRREL
Join condition for the MBRREL table.
|
static java.lang.String | JOIN_MBRROLE
Join condition for the MBRROLE table.
|
static java.lang.String | JOIN_MEMBER
Join condition for the MEMBER table.
|
static java.lang.String | JOIN_ORDERITEMS
Join condition for the ORDERITEMS table.
|
static java.lang.String | JOIN_PARENTORG
Join condition for the parent organization from the ORGENTITY table.
|
static java.lang.String | JOIN_RMAITEM
Join condition for the RMAITEM table.
|
static java.lang.String | JOIN_STOREENT
Join condition for the STOREENT table.
|
static java.lang.String | JOIN_USERREG
Join condition for the USERREG table.
|
static java.lang.String | JOIN_USERS
Join condition for the USERS table.
|
Constructor and Description |
---|
ECReturnQuery()
This method is the default constructor.
|
Modifier and Type | Method and Description |
---|---|
protected java.util.HashMap | getAliasedTableNames()
This method returns a HashMap of any aliased tables.
|
protected TableField[] | getDefaultSelectTableFields()
This method gets the TableField objects for the SELECT clause.
|
protected java.util.Vector | getJoinInformation()
This method gets the join information.
|
public static final java.lang.String COPYRIGHT
public static final java.lang.String CLASSNAME
public static java.lang.String JOIN_STOREENT
public static java.lang.String JOIN_MEMBER
public static java.lang.String JOIN_USERS
public static java.lang.String JOIN_USERREG
public static java.lang.String JOIN_PARENTORG
public static java.lang.String JOIN_ANCESTORORG
public static java.lang.String JOIN_ADDRESS
public static java.lang.String JOIN_MBRREL
public static java.lang.String JOIN_MBRROLE
public static java.lang.String JOIN_RMAITEM
public static java.lang.String JOIN_ORDERITEMS
public static java.lang.String JOIN_CONTRACT
protected java.util.Vector getJoinInformation()
protected TableField[] getDefaultSelectTableFields()
protected java.util.HashMap getAliasedTableNames()