com.wm.app.tn.db
Class EventQuery

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

All Implemented Interfaces:

com.wm.data.IData

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

Simple queries on events in the activity log. These queries can also be turned into SQL DELETE statements, allowing you to delete events from the database to clean it up.

Field Summary

static java.lang.String	ACTIVITYLOG_ID
static int	ACTIVITYLOG_ID_IDX
static java.lang.String	B2B_USER
static int	B2B_USER_ID
static java.lang.String	BRIEF_MSG
static int	BRIEF_MSG_IDX
static int	CONV_ID_IDX
static java.lang.String	DOC_ID
static int	DOC_ID_IDX
static java.lang.String	DOCTYPE_ID
static int	DOCTYPE_ID_IDX
static java.lang.String	DOCTYPE_NAME
static java.lang.String	EVENT_CLASS
static int	EVENT_CLASS_IDX
static java.lang.String	EVENT_TIMESTAMP
static int	EVENT_TIMESTAMP_IDX
static java.lang.String	EVENT_TYPE
static int	EVENT_TYPE_IDX
static java.lang.String	FULL_MSG
static int	FULL_MSG_IDX
static java.lang.String	INST_ID
static java.lang.String	PART_CORP
static java.lang.String	PART_ID
static int	PART_ID_IDX
static java.lang.String	PART_UNIT
static java.lang.String	RULE_ID
static java.lang.String	RULE_NAME
static java.lang.String	STEP_ID
static java.lang.String	TIME_SINCE
static java.lang.String	TIME_TYPE
static java.lang.String	TIME_UNTIL
static java.lang.String[]	VISIBLE_COLS

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, 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_TEST_NOT_NULL, OP_TEST_NULL, TIME_ANYTIME, TIME_CUSTOM, TIME_LAST_7_DAYS, TIME_LAST_MONTH, TIME_LAST_WEEK, 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_THIS_MONTH, TIME_THIS_WEEK, TIME_TODAY, TIME_TOMORROW, TIME_YESTERDAY, TIME_YTD, TPA_CREATED, TPA_LASTMODIFIED, TYPE_DATE, TYPE_NUMBER, TYPE_STRING

Constructor Summary

EventQuery()
Create an EventQuery.

Method Summary

void	clearSortColumns() Clear sort order
static com.wm.data.IData	create() For internal use only
java.lang.String	getActivityLogID()
java.lang.Object	getB2BUser()
java.lang.Object	getBriefMessage()
com.wm.data.IDataCursor	getCursor() For internal use only
java.lang.Object	getEventClass()
java.lang.Object	getEventType()
java.lang.Object	getFullMessage()
com.wm.data.IDataHashCursor	getHashCursor() For internal use only
com.wm.data.IDataIndexCursor	getIndexCursor() For internal use only
java.lang.String	getRelatedConversationID() Deprecated. use getRelatedInstanceID instead
java.lang.String	getRelatedDocID()
java.lang.String	getRelatedDocTypeID()
java.lang.String	getRelatedInstanceID()
java.lang.Object	getRelatedPartnerID()
java.lang.String	getRelatedRuleID()
java.lang.String	getRelatedStepID()
com.wm.data.IDataSharedCursor	getSharedCursor() For internal use only
java.lang.String[][]	getSortColumns() returns sort columns (may be null)
java.sql.Timestamp[]	getTimeInterval()
int	getTimeIntervalType()
com.wm.data.IDataTreeCursor	getTreeCursor() For internal use only
java.lang.String[]	getVisibleColumns()
boolean	isActivityLogIdVisible()
boolean	isB2BUserVisible()
boolean	isBriefMsgVisible()
boolean	isDocIdVisible()
boolean	isDocTypeIdVisible()
boolean	isEventClassVisible()
boolean	isEventTypeVisible()
boolean	isFullMsgVisible()
boolean	isInstIdVisible()
boolean	isPartIdVisible()
boolean	isRuleIdVisible()
boolean	isStepIdVisible()
boolean	isTimestampVisible()
static void	main(java.lang.String[] args) For internal use only
void	preSql() For internal use only
void	setActivityLogID(java.lang.String id) Set unique activity log id for this query
void	setActivityLogID(java.lang.String[] ids) Set an array of activity log id for this query
void	setActivityLogIdVisible(boolean b)
void	setB2BUser(java.lang.String usr) Set related B2B user for this query
void	setB2BUser(java.lang.String[][] opValue, boolean isORquery) Set related B2B user names for this query
void	setB2BUserVisible(boolean b)
void	setBriefMessage(java.lang.String msg) Set brief message for this query
void	setBriefMessage(java.lang.String[][] opValue, boolean isORquery) Set brief messages for this query
void	setBriefMsgVisible(boolean b)
void	setDocIdVisible(boolean b)
void	setDocTypeIdVisible(boolean b)
void	setEventClass(java.lang.String cls) Set event class for this query
void	setEventClass(java.lang.String[][] opValue, boolean isORquery) Set event classes for this query
void	setEventClassVisible(boolean b)
void	setEventType(int type) Set event type for this query (-1 to clear)
void	setEventType(java.lang.String[][] opValue, boolean isORquery) Set event types for this query
void	setEventTypeVisible(boolean b)
void	setFullMessage(java.lang.String msg) Set full message for this query
void	setFullMessage(java.lang.String[][] opValue, boolean isORquery) Set full messages for this query
void	setFullMsgVisible(boolean b)
void	setInstIdVisible(boolean b)
void	setPartIdVisible(boolean b)
void	setRelatedConversationID(java.lang.String id) Deprecated. use setRelatedInstanceID instead
void	setRelatedDocID(java.lang.String id) Set related doc ID for this query
void	setRelatedDocTypeID(java.lang.String[] ids) Set related DocType ID for this query.
void	setRelatedDocTypeID(java.lang.String[][] opValue, boolean isORquery) Set related DocType ID for this query.
void	setRelatedInstanceID(java.lang.String id) Set related Instance ID for this query
void	setRelatedPartnerID(java.lang.String id) Set related partner ID for this query
void	setRelatedPartnerID(java.lang.String[] ids) Set related partner ID for this query.
void	setRelatedPartnerID(java.lang.String[][] opValue, boolean isORquery) Set related partner ID for this query.
void	setRelatedRuleID(java.lang.String[] ids) Set related Processing Rule ID for this query.
void	setRelatedRuleID(java.lang.String[][] opValue, boolean isORquery) Set related Processing Rule ID for this query.
void	setRelatedStepID(java.lang.String id) Set related Setp ID for this query
void	setRuleIdVisible(boolean b)
void	setSortColumns(java.lang.String[][] columnOrder) Set the sort columns and order for this query.
void	setStepIdVisible(boolean b)
void	setTimeInterval(int which) Set time interval for this query (see TIME_ constants in Query)
void	setTimeInterval(java.sql.Timestamp since, java.sql.Timestamp until) Set custom time interval for this query
void	setTimestampVisible(boolean b)
java.lang.String	toDeletingSql()
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, searchMWS, setDistinct, setIndentSql, setOR, setViewPermission, toSql

Methods inherited from class java.lang.Object

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

Field Detail

EVENT_TYPE

public static final java.lang.String EVENT_TYPE

See Also:

Constant Field Values

EVENT_CLASS

public static final java.lang.String EVENT_CLASS

See Also:

Constant Field Values

BRIEF_MSG

public static final java.lang.String BRIEF_MSG

See Also:

Constant Field Values

FULL_MSG

public static final java.lang.String FULL_MSG

See Also:

Constant Field Values

DOC_ID

public static final java.lang.String DOC_ID

See Also:

Constant Field Values

PART_ID

public static final java.lang.String PART_ID

See Also:

Constant Field Values

INST_ID

public static final java.lang.String INST_ID

See Also:

Constant Field Values

STEP_ID

public static final java.lang.String STEP_ID

See Also:

Constant Field Values

B2B_USER

public static final java.lang.String B2B_USER

See Also:

Constant Field Values

ACTIVITYLOG_ID

public static final java.lang.String ACTIVITYLOG_ID

See Also:

Constant Field Values

EVENT_TIMESTAMP

public static final java.lang.String EVENT_TIMESTAMP

See Also:

Constant Field Values

PART_CORP

public static final java.lang.String PART_CORP

See Also:

Constant Field Values

PART_UNIT

public static final java.lang.String PART_UNIT

See Also:

Constant Field Values

DOCTYPE_ID

public static final java.lang.String DOCTYPE_ID

See Also:

Constant Field Values

DOCTYPE_NAME

public static final java.lang.String DOCTYPE_NAME

See Also:

Constant Field Values

RULE_ID

public static final java.lang.String RULE_ID

See Also:

Constant Field Values

RULE_NAME

public static final java.lang.String RULE_NAME

See Also:

Constant Field Values

EVENT_TIMESTAMP_IDX

public static final int EVENT_TIMESTAMP_IDX

See Also:

Constant Field Values

EVENT_TYPE_IDX

public static final int EVENT_TYPE_IDX

See Also:

Constant Field Values

EVENT_CLASS_IDX

public static final int EVENT_CLASS_IDX

See Also:

Constant Field Values

BRIEF_MSG_IDX

public static final int BRIEF_MSG_IDX

See Also:

Constant Field Values

FULL_MSG_IDX

public static final int FULL_MSG_IDX

See Also:

Constant Field Values

DOC_ID_IDX

public static final int DOC_ID_IDX

See Also:

Constant Field Values

PART_ID_IDX

public static final int PART_ID_IDX

See Also:

Constant Field Values

CONV_ID_IDX

public static final int CONV_ID_IDX

See Also:

Constant Field Values

B2B_USER_ID

public static final int B2B_USER_ID

See Also:

Constant Field Values

ACTIVITYLOG_ID_IDX

public static final int ACTIVITYLOG_ID_IDX

See Also:

Constant Field Values

DOCTYPE_ID_IDX

public static final int DOCTYPE_ID_IDX

See Also:

Constant Field Values

VISIBLE_COLS

public static final java.lang.String[] VISIBLE_COLS

TIME_SINCE

public static final java.lang.String TIME_SINCE

See Also:

Constant Field Values

TIME_UNTIL

public static final java.lang.String TIME_UNTIL

See Also:

Constant Field Values

TIME_TYPE

public static final java.lang.String TIME_TYPE

See Also:

Constant Field Values

Constructor Detail

EventQuery

public EventQuery()

Create an EventQuery. The default query is

SELECT * FROM ActivityLog

Method Detail

setEventType

public void setEventType(int type)

Set event type for this query (-1 to clear)

setEventType

public void setEventType(java.lang.String[][] opValue,
                         boolean isORquery)

Set event types for this query

setEventClass

public void setEventClass(java.lang.String cls)

Set event class for this query

setEventClass

public void setEventClass(java.lang.String[][] opValue,
                          boolean isORquery)

Set event classes for this query

setBriefMessage

public void setBriefMessage(java.lang.String msg)

Set brief message for this query

setBriefMessage

public void setBriefMessage(java.lang.String[][] opValue,
                            boolean isORquery)

Set brief messages for this query

setFullMessage

public void setFullMessage(java.lang.String msg)

Set full message for this query

setFullMessage

public void setFullMessage(java.lang.String[][] opValue,
                           boolean isORquery)

Set full messages for this query

setRelatedDocID

public void setRelatedDocID(java.lang.String id)

Set related doc ID for this query

setRelatedPartnerID

public void setRelatedPartnerID(java.lang.String id)

Set related partner ID for this query

setRelatedPartnerID

public void setRelatedPartnerID(java.lang.String[] ids)

Set related partner ID for this query. Accepts a String array containing partner ids

setRelatedPartnerID

public void setRelatedPartnerID(java.lang.String[][] opValue,
                                boolean isORquery)

Set related partner ID for this query. Added to handle conditions like Partner ID is blank, etc in addition to query based on list of Partner IDs. Added for TRAXs 1-1ORX7L and 1-1ORA08

setRelatedConversationID

public void setRelatedConversationID(java.lang.String id)

Deprecated. use setRelatedInstanceID instead

setRelatedInstanceID

public void setRelatedInstanceID(java.lang.String id)

Set related Instance ID for this query

setRelatedStepID

public void setRelatedStepID(java.lang.String id)

Set related Setp ID for this query

setB2BUser

public void setB2BUser(java.lang.String usr)

Set related B2B user for this query

setB2BUser

public void setB2BUser(java.lang.String[][] opValue,
                       boolean isORquery)

Set related B2B user names for this query

setActivityLogID

public void setActivityLogID(java.lang.String id)

Set unique activity log id for this query

setActivityLogID

public void setActivityLogID(java.lang.String[] ids)

Set an array of activity log id for this query

setTimeInterval

public void setTimeInterval(int which)

Set time interval for this query (see TIME_ constants in Query)

setTimeInterval

public void setTimeInterval(java.sql.Timestamp since,
                            java.sql.Timestamp until)

Set custom time interval for this query

Overrides:

setTimeInterval in class Query

setRelatedDocTypeID

public void setRelatedDocTypeID(java.lang.String[] ids)

Set related DocType ID for this query. Accepts a String array containing partner ids

setRelatedDocTypeID

public void setRelatedDocTypeID(java.lang.String[][] opValue,
                                boolean isORquery)

Set related DocType ID for this query. Added to handle conditions like DocType ID is blank, etc in addition to query based on list of DocType IDs.

setRelatedRuleID

public void setRelatedRuleID(java.lang.String[] ids)

Set related Processing Rule ID for this query. Accepts a String array containing partner ids

setRelatedRuleID

public void setRelatedRuleID(java.lang.String[][] opValue,
                             boolean isORquery)

Set related Processing Rule ID for this query. Added to handle conditions like DocType ID is blank, etc in addition to query based on list of DocType IDs.

getEventType

public java.lang.Object getEventType()

Returns:

event type for this query (-1 if none)

getEventClass

public java.lang.Object getEventClass()

Returns:

event class for this query (null if none)

getBriefMessage

public java.lang.Object getBriefMessage()

Returns:

brief message for this query (null if none)

getFullMessage

public java.lang.Object getFullMessage()

Returns:

full message for this query (null if none)

getRelatedDocID

public java.lang.String getRelatedDocID()

Returns:

related doc ID for this query (null if none)

getRelatedPartnerID

public java.lang.Object getRelatedPartnerID()

Returns:

related partner ID for this query (null if none)

getRelatedConversationID

public java.lang.String getRelatedConversationID()

Deprecated. use getRelatedInstanceID instead

getRelatedInstanceID

public java.lang.String getRelatedInstanceID()

Returns:

related Instance ID for this query (null if none)

getRelatedStepID

public java.lang.String getRelatedStepID()

Returns:

related Step ID for this query (null if none)

getB2BUser

public java.lang.Object getB2BUser()

Returns:

related B2B user for this query (null if none)

getActivityLogID

public java.lang.String getActivityLogID()

Returns:

ActivityLogID for this query

getTimeInterval

public java.sql.Timestamp[] getTimeInterval()

Returns:

time interval for this query ( { from, to } )

getTimeIntervalType

public int getTimeIntervalType()

Returns:

time interval type for this query

getRelatedDocTypeID

public java.lang.String getRelatedDocTypeID()

Returns:

related doctype id for this query

getRelatedRuleID

public java.lang.String getRelatedRuleID()

Returns:

related Rule id for this query

setTimestampVisible

public void setTimestampVisible(boolean b)

setEventTypeVisible

public void setEventTypeVisible(boolean b)

setEventClassVisible

public void setEventClassVisible(boolean b)

setBriefMsgVisible

public void setBriefMsgVisible(boolean b)

setFullMsgVisible

public void setFullMsgVisible(boolean b)

setDocIdVisible

public void setDocIdVisible(boolean b)

setPartIdVisible

public void setPartIdVisible(boolean b)

setInstIdVisible

public void setInstIdVisible(boolean b)

setStepIdVisible

public void setStepIdVisible(boolean b)

setB2BUserVisible

public void setB2BUserVisible(boolean b)

setActivityLogIdVisible

public void setActivityLogIdVisible(boolean b)

setDocTypeIdVisible

public void setDocTypeIdVisible(boolean b)

setRuleIdVisible

public void setRuleIdVisible(boolean b)

isTimestampVisible

public boolean isTimestampVisible()

isEventTypeVisible

public boolean isEventTypeVisible()

isEventClassVisible

public boolean isEventClassVisible()

isBriefMsgVisible

public boolean isBriefMsgVisible()

isFullMsgVisible

public boolean isFullMsgVisible()

isDocIdVisible

public boolean isDocIdVisible()

isPartIdVisible

public boolean isPartIdVisible()

isInstIdVisible

public boolean isInstIdVisible()

isStepIdVisible

public boolean isStepIdVisible()

isB2BUserVisible

public boolean isB2BUserVisible()

isActivityLogIdVisible

public boolean isActivityLogIdVisible()

isDocTypeIdVisible

public boolean isDocTypeIdVisible()

isRuleIdVisible

public boolean isRuleIdVisible()

getVisibleColumns

public java.lang.String[] getVisibleColumns()

setSortColumns

public void setSortColumns(java.lang.String[][] columnOrder)

Set the sort columns and order for this query. Make sure to use one of the constants above: EVENT_TIMESTAMP, EVENT_TYPE, etc. Trying to sort on a column that's not visible will be ignored.

Overrides:

setSortColumns in class Query

Parameters:

columnOrder - takes column names and sort orders (e.g. {{EVENT_TIMESTAMP, "ASC"}, {EVENT_TYPE, "DESC"}} )

getSortColumns

public java.lang.String[][] getSortColumns()

returns sort columns (may be null)

clearSortColumns

public void clearSortColumns()

Clear sort order

toDeletingSql

public java.lang.String toDeletingSql()

Returns:

SQL DELETE version of this query

preSql

public void preSql()

For internal use only

Overrides:

preSql in class Query

getCursor

public com.wm.data.IDataCursor getCursor()

For internal use only

Specified by:

getCursor 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

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

toString

public java.lang.String toString()

For internal use only

Overrides:

toString in class java.lang.Object

create

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

For internal use only

main

public static void main(java.lang.String[] args)

For internal use only