ECOrganizationQuery object
The ECOrganizationQuery object, used to perform member search, can be extended. The ECOrganizationQuery object works just like the ECUserQuery object.
You can query these tables:
Database table | Description |
---|---|
ORGENTITY | The organization's ORGENTITY record |
ADDRESS | The address for the organization. |
MBRATTRVAL | The member attribute values for this organization |
MBRREL | The organization's ancestor hierarchy |
This means that you can search based on any numeric or string attribute in any of these tables.
Example: Search organizations by organization name
ECOrganizationQuery query = new ECOrganizationQuery();
WhereClauseSearchCondition whereClause =
new WhereClauseSearchCondition(
new TableField("ORGENTITY", "ORGENTITYNAME"),
WhereClauseSearchCondition.SEARCHTYPE_CASESENSITIVE_STARTSWITH,
"myParentOrgName");
query.setWhereClause(whereClause);
Vector vecResults =
(new UserSearchAccessBean())
.executeCustomizeableMemberSearch(query);