com.ibm.commerce.search.rulequery
Class SelectQuery

java.lang.Object
  |
  +--com.ibm.commerce.search.rulequery.SelectQuery

public class SelectQuery
extends java.lang.Object

SelectQuery is similar to RuleQuery. There are two main differences. SelectQuery can be used to formulate multiple queries and execute them all in one go. SelectQuery also has following flexibility in retrieving the results. 1. Retrieves all non duplicate catentry ids for the set of queries, 2. Retrieves a fixed number of non duplicate catentry ids as returned by the database for the set of queries, 3. Retrieves a fixed number of non duplicate catentry ids picked in random for the set of queries. SelectQuery intenally depends on RuleQuery for most of its functions.


Field Summary
static java.lang.String ALL_Item
           
static int AND_Operator
           
static int ANY_QueryType
           
static int ASC_Operator
           
static int ATTRIBUTE_ATTRIBUTE_ID_Attr
           
static int ATTRIBUTE_CATENTRY_ID_Attr
           
static int ATTRIBUTE_LANGUAGE_ID_Attr
           
static int ATTRIBUTE_NAME_Attr
           
static int ATTRVALUE_ATTRIBUTE_ID_Attr
           
static int ATTRVALUE_CATENTRY_ID_Attr
           
static int ATTRVALUE_FLOATVALUE_Attr
           
static int ATTRVALUE_INTEGERVALUE_Attr
           
static int ATTRVALUE_LANGUAGE_ID_Attr
           
static int ATTRVALUE_NAME_Attr
           
static int ATTRVALUE_STRINGVALUE_Attr
           
static int AVG_Operator
           
static int BOTH_QueryType
           
static int CATENTDESC_AVAILABILITY_DATE_Attr
           
static int CATENTDESC_CATENTRY_ID_Attr
           
static int CATENTDESC_KEYWORD_Attr
           
static int CATENTDESC_LANGUAGE_ID_Attr
           
static int CATENTDESC_LONGDESCRIPTION_Attr
           
static int CATENTDESC_NAME_Attr
           
static int CATENTDESC_PARTNUMBER_Attr
           
static int CATENTDESC_PUBLISHED_Attr
           
static int CATENTDESC_SHORT_DESC_Attr
           
static int CATENTDESC_SHORTDESCRIPTION_Attr
           
static int CATENTDESC_THUMBNAIL_Attr
           
static int CATENTREL_CATENTRY_ID_CHILD_Attr
           
static int CATENTREL_CATENTRY_ID_PARENT_Attr
           
static int CATENTREL_CATREL_TYPE_ID_Attr
           
static int CATENTRY_BUYABLE_Attr
           
static int CATENTRY_CATENTRY_ID_Attr
           
static int CATENTRY_ID_Attr
           
static int CATENTRY_MARKFORDELETE_Attr
           
static int CATENTRY_MFNAME_Attr
           
static int CATENTRY_MFPARTNUMBER_Attr
           
static int CATENTRY_ONAUCTION_Attr
           
static int CATENTRY_ONSPECIAL_Attr
           
static int CATENTRY_PARTNUMBER_Attr
           
static int CATENTRY_SKU_Attr
           
static int CATENTRY_SKU_QueryType
           
static int CATGPENREL_CATALOG_ID_Attr
           
static int CATGPENREL_CATENTRY_ID_Attr
           
static int CATGPENREL_CATGROUP_ID_Attr
           
static int CATGROUP_CATGROUP_ID_Attr
           
static int CATGRPDESC_LANGUAGE_ID_Attr
           
static int CATGRPDESC_LONGDESCRIPTION_Attr
           
static int CATGRPDESC_NAME_Attr
           
static int CATGRPDESC_SHORTDESCRIPTION_Attr
           
static java.lang.String COPYRIGHT
           
static int COUNT_Operator
           
static int DESC_Operator
           
static int EQ_Operator
           
static int GE_Operator
           
static int GENERIC_QueryType
           
static int GROUP_BY_Operator
           
static int GT_Operator
           
static int IN_Operator
           
static int INVSTVW_QUANTITY_AVAILABLE_Attr
           
static int INVSTVW_QUANTITY_MEASURE_Attr
           
static int IS_NOT_NULL_Operator
           
static int IS_NULL_Operator
           
static int ITEM_QueryType
           
static int LE_Operator
           
static int LEFT_LIKE_Operator
           
static int LIKE_Operator
           
static int LISTPRICE_Attr
           
static int LISTPRICE_CATENTRY_ID_Attr
           
static int LISTPRICE_CURRENCY_Attr
           
static int LISTPRICE_LISTPRICE_Attr
           
static int LT_Operator
           
static int MAX_Operator
           
static int MIN_Operator
           
static int NE_Operator
           
static int NOT_GT_Operator
           
static int NOT_IN_Operator
           
static int NOT_LEFT_LIKE_Operator
           
static int NOT_LIKE_Operator
           
static int NOT_LT_Operator
           
static int NOT_RIGHT_LIKE_Operator
           
static int OFFER_MAXIMUMQUANTITY_Attr
           
static int OFFER_MINIMUMQUANTITY_Attr
           
static int OFFER_OFFER_ID_Attr
           
static int OFFER_TRADEPOSCN_ID_Attr
           
static int OFFERPRICE_CURRENCY_Attr
           
static int OFFERPRICE_OFFER_ID_Attr
           
static int OFFERPRICE_PRICE_Attr
           
static int OR_Operator
           
static int ORDER_BY_Operator
           
static int PRSETCEREL_CATENTRY_ID_Attr
           
static int PRSETCEREL_PRODUCTSET_ID_Attr
           
static int RIGHT_LIKE_Operator
           
static int STORECATENTRY_STORE_ID_Attr
           
static int STOREINVENTORY_QUANTITY_Attr
           
static int STOREINVENTORY_QUANTITY_MEASURE_Attr
           
static int SUM_Operator
           
static int TRADEPOSCN_TRADEPOSCN_ID_Attr
           
static int TRADEPOSCN_TYPE_ID_Attr
           
static int UPPER_Function
           
static int USER_ID_Attr
           
 
Constructor Summary
SelectQuery()
          Default select query constructor.
SelectQuery(int aStoreID, int aUserID)
          SelectQuery constructor with store and user id as arguments.
SelectQuery(int inStoreID, TradingAgreementAccessBean[] inAgreements, java.lang.Long userId)
          SelectQuery constructor with store id, trading agreement access bean and user id as arguments.
SelectQuery(com.ibm.commerce.search.rulequery.Query q)
          SelectQuery constructor with query as an argument.
SelectQuery(TradingAgreementAccessBean[] inAgreements, java.lang.Long userId)
          SelectQuery constructor with trading agreement access bean and user id as arguments.
SelectQuery(java.util.Vector inStoreIDs, int aUserID)
          SelectQuery constructor with a collection of store ids and an user id as arguments.
SelectQuery(java.util.Vector inStoreIDs, TradingAgreementAccessBean[] inAgreements, java.lang.Long userId)
          SelectQuery constructor with a collection of store ids, trading agreement access bean and user id as arguments.
 
Method Summary
 void addFilterAttribute(int attribute, int operator)
          Adds a predicate to query Where clause to filter a row, example, TABLE.COLUMN IS NOT NULL.
 void addFilterAttribute(int attribute, int operator, int function)
          Adds a predicate to query Where clause to filter a row, example FUNCTION(TABLE.COLUMN) IS NULL.
 void addFilterAttribute(int attribute, int operator, java.lang.String value)
          Adds a predicate to query Where clause to filter a row, example, TABLE.COLUMN LIKE '%VALUE%'.
 void addFilterAttribute(int attribute, int operator, java.lang.String value, int function)
          Adds a predicate to query Where clause to filter a row, example FUNCTION(TABLE.COLUMN) LIKE '%VALUE%'.
 void addFilterAttribute(com.ibm.commerce.search.rulequery.Predicate predicate)
          Adds a collection of WHERE clause predicates into temporary filter predicate collection.
 void addFilterOperator(int operator)
          Adds an operator that combines a set of filter predicates.
 void addGlobalPredicate()
          Method to insert a predicate that will be applied to entire query like BUYABLE/PUBLISHABLE/LANGUAGE_ID.
 void addGroupByAttribute(int attribute)
          To set group by operator Creation date: (6/20/2001 1:53:37 PM)
 void addOrderByAttribute(int attribute, int operator)
          To set order by operator Creation date: (6/20/2001 1:53:37 PM)
 void addRule()
          Adds an set of predicates to a Query.
 void addRule(int aQueryType)
          Adds a set of predicate to Query.
 void addSelectAttribute(int attribute, int operator)
          Adds a predicate to query Where clause, example, TABLE.COLUMN IS NOT NULL.
 void addSelectAttribute(int attribute, int operator, int function)
          Adds a predicate to query Where clause, example FUNCTION(TABLE.COLUMN) IS NULL.
 void addSelectAttribute(int attribute, int operator, java.lang.String value)
          Adds a predicate to query Where clause, example, TABLE.COLUMN LIKE '%VALUE%'.
 void addSelectAttribute(int attribute, int operator, java.lang.String value, int function)
          Adds a predicate to query Where clause, example FUNCTION(TABLE.COLUMN) LIKE '%VALUE%'.
 void addSelectAttribute(java.lang.String attribute, int operator, java.lang.String value, int attrValueType, java.lang.String languageId, java.lang.String prodType)
          Adds a Rich attribute predicate.
 void addSelectAttribute(java.lang.String attribute, int operator, java.lang.String value, int attrValueType, java.lang.String languageId, java.lang.String prodType, int function)
          Adds a Rich attribute predicate.
 void addSelectOperand(com.ibm.commerce.search.rulequery.Predicate predicate)
          Adds a collection of WHERE clause predicates into temporary select set predicate collection.
 void addSelectOperator(int operator)
          Adds an operator that combines a set of filter predicates.
 java.util.Vector execute()
          Executes a set of catalog search query and retrieves all non duplicate catentry ids that satisfy these query.
 java.util.Vector execute(int maxResults)
          Executes a set of catalog search query and retrieves certian number (specified in maxResults) of non duplicate catentry ids that satisfy these query.
 java.util.Vector execute(int numProductRequested, boolean randomStatus)
          Executes a set of catalog search query and retrieves at random a certian number (specified in numProductRequested) of non duplicate catentry ids that satisfy these query.
 java.util.Vector execute(int maxResults, com.ibm.commerce.search.rulequery.Cursor aCursor)
          Executes a set of catalog search query and retrieves certian number (specified in maxResults) of non duplicate catentry ids that satisfy these query.
protected  java.lang.String findAttributeInfoName(int attrId)
          Maps a static integer constant that defines a column name to the singleton class name that describes the column name, its data type, and the table it belong to.
protected  com.ibm.commerce.search.catalog.AttributeInfo getInstanceOfAttrInfoByClassName(java.lang.String classname)
          Given a class name in com.ibm.commerce.search.catalog package, gets the instance of the class.
 java.lang.Long getLongUserId()
          Do not modify.
 com.ibm.commerce.search.rulequery.Predicate getPredicate()
          Do not modify.
 java.util.Vector getRules()
          Do not modify.
 java.lang.Integer getStoreID()
          Do not modify.
 java.util.Vector getStoreIDs()
          Do not modify.
 java.lang.Integer getUserID()
          Do not modify.
 void reset()
          Re-initialize filterSet and selectSet variables Creation date: (10/30/00 5:52:47 AM)
 void setDistinct()
          To set disctict operator Creation date: (6/20/2001 9:33:19 AM)
 void setDistinct(boolean distinctFlag)
          To set disctict operator Creation date: (6/20/2001 9:33:19 AM)
 void setLongUserId(java.lang.Long newLongUserId)
          Do not modify.
 void setRules(java.util.Vector newRules)
          Do not modify.
 void setStoreID(int newStoreID)
          Do not modify.
 void setStoreIDs(java.util.Vector newStoreIDs)
          Do not modify.
 void setUserID(int newUserID)
          Do not modify.
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Field Detail

ALL_Item

public static final java.lang.String ALL_Item

AND_Operator

public static final int AND_Operator

ANY_QueryType

public static final int ANY_QueryType

ASC_Operator

public static final int ASC_Operator

ATTRIBUTE_ATTRIBUTE_ID_Attr

public static final int ATTRIBUTE_ATTRIBUTE_ID_Attr

ATTRIBUTE_CATENTRY_ID_Attr

public static final int ATTRIBUTE_CATENTRY_ID_Attr

ATTRIBUTE_LANGUAGE_ID_Attr

public static final int ATTRIBUTE_LANGUAGE_ID_Attr

ATTRIBUTE_NAME_Attr

public static final int ATTRIBUTE_NAME_Attr

ATTRVALUE_ATTRIBUTE_ID_Attr

public static final int ATTRVALUE_ATTRIBUTE_ID_Attr

ATTRVALUE_CATENTRY_ID_Attr

public static final int ATTRVALUE_CATENTRY_ID_Attr

ATTRVALUE_FLOATVALUE_Attr

public static final int ATTRVALUE_FLOATVALUE_Attr

ATTRVALUE_INTEGERVALUE_Attr

public static final int ATTRVALUE_INTEGERVALUE_Attr

ATTRVALUE_LANGUAGE_ID_Attr

public static final int ATTRVALUE_LANGUAGE_ID_Attr

ATTRVALUE_NAME_Attr

public static final int ATTRVALUE_NAME_Attr

ATTRVALUE_STRINGVALUE_Attr

public static final int ATTRVALUE_STRINGVALUE_Attr

AVG_Operator

public static final int AVG_Operator

BOTH_QueryType

public static final int BOTH_QueryType

CATENTDESC_AVAILABILITY_DATE_Attr

public static final int CATENTDESC_AVAILABILITY_DATE_Attr

CATENTDESC_CATENTRY_ID_Attr

public static final int CATENTDESC_CATENTRY_ID_Attr

CATENTDESC_KEYWORD_Attr

public static final int CATENTDESC_KEYWORD_Attr

CATENTDESC_LANGUAGE_ID_Attr

public static final int CATENTDESC_LANGUAGE_ID_Attr

CATENTDESC_LONGDESCRIPTION_Attr

public static final int CATENTDESC_LONGDESCRIPTION_Attr

CATENTDESC_NAME_Attr

public static final int CATENTDESC_NAME_Attr

CATENTDESC_PARTNUMBER_Attr

public static final int CATENTDESC_PARTNUMBER_Attr

CATENTDESC_PUBLISHED_Attr

public static final int CATENTDESC_PUBLISHED_Attr

CATENTDESC_SHORT_DESC_Attr

public static final int CATENTDESC_SHORT_DESC_Attr

CATENTDESC_SHORTDESCRIPTION_Attr

public static final int CATENTDESC_SHORTDESCRIPTION_Attr

CATENTDESC_THUMBNAIL_Attr

public static final int CATENTDESC_THUMBNAIL_Attr

CATENTREL_CATENTRY_ID_CHILD_Attr

public static final int CATENTREL_CATENTRY_ID_CHILD_Attr

CATENTREL_CATENTRY_ID_PARENT_Attr

public static final int CATENTREL_CATENTRY_ID_PARENT_Attr

CATENTREL_CATREL_TYPE_ID_Attr

public static final int CATENTREL_CATREL_TYPE_ID_Attr

CATENTRY_BUYABLE_Attr

public static final int CATENTRY_BUYABLE_Attr

CATENTRY_CATENTRY_ID_Attr

public static final int CATENTRY_CATENTRY_ID_Attr

CATENTRY_ID_Attr

public static final int CATENTRY_ID_Attr

CATENTRY_MARKFORDELETE_Attr

public static final int CATENTRY_MARKFORDELETE_Attr

CATENTRY_MFNAME_Attr

public static final int CATENTRY_MFNAME_Attr

CATENTRY_MFPARTNUMBER_Attr

public static final int CATENTRY_MFPARTNUMBER_Attr

CATENTRY_ONAUCTION_Attr

public static final int CATENTRY_ONAUCTION_Attr

CATENTRY_ONSPECIAL_Attr

public static final int CATENTRY_ONSPECIAL_Attr

CATENTRY_PARTNUMBER_Attr

public static final int CATENTRY_PARTNUMBER_Attr

CATENTRY_SKU_Attr

public static final int CATENTRY_SKU_Attr

CATENTRY_SKU_QueryType

public static final int CATENTRY_SKU_QueryType

CATGPENREL_CATALOG_ID_Attr

public static final int CATGPENREL_CATALOG_ID_Attr

CATGPENREL_CATENTRY_ID_Attr

public static final int CATGPENREL_CATENTRY_ID_Attr

CATGPENREL_CATGROUP_ID_Attr

public static final int CATGPENREL_CATGROUP_ID_Attr

CATGROUP_CATGROUP_ID_Attr

public static final int CATGROUP_CATGROUP_ID_Attr

CATGRPDESC_LANGUAGE_ID_Attr

public static final int CATGRPDESC_LANGUAGE_ID_Attr

CATGRPDESC_LONGDESCRIPTION_Attr

public static final int CATGRPDESC_LONGDESCRIPTION_Attr

CATGRPDESC_NAME_Attr

public static final int CATGRPDESC_NAME_Attr

CATGRPDESC_SHORTDESCRIPTION_Attr

public static final int CATGRPDESC_SHORTDESCRIPTION_Attr

COPYRIGHT

public static final java.lang.String COPYRIGHT

COUNT_Operator

public static final int COUNT_Operator

DESC_Operator

public static final int DESC_Operator

EQ_Operator

public static final int EQ_Operator

GE_Operator

public static final int GE_Operator

GENERIC_QueryType

public static final int GENERIC_QueryType

GROUP_BY_Operator

public static final int GROUP_BY_Operator

GT_Operator

public static final int GT_Operator

IN_Operator

public static final int IN_Operator

INVSTVW_QUANTITY_AVAILABLE_Attr

public static final int INVSTVW_QUANTITY_AVAILABLE_Attr

INVSTVW_QUANTITY_MEASURE_Attr

public static final int INVSTVW_QUANTITY_MEASURE_Attr

IS_NOT_NULL_Operator

public static final int IS_NOT_NULL_Operator

IS_NULL_Operator

public static final int IS_NULL_Operator

ITEM_QueryType

public static final int ITEM_QueryType

LE_Operator

public static final int LE_Operator

LEFT_LIKE_Operator

public static final int LEFT_LIKE_Operator

LIKE_Operator

public static final int LIKE_Operator

LISTPRICE_Attr

public static final int LISTPRICE_Attr

LISTPRICE_CATENTRY_ID_Attr

public static final int LISTPRICE_CATENTRY_ID_Attr

LISTPRICE_CURRENCY_Attr

public static final int LISTPRICE_CURRENCY_Attr

LISTPRICE_LISTPRICE_Attr

public static final int LISTPRICE_LISTPRICE_Attr

LT_Operator

public static final int LT_Operator

MAX_Operator

public static final int MAX_Operator

MIN_Operator

public static final int MIN_Operator

NE_Operator

public static final int NE_Operator

NOT_GT_Operator

public static final int NOT_GT_Operator

NOT_IN_Operator

public static final int NOT_IN_Operator

NOT_LEFT_LIKE_Operator

public static final int NOT_LEFT_LIKE_Operator

NOT_LIKE_Operator

public static final int NOT_LIKE_Operator

NOT_LT_Operator

public static final int NOT_LT_Operator

NOT_RIGHT_LIKE_Operator

public static final int NOT_RIGHT_LIKE_Operator

OFFER_MAXIMUMQUANTITY_Attr

public static final int OFFER_MAXIMUMQUANTITY_Attr

OFFER_MINIMUMQUANTITY_Attr

public static final int OFFER_MINIMUMQUANTITY_Attr

OFFER_OFFER_ID_Attr

public static final int OFFER_OFFER_ID_Attr

OFFER_TRADEPOSCN_ID_Attr

public static final int OFFER_TRADEPOSCN_ID_Attr

OFFERPRICE_CURRENCY_Attr

public static final int OFFERPRICE_CURRENCY_Attr

OFFERPRICE_OFFER_ID_Attr

public static final int OFFERPRICE_OFFER_ID_Attr

OFFERPRICE_PRICE_Attr

public static final int OFFERPRICE_PRICE_Attr

OR_Operator

public static final int OR_Operator

ORDER_BY_Operator

public static final int ORDER_BY_Operator

PRSETCEREL_CATENTRY_ID_Attr

public static final int PRSETCEREL_CATENTRY_ID_Attr

PRSETCEREL_PRODUCTSET_ID_Attr

public static final int PRSETCEREL_PRODUCTSET_ID_Attr

RIGHT_LIKE_Operator

public static final int RIGHT_LIKE_Operator

STORECATENTRY_STORE_ID_Attr

public static final int STORECATENTRY_STORE_ID_Attr

STOREINVENTORY_QUANTITY_Attr

public static final int STOREINVENTORY_QUANTITY_Attr

STOREINVENTORY_QUANTITY_MEASURE_Attr

public static final int STOREINVENTORY_QUANTITY_MEASURE_Attr

SUM_Operator

public static final int SUM_Operator

TRADEPOSCN_TRADEPOSCN_ID_Attr

public static final int TRADEPOSCN_TRADEPOSCN_ID_Attr

TRADEPOSCN_TYPE_ID_Attr

public static final int TRADEPOSCN_TYPE_ID_Attr

UPPER_Function

public static final int UPPER_Function

USER_ID_Attr

public static final int USER_ID_Attr
Constructor Detail

SelectQuery

public SelectQuery()
Default select query constructor. Creation date: (9/17/00 12:00:14 AM)

SelectQuery

public SelectQuery(int aStoreID,
                   int aUserID)
SelectQuery constructor with store and user id as arguments. Creation date: (9/17/00 12:00:14 AM)
Parameters:
storeID - The store id - used in the queries.
userID - The user id - used in the queries.

SelectQuery

public SelectQuery(int inStoreID,
                   TradingAgreementAccessBean[] inAgreements,
                   java.lang.Long userId)
SelectQuery constructor with store id, trading agreement access bean and user id as arguments. Creation date: (9/17/00 12:00:14 AM)
Parameters:
storeID - The store id - used in the queries.
inAgreements - The trading agreement access bean array - used in entitlement
userID - The user id of type long - used in the queries.

SelectQuery

public SelectQuery(com.ibm.commerce.search.rulequery.Query q)
SelectQuery constructor with query as an argument. Creation date: (9/17/00 12:00:14 AM)
Parameters:
q - The query object.

SelectQuery

public SelectQuery(TradingAgreementAccessBean[] inAgreements,
                   java.lang.Long userId)
SelectQuery constructor with trading agreement access bean and user id as arguments. Creation date: (9/17/00 12:00:14 AM)
Parameters:
inAgreements - The trading agreement access bean array - used in entitlement
userID - The user id - used in the queries.

SelectQuery

public SelectQuery(java.util.Vector inStoreIDs,
                   int aUserID)
SelectQuery constructor with a collection of store ids and an user id as arguments. Creation date: (9/17/00 12:00:14 AM)
Parameters:
storeID - The store id collection - used in the queries.
userID - The user id - used in the queries.

SelectQuery

public SelectQuery(java.util.Vector inStoreIDs,
                   TradingAgreementAccessBean[] inAgreements,
                   java.lang.Long userId)
SelectQuery constructor with a collection of store ids, trading agreement access bean and user id as arguments. Creation date: (9/17/00 12:00:14 AM)
Parameters:
instoreIDs - A collection of store ids - used in the queries.
inAgreements - The trading agreement access bean array - used in entitlement
userID - The user id of type long- used in the queries.
Method Detail

addFilterAttribute

public void addFilterAttribute(int attribute,
                               int operator)
                        throws java.lang.Exception
Adds a predicate to query Where clause to filter a row, example, TABLE.COLUMN IS NOT NULL. This method will use compliment of specified operator. For example if the operator is LIKE then this method will convert it to NOTLIKE and vice versa. Creation date: (08/24/00 6:56:54 PM)
Parameters:
The - static integer constant equivalent of a column name.
The - static integer constant equivalent of an operator.

addFilterAttribute

public void addFilterAttribute(int attribute,
                               int operator,
                               int function)
                        throws java.lang.Exception
Adds a predicate to query Where clause to filter a row, example FUNCTION(TABLE.COLUMN) IS NULL. This method will use compliment of specified operator. For example if the operator is LIKE then this method will convert it to NOTLIKE and vice versa. Creation date: (08/24/00 6:56:54 PM)
Parameters:
The - static integer constant equivalent of a column name.
The - static integer constant equivalent of an operator.
The - static integer constant equivalent of a function. At present only UPPER function is supported.

addFilterAttribute

public void addFilterAttribute(int attribute,
                               int operator,
                               java.lang.String value)
                        throws java.lang.Exception
Adds a predicate to query Where clause to filter a row, example, TABLE.COLUMN LIKE '%VALUE%'. This method will use compliment of specified operator. For example if the operator is LIKE then this method will convert it to NOTLIKE and vice versa. Creation date: (08/24/00 6:56:54 PM)
Parameters:
The - static integer constant equivalent of a column name.
The - static integer constant equivalent of an operator.
The - value to be filtered from the database.

addFilterAttribute

public void addFilterAttribute(int attribute,
                               int operator,
                               java.lang.String value,
                               int function)
                        throws java.lang.Exception
Adds a predicate to query Where clause to filter a row, example FUNCTION(TABLE.COLUMN) LIKE '%VALUE%'. This method will use compliment of specified operator. For example if the operator is LIKE then this method will convert it to NOTLIKE and vice versa. Creation date: (08/24/00 6:56:54 PM)
Parameters:
The - static integer constant equivalent of a column name.
The - static integer constant equivalent of an operator.
The - value to be filtered from the database.
The - static integer constant equivalent of a function. At present only UPPER function is supported.

addFilterAttribute

public void addFilterAttribute(com.ibm.commerce.search.rulequery.Predicate predicate)
                        throws java.lang.Exception
Adds a collection of WHERE clause predicates into temporary filter predicate collection. Creation date: (7/7/01 12:11:02 PM)
Parameters:
A - collection of WHERE clause predicates

addFilterOperator

public void addFilterOperator(int operator)
Adds an operator that combines a set of filter predicates. The logic for post-fix resides in this method. Creation date: (08/22/00 6:20:14 PM)
Parameters:
The - static integer constant equivalent of an operator.

addGlobalPredicate

public void addGlobalPredicate()
Method to insert a predicate that will be applied to entire query like BUYABLE/PUBLISHABLE/LANGUAGE_ID. The Global predicate will be ANDed with the selectSet/filterSet. Creation date: (8/23/2001 2:53:28 PM)

addGroupByAttribute

public void addGroupByAttribute(int attribute)
                         throws java.lang.Exception
To set group by operator Creation date: (6/20/2001 1:53:37 PM)

addOrderByAttribute

public void addOrderByAttribute(int attribute,
                                int operator)
                         throws java.lang.Exception
To set order by operator Creation date: (6/20/2001 1:53:37 PM)

addRule

public void addRule()
Adds an set of predicates to a Query. Must be specified after all the individual predicates are specified. The search interface can retrieve only Products, only Items or Both. By default the interface will retrieve only Products. Creation date: (08/22/00 6:21:32 PM)

addRule

public void addRule(int aQueryType)
Adds a set of predicate to Query. Must be specified after all the individual predicates are specified. Creation date: (11/12/00 4:12:07 PM)
Parameters:
aQueryType - The type of result to be retrieved by the query. The search interface can retrieve only Products, only Items or Both.

addSelectAttribute

public void addSelectAttribute(int attribute,
                               int operator)
                        throws java.lang.Exception
Adds a predicate to query Where clause, example, TABLE.COLUMN IS NOT NULL. Creation date: (08/24/00 6:56:54 PM)
Parameters:
The - static integer constant equivalent of a column name.
The - static integer constant equivalent of an operator.

addSelectAttribute

public void addSelectAttribute(int attribute,
                               int operator,
                               int function)
                        throws java.lang.Exception
Adds a predicate to query Where clause, example FUNCTION(TABLE.COLUMN) IS NULL. Creation date: (08/24/00 6:56:54 PM)
Parameters:
The - static integer constant equivalent of a column name.
The - static integer constant equivalent of an operator.
The - static integer constant equivalent of a function. At present only UPPER function is supported.

addSelectAttribute

public void addSelectAttribute(int attribute,
                               int operator,
                               java.lang.String value)
                        throws java.lang.Exception
Adds a predicate to query Where clause, example, TABLE.COLUMN LIKE '%VALUE%'. Creation date: (08/24/00 6:56:54 PM)
Parameters:
The - static integer constant equivalent of a column name.
The - static integer constant equivalent of an operator.
The - value to be filtered from the database.

addSelectAttribute

public void addSelectAttribute(int attribute,
                               int operator,
                               java.lang.String value,
                               int function)
                        throws java.lang.Exception
Adds a predicate to query Where clause, example FUNCTION(TABLE.COLUMN) LIKE '%VALUE%'. This method will use compliment of specified operator. For example if the operator is LIKE then this method will convert it to NOTLIKE and vice versa. Creation date: (08/24/00 6:56:54 PM)
Parameters:
The - static integer constant equivalent of a column name.
The - static integer constant equivalent of an operator.
The - value to be filtered from the database.
The - static integer constant equivalent of a function. At present only UPPER function is supported.

addSelectAttribute

public void addSelectAttribute(java.lang.String attribute,
                               int operator,
                               java.lang.String value,
                               int attrValueType,
                               java.lang.String languageId,
                               java.lang.String prodType)
                        throws java.lang.Exception
Adds a Rich attribute predicate. This method supports NAME, STRINGVALUE, FLOATVALUE and INTEGERVALUE column in AttrValue column. Creation date: (3/30/2001 1:44:27 PM)
Parameters:
attribute - A search attribute, for example Color, Size.
operator - The static integer operator constant.
value - The value of a search attribute, for example Red, Length = 32.
attrValueType - The column in AttrValue table that must be used to search for the value, example Intergervalue, Stringvalue, Floatvalue or Name.
languageId - The language id that must be used for searching the rich attribute.
prodType - The Parent - Child relationship defined in CATENREL table. At present this method only supports Product_Item or NULL.

addSelectAttribute

public void addSelectAttribute(java.lang.String attribute,
                               int operator,
                               java.lang.String value,
                               int attrValueType,
                               java.lang.String languageId,
                               java.lang.String prodType,
                               int function)
                        throws java.lang.Exception
Adds a Rich attribute predicate. This method only supports NAME, STRINGVALUE, FLOATVALUE and INTEGERVALUE column in AttrValue column. Creation date: (3/30/2001 1:44:27 PM)
Parameters:
attribute - A search attribute, for example Color, Size.
operator - The static integer operator constant.
value - The value of a search attribute, for example Red, Length = 32.
attrValueType - The column in AttrValue table that must be used to search for the value, example Intergervalue, Stringvalue, Floatvalue or Name.
languageId - The language id that must be used for searching the rich attribute.
prodType - The Parent - Child relationship defined in CATENREL table. At present this method only supports Product_Item or NULL.
function - The static integer operator for UPPER function

addSelectOperand

public void addSelectOperand(com.ibm.commerce.search.rulequery.Predicate predicate)
                      throws java.lang.Exception
Adds a collection of WHERE clause predicates into temporary select set predicate collection. Before adding to the collection this method may translate the collection of predicates into a sub-query. At present the tanslation is supported for following table columns CATGPENREL.CATGROUP_ID and CATGRPDESC.NAME or SHORTDESC or LONGDESC. Creation date: (07/07/01 12:11:02 PM)
Parameters:
predicate - A collection of predicates.

addSelectOperator

public void addSelectOperator(int operator)
Adds an operator that combines a set of filter predicates. The logic for post-fix resides in this method. Creation date: (08/22/00 6:20:14 PM)
Parameters:
The - static integer constant equivalent of an operator.

execute

public java.util.Vector execute()
                         throws java.lang.Exception
Executes a set of catalog search query and retrieves all non duplicate catentry ids that satisfy these query. Creation date: (9/18/00 8:14:39 PM)
Returns:
A collection of catentry ids.

execute

public java.util.Vector execute(int maxResults)
                         throws java.lang.Exception
Executes a set of catalog search query and retrieves certian number (specified in maxResults) of non duplicate catentry ids that satisfy these query. This version do not use cursor. Creation date: (9/18/00 8:14:39 PM)
Parameters:
maxResults - The number of results to be retrieved.
Returns:
A collection of catentry ids.

execute

public java.util.Vector execute(int numProductRequested,
                                boolean randomStatus)
                         throws java.lang.Exception
Executes a set of catalog search query and retrieves at random a certian number (specified in numProductRequested) of non duplicate catentry ids that satisfy these query. Creation date: (9/18/00 8:14:39 PM)
Parameters:
The - total number of catentry ids to be returned.
random - true if results must be random, false otherwise.
Returns:
A collection of catentry ids.

execute

public java.util.Vector execute(int maxResults,
                                com.ibm.commerce.search.rulequery.Cursor aCursor)
                         throws java.lang.Exception
Executes a set of catalog search query and retrieves certian number (specified in maxResults) of non duplicate catentry ids that satisfy these query. This version uses cursor. Creation date: (9/18/00 8:14:39 PM)
Parameters:
maxResults - The number of results to be retrieved.
aCursor - The cusrsor object.
Returns:
A collection of catentry ids.

findAttributeInfoName

protected java.lang.String findAttributeInfoName(int attrId)
Maps a static integer constant that defines a column name to the singleton class name that describes the column name, its data type, and the table it belong to. Creation date: (9/21/00 5:33:59 PM)
Parameters:
attrId - The static integer constant that defines a column name.
Returns:
The singleton class name that match the column name integer constant .

getInstanceOfAttrInfoByClassName

protected com.ibm.commerce.search.catalog.AttributeInfo getInstanceOfAttrInfoByClassName(java.lang.String classname)
                                                                                  throws java.lang.Exception
Given a class name in com.ibm.commerce.search.catalog package, gets the instance of the class. Creation date: (08/25/00 2:38:31 PM)
Parameters:
classname - The name of a class in com.ibm.commerce.search.catalog package.
Returns:
The instance of the class in com.ibm.commerce.search.catalog package.

getLongUserId

public java.lang.Long getLongUserId()
Do not modify. Method generated by VAJ. Creation date: (10/1/2001 4:15:55 PM)
Returns:
The user id of type Long.

getPredicate

public com.ibm.commerce.search.rulequery.Predicate getPredicate()
                                                         throws java.lang.Exception
Do not modify. Method generated by VAJ. Creation date: (7/6/2001 10:13:36 AM)
Returns:
The selectSet and filterSet predicate.

getRules

public java.util.Vector getRules()
Do not modify. Method generated by VAJ. Creation date: (9/17/00 12:03:38 AM)
Returns:
The query collection.

getStoreID

public java.lang.Integer getStoreID()
Do not modify. Method generated by VAJ. Creation date: (6/25/2001 2:41:44 PM)
Returns:
The store id.

getStoreIDs

public java.util.Vector getStoreIDs()
Do not modify. Method generated by VAJ. Creation date: (6/25/2001 2:41:44 PM)
Returns:
The collection of store ids.

getUserID

public java.lang.Integer getUserID()
Do not modify. Method generated by VAJ. Creation date: (6/25/2001 2:41:44 PM)
Returns:
The user id.

reset

public void reset()
Re-initialize filterSet and selectSet variables Creation date: (10/30/00 5:52:47 AM)

setDistinct

public void setDistinct()
To set disctict operator Creation date: (6/20/2001 9:33:19 AM)

setDistinct

public void setDistinct(boolean distinctFlag)
To set disctict operator Creation date: (6/20/2001 9:33:19 AM)

setLongUserId

public void setLongUserId(java.lang.Long newLongUserId)
Do not modify. Method generated by VAJ. Creation date: (10/1/2001 4:15:55 PM)
Parameters:
newLongUserId - java.lang.Long

setRules

public void setRules(java.util.Vector newRules)
Do not modify. Method generated by VAJ. Creation date: (9/17/00 12:03:38 AM)
Parameters:
newRules - java.util.Vector

setStoreID

public void setStoreID(int newStoreID)
Do not modify. Method generated by VAJ. Creation date: (9/17/00 12:01:27 AM)
Parameters:
newStoreID - int

setStoreIDs

public void setStoreIDs(java.util.Vector newStoreIDs)
Do not modify. Method generated by VAJ. Creation date: (8/15/2001 1:45:45 PM)
Parameters:
newStoreIDs - java.util.Vector

setUserID

public void setUserID(int newUserID)
Do not modify. Method generated by VAJ. Creation date: (9/17/00 12:02:06 AM)
Parameters:
newRuleID - int