public class ECUserQuery extends ECQuery
ECUserQuery query = new ECUserQuery(); WhereClauseSearchCondition whereClause = new WhereClauseSearchCondition( new TableField("USERREG", "LOGONID"), WhereClauseSearchCondition.SEARCHTYPE_CASEINSENSITIVE_CONTAINS, "myLogon"); query.setWhereClause(whereClause); Vector vecResults = (new UserSearchAccessBean()).executeCustomizeableMemberSearch( 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:
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_ACCOUNT
Join condition for the ACCOUNT table.
|
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_BUSPROF
Join condition for the BUSPROF table.
|
static java.lang.String | JOIN_MBRATTRVAL
Join condition for the MBRATTRVAL table.
|
static java.lang.String | JOIN_MBRGRPMBR
Join condition for the MBRGRPMBR 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_PARENTORG
Join condition for the parent organization from the ORGENTITY table.
|
static java.lang.String | JOIN_USERDEMO
Join condition for the USERDEMO table.
|
static java.lang.String | JOIN_USERPROF
Join condition for the USERPROF table.
|
static java.lang.String | JOIN_USERREG
Join condition for the USERREG table.
|
static java.lang.String[] | PROFILETYPE_B2B_AND_B2C_USERS
Constant to be used with the USERS.PROFILETYPE filter.
|
static java.lang.String[] | PROFILETYPE_B2B_USERS_ONLY
Constant to be used with the USERS.PROFILETYPE filter.
|
static java.lang.String[] | PROFILETYPE_B2C_USERS_ONLY
Constant to be used with the USERS.PROFILETYPE filter.
|
static java.lang.String[] | REGISTERTYPE_ADMINISTRATORS_ONLY
Constant to be used with the USERS.REGISTERTYPE filter.
|
static java.lang.String[] | REGISTERTYPE_REGISTERED_CUSTOMERS_AND_ADMINISTRATORS
Constant to be used with the USERS.REGISTERTYPE filter.
|
static java.lang.String[] | REGISTERTYPE_REGISTERED_CUSTOMERS_ONLY
Constant to be used with the USERS.REGISTERTYPE filter.
|
Constructor and Description |
---|
ECUserQuery()
Default constructor.
|
Modifier and Type | Method and Description |
---|---|
protected java.util.HashMap | getAliasedTableNames()
Return a HashMap of any aliased tables.
|
protected TableField[] | getDefaultSelectTableFields()
Get the TableField objects for the SELECT clause.
|
protected java.util.Vector | getJoinInformation()
Get the join information.
|
static WhereClauseCondition | getWhereClauseAllUsersInOrgsICanManage(java.lang.Long anUserId)
This Where Clause can be used to filter only those users for whom the active user has 'organization manage' authority for one of the ancestors.
|
static WhereClauseCondition | getWhereClauseFilterForProfileTypes(java.lang.String[] astrProfileTypes)
Filter for specific values of USERS.PROFILETYPE.
|
static WhereClauseCondition | getWhereClauseFilterForRegisterTypes(java.lang.String[] astrRegisterTypes)
Filter for specific values of USERS.REGISTERTYPE.
|
public static final java.lang.String COPYRIGHT
public static final java.lang.String CLASSNAME
public static final java.lang.String[] PROFILETYPE_B2B_USERS_ONLY
public static final java.lang.String[] PROFILETYPE_B2C_USERS_ONLY
public static final java.lang.String[] PROFILETYPE_B2B_AND_B2C_USERS
public static final java.lang.String[] REGISTERTYPE_REGISTERED_CUSTOMERS_ONLY
public static final java.lang.String[] REGISTERTYPE_ADMINISTRATORS_ONLY
public static final java.lang.String[] REGISTERTYPE_REGISTERED_CUSTOMERS_AND_ADMINISTRATORS
public static final java.lang.String JOIN_MEMBER
public static final java.lang.String JOIN_USERREG
public static final java.lang.String JOIN_USERDEMO
public static final java.lang.String JOIN_BUSPROF
public static final java.lang.String JOIN_USERPROF
public static final java.lang.String JOIN_PARENTORG
public static final java.lang.String JOIN_ANCESTORORG
public static final java.lang.String JOIN_ADDRESS
public static final java.lang.String JOIN_ACCOUNT
public static final java.lang.String JOIN_MBRREL
public static final java.lang.String JOIN_MBRROLE
public static final java.lang.String JOIN_MBRATTRVAL
public static final java.lang.String JOIN_MBRGRPMBR
protected java.util.Vector getJoinInformation()
protected TableField[] getDefaultSelectTableFields()
protected java.util.HashMap getAliasedTableNames()
public static WhereClauseCondition getWhereClauseFilterForProfileTypes(java.lang.String[] astrProfileTypes)
public static WhereClauseCondition getWhereClauseFilterForRegisterTypes(java.lang.String[] astrRegisterTypes)
public static WhereClauseCondition getWhereClauseAllUsersInOrgsICanManage(java.lang.Long anUserId)