com.ibm.commerce.returns.search

Class ECReturnQuery

  • All Implemented Interfaces:
    java.io.Serializable

    public class ECReturnQuery
extends ECQuery
    The ECReturnQuery is a concrete instantiation of the ECQuery abstract class. It is used to generate search queries for returns in the WebSphere Commerce database. This class knows the list of tables that can be selected from for an RMA query, and also knows how to join these tables. Usage: This example demonstrates a search for all returns whose logonId is LIKE %myLogon%. 
    
                        ECReturnQuery query = new ECReturnQuery();
                        WhereClauseSearchCondition whereClause = 
                                new WhereClauseSearchCondition(
                                        new TableField("USERREG", "LOGONID"),
                                        WhereClauseSearchCondition.SEARCHTYPE_CASEINSENSITIVE_CONTAINS,
                                        "myLogon");
                        query.setWhereClause(whereClause);

                        Vector vecResults =
                                (new OrderManagementJDBCHelperAccessBean()).executeCustomizableReturnSearch(
                                        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: 
      RMA         -- The return's RMA record. 
  STOREENT    -- The return's storeent record. 
  USERS       -- The return's user record. 
  USERREG     -- The return's user registry record. 
  PARENTORG   -- The return's user's parent organization (ORGENTITY table). 
  ANCESTORORG -- The return's user's ancestor organization (ORGENTITY table). 
  ADDRESS     -- The return's user's selfaddress. 
  MBRREL      -- The return's ancestors. 
  MEMBER      -- The return's MEMBER table entry.
    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.
        See Also:
        Constant Field Values

      • JOIN_STOREENT

        public static java.lang.String JOIN_STOREENT
        Join condition for the STOREENT table.

      • JOIN_MEMBER

        public static java.lang.String JOIN_MEMBER
        Join condition for the MEMBER table.

      • JOIN_USERS

        public static java.lang.String JOIN_USERS
        Join condition for the USERS table.

      • JOIN_USERREG

        public static java.lang.String JOIN_USERREG
        Join condition for the USERREG table.

      • JOIN_PARENTORG

        public static java.lang.String JOIN_PARENTORG
        Join condition for the parent organization from the ORGENTITY table.

      • JOIN_ANCESTORORG

        public static java.lang.String JOIN_ANCESTORORG
        Join condition for any ancestor organization from the ORGENTITY table.

      • JOIN_ADDRESS

        public static java.lang.String JOIN_ADDRESS
        Join condition for the ADDRESS table.

      • JOIN_MBRREL

        public static java.lang.String JOIN_MBRREL
        Join condition for the MBRREL table.

      • JOIN_MBRROLE

        public static java.lang.String JOIN_MBRROLE
        Join condition for the MBRROLE table.

      • JOIN_RMAITEM

        public static java.lang.String JOIN_RMAITEM
        Join condition for the RMAITEM table.

      • JOIN_ORDERITEMS

        public static java.lang.String JOIN_ORDERITEMS
        Join condition for the ORDERITEMS table.

      • JOIN_CONTRACT

        public static java.lang.String JOIN_CONTRACT
        Join condition for the CONTRACT table.

    • Constructor Detail

      • ECReturnQuery

        public ECReturnQuery()
        This method is the default constructor.
Skip navigation links
  • Prev Class
  • Next Class