com.ibm.commerce.search.beans
Class CategorySearchListDataBean

java.lang.Object
  |
  +--com.ibm.commerce.beans.InputDataBeanImpl
        |
        +--com.ibm.commerce.beans.SmartDataBeanImpl
              |
              +--com.ibm.commerce.search.beans.SearchBaseDataBean
                    |
                    +--com.ibm.commerce.search.beans.CategorySearchListDataBean
All Implemented Interfaces:
DataBean, InputDataBean, SearchConstants, java.io.Serializable, SmartDataBean

public class CategorySearchListDataBean
extends SearchBaseDataBean

This bean is used to retrieve catalog identifier information from master catalog based on input search criteria. This bean extends CatalogSearchBaseDataBean. The search criteria may be input using a JSP. List of variables that may be input using JSP are as follows.

  1. name (String): The value of this variable is used in search based on category name (Catgrpdesc.name column).
  2. nameCaseSensitive (String) : A user can choose case sensitive or case insensitive search. The value in this variable is used to identify if a search is case sensitive or not. The value must be either 'yes'(case sensitive search) or 'no'(case insensitive search).
  3. nameTermOperator (String) : A user can choose either 'like' or 'equal' as search operators. The value in this variable is used to store a user's choice. The value must be either 'LIKE'(for like operator) or 'EQUAL'(for equal operator).
  4. nameType (String) : A user can specify three types of search criteria All, Any, Exact Phrase. The value in this variable is used to store a user's search criteria. The value must be 'ALL'(for All search criteria), 'ANY'(for Any search criteria) and 'EXACT'(for Exact phrase criteria).
  5. shortDesc (String): The value of this variable is used in search based on category shortdescription (Catgrpdesc.shortdescription column).
  6. shortDescCaseSensitive (String) : A user can choose case sensitive or case insensitive search. The value in this variable is used to identify if a search is case sensitive or not. The value must be either 'yes'(case sensitive search) or 'no'(case insensitive search).
  7. shortDescOperator (String) : A user can choose either 'like' or 'equal' as search operators. The value in this variable is used to store a user's choice. The value must be either 'LIKE'(for like operator) or 'EQUAL'(for equal operator).
  8. shortDescType (String) : A user can specify three types of search criteria All, Any, Exact Phrase. The value in this variable is used to store a user's search criteria. The value must be 'ALL'(for All search criteria), 'ANY'(for Any search criteria) and 'EXACT'(for Exact phrase criteria).
  9. longDesc (String): The value of this variable is used in search based on category longdescription (Catgrpdesc.longdescription column).
  10. longDescCaseSensitive (String) : A user can choose case sensitive or case insensitive search. The value in this variable is used to identify if a search is case sensitive or not. The value must be either 'yes'(case sensitive search) or 'no'(case insensitive search).
  11. longDescOperator (String) : A user can choose either 'like' or 'equal' as search operators. The value in this variable is used to store a user's choice. The value must be either 'LIKE'(for like operator) or 'EQUAL'(for equal operator).
  12. longDescType (String) : A user can specify three types of search criteria All, Any, Exact Phrase. The value in this variable is used to store a user's search criteria. The value must be 'ALL'(for All search criteria), 'ANY'(for Any search criteria) and 'EXACT'(for Exact phrase criteria).
  13. keyword (String): The value of this variable is used in search based on catgroup keyword (Catgrpdesc.keyword column).
  14. keywordCaseSensitive (String) : A user can choose case sensitive or case insensitive search. The value in this variable is used to identify if a search is case sensitive or not. The value must be either 'yes'(case sensitive search) or 'no'(case insensitive search).
  15. keywordOperator (String) : A user can choose either 'like' or 'equal' as search operators. The value in this variable is used to store a user's choice. The value must be either 'LIKE'(for like operator) or 'EQUAL'(for equal operator).
  16. keywordType (String) : A user can specify three types of search criteria All, Any, Exact Phrase. The value in this variable is used to store a user's search criteria. The value must be 'ALL'(for All search criteria), 'ANY'(for Any search criteria) and 'EXACT'(for Exact phrase criteria).
  17. storeId (String) : A user can specify the store to search on. It can be single store or multiple store. In case of multiple store each store has to be delimited by ','.
  18. storeIdOperator: A user can choose one of the following operators as search operators: =, <, >, !=, <=, >=. The value in this variable is used to store a user's choice. The value must be any one of the following: 'EQUAL,' 'NOTEQUAL,' 'GREATER,' 'LESS,' 'GREATER_EQUAL,' 'LESS_EQUAL,' 'IN.'
  19. lastUpdate (String): The value of this variable is used in search based on Lastupdate (category.Lastupdate column).
  20. lastUpdateOperator (String) : A user can choose one of the following operators as search operators: =, <, >, !=, <=, >=. The value in this variable is used to store a user's choice. The value must be any one of the following: 'EQUAL,' 'NOTEQUAL,' 'GREATER,' 'LESS,' 'GREATER_EQUAL,' 'LESS_EQUAL.'
  21. markForDelete (String): The value is used to search on markForDelete (category.markfordelete column).
  22. markForDeleteOperator (String) : A user can choose one of the following operators as search operators: =, <, >, !=, <=, >=. The value in this variable is used to store a user's choice. The value must be any one of the following: 'EQUAL,' 'NOTEQUAL,' 'GREATER,' 'LESS,' 'GREATER_EQUAL,' 'LESS_EQUAL.'
  23. published (String): The value is used to search on published (Catgrpdesc.published column).
  24. publishedOperator (String) : A user can choose one of the following operators as search operators: =, <, >, !=, <=, >=. The value in this variable is used to store a user's choice. The value must be any one of the following: 'EQUAL,' 'NOTEQUAL,' 'GREATER,' 'LESS,' 'GREATER_EQUAL,' 'LESS_EQUAL.'
  25. identifier (String): The value of this variable is used in search based on catgroup identifier (Catgroup.identifier column).
  26. identifierCaseSensitive (String) : A user can choose case sensitive or case insensitive search. The value in this variable is used to identify if a search is case sensitive or not. The value must be either 'yes'(case sensitive search) or 'no'(case insensitive search).
  27. identifierOperator (String) : A user can choose either 'like' or 'equal' as search operators. The value in this variable is used to store a user's choice. The value must be either 'LIKE'(for like operator) or 'EQUAL'(for equal operator).
  28. identifierType (String) : A user can specify three types of search criteria All, Any, Exact Phrase. The value in this variable is used to store a user's search criteria. The value must be 'ALL'(for All search criteria), 'ANY'(for Any search criteria) and 'EXACT'(for Exact phrase criteria).
See Also:
Serialized Form

Field Summary
 
Fields inherited from class com.ibm.commerce.search.beans. SearchBaseDataBean
aCursor, beginIndex, commandContext, databaseType, pageSize, q, resultCount
 
Fields inherited from class com.ibm.commerce.beans. SmartDataBeanImpl
COPYRIGHT
 
Fields inherited from class com.ibm.commerce.beans. InputDataBeanImpl
requestProperties
 
Fields inherited from interface com.ibm.commerce.search.beans. SearchConstants
ALL, ALL_CATALOG, ALL_CATEGORIES, ALLWORDS, ANYWORDS, ATTRVALUE_FLOATVALUE, ATTRVALUE_INTEGERVALUE, ATTRVALUE_STRINGVALUE, BOTH, CASE_SENSITIVE, CATGPENREL_BOTH_SCHEMA_TYPE, CATGPENREL_PRODUCT_SCHEMA_TYPE, COPYRIGHT, DISTINCT_RESULT, EXACTPHRASE, ITEM, LISTPRICE_ON, MASTER_CATALOG, OPERATOR_EQUAL, OPERATOR_GREATER, OPERATOR_GREATER_EQUAL, OPERATOR_IN, OPERATOR_LESS, OPERATOR_LESS_EQUAL, OPERATOR_LIKE, OPERATOR_NOT_EQUAL, OPERATOR_NOT_LIKE, PRODUCT, SEARCH_IN_CATEGORYNAME, SEARCH_IN_CATEGORYNAME_AND_DESCRIPTIONS, SEARCH_IN_CATEGORYNAME_AND_SHORT_DESCRIPTION, SEARCH_IN_KEYWORD, SEARCH_IN_PRODUCTNAME, SEARCH_IN_PRODUCTNAME_AND_DESCRIPTIONS, SEARCH_IN_PRODUCTNAME_AND_SHORT_DESCRIPTION
 
Fields inherited from interface com.ibm.commerce.beans. DataBean
emptyString
 
Constructor Summary
CategorySearchListDataBean()
          AdvancedCatEntrySearchListDataBean constructor comment.
 
Method Summary
protected  Predicate buildBooleanPredicate(java.lang.String aTerm, java.lang.String aOperator, java.lang.String aType, java.lang.String caseSensitive, int attrIdentity)
          Formulate a search predicate, to search on a Varchar or Char column.
protected  void execute()
          Calls the search interface to query the database.
 java.lang.String getDistinct()
          Defines SQL distinct qualifier.
 java.lang.String getIdentifier()
          The value of this variable is used in search based on catgroup identifier (Catgroup.identifier column).
 java.lang.String getIdentifierCaseSensitive()
          A user can choose case sensitive or case insensitive search.
 java.lang.String getIdentifierOperator()
          A user can choose either 'like' or 'equal' as search operators.
 java.lang.String getIdentifierType()
          A user can specify three types of search criteria All, Any, Exact Phrase.
 java.lang.String getKeyword()
          The value of this variable is used in search based on catgroup keyword (Catgrpdesc.keyword column).
 java.lang.String getKeywordCaseSensitive()
          A user can choose case sensitive or case insensitive search.
 java.lang.String getKeywordOperator()
          A user can choose either 'like' or 'equal' as search operators.
 java.lang.String getKeywordType()
          A user can specify three types of search criteria All, Any, Exact Phrase.
 java.lang.String getLangId()
          The langId for to search.
 java.lang.String getLastUpdate()
          The value of this variable is used in search based on Lastupdate (category.Lastupdate column).
 java.lang.String getLastUpdateOperator()
          /** A user can choose one of the following operators as search operators: =, <, >, !=, <=, >=.
 java.lang.String getLongDesc()
          The value of this variable is used in search based on category longdescription (Catgrpdesc.longdescription column).
 java.lang.String getLongDescCaseSensitive()
          A user can choose case sensitive or case insensitive search.
 java.lang.String getLongDescOperator()
          A user can choose either 'like' or 'equal' as search operators.
 java.lang.String getLongDescType()
          A user can specify three types of search criteria All, Any, Exact Phrase.
 java.lang.String getMarkForDelete()
          The value is used to search on markForDelete (category.markfordelete column).
 java.lang.String getMarkForDeleteOperator()
          A user can choose either 'like' or 'equal' as search operators.
 java.lang.String getName()
          A user can choose either 'like' or 'equal' as search operators.
 java.lang.String getNameCaseSensitive()
          A user can choose case sensitive or case insensitive search.
 java.lang.String getNameTermOperator()
          A user can choose either 'like' or 'equal' as search operators.
 java.lang.String getNameType()
          A user can specify three types of search criteria All, Any, Exact Phrase.
 java.lang.String getOrderBy1()
          Result set will be sorted by this attribute.
 java.lang.String getOrderByOperator1()
          Attributes can be sorted by ascending (default) or decending order.
 java.lang.String getPublished()
          The value is used to search on published (Catgrpdesc.published column).
 java.lang.String getPublishedOperator()
          A user can choose one of the following operators as search operators: =, <, >, !=, <=, >=.
 java.lang.String getResultCount()
          Returns resultCount
  CategoryDataBean[] getResultList()
          resultList (CatalogDataBean) : Search results as array of CatalogDataBeans from resultSet variable.
 java.lang.String getResultName()
          Column names for building a result set.
 java.util.Vector getResultSet()
          Search results as vector of vectors of strings containing rows with result set columns where first column must be Catalog ids.
 java.util.Vector getResultSetName()
          Search results as vector of vectors of strings containing result set column names.
 java.lang.String getShortDesc()
          The value of this variable is used in search based on category shortdescription (Catgrpdesc.
 java.lang.String getShortDescCaseSensitive()
          A user can choose case sensitive or case insensitive search.
 java.lang.String getShortDescOperator()
          A user can choose either 'like' or 'equal' as search operators.
 java.lang.String getShortDescType()
          A user can specify three types of search criteria All, Any, Exact Phrase.
 java.lang.String getStoreId()
          A user can specify the store to search on.
 java.lang.String getStoreIdOperator()
          A user can choose one of the following operators as search operators: =, <, >, !=, <=, >=.
 int getUserId()
          The userId from command context.
protected  void initialize()
          initialize the data bean with command context
 void populate()
          Populate the data bean
 void setDistinct(java.lang.String newDistinct)
          Defines SQL distinct qualifier.
 void setIdentifier(java.lang.String newIdentifier)
          The value of this variable is used in search based on catgroup identifier (Catgroup.identifier column).
 void setIdentifierCaseSensitive(java.lang.String newIdentifierCaseSensitive)
          A user can choose case sensitive or case insensitive search.
 void setIdentifierOperator(java.lang.String newIdentifierOperator)
          A user can choose either 'like' or 'equal' as search operators.
 void setIdentifierType(java.lang.String newIdentifierType)
          A user can specify three types of search criteria All, Any, Exact Phrase.
 void setKeyword(java.lang.String newKeyword)
          The value of this variable is used in search based on catgroup keyword (Catgrpdesc.keyword column).
 void setKeywordCaseSensitive(java.lang.String newKeywordCaseSensitive)
          A user can choose case sensitive or case insensitive search.
 void setKeywordOperator(java.lang.String newKeywordOperator)
          A user can choose either 'like' or 'equal' as search operators.
 void setKeywordType(java.lang.String newKeywordType)
          A user can specify three types of search criteria All, Any, Exact Phrase.
 void setLangId(java.lang.String newLangId)
          The langId for to search.
 void setLastUpdate(java.lang.String newLastUpdate)
          The value of this variable is used in search based on Lastupdate (category.Lastupdate column).
 void setLastUpdateOperator(java.lang.String newLastUpdateOperator)
          A user can choose one of the following operators as search operators: =, <, >, !=, <=, >=.
 void setLongDesc(java.lang.String newLongDesc)
          The value of this variable is used in search based on category longdescription (Catgrpdesc.longdescription column).
 void setLongDescCaseSensitive(java.lang.String newLongDescCaseSensitive)
          A user can choose case sensitive or case insensitive search.
 void setLongDescOperator(java.lang.String newLongDescOperator)
          A user can choose either 'like' or 'equal' as search operators.
 void setLongDescType(java.lang.String newLongDescType)
          A user can specify three types of search criteria All, Any, Exact Phrase.
 void setMarkForDelete(java.lang.String newMarkForDelete)
          The value is used to search on markForDelete (category.markfordelete column).
 void setMarkForDeleteOperator(java.lang.String newMarkForDeleteOperator)
          A user can choose either 'like' or 'equal' as search operators.
 void setName(java.lang.String newName)
          The value of this variable is used in search based on Category name (Category.name column).
 void setNameCaseSensitive(java.lang.String newNameCaseSensitive)
          A user can choose case sensitive or case insensitive search.
 void setNameTermOperator(java.lang.String newNameTermOperator)
          A user can choose either 'like' or 'equal' as search operators.
 void setNameType(java.lang.String newNameType)
          A user can specify three types of search criteria All, Any, Exact Phrase.
 void setOrderBy1(java.lang.String newOrderBy1)
          Result set will be sorted by this attribute.
 void setOrderByOperator1(java.lang.String newOrderByOperator1)
          Attributes can be sorted by ascending (default) or decending order.
protected  void setPredefinedAttributes()
          Use rulequery to build the query predicate.
 void setPublished(java.lang.String newPublished)
          The value is used to search on published (Catgrpdesc.published column).
 void setPublishedOperator(java.lang.String newPublishedOperator)
          A user can choose one of the following operators as search operators: =, <, >, !=, <=, >=.
 void setResultCount(java.lang.String newResultCount)
          Accessor generated by VAJ - do not modify.
 void setResultList( CategoryDataBean[] newResultList)
          Search results as array of CategoryDataBean from resultSet variable.
 void setResultName(java.lang.String newResultName)
          Column names for building a result set.
 void setResultSet(java.util.Vector newResultSet)
          Search results as vector of vectors of strings containing rows with result set columns where first column must be Category ids.
 void setResultSetName(java.lang.String newResultName)
          Search results as vector of vectors of strings containing result set column names.
 void setShortDesc(java.lang.String newShortDesc)
          The value of this variable is used in search based on category shortdescription (Catgrpdesc.
 void setShortDescCaseSensitive(java.lang.String newShortDescCaseSensitive)
          A user can choose case sensitive or case insensitive search.
 void setShortDescOperator(java.lang.String newShortDescOperator)
          A user can choose either 'like' or 'equal' as search operators.
 void setShortDescType(java.lang.String newShortDescType)
          A user can specify three types of search criteria All, Any, Exact Phrase.
 void setStoreId(java.lang.String newStoreId)
          A user can specify the store to search on.
 void setStoreIdOperator(java.lang.String newStoreIdOperator)
          A user can choose one of the following operators as search operators: =, <, >, !=, <=, >=.
 void setUserId(int newUserId)
          The userId from command context.
 
Methods inherited from class com.ibm.commerce.search.beans. SearchBaseDataBean
getBeginIndex, getNumericOperator, getPageSize, getStringOperator, isEmpty, setBeginIndex, setPageSize
 
Methods inherited from class com.ibm.commerce.beans. SmartDataBeanImpl
fulfills, getCommandContext, getResources, setCommandContext
 
Methods inherited from class com.ibm.commerce.beans. InputDataBeanImpl
getRequestProperties, setRequestProperties
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 
Methods inherited from interface com.ibm.commerce.beans. InputDataBean
getRequestProperties, setRequestProperties
 

Constructor Detail

CategorySearchListDataBean

public CategorySearchListDataBean()
AdvancedCatEntrySearchListDataBean constructor comment.
Method Detail

buildBooleanPredicate

protected Predicate buildBooleanPredicate(java.lang.String aTerm,
                                          java.lang.String aOperator,
                                          java.lang.String aType,
                                          java.lang.String caseSensitive,
                                          int attrIdentity)
Formulate a search predicate, to search on a Varchar or Char column. This method supports construction of boolean predicate and search based on case.
Parameters:
aTerm - The search term (can be EQUAL, LIKE, NOT_LIKE).
aOperator - The search operator (string type operator).
aType - The user can specify three types of search criteria All, Any, Exact Phrase. The value in this variable is used to store a user's search criteria. The value must be 'ALL'(for All search criteria), 'ANY'(for Any search criteria) and 'EXACT'(for Exact phrase criteria).
caseSensitive - The user can choose case sensitive or case insensitive search. The value in this variable is used to identify if a search is case sensitive or not. The value must be either 'yes' (case sensitive) or 'no' (case insensitive)
attrIdentity - The column to search on.
Returns:
com.ibm.commerce.search.base.Predicate The predicate containing constraints

getDistinct

public java.lang.String getDistinct()
Defines SQL distinct qualifier. It is useful when using order by where distinct qualifer is not permitted.
Returns:
java.lang.String

execute

protected void execute()
Calls the search interface to query the database.
Specified by:
execute in class SearchBaseDataBean

getIdentifier

public java.lang.String getIdentifier()
The value of this variable is used in search based on catgroup identifier (Catgroup.identifier column).
Returns:
java.lang.String

getIdentifierCaseSensitive

public java.lang.String getIdentifierCaseSensitive()
A user can choose case sensitive or case insensitive search. The value in this variable is used to identify if a search is case sensitive or not. The value must be either 'yes'(case sensitive search) or 'no'(case insensitive search).
Returns:
java.lang.String

getIdentifierOperator

public java.lang.String getIdentifierOperator()
A user can choose either 'like' or 'equal' as search operators. The value in this variable is used to store a user's choice. The value must be either 'LIKE'(for like operator) or 'EQUAL'(for equal operator).
Returns:
java.lang.String

getIdentifierType

public java.lang.String getIdentifierType()
A user can specify three types of search criteria All, Any, Exact Phrase. The value in this variable is used to store a user's search criteria. The value must be 'ALL'(for All search criteria), 'ANY'(for Any search criteria) and 'EXACT'(for Exact phrase criteria).
Returns:
java.lang.String

getKeyword

public java.lang.String getKeyword()
The value of this variable is used in search based on catgroup keyword (Catgrpdesc.keyword column).
Returns:
java.lang.String

getKeywordCaseSensitive

public java.lang.String getKeywordCaseSensitive()
A user can choose case sensitive or case insensitive search. The value in this variable is used to identify if a search is case sensitive or not. The value must be either 'yes'(case sensitive search) or 'no'(case insensitive search).
Returns:
java.lang.String

getKeywordOperator

public java.lang.String getKeywordOperator()
A user can choose either 'like' or 'equal' as search operators. The value in this variable is used to store a user's choice. The value must be either 'LIKE'(for like operator) or 'EQUAL'(for equal operator).
Returns:
java.lang.String

getKeywordType

public java.lang.String getKeywordType()
A user can specify three types of search criteria All, Any, Exact Phrase. The value in this variable is used to store a user's search criteria. The value must be 'ALL'(for All search criteria), 'ANY'(for Any search criteria) and 'EXACT'(for Exact phrase criteria).
Returns:
java.lang.String

getLangId

public java.lang.String getLangId()
The langId for to search. If not provided the default from command context will be used.
Returns:
java.lang.String

getLastUpdate

public java.lang.String getLastUpdate()
The value of this variable is used in search based on Lastupdate (category.Lastupdate column).
Returns:
java.lang.String

getLastUpdateOperator

public java.lang.String getLastUpdateOperator()
/** A user can choose one of the following operators as search operators: =, <, >, !=, <=, >=. The value in this variable is used to store a user's choice. The value must be any one of the following: 'EQUAL,' 'NOTEQUAL,' 'GREATER,' 'LESS,' 'GREATER_EQUAL,' 'LESS_EQUAL.'
Returns:
java.lang.String

getLongDesc

public java.lang.String getLongDesc()
The value of this variable is used in search based on category longdescription (Catgrpdesc.longdescription column).
Returns:
java.lang.String

getLongDescCaseSensitive

public java.lang.String getLongDescCaseSensitive()
A user can choose case sensitive or case insensitive search. The value in this variable is used to identify if a search is case sensitive or not. The value must be either 'yes'(case sensitive search) or 'no'(case insensitive search).
Returns:
java.lang.String

getLongDescOperator

public java.lang.String getLongDescOperator()
A user can choose either 'like' or 'equal' as search operators. The value in this variable is used to store a user's choice. The value must be either 'LIKE'(for like operator) or 'EQUAL' (for equal operator).
Returns:
java.lang.String

getLongDescType

public java.lang.String getLongDescType()
A user can specify three types of search criteria All, Any, Exact Phrase. The value in this variable is used to store a user's search criteria. The value must be 'ALL'(for All search criteria), 'ANY'(for Any search criteria) and 'EXACT'(for Exact phrase criteria).
Returns:
java.lang.String

getMarkForDelete

public java.lang.String getMarkForDelete()
The value is used to search on markForDelete (category.markfordelete column).
Returns:
java.lang.String

getMarkForDeleteOperator

public java.lang.String getMarkForDeleteOperator()
A user can choose either 'like' or 'equal' as search operators. The value in this variable is used to store a user's choice. The value must be either 'LIKE'(for like operator) or 'EQUAL' (for equal operator).
Returns:
java.lang.String

getName

public java.lang.String getName()
A user can choose either 'like' or 'equal' as search operators. The value in this variable is used to store a user's choice. The value must be either 'LIKE'(for like operator) or 'EQUAL'(for equal operator).
Returns:
java.lang.String

getNameCaseSensitive

public java.lang.String getNameCaseSensitive()
A user can choose case sensitive or case insensitive search. The value in this variable is used to identify if a search is case sensitive or not. The value must be either 'yes'(case sensitive search) or 'no'(case insensitive search).
Returns:
java.lang.String

getNameTermOperator

public java.lang.String getNameTermOperator()
A user can choose either 'like' or 'equal' as search operators. The value in this variable is used to store a user's choice. The value must be either 'LIKE'(for like operator) or 'EQUAL' (for equal operator).
Returns:
java.lang.String

getNameType

public java.lang.String getNameType()
A user can specify three types of search criteria All, Any, Exact Phrase. The value in this variable is used to store a user's search criteria. The value must be 'ALL'(for All search criteria), 'ANY'(for Any search criteria) and 'EXACT'(for Exact phrase criteria).
Returns:
java.lang.String

getOrderBy1

public java.lang.String getOrderBy1()
Result set will be sorted by this attribute.
Returns:
java.lang.String

getOrderByOperator1

public java.lang.String getOrderByOperator1()
Attributes can be sorted by ascending (default) or decending order.
Returns:
java.lang.String

getPublished

public java.lang.String getPublished()
The value is used to search on published (Catgrpdesc.published column).
Returns:
java.lang.String

getPublishedOperator

public java.lang.String getPublishedOperator()
A user can choose one of the following operators as search operators: =, <, >, !=, <=, >=. The value in this variable is used to store a user's choice. The value must be any one of the following: 'EQUAL,' 'NOTEQUAL,' 'GREATER,' 'LESS,' 'GREATER_EQUAL,' 'LESS_EQUAL.'
Returns:
java.lang.String

getResultCount

public java.lang.String getResultCount()
Returns resultCount
Overrides:
getResultCount in class SearchBaseDataBean
Returns:
The number of rows retrieved for this search criteria.

getResultList

public CategoryDataBean[] getResultList()
resultList (CatalogDataBean) : Search results as array of CatalogDataBeans from resultSet variable.
Returns:
com.ibm.commerce.catalog.beans.CategoryDataBean[]

getResultName

public java.lang.String getResultName()
Column names for building a result set. See valid column names in AttributeInfoDictionary.initialize().
Returns:
java.lang.String

getResultSet

public java.util.Vector getResultSet()
Search results as vector of vectors of strings containing rows with result set columns where first column must be Catalog ids.
Returns:
java.util.Vector

getResultSetName

public java.util.Vector getResultSetName()
Search results as vector of vectors of strings containing result set column names.
Returns:
java.lang.String

getShortDesc

public java.lang.String getShortDesc()
The value of this variable is used in search based on category shortdescription (Catgrpdesc. shortdescription column).
Returns:
java.lang.String

getShortDescCaseSensitive

public java.lang.String getShortDescCaseSensitive()
A user can choose case sensitive or case insensitive search. The value in this variable is used to identify if a search is case sensitive or not. The value must be either 'yes'(case sensitive search) or 'no'(case insensitive search).
Returns:
java.lang.String

getShortDescOperator

public java.lang.String getShortDescOperator()
A user can choose either 'like' or 'equal' as search operators. The value in this variable is used to store a user's choice. The value must be either 'LIKE'(for like operator) or 'EQUAL' (for equal operator).
Returns:
java.lang.String

getShortDescType

public java.lang.String getShortDescType()
A user can specify three types of search criteria All, Any, Exact Phrase. The value in this variable is used to store a user's search criteria. The value must be 'ALL'(for All search criteria),
Returns:
java.lang.String

getStoreId

public java.lang.String getStoreId()
A user can specify the store to search on. It can be single store or multiple store. In case of multiple store each store has to be delimited by ','.
Returns:
java.lang.String

getStoreIdOperator

public java.lang.String getStoreIdOperator()
A user can choose one of the following operators as search operators: =, <, >, !=, <=, >=. The value in this variable is used to store a user's choice. The value must be any one of the following: 'EQUAL,' 'NOTEQUAL,' 'GREATER,' 'LESS,' 'GREATER_EQUAL,' 'LESS_EQUAL,' 'IN.'
Returns:
java.lang.String

getUserId

public int getUserId()
The userId from command context.
Returns:
int

initialize

protected void initialize()
initialize the data bean with command context
Overrides:
initialize in class SearchBaseDataBean

populate

public void populate()
Populate the data bean
Specified by:
populate in interface SmartDataBean
Specified by:
populate in class SearchBaseDataBean

setDistinct

public void setDistinct(java.lang.String newDistinct)
Defines SQL distinct qualifier. It is useful when using order by where distinct qualifer is not permitted.
Parameters:
newDistinct - java.lang.String

setIdentifier

public void setIdentifier(java.lang.String newIdentifier)
The value of this variable is used in search based on catgroup identifier (Catgroup.identifier column).
Parameters:
newIdentifier - java.lang.String

setIdentifierCaseSensitive

public void setIdentifierCaseSensitive(java.lang.String newIdentifierCaseSensitive)
A user can choose case sensitive or case insensitive search. The value in this variable is used to identify if a search is case sensitive or not. The value must be either 'yes'(case sensitive search) or 'no'(case insensitive search).
Parameters:
newIdentifierCaseSensitive - java.lang.String

setIdentifierOperator

public void setIdentifierOperator(java.lang.String newIdentifierOperator)
A user can choose either 'like' or 'equal' as search operators. The value in this variable is used to store a user's choice. The value must be either 'LIKE'(for like operator) or 'EQUAL' (for equal operator).
Parameters:
newIdentifierOperator - java.lang.String

setIdentifierType

public void setIdentifierType(java.lang.String newIdentifierType)
A user can specify three types of search criteria All, Any, Exact Phrase. The value in this variable is used to store a user's search criteria. The value must be 'ALL'(for All search criteria), 'ANY'(for Any search criteria) and 'EXACT'(for Exact phrase criteria).
Parameters:
newIdentifierType - java.lang.String

setKeyword

public void setKeyword(java.lang.String newKeyword)
The value of this variable is used in search based on catgroup keyword (Catgrpdesc.keyword column).
Parameters:
newKeyword - java.lang.String

setKeywordCaseSensitive

public void setKeywordCaseSensitive(java.lang.String newKeywordCaseSensitive)
A user can choose case sensitive or case insensitive search. The value in this variable is used to identify if a search is case sensitive or not. The value must be either 'yes'(case sensitive search) or 'no'(case insensitive search).
Parameters:
newKeywordCaseSensitive - java.lang.String

setKeywordOperator

public void setKeywordOperator(java.lang.String newKeywordOperator)
A user can choose either 'like' or 'equal' as search operators. The value in this variable is used to store a user's choice. The value must be either 'LIKE'(for like operator) or 'EQUAL' (for equal operator).
Parameters:
newKeywordOperator - java.lang.String

setKeywordType

public void setKeywordType(java.lang.String newKeywordType)
A user can specify three types of search criteria All, Any, Exact Phrase. The value in this variable is used to store a user's search criteria. The value must be 'ALL'(for All search criteria), 'ANY'(for Any search criteria) and 'EXACT'(for Exact phrase criteria).
Parameters:
newKeywordType - java.lang.String

setLangId

public void setLangId(java.lang.String newLangId)
The langId for to search. If not provided the default from command context will be used.
Parameters:
newLangId - java.lang.String

setLastUpdate

public void setLastUpdate(java.lang.String newLastUpdate)
The value of this variable is used in search based on Lastupdate (category.Lastupdate column).
Parameters:
newLastUpdate - java.lang.String

setLastUpdateOperator

public void setLastUpdateOperator(java.lang.String newLastUpdateOperator)
A user can choose one of the following operators as search operators: =, <, >, !=, <=, >=. The value in this variable is used to store a user's choice. The value must be any one of the following: 'EQUAL,' 'NOTEQUAL,' 'GREATER,' 'LESS,' 'GREATER_EQUAL,' 'LESS_EQUAL.'
Parameters:
newLastUpdateOperator - java.lang.String

setLongDesc

public void setLongDesc(java.lang.String newLongDesc)
The value of this variable is used in search based on category longdescription (Catgrpdesc.longdescription column).
Parameters:
newLongDesc - java.lang.String

setLongDescCaseSensitive

public void setLongDescCaseSensitive(java.lang.String newLongDescCaseSensitive)
A user can choose case sensitive or case insensitive search. The value in this variable is used to identify if a search is case sensitive or not. The value must be either 'yes'(case sensitive search) or 'no'(case insensitive search).
Parameters:
newLongDescCaseSensitive - java.lang.String

setLongDescOperator

public void setLongDescOperator(java.lang.String newLongDescOperator)
A user can choose either 'like' or 'equal' as search operators. The value in this variable is used to store a user's choice. The value must be either 'LIKE'(for like operator) or 'EQUAL' (for equal operator).
Parameters:
newLongDescOperator - java.lang.String

setLongDescType

public void setLongDescType(java.lang.String newLongDescType)
A user can specify three types of search criteria All, Any, Exact Phrase. The value in this variable is used to store a user's search criteria. The value must be 'ALL'(for All search criteria), 'ANY'(for Any search criteria) and 'EXACT'(for Exact phrase criteria).
Parameters:
newLongDescType - java.lang.String

setMarkForDelete

public void setMarkForDelete(java.lang.String newMarkForDelete)
The value is used to search on markForDelete (category.markfordelete column).
Parameters:
newMarkForDelete - java.lang.String

setMarkForDeleteOperator

public void setMarkForDeleteOperator(java.lang.String newMarkForDeleteOperator)
A user can choose either 'like' or 'equal' as search operators. The value in this variable is used to store a user's choice. The value must be either 'LIKE'(for like operator) or 'EQUAL' (for equal operator).
Parameters:
newMarkForDeleteOperator - java.lang.String

setName

public void setName(java.lang.String newName)
The value of this variable is used in search based on Category name (Category.name column).
Parameters:
newName - java.lang.String

setNameCaseSensitive

public void setNameCaseSensitive(java.lang.String newNameCaseSensitive)
A user can choose case sensitive or case insensitive search. The value in this variable is used to identify if a search is case sensitive or not. The value must be either 'yes'(case sensitive search) or 'no'(case insensitive search).
Parameters:
newNameCaseSensitive - java.lang.String

setNameTermOperator

public void setNameTermOperator(java.lang.String newNameTermOperator)
A user can choose either 'like' or 'equal' as search operators. The value in this variable is used to store a user's choice. The value must be either 'LIKE'(for like operator) or 'EQUAL' (for equal operator).
Parameters:
newNameTermOperator - java.lang.String

setNameType

public void setNameType(java.lang.String newNameType)
A user can specify three types of search criteria All, Any, Exact Phrase. The value in this variable is used to store a user's search criteria. The value must be 'ALL'(for All search criteria), 'ANY'(for Any search criteria) and 'EXACT'(for Exact phrase criteria).
Parameters:
newNameType - java.lang.String

setOrderBy1

public void setOrderBy1(java.lang.String newOrderBy1)
Result set will be sorted by this attribute.
Parameters:
newOrderBy1 - java.lang.String

setOrderByOperator1

public void setOrderByOperator1(java.lang.String newOrderByOperator1)
Attributes can be sorted by ascending (default) or decending order.
Parameters:
newOrderByOperator1 - java.lang.String

setPredefinedAttributes

protected void setPredefinedAttributes()
Use rulequery to build the query predicate.
Specified by:
setPredefinedAttributes in class SearchBaseDataBean

setPublished

public void setPublished(java.lang.String newPublished)
The value is used to search on published (Catgrpdesc.published column).
Parameters:
newPublished - java.lang.String

setPublishedOperator

public void setPublishedOperator(java.lang.String newPublishedOperator)
A user can choose one of the following operators as search operators: =, <, >, !=, <=, >=. The value in this variable is used to store a user's choice. The value must be any one of the following: 'EQUAL,' 'NOTEQUAL,' 'GREATER,' 'LESS,' 'GREATER_EQUAL,' 'LESS_EQUAL.'
Parameters:
newPublishedOperator - java.lang.String

setResultCount

public void setResultCount(java.lang.String newResultCount)
Accessor generated by VAJ - do not modify.
Overrides:
setResultCount in class SearchBaseDataBean
Parameters:
newResultCount - java.lang.String

setResultList

public void setResultList(CategoryDataBean[] newResultList)
Search results as array of CategoryDataBean from resultSet variable.
Parameters:
newResultList - com.ibm.commerce.catalog.beans.CategoryDataBean[]

setResultName

public void setResultName(java.lang.String newResultName)
Column names for building a result set. See valid column names in AttributeInfoDictionary.initialize().
Parameters:
newResultName - java.lang.String

setResultSet

public void setResultSet(java.util.Vector newResultSet)
Search results as vector of vectors of strings containing rows with result set columns where first column must be Category ids.
Parameters:
newResultSet - java.util.Vector

setResultSetName

public void setResultSetName(java.lang.String newResultName)
Search results as vector of vectors of strings containing result set column names.

setShortDesc

public void setShortDesc(java.lang.String newShortDesc)
The value of this variable is used in search based on category shortdescription (Catgrpdesc. shortdescription column).
Parameters:
newShortDesc - java.lang.String

setShortDescCaseSensitive

public void setShortDescCaseSensitive(java.lang.String newShortDescCaseSensitive)
A user can choose case sensitive or case insensitive search. The value in this variable is used to identify if a search is case sensitive or not. The value must be either 'yes'(case sensitive search) or 'no'(case insensitive search).
Parameters:
newShortDescCaseSensitive - java.lang.String

setShortDescOperator

public void setShortDescOperator(java.lang.String newShortDescOperator)
A user can choose either 'like' or 'equal' as search operators. The value in this variable is used to store a user's choice. The value must be either 'LIKE'(for like operator) or 'EQUAL' (for equal operator).
Parameters:
newShortDescOperator - java.lang.String

setShortDescType

public void setShortDescType(java.lang.String newShortDescType)
A user can specify three types of search criteria All, Any, Exact Phrase. The value in this variable is used to store a user's search criteria. The value must be 'ALL'(for All search criteria),
Parameters:
newShortDescType - java.lang.String

setStoreId

public void setStoreId(java.lang.String newStoreId)
A user can specify the store to search on. It can be single store or multiple store. In case of multiple store each store has to be delimited by ','.
Parameters:
newStoreId - java.lang.String

setStoreIdOperator

public void setStoreIdOperator(java.lang.String newStoreIdOperator)
A user can choose one of the following operators as search operators: =, <, >, !=, <=, >=. The value in this variable is used to store a user's choice. The value must be any one of the following: 'EQUAL,' 'NOTEQUAL,' 'GREATER,' 'LESS,' 'GREATER_EQUAL,' 'LESS_EQUAL,' 'IN.'
Parameters:
newStoreIdOperator - java.lang.String

setUserId

public void setUserId(int newUserId)
The userId from command context.
Parameters:
newUserId - int