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.
- Retrieves all non duplicate catentry ids for the set of queries,
- Retrieves a fixed number of non-duplicate catentry ids as returned by the database for the set of queries,
- Retrieves a fixed number of non-duplicate catentry ids picked in random for the set of queries.
SelectQuery internally depends on RuleQuery for most of its functions.

Field Summary

Fields
Modifier and Type	Field and Description
`static java.lang.String`	`ALL_Item` References the constant string value representing the ALL_Item.
`static int`	`AND_Operator` References the constant integer value representing the AND Operator.
`static int`	`ANY_QueryType` References the constant integer value representing the ANY QueryType.
`static int`	`ASC_Operator` References the constant integer value representing the ASC Operator.
`static int`	`ATTRIBUTE_ATTRIBUTE_ID_Attr` References the value used for the ATTRIBUTE_ID column of the ATTRIBUTE database table.
`static int`	`ATTRIBUTE_CATENTRY_ID_Attr` References the value used for the CATENTRY_ID column of the ATTRIBUTE database table.
`static int`	`ATTRIBUTE_LANGUAGE_ID_Attr` References the value used for the LANGUAGE_ID column of the ATTRIBUTE database table.
`static int`	`ATTRIBUTE_NAME_Attr` References the value used for the NAME column of the ATTRIBUTE database table.
`static int`	`ATTRVALUE_ATTRIBUTE_ID_Attr` References the value used for the ATTRIBUTE_ID column of the ATTRVALUE database table.
`static int`	`ATTRVALUE_CATENTRY_ID_Attr` References the value used for the CATENTRY_ID column of the ATTRVALUE database table.
`static int`	`ATTRVALUE_FLOATVALUE_Attr` References the value used for the FLOATVALUE column of the ATTRVALUE database table.
`static int`	`ATTRVALUE_INTEGERVALUE_Attr` References the value used for the INTEGERVALUE column of the ATTRVALUE database table.
`static int`	`ATTRVALUE_LANGUAGE_ID_Attr` References the value used for the LANGUAGE_ID column of the ATTRVALUE database table.
`static int`	`ATTRVALUE_NAME_Attr` References the value used for the NAME column of the ATTRVALUE database table.
`static int`	`ATTRVALUE_STRINGVALUE_Attr` References the value used for the STRINGVALUE column of the ATTRVALUE database table.
`static int`	`AVG_Operator` References the constant integer value representing the AVG Operator.
`static int`	`BOTH_QueryType` References the constant integer value representing the BOTH Query Type.
`static int`	`BUNDLE_CatEntryType` References the constant integer value representing the BUNDLE CatEntry Type.
`static int`	`CATALOG_CATALOG_ID_Attr` References the value used for the CATALOG_ID column of the CATALOG database table.
`static int`	`CATALOG_DESCRIPTION_Attr` References the value used for the DESCRIPTION column of the CATALOG database table.
`static int`	`CATALOG_IDENTIFIER_Attr` References the value used for the IDENTIFIER column of the CATALOG database table.
`static int`	`CATALOGDSC_LANGUAGE_ID_Attr` References the value used for the LANGUAGE_ID column of the CATALOGDSC database table.
`static int`	`CATALOGDSC_NAME_Attr` References the value used for the NAME column of the CATALOGDSC database table.
`static int`	`CATALOGDSC_SHORTDESCRIPTION_Attr` References the value used for the SHORTDESCRIPTION column of the CATALOGDSC database table.
`static int`	`CATENTDESC_AVAILABILITY_DATE_Attr` References the value used for the AVAILABILITY_DATE column of the CATENTDESC database table
`static int`	`CATENTDESC_AVAILABLE_Attr` References the value used for the AVAILABLE column of the CATENTDESC database table.
`static int`	`CATENTDESC_CATENTRY_ID_Attr` References the value used for the CATENTRY_ID column of the CATENTDESC database table
`static int`	`CATENTDESC_KEYWORD_Attr` References the value used for the KEYWORD column of the CATENTDESC database table.
`static int`	`CATENTDESC_LANGUAGE_ID_Attr` References the value used for the LANGUAGE_ID column of the CATENTDESC database table
`static int`	`CATENTDESC_LONGDESCRIPTION_Attr` References the value used for the LONGDESCRIPTION column of the CATENTDESC database table
`static int`	`CATENTDESC_NAME_Attr` References the value used for the NAME column of the CATENTDESC database table
`static int`	`CATENTDESC_PARTNUMBER_Attr` References the value used for the PARTNUMBER column of the CATENTDESC database table
`static int`	`CATENTDESC_PUBLISHED_Attr` References the value used for the PUBLISHED column of the CATENTDESC database table
`static int`	`CATENTDESC_SHORT_DESC_Attr` References the value used for the SHORT_DESC column of the CATENTDESC database table
`static int`	`CATENTDESC_SHORTDESCRIPTION_Attr` References the value used for the SHORTDESCRIPTION column of the Listprice CATENTDESC table
`static int`	`CATENTDESC_THUMBNAIL_Attr` References the value used for the THUMBNAIL column of the CATENTDESC database table
`static int`	`CATENTREL_CATENTRY_ID_CHILD_Attr` References the value used for the CATENTRY_ID_CHILD column of the CATENTREL database table.
`static int`	`CATENTREL_CATENTRY_ID_PARENT_Attr` References the value used for the CATENTRY_ID_PARENT column of the CATENTREL database table.
`static int`	`CATENTREL_CATREL_TYPE_ID_Attr` References the value used for the CATREL_TYPE_ID column of the CATENTREL database table.
`static int`	`CATENTRY_BUYABLE_Attr` References the value used for the BUYABLE column of the CATENTRY database table
`static int`	`CATENTRY_CATENTRY_ID_Attr` References the value used for the CATENTRY_ID column of the CATENTRY database table
`static int`	`CATENTRY_ID_Attr` References the value used for the CATENTRY_ID column of the CATENTRY database table
`static int`	`CATENTRY_LASTUPDATE_Attr` References the value used for the LASTUPDATE column of the CATENTRY database table
`static int`	`CATENTRY_MARKFORDELETE_Attr` References the value used for the MARKFORDELETE column of the CATENTRY database table
`static int`	`CATENTRY_MFNAME_Attr` References the value used for the MFNAME column of the CATENTRY database table
`static int`	`CATENTRY_MFPARTNUMBER_Attr` References the value used for the MFPARTNUMBER column of the CATENTRY database table
`static int`	`CATENTRY_ONAUCTION_Attr` References the value used for the ONAUCTION column of the CATENTRY database table
`static int`	`CATENTRY_ONSPECIAL_Attr` References the value used for the ONSPECIAL column of the CATENTRY database table
`static int`	`CATENTRY_PARTNUMBER_Attr` References the value used for the PARTNUMBER column of the CATENTRY database table
`static int`	`CATENTRY_SKU_Attr` References the value used for the SKU column of the CATENTRY database table
`static int`	`CATENTRY_SKU_QueryType` References the constant integer value representing the CATENTRY_SKU Query Type.
`static int`	`CATGPENREL_CATALOG_ID_Attr` References the value used for the CATALOG_ID column of the CATGPENREL database table.
`static int`	`CATGPENREL_CATENTRY_ID_Attr` References the value used for the CATENTRY_ID column of the CATGPENREL database table.
`static int`	`CATGPENREL_CATGROUP_ID_Attr` References the value used for the CATGROUP_ID column of the CATGPENREL database table.
`static int`	`CATGROUP_CATGROUP_ID_Attr` References the value used for the CATGROUP_ID column of the CATGROUP database table.
`static int`	`CATGROUP_IDENTIFIER_Attr` References the value used for the IDENTIFIER column of the CATGROUP database table.
`static int`	`CATGROUP_IDENTIFIER_ID_Attr` References the value used for the IDENTIFIER_ID column of the CATGROUP database table.
`static int`	`CATGROUP_LASTUPDATE_Attr` References the value used for the LASTUPDATE column of the CATGROUP database table.
`static int`	`CATGROUP_MARKFORDELETE_Attr` References the value used for the MARKFORDELETE column of the CATGROUP database table.
`static int`	`CATGRPDESC_KEYWORD_Attr` References the value used for the KEYWORD column of the CATGRPDESC database table
`static int`	`CATGRPDESC_LANGUAGE_ID_Attr` References the value used for the LANGUAGE_ID column of the CATGRPDESC database table
`static int`	`CATGRPDESC_LONGDESCRIPTION_Attr` References the value used for the LONGDESCRIPTION column of the CATGRPDESC database table
`static int`	`CATGRPDESC_NAME_Attr` References the value used for the NAME column of the CATGRPDESC database table
`static int`	`CATGRPDESC_PUBLISHED_Attr` References the value used for the PUBLISHED column of the CATGRPDESC database table
`static int`	`CATGRPDESC_SHORTDESCRIPTION_Attr` References the value used for the SHORTDESCRIPTION column of the CATGRPDESC database table
`static java.lang.String`	`COPYRIGHT`
`static int`	`COUNT_Operator` References the constant integer value representing the COUNT Operator.
`static int`	`DESC_Operator` References the constant integer value representing the DESC Operator.
`static int`	`EQ_Operator` References the constant integer value representing the EQ Operator.
`static int`	`GE_Operator` References the constant integer value representing the GE Operator.
`static int`	`GENERIC_QueryType` References the constant integer value representing the GENERIC Query Type.
`static int`	`GROUP_BY_Operator` References the constant integer value representing the GROUP_BY Operator.
`static int`	`GT_Operator` References the constant integer value representing the GT Operator.
`static int`	`IN_Operator` References the constant integer value representing the IN Operator.
`static int`	`INVSTVW_QUANTITY_AVAILABLE_Attr` References the value used for the QUANTITY_AVAILABLE column of the INVSTVW database table.
`static int`	`INVSTVW_QUANTITY_MEASURE_Attr` References the value used for the QUANTITY_MEASURE column of the INVSTVW database table.
`static int`	`INVSTVW_STORE_ID_Attr` References the value used for the STORE_ID column of the INVSTVW database table.
`static int`	`IS_NOT_NULL_Operator` References the constant integer value representing the IS_NOT_NULL Operator.
`static int`	`IS_NULL_Operator` References the constant integer value representing the IS_NULL Operator.
`static int`	`ITEM_CatEntryType` References the constant integer value representing the ITEM CatEntry Type.
`static int`	`ITEM_QueryType` References the constant integer value representing the ITEM Query Type.
`static int`	`LE_Operator` References the constant integer value representing the LE Operator.
`static int`	`LEFT_LIKE_Operator` References the constant integer value representing the LEFT_LIKE Operator.
`static int`	`LIKE_Operator` References the constant integer value representing the LIKE Operator.
`static int`	`LISTPRICE_Attr` References the value used for the LISTPRICE column of the Listprice database table
`static int`	`LISTPRICE_CATENTRY_ID_Attr` References the value used for the CATENTRY_ID column of the Listprice database table
`static int`	`LISTPRICE_CURRENCY_Attr` References the value used for the CURRENCY column of the Listprice database table
`static int`	`LISTPRICE_LISTPRICE_Attr` References the value used for the LISTPRICE column of the Listprice database table
`static int`	`LT_Operator` References the constant integer value representing the LT Operator.
`static int`	`MAX_Operator` References the constant integer value representing the MAX Operator.
`static int`	`MIN_Operator` References the constant integer value representing the MIN Operator.
`static int`	`NE_Operator` References the constant integer value representing the NE Operator.
`static int`	`NOT_GT_Operator` References the constant integer value representing the NOT_GT Operator.
`static int`	`NOT_IN_Operator` References the constant integer value representing the NOT_IN Operator.
`static int`	`NOT_LEFT_LIKE_Operator` References the constant integer value representing the NOT_LEFT_LIKE Operator.
`static int`	`NOT_LIKE_Operator` References the constant integer value representing the NOT_LIKE Operator.
`static int`	`NOT_LT_Operator` References the constant integer value representing the NOT_LT Operator.
`static int`	`NOT_RIGHT_LIKE_Operator` References the constant integer value representing the NOT_RIGHT_LIKE Operator.
`static int`	`OFFER_MAXIMUMQUANTITY_Attr` References the value used for the MAXIMUMQUANTITY column of the OFFER database table.
`static int`	`OFFER_MINIMUMQUANTITY_Attr` References the value used for the MINIMUMQUANTITY column of the OFFER database table.
`static int`	`OFFER_OFFER_ID_Attr` References the value used for the OFFER_ID column of the OFFER database table.
`static int`	`OFFER_TRADEPOSCN_ID_Attr` References the value used for the TRADEPOSCN_ID column of the OFFER database table.
`static int`	`OFFERPRICE_CURRENCY_Attr` References the value used for the CURRENCY column of the OFFERPRICE database table
`static int`	`OFFERPRICE_OFFER_ID_Attr` References the value used for the OFFER_ID column of the OFFERPRICE database table.
`static int`	`OFFERPRICE_PRICE_Attr` References the value used for the PRICE column of the OFFERPRICE database table.
`static int`	`OR_Operator` References the constant integer value representing the OR Operator.
`static int`	`ORDER_BY_Operator` References the constant integer value representing the ORDER_BY Operator.
`static int`	`PACKAGE_CatEntryType` References the constant integer value representing the PACKAGE CatEntry Type.
`static int`	`PRODUCT_CatEntryType` References the constant integer value representing the PRODUCT_CatEntry Type.
`static int`	`PRSETCEREL_CATENTRY_ID_Attr` References the value used for the CATENTRY_ID column of the PRSETCEREL database table.
`static int`	`PRSETCEREL_PRODUCTSET_ID_Attr` References the value used for the PRODUCTSET_ID column of the PRSETCEREL database table.
`static int`	`RIGHT_LIKE_Operator` References the constant integer value representing the RIGHT_LIKE Operator.
`static int`	`STDPRICEVW_CATENTRY_ID_Attr` References the value used for the CATENTRY_ID column of the STDPRICEVW database table.
`static int`	`STDPRICEVW_CURRENCY_Attr` References the value used for the CURRENCY column of the STDPRICEVW database table.
`static int`	`STDPRICEVW_PRICE_Attr` References the value used for the PRICE column of the STDPRICEVW database table.
`static int`	`STORECAT_MASTERCATALOG_Attr` References the value used for the MASTERCATALOG column of the STORECAT database table.
`static int`	`STORECAT_STOREENT_ID_Attr` References the value used for the STOREENT_ID column of the STORECAT database table.
`static int`	`STORECATENTRY_STORE_ID_Attr` References the value used for the STORE_ID column of the STORECATENTRY database table.
`static int`	`STORECGRP_STOREENT_ID_Attr` References the value used for the STOREENT_ID column of the STORECGRP database table.
`static int`	`STOREINVENTORY_QUANTITY_Attr` References the value used for the QUANTITY column of the STOREINVENTORY database table
`static int`	`STOREINVENTORY_QUANTITY_MEASURE_Attr` References the value used for the QUANTITY_MEASURE column of the STOREINVENTORY database table
`static int`	`SUM_Operator` References the constant integer value representing the SUM Operator.
`static int`	`TRADEPOSCN_TRADEPOSCN_ID_Attr` References the value used for the TRADEPOSCN_ID column of the TRADEPOSCN database table.
`static int`	`TRADEPOSCN_TYPE_ID_Attr` References the value used for the TYPE_ID column of the TRADEPOSCN database table.
`static int`	`UPPER_Function` References the constant integer value representing the UPPER Function.
`static int`	`USER_ID_Attr` References the value used for the USER_ID.

Constructor Summary

Constructors
Constructor and Description
`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. Replaced by `SelectQuery(int inStoreID, TradingAgreementAccessBean[] inAgreements, Long userId)`.
`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.base.Query q)` SelectQuery constructor with query as an argument.
`SelectQuery(TradingAgreementAccessBean[] inAgreements)` Deprecated. Replaced by `SelectQuery(TradingAgreementAccessBean[] inAgreements, Long userId)`.
`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 a user id as arguments.
`SelectQuery(java.util.Vector inStoreIDs, TradingAgreementAccessBean[] inAgreements)` Deprecated. Replaced by `SelectQuery(Vector inStoreIDs, TradingAgreementAccessBean[] inAgreements, Long userId)`.
`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

All Methods Instance Methods Concrete Methods Deprecated Methods
Modifier and Type	Method and Description
`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.base.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(com.ibm.commerce.search.base.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 The attribute parameter values are obtained from the corresponding constants defined within this class.
`void`	`addOrderByAttribute(int attribute, int operator)` To set order by operator The attribute and operator parameter values are obtained from the corresponding constants defined within this class.
`void`	`addRule()` Adds a 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. Replaced by `addSelectAttribute(int attribute, int operator, String 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`	`addSelectAttribute(java.lang.String attribute, int operator, java.lang.String value, java.lang.String languageId, java.lang.String prodType)` Deprecated. Replaced by `addSelectAttribute(String attribute, int operator, String value, int attrValueType, String languageId, String prodType, int function)`.
`void`	`addSelectAttribute(java.lang.String attribute, int operator, java.lang.String value, java.lang.String languageId, java.lang.String prodType, int function)` Deprecated. Replaced by `addSelectAttribute(String attribute, int operator, String value, int attrValueType, String languageId, String prodType, int function)`.
`void`	`addSelectOperand(com.ibm.commerce.search.base.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 certain 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 certain number (specified in numProductRequested) of non duplicate `catentry` ids that satisfy these query.
`java.util.Vector`	`execute(int maxResults, com.ibm.commerce.base.objects.Cursor aCursor)` Executes a set of catalog search query and retrieves certain number (specified in `maxResults`) of non duplicate `catentry` ids that satisfy these query.
`java.lang.Long`	`getLongUserId()` Returns the user id.
`com.ibm.commerce.search.base.Predicate`	`getPredicate()` Returns the selectSet and filterSet predicate.
`java.util.Vector`	`getRules()` Returns the query collection.
`java.lang.Integer`	`getStoreID()` Returns the store id.
`java.util.Vector`	`getStoreIDs()` Returns the collection of store ids.
`java.lang.Integer`	`getUserID()` Returns the user id.
`void`	`reset()` Re-initialize filterSet and selectSet variables
`void`	`setDistinct()` To set distinct operator
`void`	`setDistinct(boolean distinctFlag)` To set distinct operator.
`void`	`setLongUserId(java.lang.Long newLongUserId)` To set the user id.
`void`	`setRules(java.util.Vector newRules)` To set the query collection.
`void`	`setStoreID(int newStoreID)` To set the store id.
`void`	`setStoreIDs(java.util.Vector newStoreIDs)` To set the collection of store ids.
`void`	`setUserID(int newUserID)` To set the user id.

Methods inherited from class java.lang.Object
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

- Field Detail
  - COPYRIGHT
```
public static final java.lang.String COPYRIGHT
```
    See Also:
    
    Constant Field Values
  - LISTPRICE_LISTPRICE_Attr
```
public static final int LISTPRICE_LISTPRICE_Attr
```
    References the value used for the LISTPRICE column of the Listprice database table
    
    See Also:
    
    Constant Field Values
  - LISTPRICE_Attr
```
public static final int LISTPRICE_Attr
```
    References the value used for the LISTPRICE column of the Listprice database table
    
    See Also:
    
    Constant Field Values
  - LISTPRICE_CURRENCY_Attr
```
public static final int LISTPRICE_CURRENCY_Attr
```
    References the value used for the CURRENCY column of the Listprice database table
    
    See Also:
    
    Constant Field Values
  - LISTPRICE_CATENTRY_ID_Attr
```
public static final int LISTPRICE_CATENTRY_ID_Attr
```
    References the value used for the CATENTRY_ID column of the Listprice database table
    
    See Also:
    
    Constant Field Values
  - STOREINVENTORY_QUANTITY_Attr
```
public static final int STOREINVENTORY_QUANTITY_Attr
```
    References the value used for the QUANTITY column of the STOREINVENTORY database table
    
    See Also:
    
    Constant Field Values
  - STOREINVENTORY_QUANTITY_MEASURE_Attr
```
public static final int STOREINVENTORY_QUANTITY_MEASURE_Attr
```
    References the value used for the QUANTITY_MEASURE column of the STOREINVENTORY database table
    
    See Also:
    
    Constant Field Values
  - CATGRPDESC_NAME_Attr
```
public static final int CATGRPDESC_NAME_Attr
```
    References the value used for the NAME column of the CATGRPDESC database table
    
    See Also:
    
    Constant Field Values
  - CATGRPDESC_LANGUAGE_ID_Attr
```
public static final int CATGRPDESC_LANGUAGE_ID_Attr
```
    References the value used for the LANGUAGE_ID column of the CATGRPDESC database table
    
    See Also:
    
    Constant Field Values
  - CATGRPDESC_LONGDESCRIPTION_Attr
```
public static final int CATGRPDESC_LONGDESCRIPTION_Attr
```
    References the value used for the LONGDESCRIPTION column of the CATGRPDESC database table
    
    See Also:
    
    Constant Field Values
  - CATGRPDESC_SHORTDESCRIPTION_Attr
```
public static final int CATGRPDESC_SHORTDESCRIPTION_Attr
```
    References the value used for the SHORTDESCRIPTION column of the CATGRPDESC database table
    
    See Also:
    
    Constant Field Values
  - CATGRPDESC_KEYWORD_Attr
```
public static final int CATGRPDESC_KEYWORD_Attr
```
    References the value used for the KEYWORD column of the CATGRPDESC database table
    
    See Also:
    
    Constant Field Values
  - CATGRPDESC_PUBLISHED_Attr
```
public static final int CATGRPDESC_PUBLISHED_Attr
```
    References the value used for the PUBLISHED column of the CATGRPDESC database table
    
    See Also:
    
    Constant Field Values
  - CATENTRY_SKU_Attr
```
public static final int CATENTRY_SKU_Attr
```
    References the value used for the SKU column of the CATENTRY database table
    
    See Also:
    
    Constant Field Values
  - CATENTRY_CATENTRY_ID_Attr
```
public static final int CATENTRY_CATENTRY_ID_Attr
```
    References the value used for the CATENTRY_ID column of the CATENTRY database table
    
    See Also:
    
    Constant Field Values
  - CATENTRY_ID_Attr
```
public static final int CATENTRY_ID_Attr
```
    References the value used for the CATENTRY_ID column of the CATENTRY database table
    
    See Also:
    
    Constant Field Values
  - CATENTRY_BUYABLE_Attr
```
public static final int CATENTRY_BUYABLE_Attr
```
    References the value used for the BUYABLE column of the CATENTRY database table
    
    See Also:
    
    Constant Field Values
  - CATENTRY_ONAUCTION_Attr
```
public static final int CATENTRY_ONAUCTION_Attr
```
    References the value used for the ONAUCTION column of the CATENTRY database table
    
    See Also:
    
    Constant Field Values
  - CATENTRY_ONSPECIAL_Attr
```
public static final int CATENTRY_ONSPECIAL_Attr
```
    References the value used for the ONSPECIAL column of the CATENTRY database table
    
    See Also:
    
    Constant Field Values
  - CATENTRY_PARTNUMBER_Attr
```
public static final int CATENTRY_PARTNUMBER_Attr
```
    References the value used for the PARTNUMBER column of the CATENTRY database table
    
    See Also:
    
    Constant Field Values
  - CATENTRY_MFNAME_Attr
```
public static final int CATENTRY_MFNAME_Attr
```
    References the value used for the MFNAME column of the CATENTRY database table
    
    See Also:
    
    Constant Field Values
  - CATENTRY_MFPARTNUMBER_Attr
```
public static final int CATENTRY_MFPARTNUMBER_Attr
```
    References the value used for the MFPARTNUMBER column of the CATENTRY database table
    
    See Also:
    
    Constant Field Values
  - CATENTRY_MARKFORDELETE_Attr
```
public static final int CATENTRY_MARKFORDELETE_Attr
```
    References the value used for the MARKFORDELETE column of the CATENTRY database table
    
    See Also:
    
    Constant Field Values
  - CATENTRY_LASTUPDATE_Attr
```
public static final int CATENTRY_LASTUPDATE_Attr
```
    References the value used for the LASTUPDATE column of the CATENTRY database table
    
    See Also:
    
    Constant Field Values
  - CATENTDESC_NAME_Attr
```
public static final int CATENTDESC_NAME_Attr
```
    References the value used for the NAME column of the CATENTDESC database table
    
    See Also:
    
    Constant Field Values
  - CATENTDESC_AVAILABILITY_DATE_Attr
```
public static final int CATENTDESC_AVAILABILITY_DATE_Attr
```
    References the value used for the AVAILABILITY_DATE column of the CATENTDESC database table
    
    See Also:
    
    Constant Field Values
  - CATENTDESC_LANGUAGE_ID_Attr
```
public static final int CATENTDESC_LANGUAGE_ID_Attr
```
    References the value used for the LANGUAGE_ID column of the CATENTDESC database table
    
    See Also:
    
    Constant Field Values
  - CATENTDESC_PUBLISHED_Attr
```
public static final int CATENTDESC_PUBLISHED_Attr
```
    References the value used for the PUBLISHED column of the CATENTDESC database table
    
    See Also:
    
    Constant Field Values
  - CATENTDESC_SHORT_DESC_Attr
```
public static final int CATENTDESC_SHORT_DESC_Attr
```
    References the value used for the SHORT_DESC column of the CATENTDESC database table
    
    See Also:
    
    Constant Field Values
  - CATENTDESC_CATENTRY_ID_Attr
```
public static final int CATENTDESC_CATENTRY_ID_Attr
```
    References the value used for the CATENTRY_ID column of the CATENTDESC database table
    
    See Also:
    
    Constant Field Values
  - CATENTDESC_THUMBNAIL_Attr
```
public static final int CATENTDESC_THUMBNAIL_Attr
```
    References the value used for the THUMBNAIL column of the CATENTDESC database table
    
    See Also:
    
    Constant Field Values
  - CATENTDESC_LONGDESCRIPTION_Attr
```
public static final int CATENTDESC_LONGDESCRIPTION_Attr
```
    References the value used for the LONGDESCRIPTION column of the CATENTDESC database table
    
    See Also:
    
    Constant Field Values
  - CATENTDESC_SHORTDESCRIPTION_Attr
```
public static final int CATENTDESC_SHORTDESCRIPTION_Attr
```
    References the value used for the SHORTDESCRIPTION column of the Listprice CATENTDESC table
    
    See Also:
    
    Constant Field Values
  - CATENTDESC_PARTNUMBER_Attr
```
public static final int CATENTDESC_PARTNUMBER_Attr
```
    References the value used for the PARTNUMBER column of the CATENTDESC database table
    
    See Also:
    
    Constant Field Values
  - CATENTDESC_KEYWORD_Attr
```
public static final int CATENTDESC_KEYWORD_Attr
```
    References the value used for the KEYWORD column of the CATENTDESC database table.
    
    See Also:
    
    Constant Field Values
  - CATENTDESC_AVAILABLE_Attr
```
public static final int CATENTDESC_AVAILABLE_Attr
```
    References the value used for the AVAILABLE column of the CATENTDESC database table.
    
    See Also:
    
    Constant Field Values
  - STORECATENTRY_STORE_ID_Attr
```
public static final int STORECATENTRY_STORE_ID_Attr
```
    References the value used for the STORE_ID column of the STORECATENTRY database table.
    
    See Also:
    
    Constant Field Values
  - USER_ID_Attr
```
public static final int USER_ID_Attr
```
    References the value used for the USER_ID.
    
    See Also:
    
    Constant Field Values
  - CATENTREL_CATENTRY_ID_CHILD_Attr
```
public static final int CATENTREL_CATENTRY_ID_CHILD_Attr
```
    References the value used for the CATENTRY_ID_CHILD column of the CATENTREL database table.
    
    See Also:
    
    Constant Field Values
  - CATENTREL_CATENTRY_ID_PARENT_Attr
```
public static final int CATENTREL_CATENTRY_ID_PARENT_Attr
```
    References the value used for the CATENTRY_ID_PARENT column of the CATENTREL database table.
    
    See Also:
    
    Constant Field Values
  - CATENTREL_CATREL_TYPE_ID_Attr
```
public static final int CATENTREL_CATREL_TYPE_ID_Attr
```
    References the value used for the CATREL_TYPE_ID column of the CATENTREL database table.
    
    See Also:
    
    Constant Field Values
  - ATTRIBUTE_NAME_Attr
```
public static final int ATTRIBUTE_NAME_Attr
```
    References the value used for the NAME column of the ATTRIBUTE database table.
    
    See Also:
    
    Constant Field Values
  - ATTRIBUTE_LANGUAGE_ID_Attr
```
public static final int ATTRIBUTE_LANGUAGE_ID_Attr
```
    References the value used for the LANGUAGE_ID column of the ATTRIBUTE database table.
    
    See Also:
    
    Constant Field Values
  - ATTRIBUTE_CATENTRY_ID_Attr
```
public static final int ATTRIBUTE_CATENTRY_ID_Attr
```
    References the value used for the CATENTRY_ID column of the ATTRIBUTE database table.
    
    See Also:
    
    Constant Field Values
  - ATTRIBUTE_ATTRIBUTE_ID_Attr
```
public static final int ATTRIBUTE_ATTRIBUTE_ID_Attr
```
    References the value used for the ATTRIBUTE_ID column of the ATTRIBUTE database table.
    
    See Also:
    
    Constant Field Values
  - ATTRVALUE_LANGUAGE_ID_Attr
```
public static final int ATTRVALUE_LANGUAGE_ID_Attr
```
    References the value used for the LANGUAGE_ID column of the ATTRVALUE database table.
    
    See Also:
    
    Constant Field Values
  - ATTRVALUE_NAME_Attr
```
public static final int ATTRVALUE_NAME_Attr
```
    References the value used for the NAME column of the ATTRVALUE database table.
    
    See Also:
    
    Constant Field Values
  - ATTRVALUE_CATENTRY_ID_Attr
```
public static final int ATTRVALUE_CATENTRY_ID_Attr
```
    References the value used for the CATENTRY_ID column of the ATTRVALUE database table.
    
    See Also:
    
    Constant Field Values
  - ATTRVALUE_STRINGVALUE_Attr
```
public static final int ATTRVALUE_STRINGVALUE_Attr
```
    References the value used for the STRINGVALUE column of the ATTRVALUE database table.
    
    See Also:
    
    Constant Field Values
  - ATTRVALUE_ATTRIBUTE_ID_Attr
```
public static final int ATTRVALUE_ATTRIBUTE_ID_Attr
```
    References the value used for the ATTRIBUTE_ID column of the ATTRVALUE database table.
    
    See Also:
    
    Constant Field Values
  - ATTRVALUE_FLOATVALUE_Attr
```
public static final int ATTRVALUE_FLOATVALUE_Attr
```
    References the value used for the FLOATVALUE column of the ATTRVALUE database table.
    
    See Also:
    
    Constant Field Values
  - ATTRVALUE_INTEGERVALUE_Attr
```
public static final int ATTRVALUE_INTEGERVALUE_Attr
```
    References the value used for the INTEGERVALUE column of the ATTRVALUE database table.
    
    See Also:
    
    Constant Field Values
  - CATGPENREL_CATGROUP_ID_Attr
```
public static final int CATGPENREL_CATGROUP_ID_Attr
```
    References the value used for the CATGROUP_ID column of the CATGPENREL database table.
    
    See Also:
    
    Constant Field Values
  - CATGPENREL_CATENTRY_ID_Attr
```
public static final int CATGPENREL_CATENTRY_ID_Attr
```
    References the value used for the CATENTRY_ID column of the CATGPENREL database table.
    
    See Also:
    
    Constant Field Values
  - CATGPENREL_CATALOG_ID_Attr
```
public static final int CATGPENREL_CATALOG_ID_Attr
```
    References the value used for the CATALOG_ID column of the CATGPENREL database table.
    
    See Also:
    
    Constant Field Values
  - CATGROUP_CATGROUP_ID_Attr
```
public static final int CATGROUP_CATGROUP_ID_Attr
```
    References the value used for the CATGROUP_ID column of the CATGROUP database table.
    
    See Also:
    
    Constant Field Values
  - CATGROUP_MARKFORDELETE_Attr
```
public static final int CATGROUP_MARKFORDELETE_Attr
```
    References the value used for the MARKFORDELETE column of the CATGROUP database table.
    
    See Also:
    
    Constant Field Values
  - CATGROUP_LASTUPDATE_Attr
```
public static final int CATGROUP_LASTUPDATE_Attr
```
    References the value used for the LASTUPDATE column of the CATGROUP database table.
    
    See Also:
    
    Constant Field Values
  - CATGROUP_IDENTIFIER_ID_Attr
```
public static final int CATGROUP_IDENTIFIER_ID_Attr
```
    References the value used for the IDENTIFIER_ID column of the CATGROUP database table.
    
    See Also:
    
    Constant Field Values
  - CATGROUP_IDENTIFIER_Attr
```
public static final int CATGROUP_IDENTIFIER_Attr
```
    References the value used for the IDENTIFIER column of the CATGROUP database table.
    
    See Also:
    
    Constant Field Values
  - PRSETCEREL_PRODUCTSET_ID_Attr
```
public static final int PRSETCEREL_PRODUCTSET_ID_Attr
```
    References the value used for the PRODUCTSET_ID column of the PRSETCEREL database table.
    
    See Also:
    
    Constant Field Values
  - PRSETCEREL_CATENTRY_ID_Attr
```
public static final int PRSETCEREL_CATENTRY_ID_Attr
```
    References the value used for the CATENTRY_ID column of the PRSETCEREL database table.
    
    See Also:
    
    Constant Field Values
  - OFFERPRICE_PRICE_Attr
```
public static final int OFFERPRICE_PRICE_Attr
```
    References the value used for the PRICE column of the OFFERPRICE database table.
    
    See Also:
    
    Constant Field Values
  - OFFERPRICE_OFFER_ID_Attr
```
public static final int OFFERPRICE_OFFER_ID_Attr
```
    References the value used for the OFFER_ID column of the OFFERPRICE database table.
    
    See Also:
    
    Constant Field Values
  - OFFERPRICE_CURRENCY_Attr
```
public static final int OFFERPRICE_CURRENCY_Attr
```
    References the value used for the CURRENCY column of the OFFERPRICE database table
    
    See Also:
    
    Constant Field Values
  - OFFER_TRADEPOSCN_ID_Attr
```
public static final int OFFER_TRADEPOSCN_ID_Attr
```
    References the value used for the TRADEPOSCN_ID column of the OFFER database table.
    
    See Also:
    
    Constant Field Values
  - OFFER_OFFER_ID_Attr
```
public static final int OFFER_OFFER_ID_Attr
```
    References the value used for the OFFER_ID column of the OFFER database table.
    
    See Also:
    
    Constant Field Values
  - OFFER_MAXIMUMQUANTITY_Attr
```
public static final int OFFER_MAXIMUMQUANTITY_Attr
```
    References the value used for the MAXIMUMQUANTITY column of the OFFER database table.
    
    See Also:
    
    Constant Field Values
  - OFFER_MINIMUMQUANTITY_Attr
```
public static final int OFFER_MINIMUMQUANTITY_Attr
```
    References the value used for the MINIMUMQUANTITY column of the OFFER database table.
    
    See Also:
    
    Constant Field Values
  - TRADEPOSCN_TRADEPOSCN_ID_Attr
```
public static final int TRADEPOSCN_TRADEPOSCN_ID_Attr
```
    References the value used for the TRADEPOSCN_ID column of the TRADEPOSCN database table.
    
    See Also:
    
    Constant Field Values
  - TRADEPOSCN_TYPE_ID_Attr
```
public static final int TRADEPOSCN_TYPE_ID_Attr
```
    References the value used for the TYPE_ID column of the TRADEPOSCN database table.
    
    See Also:
    
    Constant Field Values
  - INVSTVW_QUANTITY_AVAILABLE_Attr
```
public static final int INVSTVW_QUANTITY_AVAILABLE_Attr
```
    References the value used for the QUANTITY_AVAILABLE column of the INVSTVW database table.
    
    See Also:
    
    Constant Field Values
  - INVSTVW_QUANTITY_MEASURE_Attr
```
public static final int INVSTVW_QUANTITY_MEASURE_Attr
```
    References the value used for the QUANTITY_MEASURE column of the INVSTVW database table.
    
    See Also:
    
    Constant Field Values
  - INVSTVW_STORE_ID_Attr
```
public static final int INVSTVW_STORE_ID_Attr
```
    References the value used for the STORE_ID column of the INVSTVW database table.
    
    See Also:
    
    Constant Field Values
  - STDPRICEVW_PRICE_Attr
```
public static final int STDPRICEVW_PRICE_Attr
```
    References the value used for the PRICE column of the STDPRICEVW database table.
    
    See Also:
    
    Constant Field Values
  - STDPRICEVW_CATENTRY_ID_Attr
```
public static final int STDPRICEVW_CATENTRY_ID_Attr
```
    References the value used for the CATENTRY_ID column of the STDPRICEVW database table.
    
    See Also:
    
    Constant Field Values
  - STDPRICEVW_CURRENCY_Attr
```
public static final int STDPRICEVW_CURRENCY_Attr
```
    References the value used for the CURRENCY column of the STDPRICEVW database table.
    
    See Also:
    
    Constant Field Values
  - CATALOG_CATALOG_ID_Attr
```
public static final int CATALOG_CATALOG_ID_Attr
```
    References the value used for the CATALOG_ID column of the CATALOG database table.
    
    See Also:
    
    Constant Field Values
  - CATALOG_DESCRIPTION_Attr
```
public static final int CATALOG_DESCRIPTION_Attr
```
    References the value used for the DESCRIPTION column of the CATALOG database table.
    
    See Also:
    
    Constant Field Values
  - CATALOG_IDENTIFIER_Attr
```
public static final int CATALOG_IDENTIFIER_Attr
```
    References the value used for the IDENTIFIER column of the CATALOG database table.
    
    See Also:
    
    Constant Field Values
  - CATALOGDSC_NAME_Attr
```
public static final int CATALOGDSC_NAME_Attr
```
    References the value used for the NAME column of the CATALOGDSC database table.
    
    See Also:
    
    Constant Field Values
  - CATALOGDSC_SHORTDESCRIPTION_Attr
```
public static final int CATALOGDSC_SHORTDESCRIPTION_Attr
```
    References the value used for the SHORTDESCRIPTION column of the CATALOGDSC database table.
    
    See Also:
    
    Constant Field Values
  - CATALOGDSC_LANGUAGE_ID_Attr
```
public static final int CATALOGDSC_LANGUAGE_ID_Attr
```
    References the value used for the LANGUAGE_ID column of the CATALOGDSC database table.
    
    See Also:
    
    Constant Field Values
  - STORECAT_MASTERCATALOG_Attr
```
public static final int STORECAT_MASTERCATALOG_Attr
```
    References the value used for the MASTERCATALOG column of the STORECAT database table.
    
    See Also:
    
    Constant Field Values
  - STORECAT_STOREENT_ID_Attr
```
public static final int STORECAT_STOREENT_ID_Attr
```
    References the value used for the STOREENT_ID column of the STORECAT database table.
    
    See Also:
    
    Constant Field Values
  - STORECGRP_STOREENT_ID_Attr
```
public static final int STORECGRP_STOREENT_ID_Attr
```
    References the value used for the STOREENT_ID column of the STORECGRP database table.
    
    See Also:
    
    Constant Field Values
  - OR_Operator
```
public static final int OR_Operator
```
    References the constant integer value representing the OR Operator.
    
    See Also:
    
    Constant Field Values
  - AND_Operator
```
public static final int AND_Operator
```
    References the constant integer value representing the AND Operator.
    
    See Also:
    
    Constant Field Values
  - IS_NULL_Operator
```
public static final int IS_NULL_Operator
```
    References the constant integer value representing the IS_NULL Operator.
    
    See Also:
    
    Constant Field Values
  - IS_NOT_NULL_Operator
```
public static final int IS_NOT_NULL_Operator
```
    References the constant integer value representing the IS_NOT_NULL Operator.
    
    See Also:
    
    Constant Field Values
  - LIKE_Operator
```
public static final int LIKE_Operator
```
    References the constant integer value representing the LIKE Operator.
    
    See Also:
    
    Constant Field Values
  - LEFT_LIKE_Operator
```
public static final int LEFT_LIKE_Operator
```
    References the constant integer value representing the LEFT_LIKE Operator.
    
    See Also:
    
    Constant Field Values
  - RIGHT_LIKE_Operator
```
public static final int RIGHT_LIKE_Operator
```
    References the constant integer value representing the RIGHT_LIKE Operator.
    
    See Also:
    
    Constant Field Values
  - NOT_LIKE_Operator
```
public static final int NOT_LIKE_Operator
```
    References the constant integer value representing the NOT_LIKE Operator.
    
    See Also:
    
    Constant Field Values
  - NOT_LEFT_LIKE_Operator
```
public static final int NOT_LEFT_LIKE_Operator
```
    References the constant integer value representing the NOT_LEFT_LIKE Operator.
    
    See Also:
    
    Constant Field Values
  - NOT_RIGHT_LIKE_Operator
```
public static final int NOT_RIGHT_LIKE_Operator
```
    References the constant integer value representing the NOT_RIGHT_LIKE Operator.
    
    See Also:
    
    Constant Field Values
  - EQ_Operator
```
public static final int EQ_Operator
```
    References the constant integer value representing the EQ Operator.
    
    See Also:
    
    Constant Field Values
  - GT_Operator
```
public static final int GT_Operator
```
    References the constant integer value representing the GT Operator.
    
    See Also:
    
    Constant Field Values
  - GE_Operator
```
public static final int GE_Operator
```
    References the constant integer value representing the GE Operator.
    
    See Also:
    
    Constant Field Values
  - LT_Operator
```
public static final int LT_Operator
```
    References the constant integer value representing the LT Operator.
    
    See Also:
    
    Constant Field Values
  - LE_Operator
```
public static final int LE_Operator
```
    References the constant integer value representing the LE Operator.
    
    See Also:
    
    Constant Field Values
  - NE_Operator
```
public static final int NE_Operator
```
    References the constant integer value representing the NE Operator.
    
    See Also:
    
    Constant Field Values
  - IN_Operator
```
public static final int IN_Operator
```
    References the constant integer value representing the IN Operator.
    
    See Also:
    
    Constant Field Values
  - NOT_IN_Operator
```
public static final int NOT_IN_Operator
```
    References the constant integer value representing the NOT_IN Operator.
    
    See Also:
    
    Constant Field Values
  - NOT_GT_Operator
```
public static final int NOT_GT_Operator
```
    References the constant integer value representing the NOT_GT Operator.
    
    See Also:
    
    Constant Field Values
  - NOT_LT_Operator
```
public static final int NOT_LT_Operator
```
    References the constant integer value representing the NOT_LT Operator.
    
    See Also:
    
    Constant Field Values
  - GROUP_BY_Operator
```
public static final int GROUP_BY_Operator
```
    References the constant integer value representing the GROUP_BY Operator.
    
    See Also:
    
    Constant Field Values
  - ORDER_BY_Operator
```
public static final int ORDER_BY_Operator
```
    References the constant integer value representing the ORDER_BY Operator.
    
    See Also:
    
    Constant Field Values
  - COUNT_Operator
```
public static final int COUNT_Operator
```
    References the constant integer value representing the COUNT Operator.
    
    See Also:
    
    Constant Field Values
  - ASC_Operator
```
public static final int ASC_Operator
```
    References the constant integer value representing the ASC Operator.
    
    See Also:
    
    Constant Field Values
  - DESC_Operator
```
public static final int DESC_Operator
```
    References the constant integer value representing the DESC Operator.
    
    See Also:
    
    Constant Field Values
  - MIN_Operator
```
public static final int MIN_Operator
```
    References the constant integer value representing the MIN Operator.
    
    See Also:
    
    Constant Field Values
  - MAX_Operator
```
public static final int MAX_Operator
```
    References the constant integer value representing the MAX Operator.
    
    See Also:
    
    Constant Field Values
  - SUM_Operator
```
public static final int SUM_Operator
```
    References the constant integer value representing the SUM Operator.
    
    See Also:
    
    Constant Field Values
  - AVG_Operator
```
public static final int AVG_Operator
```
    References the constant integer value representing the AVG Operator.
    
    See Also:
    
    Constant Field Values
  - UPPER_Function
```
public static final int UPPER_Function
```
    References the constant integer value representing the UPPER Function.
    
    See Also:
    
    Constant Field Values
  - GENERIC_QueryType
```
public static final int GENERIC_QueryType
```
    References the constant integer value representing the GENERIC Query Type.
    
    See Also:
    
    Constant Field Values
  - CATENTRY_SKU_QueryType
```
public static final int CATENTRY_SKU_QueryType
```
    References the constant integer value representing the CATENTRY_SKU Query Type.
    
    See Also:
    
    Constant Field Values
  - ANY_QueryType
```
public static final int ANY_QueryType
```
    References the constant integer value representing the ANY QueryType.
    
    See Also:
    
    Constant Field Values
  - ITEM_QueryType
```
public static final int ITEM_QueryType
```
    References the constant integer value representing the ITEM Query Type.
    
    See Also:
    
    Constant Field Values
  - BOTH_QueryType
```
public static final int BOTH_QueryType
```
    References the constant integer value representing the BOTH Query Type.
    
    See Also:
    
    Constant Field Values
  - ITEM_CatEntryType
```
public static final int ITEM_CatEntryType
```
    References the constant integer value representing the ITEM CatEntry Type.
    
    See Also:
    
    Constant Field Values
  - BUNDLE_CatEntryType
```
public static final int BUNDLE_CatEntryType
```
    References the constant integer value representing the BUNDLE CatEntry Type.
    
    See Also:
    
    Constant Field Values
  - PACKAGE_CatEntryType
```
public static final int PACKAGE_CatEntryType
```
    References the constant integer value representing the PACKAGE CatEntry Type.
    
    See Also:
    
    Constant Field Values
  - PRODUCT_CatEntryType
```
public static final int PRODUCT_CatEntryType
```
    References the constant integer value representing the PRODUCT_CatEntry Type.
    
    See Also:
    
    Constant Field Values
  - ALL_Item
```
public static final java.lang.String ALL_Item
```
    References the constant string value representing the ALL_Item.
    
    See Also:
    
    Constant Field Values
- Constructor Detail
  - SelectQuery
```
public SelectQuery()
```
    Default select query constructor.
  - SelectQuery
```
public SelectQuery(TradingAgreementAccessBean[] inAgreements)
```
    Deprecated. Replaced by SelectQuery(TradingAgreementAccessBean[] inAgreements, Long userId).
    
    SelectQuery constructor with trading agreement access bean as an argument.
  - 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
    
    userID - The user id - used in the queries.
  - SelectQuery
```
public SelectQuery(int inStoreID,
                   TradingAgreementAccessBean[] inAgreements)
```
    Deprecated. Replaced by SelectQuery(int inStoreID, TradingAgreementAccessBean[] inAgreements, Long userId).
    
    SelectQuery constructor with store id and trading agreement access bean as arguments.
  - 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:
    
    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(int aStoreID,
                   int aUserID)
```
    SelectQuery constructor with store and user id as arguments.
    
    Parameters:
    
    storeID - The store id - used in the queries.
    
    userID - The user id - used in the queries.
  - SelectQuery
```
public SelectQuery(com.ibm.commerce.search.base.Query q)
```
    SelectQuery constructor with query as an argument.
    
    Parameters:
    
    q - The query object.
  - SelectQuery
```
public SelectQuery(java.util.Vector inStoreIDs,
                   TradingAgreementAccessBean[] inAgreements)
```
    Deprecated. Replaced by SelectQuery(Vector inStoreIDs, TradingAgreementAccessBean[] inAgreements, Long userId).
    
    SelectQuery constructor with collection of store ids and trading agreement access bean as arguments.
  - 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:
    
    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.
  - SelectQuery
```
public SelectQuery(java.util.Vector inStoreIDs,
                   int aUserID)
```
    SelectQuery constructor with a collection of store ids and a user id as arguments.
    
    Parameters:
    
    storeID - The store id collection - used in the queries.
    
    userID - The user id - 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. The attribute and operator parameter values are obtained from the corresponding constants defined within this class.
    
    Parameters:
    
    The - static integer constant equivalent of a column name.
    
    The - static integer constant equivalent of an operator.
    
    Throws:
    
    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. The attribute, operator, and function parameter values are obtained from the corresponding constants defined within this class.
    
    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.
    
    Throws:
    
    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. The attribute and operator parameter values are obtained from the corresponding constants defined within this class.
    
    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.
    
    Throws:
    
    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. The attribute, operator, and function parameter values are obtained from the corresponding constants defined within this class.
    
    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.
    
    Throws:
    
    java.lang.Exception
  - addFilterAttribute
```
public void addFilterAttribute(com.ibm.commerce.search.base.Predicate predicate)
                        throws java.lang.Exception
```
    Adds a collection of WHERE clause predicates into temporary filter predicate collection.
    
    Parameters:
    
    A - collection of WHERE clause predicates
    
    Throws:
    
    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. The operator parameter values are obtained from the corresponding constants defined within this class.
    
    Parameters:
    
    The - static integer constant equivalent of an operator.
  - addGlobalPredicate
```
public void addGlobalPredicate(com.ibm.commerce.search.base.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 The attribute parameter values are obtained from the corresponding constants defined within this class.
    
    Throws:
    
    java.lang.Exception
  - addOrderByAttribute
```
public void addOrderByAttribute(int attribute,
                                int operator)
                         throws java.lang.Exception
```
    To set order by operator The attribute and operator parameter values are obtained from the corresponding constants defined within this class.
    
    Throws:
    
    java.lang.Exception
  - addRule
```
public void addRule()
```
    Adds a 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.
  - 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. The attribute and operator parameter values are obtained from the corresponding constants defined within this class.
    
    Parameters:
    
    The - static integer constant equivalent of a column name.
    
    The - static integer constant equivalent of an operator.
    
    Throws:
    
    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. The attribute, operator, and function parameter values are obtained from the corresponding constants defined within this class.
    
    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.
    
    Throws:
    
    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%'. The attribute and operator parameter values are obtained from the corresponding constants defined within this class.
    
    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.
    
    Throws:
    
    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. The attribute, operator, and function parameter values are obtained from the corresponding constants defined within this class.
    
    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.
    
    Throws:
    
    java.lang.Exception
  - addSelectAttribute
```
public void addSelectAttribute(java.lang.String attribute,
                               int operator,
                               java.lang.String value)
                        throws java.lang.Exception
```
    Deprecated. Replaced by addSelectAttribute(int attribute, int operator, String value).
    
    Adds a Rich attribute predicate. This method only supports NAME column in AttrValue column. The attribute and operator parameter values are obtained from the corresponding constants defined within this class.
    
    Parameters:
    
    attribute - An attribute defined in Attribute table, for example Color, Size.
    
    operator - The static integer operator constant.
    
    value - The value of an attribute defined in AttrValue table, for example Red, Length = 32.
    
    Throws:
    
    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. The attribute and operator parameter values are obtained from the corresponding constants defined within this class.
    
    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 Integervalue, 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.
    
    Throws:
    
    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. The attribute, operator, and function parameter values are obtained from the corresponding constants defined within this class.
    
    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 Integervalue, 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
    
    Throws:
    
    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. Replaced by addSelectAttribute(String attribute, int operator, String value, int attrValueType, String languageId, String prodType, int function).
    
    Adds a Rich attribute predicate. This method only supports NAME column in AttrValue column. The attribute, operator, and function parameter values are obtained from the corresponding constants defined within this class.
    
    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.
    
    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.
    
    Throws:
    
    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. Replaced by addSelectAttribute(String attribute, int operator, String value, int attrValueType, String languageId, String prodType, int function).
    
    Adds a Rich attribute predicate. This method only supports NAME, STRINGVALUE, FLOATVALUE and INTEGERVALUE column in AttrValue column. The attribute, operator, and function parameter values are obtained from the corresponding constants defined within this class.
    
    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 Integervalue, 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
    
    Throws:
    
    java.lang.Exception
  - addSelectOperand
```
public void addSelectOperand(com.ibm.commerce.search.base.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 translation is supported for following table columns CATGPENREL.CATGROUP_ID and CATGRPDESC.NAME or SHORTDESC or LONGDESC.
    
    Parameters:
    
    predicate - A collection of predicates.
    
    Throws:
    
    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.
    
    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.
    
    Returns:
    
    A collection of catentry ids.
    
    Throws:
    
    java.lang.Exception
  - execute
```
public java.util.Vector execute(int maxResults)
                         throws java.lang.Exception
```
    Executes a set of catalog search query and retrieves certain number (specified in maxResults) of non duplicate catentry ids that satisfy these query. This version does not use cursor.
    
    Parameters:
    
    maxResults - The number of results to be retrieved.
    
    Returns:
    
    A collection of catentry ids.
    
    Throws:
    
    java.lang.Exception
  - execute
```
public java.util.Vector execute(int maxResults,
                                com.ibm.commerce.base.objects.Cursor aCursor)
                         throws java.lang.Exception
```
    Executes a set of catalog search query and retrieves certain 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 cursor object.
    
    Returns:
    
    A collection of catentry ids.
    
    Throws:
    
    java.lang.Exception
  - 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 certain number (specified in numProductRequested) of non duplicate catentry ids that satisfy these query.
    
    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.
    
    Throws:
    
    java.lang.Exception
  - getLongUserId
```
public java.lang.Long getLongUserId()
```
    Returns the user id.
    
    Returns:
    
    The user id of type Long.
  - getPredicate
```
public com.ibm.commerce.search.base.Predicate getPredicate()
                                                    throws java.lang.Exception
```
    Returns the selectSet and filterSet predicate.
    
    Throws:
    
    java.lang.Exception
  - getRules
```
public java.util.Vector getRules()
```
    Returns the query collection.
  - getStoreID
```
public java.lang.Integer getStoreID()
```
    Returns the store id.
  - getStoreIDs
```
public java.util.Vector getStoreIDs()
```
    Returns the collection of store ids.
  - getUserID
```
public java.lang.Integer getUserID()
```
    Returns the user id.
  - reset
```
public void reset()
```
    Re-initialize filterSet and selectSet variables
  - setDistinct
```
public void setDistinct()
```
    To set distinct operator
  - setDistinct
```
public void setDistinct(boolean distinctFlag)
```
    To set distinct operator.
    
    Parameters:
    
    distinctFlag - java.lang.Boolean. The value to set for the distinct operator.
  - setLongUserId
```
public void setLongUserId(java.lang.Long newLongUserId)
```
    To set the user id.
    
    Parameters:
    
    newLongUserId - java.lang.Long. The user ID to set.
  - setRules
```
public void setRules(java.util.Vector newRules)
```
    To set the query collection.
    
    Parameters:
    
    newRules - java.util.Vector. the query collection to set.
  - setStoreID
```
public void setStoreID(int newStoreID)
```
    To set the store id.
    
    Parameters:
    
    newStoreID - int. The store ID to set.
  - setStoreIDs
```
public void setStoreIDs(java.util.Vector newStoreIDs)
```
    To set the collection of store ids.
    
    Parameters:
    
    newStoreIDs - java.util.Vector. The vector of store IDs.
  - setUserID
```
public void setUserID(int newUserID)
```
    To set the user id.
    
    Parameters:
    
    newUserID - int. The user ID.

Methods inherited from class java.lang.Object

COPYRIGHT

LISTPRICE_LISTPRICE_Attr

LISTPRICE_Attr

LISTPRICE_CURRENCY_Attr

LISTPRICE_CATENTRY_ID_Attr

STOREINVENTORY_QUANTITY_Attr

STOREINVENTORY_QUANTITY_MEASURE_Attr

CATGRPDESC_NAME_Attr

CATGRPDESC_LANGUAGE_ID_Attr

CATGRPDESC_LONGDESCRIPTION_Attr

CATGRPDESC_SHORTDESCRIPTION_Attr

CATGRPDESC_KEYWORD_Attr

CATGRPDESC_PUBLISHED_Attr

CATENTRY_SKU_Attr

CATENTRY_CATENTRY_ID_Attr

CATENTRY_ID_Attr

CATENTRY_BUYABLE_Attr

CATENTRY_ONAUCTION_Attr

CATENTRY_ONSPECIAL_Attr

CATENTRY_PARTNUMBER_Attr

CATENTRY_MFNAME_Attr

CATENTRY_MFPARTNUMBER_Attr

CATENTRY_MARKFORDELETE_Attr

CATENTRY_LASTUPDATE_Attr

CATENTDESC_NAME_Attr

CATENTDESC_AVAILABILITY_DATE_Attr

CATENTDESC_LANGUAGE_ID_Attr

CATENTDESC_PUBLISHED_Attr

CATENTDESC_SHORT_DESC_Attr

CATENTDESC_CATENTRY_ID_Attr

CATENTDESC_THUMBNAIL_Attr

CATENTDESC_LONGDESCRIPTION_Attr

CATENTDESC_SHORTDESCRIPTION_Attr

CATENTDESC_PARTNUMBER_Attr

CATENTDESC_KEYWORD_Attr

CATENTDESC_AVAILABLE_Attr

STORECATENTRY_STORE_ID_Attr

USER_ID_Attr

CATENTREL_CATENTRY_ID_CHILD_Attr

CATENTREL_CATENTRY_ID_PARENT_Attr

CATENTREL_CATREL_TYPE_ID_Attr

ATTRIBUTE_NAME_Attr

ATTRIBUTE_LANGUAGE_ID_Attr

ATTRIBUTE_CATENTRY_ID_Attr

ATTRIBUTE_ATTRIBUTE_ID_Attr

ATTRVALUE_LANGUAGE_ID_Attr

ATTRVALUE_NAME_Attr

ATTRVALUE_CATENTRY_ID_Attr

ATTRVALUE_STRINGVALUE_Attr

ATTRVALUE_ATTRIBUTE_ID_Attr

ATTRVALUE_FLOATVALUE_Attr

ATTRVALUE_INTEGERVALUE_Attr

CATGPENREL_CATGROUP_ID_Attr

CATGPENREL_CATENTRY_ID_Attr

CATGPENREL_CATALOG_ID_Attr

CATGROUP_CATGROUP_ID_Attr

CATGROUP_MARKFORDELETE_Attr

CATGROUP_LASTUPDATE_Attr

CATGROUP_IDENTIFIER_ID_Attr

CATGROUP_IDENTIFIER_Attr

PRSETCEREL_PRODUCTSET_ID_Attr

PRSETCEREL_CATENTRY_ID_Attr

OFFERPRICE_PRICE_Attr

OFFERPRICE_OFFER_ID_Attr

OFFERPRICE_CURRENCY_Attr

OFFER_TRADEPOSCN_ID_Attr

OFFER_OFFER_ID_Attr

OFFER_MAXIMUMQUANTITY_Attr

OFFER_MINIMUMQUANTITY_Attr

TRADEPOSCN_TRADEPOSCN_ID_Attr

TRADEPOSCN_TYPE_ID_Attr

INVSTVW_QUANTITY_AVAILABLE_Attr

INVSTVW_QUANTITY_MEASURE_Attr

INVSTVW_STORE_ID_Attr

STDPRICEVW_PRICE_Attr

STDPRICEVW_CATENTRY_ID_Attr

STDPRICEVW_CURRENCY_Attr

CATALOG_CATALOG_ID_Attr

CATALOG_DESCRIPTION_Attr