com.ibm.commerce.marketingcenter.events.objects
Interface CampaignStatisticsBeanFinderHelper


public interface CampaignStatisticsBeanFinderHelper

For each finder method, other than findByPrimaryKey and the finder methods generated for supporting associations, which is defined in the home interface, an SQL query string or a method declaration must be defined in this interface. For example, the home interface may contain the method: public java.util.Enumeration findGreaterThan(int threshold) throws java.rmi.RemoteException, javax.ejb.FinderException; The user may provide one of the following three forms in this interface: SELECT Custom Finder: Note: For compatibility with old code. Do not use this form for new development. public static final String findGreaterThanQueryString = "SELECT * FROM MYTABLE T1 WHERE T1.VALUE > ?"; WHERE Custom Finder: public static final String findGreaterThanWhereClause = "T1.VALUE > ?"; In case that there is no where clause in the SQL statement such as "SELECT * FROM MYTABLE", use a query string that always evaluates to true. For example, public static final String findAllWhereClause = "1 = 1"; Method Custom Finder: public java.sql.PreparedStatement findGreaterThan(int threshold) throws Exception; An implementation of this method must be provided in a class that follows these rules: 1. The name of the class is either FinderObject or the name of the class is specified in the environment properties of the enterprise bean. The name of the property must be CustomFinderClassName. The value of the property is the class name without a package name. 2. The class must be in the same package as the deployed code for the bean. 3. The class must extend com.ibm.vap.finders.VapEJSJDBCFinderObject and must implement this finder helper interface. This implementation will be referenced by the persister class generated when deployed code is generated.


Field Summary
static java.lang.String findAllOrderByClickCountWhereClause
           
static java.lang.String findAllOrderByMpeNameWhereClause
           
static java.lang.String findAllOrderByViewCountWhereClause
           
static java.lang.String findAllWhereClause
           
static java.lang.String findByInitiativeIdOrderByClickCountWhereClause
           
static java.lang.String findByInitiativeIdOrderByMpeNameWhereClause
           
static java.lang.String findByInitiativeIdOrderByViewCountWhereClause
           
static java.lang.String findByInitiativeIdWhereClause
           
static java.lang.String findByMpeIdOrderByClickCountWhereClause
           
static java.lang.String findByMpeIdOrderByMpeNameWhereClause
           
static java.lang.String findByMpeIdOrderByViewCountWhereClause
           
static java.lang.String findByMpeIdWhereClause
           
 

Field Detail

findAllOrderByClickCountWhereClause

public static final java.lang.String findAllOrderByClickCountWhereClause

findAllOrderByMpeNameWhereClause

public static final java.lang.String findAllOrderByMpeNameWhereClause

findAllOrderByViewCountWhereClause

public static final java.lang.String findAllOrderByViewCountWhereClause

findAllWhereClause

public static final java.lang.String findAllWhereClause

findByInitiativeIdOrderByClickCountWhereClause

public static final java.lang.String findByInitiativeIdOrderByClickCountWhereClause

findByInitiativeIdOrderByMpeNameWhereClause

public static final java.lang.String findByInitiativeIdOrderByMpeNameWhereClause

findByInitiativeIdOrderByViewCountWhereClause

public static final java.lang.String findByInitiativeIdOrderByViewCountWhereClause

findByInitiativeIdWhereClause

public static final java.lang.String findByInitiativeIdWhereClause

findByMpeIdOrderByClickCountWhereClause

public static final java.lang.String findByMpeIdOrderByClickCountWhereClause

findByMpeIdOrderByMpeNameWhereClause

public static final java.lang.String findByMpeIdOrderByMpeNameWhereClause

findByMpeIdOrderByViewCountWhereClause

public static final java.lang.String findByMpeIdOrderByViewCountWhereClause

findByMpeIdWhereClause

public static final java.lang.String findByMpeIdWhereClause