com.wm.app.tn.db
Class RouteQuery

java.lang.Object
  com.wm.app.tn.db.Query
      com.wm.app.tn.db.RouteQuery

All Implemented Interfaces:

com.wm.data.IData

public class RouteQuery
extends Query
implements com.wm.data.IData

Author:

svo To change the template for this generated type comment go to Window>Preferences>Java>Code Generation>Code and Comments

Field Summary

static int	COL_DISABLED
static int	COL_DOC_TYPES
static int	COL_INDEX
static int	COL_MOD_TIME
static int	COL_RECEIVERS
static int	COL_RULE_NAME
static int	COL_SENDERS
static int	COL_USER_STATUSES
static java.lang.String	DISPLAY_COLS
static java.lang.String	DOC_TYPES
static java.lang.String	KEY_MAP
static java.lang.String	ORD
static java.lang.String	ORD_FROM
static java.lang.String	ORD_TO
static java.lang.String	RECEIVERGROUPS
static java.lang.String	RECEIVERS
static java.lang.String	RULE_NAME
static java.lang.String	SEARCH_ORD
static java.lang.String	SENDERGROUPS
static java.lang.String	SENDERS
static java.lang.String	TIME
static java.lang.String	TIME_AFTER
static int	TIME_ANYTIME
static java.lang.String	TIME_BEFORE
static int	TIME_CUSTOM
static java.lang.String	TIME_INTERVAL
static int	TIME_LAST_7_DAYS
static int	TIME_LAST_MONTH
static int	TIME_LAST_WEEK
static int	TIME_THIS_MONTH
static int	TIME_THIS_WEEK
static int	TIME_TODAY
static int	TIME_YESTERDAY
static int	TIME_YTD
static java.lang.String	USER_STATUSES

Fields inherited from class com.wm.app.tn.db.Query

ACTLOG_EVENT_TIMESTAMP, BDTYPE_LASTMODIFIED, DJOB_TIME_CREATED, DJOB_TIME_UPDATED, DOC_TIMESTAMP, FN_AVG, FN_MAX, FN_MIN, FN_SUM, INVITE_ALERTDATE, INVITE_EXPIRYDATE, INVITE_LASTSENT, OP_COMP_AFTER, OP_COMP_BEFORE, OP_COMP_CONTAINS, OP_COMP_EQ, OP_COMP_GEQ, OP_COMP_GT, OP_COMP_INCLUDES, OP_COMP_LEQ, OP_COMP_LT, OP_COMP_NEQ, OP_MATCHES, OP_TEST_NOT_NULL, OP_TEST_NULL, TIME_NEXT_10_MIN, TIME_NEXT_12_HOURS, TIME_NEXT_24_HOURS, TIME_NEXT_3_HOURS, TIME_NEXT_30_MIN, TIME_NEXT_6_HOURS, TIME_NEXT_HOUR, TIME_TOMORROW, TPA_CREATED, TPA_LASTMODIFIED, TYPE_DATE, TYPE_NUMBER, TYPE_STRING

Constructor Summary

RouteQuery()

Method Summary

static com.wm.data.IData	create() For internal use only
java.lang.Object	get(java.lang.String key)
com.wm.data.IDataCursor	getCursor() For internal use only
int[]	getDisplayColumns()
java.util.Vector	getDocTypes()
com.wm.data.IDataHashCursor	getHashCursor() For internal use only
com.wm.data.IDataIndexCursor	getIndexCursor() For internal use only
java.util.Hashtable	getMap()
java.lang.String	getOrdinalFrom()
java.lang.String	getOrdinalTo()
java.util.Vector	getReceiverGroups()
java.util.Vector	getReceivers()
java.lang.String	getRuleName()
java.util.Vector	getSearchOrder()
java.util.Vector	getSenderGroups()
java.util.Vector	getSenders()
com.wm.data.IDataSharedCursor	getSharedCursor() For internal use only
java.sql.Timestamp[]	getTimeInterval()
int	getTimeIntervalType()
com.wm.data.IDataTreeCursor	getTreeCursor() For internal use only
java.util.Vector	getUserStatuses()
boolean	isDocTypesSelected()
boolean	isModTimeSelected()
boolean	isOrdinalRangeSelected()
boolean	isReceiversSelected()
boolean	isRuleNameSelected()
boolean	isSendersSelected()
boolean	isUserStatusesSelected()
void	setDaysAgo(int ago) Query by TPA timestamp, based on "number of days ago".
void	setDisplayColumns(int[] cols)
void	setDocTypes(java.util.Vector docTypes)
void	setOrdinalFrom(java.lang.String from)
void	setOrdinalTo(java.lang.String to)
void	setReceiverGroups(java.util.Vector receiverGrps)
void	setReceivers(java.util.Vector receivers)
void	setRuleName(java.lang.String ruleName)
void	setSearchOrder(java.util.Vector v)
void	setSenderGroups(java.util.Vector senderGrps)
void	setSenders(java.util.Vector senders)
void	setTimeInterval(int which) Set the time interval based on simple codes.
void	setTimeInterval(java.sql.Timestamp begin, java.sql.Timestamp end) Set the time interval based on absolute times.
void	setUserStatuses(java.util.Vector userStatuses)
java.lang.String	toString() For internal use only

Methods inherited from class com.wm.app.tn.db.Query

beginningOfDay, escapeString, evaluate, evaluateListConditions, generateClause, generateClause, generateColumnList, generateComp, generateComp, generateComp, generateListComp, generateNumericClause, generateStringLit, generateStringLit, generateTimeInterval, generateTimestampLiteral, getIntervalType, getUnique, isDateTime, isDistinct, isIndentSql, isOR, preSql, searchMWS, setAlertTimeInterval, setDistinct, setExpiryTimeInterval, setIndentSql, setLastReminderInterval, setOR, setSortColumns, setViewPermission, toSql

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, wait, wait, wait

Field Detail

SENDERS

public static final java.lang.String SENDERS

See Also:

Constant Field Values

RECEIVERS

public static final java.lang.String RECEIVERS

See Also:

Constant Field Values

SENDERGROUPS

public static final java.lang.String SENDERGROUPS

See Also:

Constant Field Values

RECEIVERGROUPS

public static final java.lang.String RECEIVERGROUPS

See Also:

Constant Field Values

DOC_TYPES

public static final java.lang.String DOC_TYPES

See Also:

Constant Field Values

USER_STATUSES

public static final java.lang.String USER_STATUSES

See Also:

Constant Field Values

RULE_NAME

public static final java.lang.String RULE_NAME

See Also:

Constant Field Values

TIME

public static final java.lang.String TIME

See Also:

Constant Field Values

ORD

public static final java.lang.String ORD

See Also:

Constant Field Values

TIME_INTERVAL

public static final java.lang.String TIME_INTERVAL

See Also:

Constant Field Values

TIME_AFTER

public static final java.lang.String TIME_AFTER

See Also:

Constant Field Values

TIME_BEFORE

public static final java.lang.String TIME_BEFORE

See Also:

Constant Field Values

ORD_FROM

public static final java.lang.String ORD_FROM

See Also:

Constant Field Values

ORD_TO

public static final java.lang.String ORD_TO

See Also:

Constant Field Values

KEY_MAP

public static final java.lang.String KEY_MAP

See Also:

Constant Field Values

SEARCH_ORD

public static final java.lang.String SEARCH_ORD

See Also:

Constant Field Values

TIME_CUSTOM

public static final int TIME_CUSTOM

See Also:

Constant Field Values

TIME_ANYTIME

public static final int TIME_ANYTIME

See Also:

Constant Field Values

TIME_TODAY

public static final int TIME_TODAY

See Also:

Constant Field Values

TIME_YESTERDAY

public static final int TIME_YESTERDAY

See Also:

Constant Field Values

TIME_LAST_7_DAYS

public static final int TIME_LAST_7_DAYS

See Also:

Constant Field Values

TIME_THIS_WEEK

public static final int TIME_THIS_WEEK

See Also:

Constant Field Values

TIME_LAST_WEEK

public static final int TIME_LAST_WEEK

See Also:

Constant Field Values

TIME_THIS_MONTH

public static final int TIME_THIS_MONTH

See Also:

Constant Field Values

TIME_LAST_MONTH

public static final int TIME_LAST_MONTH

See Also:

Constant Field Values

TIME_YTD

public static final int TIME_YTD

See Also:

Constant Field Values

DISPLAY_COLS

public static final java.lang.String DISPLAY_COLS

See Also:

Constant Field Values

COL_INDEX

public static final int COL_INDEX

See Also:

Constant Field Values

COL_SENDERS

public static final int COL_SENDERS

See Also:

Constant Field Values

COL_RECEIVERS

public static final int COL_RECEIVERS

See Also:

Constant Field Values

COL_DOC_TYPES

public static final int COL_DOC_TYPES

See Also:

Constant Field Values

COL_USER_STATUSES

public static final int COL_USER_STATUSES

See Also:

Constant Field Values

COL_RULE_NAME

public static final int COL_RULE_NAME

See Also:

Constant Field Values

COL_MOD_TIME

public static final int COL_MOD_TIME

See Also:

Constant Field Values

COL_DISABLED

public static final int COL_DISABLED

See Also:

Constant Field Values

Constructor Detail

RouteQuery

public RouteQuery()

Method Detail

getCursor

public com.wm.data.IDataCursor getCursor()

For internal use only

Specified by:

getCursor in interface com.wm.data.IData

getIndexCursor

public com.wm.data.IDataIndexCursor getIndexCursor()

For internal use only

Specified by:

getIndexCursor in interface com.wm.data.IData

getTreeCursor

public com.wm.data.IDataTreeCursor getTreeCursor()

For internal use only

Specified by:

getTreeCursor in interface com.wm.data.IData

getHashCursor

public com.wm.data.IDataHashCursor getHashCursor()

For internal use only

Specified by:

getHashCursor in interface com.wm.data.IData

getSharedCursor

public com.wm.data.IDataSharedCursor getSharedCursor()

For internal use only

Specified by:

getSharedCursor in interface com.wm.data.IData

create

public static com.wm.data.IData create()

For internal use only

get

public final java.lang.Object get(java.lang.String key)

toString

public java.lang.String toString()

For internal use only

Overrides:

toString in class java.lang.Object

setSenders

public void setSenders(java.util.Vector senders)

setSenderGroups

public void setSenderGroups(java.util.Vector senderGrps)

setReceivers

public void setReceivers(java.util.Vector receivers)

setReceiverGroups

public void setReceiverGroups(java.util.Vector receiverGrps)

setDocTypes

public void setDocTypes(java.util.Vector docTypes)

setUserStatuses

public void setUserStatuses(java.util.Vector userStatuses)

setDaysAgo

public void setDaysAgo(int ago)

Query by TPA timestamp, based on "number of days ago". To clear this field, call this method with -1.

Parameters:

ago - how many 24-hour days to go back (0 is till midnight last night, 1 is 24 hours ago, 2 is 48 hours ago, and so on)

setTimeInterval

public void setTimeInterval(int which)

Set the time interval based on simple codes.

Parameters:

which - the interval to use

setTimeInterval

public void setTimeInterval(java.sql.Timestamp begin,
                            java.sql.Timestamp end)

Set the time interval based on absolute times.

Overrides:

setTimeInterval in class Query

Parameters:

since - the start of the interval (null means open-ended)

until - the end of the interval (null means open-ended)

setRuleName

public void setRuleName(java.lang.String ruleName)

setOrdinalFrom

public void setOrdinalFrom(java.lang.String from)

setOrdinalTo

public void setOrdinalTo(java.lang.String to)

setSearchOrder

public void setSearchOrder(java.util.Vector v)

setDisplayColumns

public void setDisplayColumns(int[] cols)

getSenders

public java.util.Vector getSenders()

getSenderGroups

public java.util.Vector getSenderGroups()

getReceivers

public java.util.Vector getReceivers()

getReceiverGroups

public java.util.Vector getReceiverGroups()

getDocTypes

public java.util.Vector getDocTypes()

getUserStatuses

public java.util.Vector getUserStatuses()

getTimeInterval

public java.sql.Timestamp[] getTimeInterval()

Returns:

the time interval (one or both of the elts. could be null)

getTimeIntervalType

public int getTimeIntervalType()

Returns:

the code for the time interval (could be -1)

getRuleName

public java.lang.String getRuleName()

getOrdinalFrom

public java.lang.String getOrdinalFrom()

getOrdinalTo

public java.lang.String getOrdinalTo()

getMap

public java.util.Hashtable getMap()

getSearchOrder

public java.util.Vector getSearchOrder()

getDisplayColumns

public int[] getDisplayColumns()

isSendersSelected

public boolean isSendersSelected()

isReceiversSelected

public boolean isReceiversSelected()

isDocTypesSelected

public boolean isDocTypesSelected()

isUserStatusesSelected

public boolean isUserStatusesSelected()

isRuleNameSelected

public boolean isRuleNameSelected()

isModTimeSelected

public boolean isModTimeSelected()

isOrdinalRangeSelected

public boolean isOrdinalRangeSelected()