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.
|
DEFAULT_START, UNDEFINED_MAX_RESULTS
Constructor and Description |
---|
ECUserQuery()
Default constructor.
|
Modifier and Type | Method and Description |
---|---|
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.
|
executeQuery, getAdditionalSelectTableFields, getMaxResults, getOrderBy, getResultSize, getRetrieveCountOnly, getStart, getUncommittedRead, getWhereClause, isValid, setAdditionalSelectTableFields, setAllFromTables, setMaxResults, setOrderBy, setRetrieveCountOnly, setStart, setUncommittedRead, setWhereClause, toString
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
public static WhereClauseCondition getWhereClauseFilterForProfileTypes(java.lang.String[] astrProfileTypes)
astrProfileTypes
- The PROFILETYPE values to filter by.public static WhereClauseCondition getWhereClauseFilterForRegisterTypes(java.lang.String[] astrRegisterTypes)
astrRegisterTypes
- The REGISTERTYPE values to filter by.public static WhereClauseCondition getWhereClauseAllUsersInOrgsICanManage(java.lang.Long anUserId)
anUserId
- The user who is performing the query