com.ibm.commerce.member.search

Class ECOrganizationQuery

  • All Implemented Interfaces:
    java.io.Serializable


    public class ECOrganizationQuery
    extends ECQuery
    Query object used for searching organizations in WebSphere Commerce. Tables that can be used with this query object are
    ORGENTITY
    --
    The organization's ORGENTITY record.
    ADDRESS
    --
    The self address for this organization's self address
    MBRATTRVAL
    --
    The member attribute values for this organization.
    MBRREL
    --
    The organization's ancestor hierarchy.
    PARENTORG
    --
    The ORGENTITY record for the parent organization
    ANCESTORORG
    --
    Any ancestor organization for this organization
    MEMBER
    --
    The organization's MEMBER table entry.
    Note that there is deliberately no join information setup for MBRROLE, because that table can be used in a variety of different ways in conjunction with the ORGENTITY table.
    See Also:
    Serialized Form
    • Field Detail

      • COPYRIGHT

        public static final java.lang.String COPYRIGHT
        IBM Copyright
        See Also:
        Constant Field Values
      • CLASSNAME

        public static final java.lang.String CLASSNAME
        The class name.
      • JOIN_MEMBER

        public static final java.lang.String JOIN_MEMBER
        Join condition for the MEMBER table.
        See Also:
        Constant Field Values
      • JOIN_ADDRESS

        public static final java.lang.String JOIN_ADDRESS
        Join condition for the ADDRESS table.
        See Also:
        Constant Field Values
      • JOIN_MBRREL

        public static final java.lang.String JOIN_MBRREL
        Join condition for the MBRREL table.
        See Also:
        Constant Field Values
      • JOIN_MBRATTRVAL

        public static final java.lang.String JOIN_MBRATTRVAL
        Join condition for the MBRATTRVAL table.
        See Also:
        Constant Field Values
      • JOIN_PARENTORG

        public static final java.lang.String JOIN_PARENTORG
        Join condition for the ORGENTITY record for the parent ORGENTITY.
        See Also:
        Constant Field Values
      • JOIN_ANCESTORORG

        public static final java.lang.String JOIN_ANCESTORORG
        Join condition for any ancestor organization from the ORGENTITY table.
        See Also:
        Constant Field Values
    • Constructor Detail

      • ECOrganizationQuery

        public ECOrganizationQuery()
    • Method Detail

      • getWhereClauseAllOrgsWhereRoleIsPlayed

        public static WhereClauseCondition getWhereClauseAllOrgsWhereRoleIsPlayed(java.lang.Long anUserId)
        Gets a WHERE clause that includes all organizations where the user plays any role, except Registered Customer role. It also includes organizations that are part of the Registered Customers member group that is owned by an organization where the user plays one of the following roles: Seller Administrator, Customer Service Representative or Customer Service Supervisor. The roles can be configured by modifying WC_install_dir\xml\tools\buyerconsole\MemberSearch.xml
        Parameters:
        anUserId - The user's Id.
        Returns:
        A where clause condition that includes the organizations where the user plays any administrative role; empty condition if the user is a Site Administrator; null if the userId passed in is null.
      • getWhereClauseAllOrgsICanManage

        public static WhereClauseCondition getWhereClauseAllOrgsICanManage(java.lang.Long anUserId)
        Gets a WHERE clause that includes organizations that the user is allowed to manage. This includes organizations where the user has an administrative role: Site Administrator, Seller Administrator, Buyer Administrator or Channel Manager. It also includes organizations that are part of the Registered Customers member group that is owned by an organization where the user plays one of the following roles: Seller Administrator, Customer Service Representative or Customer Service Supervisor. The roles can be configured by modifying WC_install_dir\xml\tools\buyerconsole\MemberSearch.xml
        Parameters:
        anUserId - The user's Id.
        Returns:
        A where clause condition that includes the organizations where the user plays an administrative role; empty condition if the user is a site admin; null if the userId passed in is null.
      • getWhereClauseAllOrgsWhereICanAssignRoles

        public static WhereClauseCondition getWhereClauseAllOrgsWhereICanAssignRoles(java.lang.Long anUserId)
        Gets a WHERE clause that includes organizations where the current user is allowed to assign a role to another user. This includes organizations where the user has an administrative role: Site Administrator, Seller Administrator, Buyer Administrator, Channel Manager, Customer Service Representative or Customer Service Supervisor. The roles can be configured by modifying WC_install_dir\xml\tools\buyerconsole\MemberSearch.xml
        Parameters:
        anUserId - The user's Id.
        Returns:
        A where clause condition that includes the organizations where the user plays an administrative role; empty condition if the user is a Site Administrator; null if the userId passed in is null.