Develop > Controller layer > Application developer > Member subsystem > Member search
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:
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);
Related concepts
Related tasks
Extend the ECOrganizationQuery and ECUserQuery objects
Related reference