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 BUNDLE_CatEntryType
           
static int CATALOG_CATALOG_ID_Attr
           
static int CATALOG_DESCRIPTION_Attr
           
static int CATALOG_IDENTIFIER_Attr
           
static int CATALOGDSC_LANGUAGE_ID_Attr
           
static int CATALOGDSC_NAME_Attr
           
static int CATALOGDSC_SHORTDESCRIPTION_Attr
           
static int CATENTDESC_AVAILABILITY_DATE_Attr
           
static int CATENTDESC_AVAILABLE_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_LASTUPDATE_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 CATGROUP_IDENTIFIER_Attr
           
static int CATGROUP_IDENTIFIER_ID_Attr
           
static int CATGROUP_LASTUPDATE_Attr
           
static int CATGROUP_MARKFORDELETE_Attr
           
static int CATGRPDESC_KEYWORD_Attr
           
static int CATGRPDESC_LANGUAGE_ID_Attr
           
static int CATGRPDESC_LONGDESCRIPTION_Attr
           
static int CATGRPDESC_NAME_Attr
           
static int CATGRPDESC_PUBLISHED_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 INVSTVW_STORE_ID_Attr
           
static int IS_NOT_NULL_Operator
           
static int IS_NULL_Operator
           
static int ITEM_CatEntryType
           
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 PACKAGE_CatEntryType
           
static int PRODUCT_CatEntryType
           
static int PRSETCEREL_CATENTRY_ID_Attr
           
static int PRSETCEREL_PRODUCTSET_ID_Attr
           
static int RIGHT_LIKE_Operator
           
static int STDPRICEVW_CATENTRY_ID_Attr
           
static int STDPRICEVW_CURRENCY_Attr
           
static int STDPRICEVW_PRICE_Attr
           
static int STORECAT_MASTERCATALOG_Attr
           
static int STORECAT_STOREENT_ID_Attr
           
static int STORECATENTRY_STORE_ID_Attr
           
static int STORECGRP_STOREENT_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)
          Deprecated.  
SelectQuery(int inStoreID, TradingAgreementAccessBean[] inAgreements, java.lang.Long userId)
          SelectQuery constructor with store id, trading agreement access bean and user id as arguments.
SelectQuery( TradingAgreementAccessBean[] inAgreements)
          Deprecated.  
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)
          Deprecated.  
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(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(Predicate p)
          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
 void addOrderByAttribute(int attribute, int operator)
          To set order by operator
 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)
          Deprecated.  
 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 addSelectAttribute(java.lang.String attribute, int operator, java.lang.String value, java.lang.String languageId, java.lang.String prodType)
          Deprecated.  
 void addSelectAttribute(java.lang.String attribute, int operator, java.lang.String value, java.lang.String languageId, java.lang.String prodType, int function)
          Deprecated.  
 void addSelectOperand(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 maxResults, 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  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.
 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
 void setDistinct()
          To set disctict operator
 void setDistinct(boolean distinctFlag)
          To set disctict operator
 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
public static final java.lang.String COPYRIGHT
See Also:
Constant Field Values

LISTPRICE_LISTPRICE_Attr

public static final int LISTPRICE_LISTPRICE_Attr
See Also:
Constant Field Values

LISTPRICE_Attr

public static final int LISTPRICE_Attr
See Also:
Constant Field Values

LISTPRICE_CURRENCY_Attr

public static final int LISTPRICE_CURRENCY_Attr
See Also:
Constant Field Values

LISTPRICE_CATENTRY_ID_Attr

public static final int LISTPRICE_CATENTRY_ID_Attr
See Also:
Constant Field Values

STOREINVENTORY_QUANTITY_Attr

public static final int STOREINVENTORY_QUANTITY_Attr
See Also:
Constant Field Values

STOREINVENTORY_QUANTITY_MEASURE_Attr

public static final int STOREINVENTORY_QUANTITY_MEASURE_Attr
See Also:
Constant Field Values

CATGRPDESC_NAME_Attr

public static final int CATGRPDESC_NAME_Attr
See Also:
Constant Field Values

CATGRPDESC_LANGUAGE_ID_Attr

public static final int CATGRPDESC_LANGUAGE_ID_Attr
See Also:
Constant Field Values

CATGRPDESC_LONGDESCRIPTION_Attr

public static final int CATGRPDESC_LONGDESCRIPTION_Attr
See Also:
Constant Field Values

CATGRPDESC_SHORTDESCRIPTION_Attr

public static final int CATGRPDESC_SHORTDESCRIPTION_Attr
See Also:
Constant Field Values

CATGRPDESC_KEYWORD_Attr

public static final int CATGRPDESC_KEYWORD_Attr
See Also:
Constant Field Values

CATGRPDESC_PUBLISHED_Attr

public static final int CATGRPDESC_PUBLISHED_Attr
See Also:
Constant Field Values

CATENTRY_SKU_Attr

public static final int CATENTRY_SKU_Attr
See Also:
Constant Field Values

CATENTRY_CATENTRY_ID_Attr

public static final int CATENTRY_CATENTRY_ID_Attr
See Also:
Constant Field Values

CATENTRY_ID_Attr

public static final int CATENTRY_ID_Attr
See Also:
Constant Field Values

CATENTRY_BUYABLE_Attr

public static final int CATENTRY_BUYABLE_Attr
See Also:
Constant Field Values

CATENTRY_ONAUCTION_Attr

public static final int CATENTRY_ONAUCTION_Attr
See Also:
Constant Field Values

CATENTRY_ONSPECIAL_Attr

public static final int CATENTRY_ONSPECIAL_Attr
See Also:
Constant Field Values

CATENTRY_PARTNUMBER_Attr

public static final int CATENTRY_PARTNUMBER_Attr
See Also:
Constant Field Values

CATENTRY_MFNAME_Attr

public static final int CATENTRY_MFNAME_Attr
See Also:
Constant Field Values

CATENTRY_MFPARTNUMBER_Attr

public static final int CATENTRY_MFPARTNUMBER_Attr
See Also:
Constant Field Values

CATENTRY_MARKFORDELETE_Attr

public static final int CATENTRY_MARKFORDELETE_Attr
See Also:
Constant Field Values

CATENTRY_LASTUPDATE_Attr

public static final int CATENTRY_LASTUPDATE_Attr
See Also:
Constant Field Values

CATENTDESC_NAME_Attr

public static final int CATENTDESC_NAME_Attr
See Also:
Constant Field Values

CATENTDESC_AVAILABILITY_DATE_Attr

public static final int CATENTDESC_AVAILABILITY_DATE_Attr
See Also:
Constant Field Values

CATENTDESC_LANGUAGE_ID_Attr

public static final int CATENTDESC_LANGUAGE_ID_Attr
See Also:
Constant Field Values

CATENTDESC_PUBLISHED_Attr

public static final int CATENTDESC_PUBLISHED_Attr
See Also:
Constant Field Values

CATENTDESC_SHORT_DESC_Attr

public static final int CATENTDESC_SHORT_DESC_Attr
See Also:
Constant Field Values

CATENTDESC_CATENTRY_ID_Attr

public static final int CATENTDESC_CATENTRY_ID_Attr
See Also:
Constant Field Values

CATENTDESC_THUMBNAIL_Attr

public static final int CATENTDESC_THUMBNAIL_Attr
See Also:
Constant Field Values

CATENTDESC_LONGDESCRIPTION_Attr

public static final int CATENTDESC_LONGDESCRIPTION_Attr
See Also:
Constant Field Values

CATENTDESC_SHORTDESCRIPTION_Attr

public static final int CATENTDESC_SHORTDESCRIPTION_Attr
See Also:
Constant Field Values

CATENTDESC_PARTNUMBER_Attr

public static final int CATENTDESC_PARTNUMBER_Attr
See Also:
Constant Field Values

CATENTDESC_KEYWORD_Attr

public static final int CATENTDESC_KEYWORD_Attr
See Also:
Constant Field Values

CATENTDESC_AVAILABLE_Attr

public static final int CATENTDESC_AVAILABLE_Attr
See Also:
Constant Field Values

STORECATENTRY_STORE_ID_Attr

public static final int STORECATENTRY_STORE_ID_Attr
See Also:
Constant Field Values

USER_ID_Attr

public static final int USER_ID_Attr
See Also:
Constant Field Values

CATENTREL_CATENTRY_ID_CHILD_Attr

public static final int CATENTREL_CATENTRY_ID_CHILD_Attr
See Also:
Constant Field Values

CATENTREL_CATENTRY_ID_PARENT_Attr

public static final int CATENTREL_CATENTRY_ID_PARENT_Attr
See Also:
Constant Field Values

CATENTREL_CATREL_TYPE_ID_Attr

public static final int CATENTREL_CATREL_TYPE_ID_Attr
See Also:
Constant Field Values

ATTRIBUTE_NAME_Attr

public static final int ATTRIBUTE_NAME_Attr
See Also:
Constant Field Values

ATTRIBUTE_LANGUAGE_ID_Attr

public static final int ATTRIBUTE_LANGUAGE_ID_Attr
See Also:
Constant Field Values

ATTRIBUTE_CATENTRY_ID_Attr

public static final int ATTRIBUTE_CATENTRY_ID_Attr
See Also:
Constant Field Values

ATTRIBUTE_ATTRIBUTE_ID_Attr

public static final int ATTRIBUTE_ATTRIBUTE_ID_Attr
See Also:
Constant Field Values

ATTRVALUE_LANGUAGE_ID_Attr

public static final int ATTRVALUE_LANGUAGE_ID_Attr
See Also:
Constant Field Values

ATTRVALUE_NAME_Attr

public static final int ATTRVALUE_NAME_Attr
See Also:
Constant Field Values

ATTRVALUE_CATENTRY_ID_Attr

public static final int ATTRVALUE_CATENTRY_ID_Attr
See Also:
Constant Field Values

ATTRVALUE_STRINGVALUE_Attr

public static final int ATTRVALUE_STRINGVALUE_Attr
See Also:
Constant Field Values

ATTRVALUE_ATTRIBUTE_ID_Attr

public static final int ATTRVALUE_ATTRIBUTE_ID_Attr
See Also:
Constant Field Values

ATTRVALUE_FLOATVALUE_Attr

public static final int ATTRVALUE_FLOATVALUE_Attr
See Also:
Constant Field Values

ATTRVALUE_INTEGERVALUE_Attr

public static final int ATTRVALUE_INTEGERVALUE_Attr
See Also:
Constant Field Values

CATGPENREL_CATGROUP_ID_Attr

public static final int CATGPENREL_CATGROUP_ID_Attr
See Also:
Constant Field Values

CATGPENREL_CATENTRY_ID_Attr

public static final int CATGPENREL_CATENTRY_ID_Attr
See Also:
Constant Field Values

CATGPENREL_CATALOG_ID_Attr

public static final int CATGPENREL_CATALOG_ID_Attr
See Also:
Constant Field Values

CATGROUP_CATGROUP_ID_Attr

public static final int CATGROUP_CATGROUP_ID_Attr
See Also:
Constant Field Values

CATGROUP_MARKFORDELETE_Attr

public static final int CATGROUP_MARKFORDELETE_Attr
See Also:
Constant Field Values

CATGROUP_LASTUPDATE_Attr

public static final int CATGROUP_LASTUPDATE_Attr
See Also:
Constant Field Values

CATGROUP_IDENTIFIER_ID_Attr

public static final int CATGROUP_IDENTIFIER_ID_Attr
See Also:
Constant Field Values

CATGROUP_IDENTIFIER_Attr

public static final int CATGROUP_IDENTIFIER_Attr
See Also:
Constant Field Values

PRSETCEREL_PRODUCTSET_ID_Attr

public static final int PRSETCEREL_PRODUCTSET_ID_Attr
See Also:
Constant Field Values

PRSETCEREL_CATENTRY_ID_Attr

public static final int PRSETCEREL_CATENTRY_ID_Attr
See Also:
Constant Field Values

OFFERPRICE_PRICE_Attr

public static final int OFFERPRICE_PRICE_Attr
See Also:
Constant Field Values

OFFERPRICE_OFFER_ID_Attr

public static final int OFFERPRICE_OFFER_ID_Attr
See Also:
Constant Field Values

OFFERPRICE_CURRENCY_Attr

public static final int OFFERPRICE_CURRENCY_Attr
See Also:
Constant Field Values

OFFER_TRADEPOSCN_ID_Attr

public static final int OFFER_TRADEPOSCN_ID_Attr
See Also:
Constant Field Values

OFFER_OFFER_ID_Attr

public static final int OFFER_OFFER_ID_Attr
See Also:
Constant Field Values

OFFER_MAXIMUMQUANTITY_Attr

public static final int OFFER_MAXIMUMQUANTITY_Attr
See Also:
Constant Field Values

OFFER_MINIMUMQUANTITY_Attr

public static final int OFFER_MINIMUMQUANTITY_Attr
See Also:
Constant Field Values

TRADEPOSCN_TRADEPOSCN_ID_Attr

public static final int TRADEPOSCN_TRADEPOSCN_ID_Attr
See Also:
Constant Field Values

TRADEPOSCN_TYPE_ID_Attr

public static final int TRADEPOSCN_TYPE_ID_Attr
See Also:
Constant Field Values

INVSTVW_QUANTITY_AVAILABLE_Attr

public static final int INVSTVW_QUANTITY_AVAILABLE_Attr
See Also:
Constant Field Values

INVSTVW_QUANTITY_MEASURE_Attr

public static final int INVSTVW_QUANTITY_MEASURE_Attr
See Also:
Constant Field Values

INVSTVW_STORE_ID_Attr

public static final int INVSTVW_STORE_ID_Attr
See Also:
Constant Field Values

STDPRICEVW_PRICE_Attr

public static final int STDPRICEVW_PRICE_Attr
See Also:
Constant Field Values

STDPRICEVW_CATENTRY_ID_Attr

public static final int STDPRICEVW_CATENTRY_ID_Attr
See Also:
Constant Field Values

STDPRICEVW_CURRENCY_Attr

public static final int STDPRICEVW_CURRENCY_Attr
See Also:
Constant Field Values

CATALOG_CATALOG_ID_Attr

public static final int CATALOG_CATALOG_ID_Attr
See Also:
Constant Field Values

CATALOG_DESCRIPTION_Attr

public static final int CATALOG_DESCRIPTION_Attr
See Also:
Constant Field Values

CATALOG_IDENTIFIER_Attr

public static final int CATALOG_IDENTIFIER_Attr
See Also:
Constant Field Values

CATALOGDSC_NAME_Attr

public static final int CATALOGDSC_NAME_Attr
See Also:
Constant Field Values

CATALOGDSC_SHORTDESCRIPTION_Attr

public static final int CATALOGDSC_SHORTDESCRIPTION_Attr
See Also:
Constant Field Values

CATALOGDSC_LANGUAGE_ID_Attr

public static final int CATALOGDSC_LANGUAGE_ID_Attr
See Also:
Constant Field Values

STORECAT_MASTERCATALOG_Attr

public static final int STORECAT_MASTERCATALOG_Attr
See Also:
Constant Field Values

STORECAT_STOREENT_ID_Attr

public static final int STORECAT_STOREENT_ID_Attr
See Also:
Constant Field Values

STORECGRP_STOREENT_ID_Attr

public static final int STORECGRP_STOREENT_ID_Attr
See Also:
Constant Field Values

OR_Operator

public static final int OR_Operator
See Also:
Constant Field Values

AND_Operator

public static final int AND_Operator
See Also:
Constant Field Values

IS_NULL_Operator

public static final int IS_NULL_Operator
See Also:
Constant Field Values

IS_NOT_NULL_Operator

public static final int IS_NOT_NULL_Operator
See Also:
Constant Field Values

LIKE_Operator

public static final int LIKE_Operator
See Also:
Constant Field Values

LEFT_LIKE_Operator

public static final int LEFT_LIKE_Operator
See Also:
Constant Field Values

RIGHT_LIKE_Operator

public static final int RIGHT_LIKE_Operator
See Also:
Constant Field Values

NOT_LIKE_Operator

public static final int NOT_LIKE_Operator
See Also:
Constant Field Values

NOT_LEFT_LIKE_Operator

public static final int NOT_LEFT_LIKE_Operator
See Also:
Constant Field Values

NOT_RIGHT_LIKE_Operator

public static final int NOT_RIGHT_LIKE_Operator
See Also:
Constant Field Values

EQ_Operator

public static final int EQ_Operator
See Also:
Constant Field Values

GT_Operator

public static final int GT_Operator
See Also:
Constant Field Values

GE_Operator

public static final int GE_Operator
See Also:
Constant Field Values

LT_Operator

public static final int LT_Operator
See Also:
Constant Field Values

LE_Operator

public static final int LE_Operator
See Also:
Constant Field Values

NE_Operator

public static final int NE_Operator
See Also:
Constant Field Values

IN_Operator

public static final int IN_Operator
See Also:
Constant Field Values

NOT_IN_Operator

public static final int NOT_IN_Operator
See Also:
Constant Field Values

NOT_GT_Operator

public static final int NOT_GT_Operator
See Also:
Constant Field Values

NOT_LT_Operator

public static final int NOT_LT_Operator
See Also:
Constant Field Values

GROUP_BY_Operator

public static final int GROUP_BY_Operator
See Also:
Constant Field Values

ORDER_BY_Operator

public static final int ORDER_BY_Operator
See Also:
Constant Field Values

COUNT_Operator

public static final int COUNT_Operator
See Also:
Constant Field Values

ASC_Operator

public static final int ASC_Operator
See Also:
Constant Field Values

DESC_Operator

public static final int DESC_Operator
See Also:
Constant Field Values

MIN_Operator

public static final int MIN_Operator
See Also:
Constant Field Values

MAX_Operator

public static final int MAX_Operator
See Also:
Constant Field Values

SUM_Operator

public static final int SUM_Operator
See Also:
Constant Field Values

AVG_Operator

public static final int AVG_Operator
See Also:
Constant Field Values

UPPER_Function

public static final int UPPER_Function
See Also:
Constant Field Values

GENERIC_QueryType

public static final int GENERIC_QueryType
See Also:
Constant Field Values

CATENTRY_SKU_QueryType

public static final int CATENTRY_SKU_QueryType
See Also:
Constant Field Values

ANY_QueryType

public static final int ANY_QueryType
See Also:
Constant Field Values

ITEM_QueryType

public static final int ITEM_QueryType
See Also:
Constant Field Values

BOTH_QueryType

public static final int BOTH_QueryType
See Also:
Constant Field Values

ITEM_CatEntryType

public static final int ITEM_CatEntryType
See Also:
Constant Field Values

BUNDLE_CatEntryType

public static final int BUNDLE_CatEntryType
See Also:
Constant Field Values

PACKAGE_CatEntryType

public static final int PACKAGE_CatEntryType
See Also:
Constant Field Values

PRODUCT_CatEntryType

public static final int PRODUCT_CatEntryType
See Also:
Constant Field Values

ALL_Item

public static final java.lang.String ALL_Item
See Also:
Constant Field Values
Constructor Detail

SelectQuery

public SelectQuery()
Default select query constructor.

SelectQuery

public SelectQuery(TradingAgreementAccessBean[] inAgreements)
Deprecated.  

SelectQuery

public SelectQuery(TradingAgreementAccessBean[] inAgreements,
                   java.lang.Long userId)
SelectQuery constructor with trading agreement access bean and user id as arguments.
Parameters:
inAgreements - The trading agreement access bean array - used in entitlement

SelectQuery

public SelectQuery(int inStoreID,
TradingAgreementAccessBean[] inAgreements)
Deprecated.  

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.
Parameters:
inAgreements - The trading agreement access bean array - used in entitlement

SelectQuery

public SelectQuery(int aStoreID,
                   int aUserID)
SelectQuery constructor with store and user id as arguments.

SelectQuery

public SelectQuery(java.util.Vector inStoreIDs,
TradingAgreementAccessBean[] inAgreements)
Deprecated.  

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.
Parameters:
inAgreements - The trading agreement access bean array - used in entitlement

SelectQuery

public SelectQuery(java.util.Vector inStoreIDs,
                   int aUserID)
SelectQuery constructor with a collection of store ids and an user id as arguments.
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.
java.lang.Exception

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.
java.lang.Exception

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.
java.lang.Exception

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.
java.lang.Exception

addFilterAttribute

public void addFilterAttribute(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)
java.lang.Exception

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.

addGlobalPredicate

public void addGlobalPredicate(Predicate p)
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.

addGroupByAttribute

public void addGroupByAttribute(int attribute)
                         throws java.lang.Exception
To set group by operator
java.lang.Exception

addOrderByAttribute

public void addOrderByAttribute(int attribute,
                                int operator)
                         throws java.lang.Exception
To set order by operator
java.lang.Exception

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.
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.
java.lang.Exception

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.
java.lang.Exception

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%'.
java.lang.Exception

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.
java.lang.Exception

addSelectAttribute

public void addSelectAttribute(java.lang.String attribute,
                               int operator,
                               java.lang.String value)
                        throws java.lang.Exception
Deprecated.  
java.lang.Exception

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.
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.
java.lang.Exception

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.
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
java.lang.Exception

addSelectAttribute

public void addSelectAttribute(java.lang.String attribute,
                               int operator,
                               java.lang.String value,
                               java.lang.String languageId,
                               java.lang.String prodType)
                        throws java.lang.Exception
Deprecated.  
java.lang.Exception

addSelectAttribute

public void addSelectAttribute(java.lang.String attribute,
                               int operator,
                               java.lang.String value,
                               java.lang.String languageId,
                               java.lang.String prodType,
                               int function)
                        throws java.lang.Exception
Deprecated.  
java.lang.Exception

addSelectOperand

public void addSelectOperand(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.
Parameters:
predicate - A collection of predicates.
java.lang.Exception

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.

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.
Returns:
A collection of catentry ids.
java.lang.Exception

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.
Parameters:
maxResults - The number of results to be retrieved.
Returns:
A collection of catentry ids.
java.lang.Exception

execute

public java.util.Vector execute(int maxResults,
                                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.
Parameters:
maxResults - The number of results to be retrieved.
aCursor - The cusrsor object.
Returns:
A collection of catentry ids.
java.lang.Exception

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.
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 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.
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.
java.lang.Exception

getLongUserId

public java.lang.Long getLongUserId()
Do not modify. Method generated by VAJ.
Returns:
The user id of type Long.

getPredicate

public Predicate getPredicate()
                       throws java.lang.Exception
Do not modify. Method generated by VAJ.
Returns:
The selectSet and filterSet predicate.
java.lang.Exception

getRules

public java.util.Vector getRules()
Do not modify. Method generated by VAJ.
Returns:
The query collection.

getStoreID

public java.lang.Integer getStoreID()
Do not modify. Method generated by VAJ.
Returns:
The store id.

getStoreIDs

public java.util.Vector getStoreIDs()
Do not modify. Method generated by VAJ.
Returns:
The collection of store ids.

getUserID

public java.lang.Integer getUserID()
Do not modify. Method generated by VAJ.
Returns:
The user id.

reset

public void reset()
Re-initialize filterSet and selectSet variables

setDistinct

public void setDistinct()
To set disctict operator

setDistinct

public void setDistinct(boolean distinctFlag)
To set disctict operator

setLongUserId

public void setLongUserId(java.lang.Long newLongUserId)
Do not modify. Method generated by VAJ.
Parameters:
newLongUserId - java.lang.Long

setRules

public void setRules(java.util.Vector newRules)
Do not modify. Method generated by VAJ.
Parameters:
newRules - java.util.Vector

setStoreID

public void setStoreID(int newStoreID)
Do not modify. Method generated by VAJ.
Parameters:
newStoreID - int

setStoreIDs

public void setStoreIDs(java.util.Vector newStoreIDs)
Do not modify. Method generated by VAJ.
Parameters:
newStoreIDs - java.util.Vector

setUserID

public void setUserID(int newUserID)
Do not modify. Method generated by VAJ.