com.wm.app.tn.db
Class DeliveryJobQuery
java.lang.Object
com.wm.app.tn.db.Query
com.wm.app.tn.db.DeliveryJobQuery
- All Implemented Interfaces:
- com.wm.data.IData
public class DeliveryJobQuery
- extends Query
- implements com.wm.data.IData
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_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 |
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, setAlertTimeInterval, setDistinct, setExpiryTimeInterval, setIndentSql, setLastReminderInterval, setOR, setViewPermission, toSql |
Methods inherited from class java.lang.Object |
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
DELIVERY_JOBTYPE
public static java.lang.String DELIVERY_JOBTYPE
PROCESSINGRULE_JOBTYPE
public static java.lang.String PROCESSINGRULE_JOBTYPE
JOB_ID
public static final java.lang.String JOB_ID
- See Also:
- Constant Field Values
SRV_ID
public static final java.lang.String SRV_ID
- See Also:
- Constant Field Values
TIME_CREATED
public static final java.lang.String TIME_CREATED
- See Also:
- Constant Field Values
TIME_UPDATED
public static final java.lang.String TIME_UPDATED
- See Also:
- Constant Field Values
JOB_STAT
public static final java.lang.String JOB_STAT
- See Also:
- Constant Field Values
TTW
public static final java.lang.String TTW
- See Also:
- Constant Field Values
RETRIES
public static final java.lang.String RETRIES
- See Also:
- Constant Field Values
RETRY_LIMIT
public static final java.lang.String RETRY_LIMIT
- See Also:
- Constant Field Values
RETRY_FACTOR
public static final java.lang.String RETRY_FACTOR
- See Also:
- Constant Field Values
T_STAT
public static final java.lang.String T_STAT
- See Also:
- Constant Field Values
T_STAT_MSG
public static final java.lang.String T_STAT_MSG
- See Also:
- Constant Field Values
T_TIME
public static final java.lang.String T_TIME
- See Also:
- Constant Field Values
DOC_ID
public static final java.lang.String DOC_ID
- See Also:
- Constant Field Values
SVC_NAME
public static final java.lang.String SVC_NAME
- See Also:
- Constant Field Values
PART_ID
public static final java.lang.String PART_ID
- See Also:
- Constant Field Values
JOB_TYPE
public static final java.lang.String JOB_TYPE
- See Also:
- Constant Field Values
SENDER_ID
public static final java.lang.String SENDER_ID
- See Also:
- Constant Field Values
QUEUE_NAME
public static final java.lang.String QUEUE_NAME
- 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
SENDER_CORP
public static final java.lang.String SENDER_CORP
- See Also:
- Constant Field Values
SENDER_UNIT
public static final java.lang.String SENDER_UNIT
- See Also:
- Constant Field Values
FIELDS
public static final java.lang.String[] FIELDS
JOB_ID_IDX
public static final int JOB_ID_IDX
- See Also:
- Constant Field Values
SRV_IDX
public static final int SRV_IDX
- See Also:
- Constant Field Values
TIME_CREATED_IDX
public static final int TIME_CREATED_IDX
- See Also:
- Constant Field Values
TIME_UPDATED_IDX
public static final int TIME_UPDATED_IDX
- See Also:
- Constant Field Values
JOB_STAT_IDX
public static final int JOB_STAT_IDX
- See Also:
- Constant Field Values
TTW_IDX
public static final int TTW_IDX
- See Also:
- Constant Field Values
RETRIES_IDX
public static final int RETRIES_IDX
- See Also:
- Constant Field Values
RETRY_LIMIT_IDX
public static final int RETRY_LIMIT_IDX
- See Also:
- Constant Field Values
RETRY_FACTOR_IDX
public static final int RETRY_FACTOR_IDX
- See Also:
- Constant Field Values
T_STAT_IDX
public static final int T_STAT_IDX
- See Also:
- Constant Field Values
T_STAT_MSG_IDX
public static final int T_STAT_MSG_IDX
- See Also:
- Constant Field Values
T_TIME_IDX
public static final int T_TIME_IDX
- See Also:
- Constant Field Values
SVC_NAME_IDX
public static final int SVC_NAME_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
JOB_TYPE_IDX
public static final int JOB_TYPE_IDX
- See Also:
- Constant Field Values
SENDER_ID_IDX
public static final int SENDER_ID_IDX
- See Also:
- Constant Field Values
QUEUE_NAME_IDX
public static final int QUEUE_NAME_IDX
- See Also:
- Constant Field Values
VISIBLE_COLS
public static final java.lang.String[] VISIBLE_COLS
TIME_TYPE
public static final java.lang.String TIME_TYPE
- See Also:
- Constant Field Values
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
TABLES_RIGHT
public static final java.lang.String[][] TABLES_RIGHT
DeliveryJobQuery
public DeliveryJobQuery()
setInternalDocId
public void setInternalDocId(java.lang.String id)
setJobId
public void setJobId(java.lang.String id)
setPartnerId
public void setPartnerId(java.lang.String id)
setPartnerId
public void setPartnerId(java.lang.String[][] opValue,
boolean isORquery)
setSenderId
public void setSenderId(java.lang.String id)
setQueueName
public void setQueueName(java.lang.String qName)
setQueueName
public void setQueueName(java.lang.String[][] opValue,
boolean isORquery)
setServerId
public void setServerId(java.lang.String id)
setJobStatus
public void setJobStatus(java.lang.String status)
setJobStatus
public void setJobStatus(java.lang.String[][] opValue,
boolean isORquery)
setJobType
public void setJobType(java.lang.String type)
setJobType
public void setJobType(java.lang.String[][] opValue,
boolean isORquery)
setServiceName
public void setServiceName(java.lang.String name)
setServiceName
public void setServiceName(java.lang.String[][] opValue,
boolean isORquery)
setTimeInterval
public void setTimeInterval(int which)
setTimeInterval
public void setTimeInterval(java.sql.Timestamp since,
java.sql.Timestamp until)
- Overrides:
setTimeInterval
in class Query
getInternalDocId
public java.lang.String getInternalDocId()
getJobId
public java.lang.String getJobId()
getJobType
public java.lang.Object getJobType()
getPartnerId
public java.lang.Object getPartnerId()
getSenderId
public java.lang.String getSenderId()
getQueueName
public java.lang.Object getQueueName()
getServerId
public java.lang.String getServerId()
getJobStatus
public java.lang.Object getJobStatus()
getServiceName
public java.lang.Object getServiceName()
getTimeInterval
public java.sql.Timestamp[] getTimeInterval()
getTimeIntervalType
public int getTimeIntervalType()
setServerIdVisible
public void setServerIdVisible(boolean b)
setTimeCreatedVisible
public void setTimeCreatedVisible(boolean b)
setTimeUpdatedVisible
public void setTimeUpdatedVisible(boolean b)
setJobStatusVisible
public void setJobStatusVisible(boolean b)
setTimeToWaitVisible
public void setTimeToWaitVisible(boolean b)
setRetriesVisible
public void setRetriesVisible(boolean b)
setRetryLimitVisible
public void setRetryLimitVisible(boolean b)
setRetryFactorVisible
public void setRetryFactorVisible(boolean b)
setTransportationStatusVisible
public void setTransportationStatusVisible(boolean b)
setStatusMessageVisible
public void setStatusMessageVisible(boolean b)
setTransportationTimeVisible
public void setTransportationTimeVisible(boolean b)
setServiceNameVisible
public void setServiceNameVisible(boolean b)
setInternalDocIdVisible
public void setInternalDocIdVisible(boolean b)
setPartnerIdVisible
public void setPartnerIdVisible(boolean b)
setJobTypeVisible
public void setJobTypeVisible(boolean b)
setSenderIdVisible
public void setSenderIdVisible(boolean b)
setQueueNameVisible
public void setQueueNameVisible(boolean b)
isJobIdVisible
public boolean isJobIdVisible()
isServerIdVisible
public boolean isServerIdVisible()
isTimeCreatedVisible
public boolean isTimeCreatedVisible()
isTimeUpdatedVisible
public boolean isTimeUpdatedVisible()
isJobStatusVisible
public boolean isJobStatusVisible()
isTimeToWaitVisible
public boolean isTimeToWaitVisible()
isRetriesVisible
public boolean isRetriesVisible()
isRetryLimitVisible
public boolean isRetryLimitVisible()
isRetryFactorVisible
public boolean isRetryFactorVisible()
isTransportationStatusVisible
public boolean isTransportationStatusVisible()
isStatusMessageVisible
public boolean isStatusMessageVisible()
isTransportationTimeVisible
public boolean isTransportationTimeVisible()
isServiceNameVisible
public boolean isServiceNameVisible()
isInternalDocIdVisible
public boolean isInternalDocIdVisible()
isPartnerIdVisible
public boolean isPartnerIdVisible()
isJobTypeVisible
public boolean isJobTypeVisible()
isSenderIdVisible
public boolean isSenderIdVisible()
isQueueNameVisible
public boolean isQueueNameVisible()
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: JOB_ID, SRV_ID, 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. {{TIMESTAMP, "ASC"}, {SENDERID, "DESC"}} )
getSortColumns
public java.lang.String[][] getSortColumns()
- returns sort columns (may be null)
clearSortColumns
public void clearSortColumns()
- Clear sort order
toPreDeleteSql
public java.lang.String toPreDeleteSql()
toDeletingSql
public java.lang.String toDeletingSql()
preSql
public void preSql()
- For internal use only
- Overrides:
preSql
in class Query
getCursor
public com.wm.data.IDataCursor getCursor()
- Specified by:
getCursor
in interface com.wm.data.IData
getSharedCursor
public com.wm.data.IDataSharedCursor getSharedCursor()
- Specified by:
getSharedCursor
in interface com.wm.data.IData
getIndexCursor
public com.wm.data.IDataIndexCursor getIndexCursor()
- Specified by:
getIndexCursor
in interface com.wm.data.IData
getTreeCursor
public com.wm.data.IDataTreeCursor getTreeCursor()
- Specified by:
getTreeCursor
in interface com.wm.data.IData
getHashCursor
public com.wm.data.IDataHashCursor getHashCursor()
- Specified by:
getHashCursor
in interface com.wm.data.IData
create
public static com.wm.data.IData create()
main
public static void main(java.lang.String[] args)