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);