com.wm.app.tn.db
Class SimpleDocQuery

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

All Implemented Interfaces:

com.wm.data.IData

Direct Known Subclasses:

ComplexDocQuery

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

Simple queries on documents in the datastore. This class provides matching on envelope fields of the document (sender, receiver, doctype, etc.), and control over the results that are returned. Attributes will never be queried or returned by an SDQ. In general, setters will removed the associated criterion if handed a null value. For instance, setSender(null) will remove any sender criteria.

Field Summary

static java.lang.String	COMMENTS
static java.lang.String	CONVID
static java.lang.String	GROUPID
static java.lang.String	INTERNALID
static java.lang.String	MSGTYPE
static java.lang.String	NATIVEID
static java.lang.String	RECEIVERCORP
static java.lang.String	RECEIVERPROFILEGROUP
static java.lang.String	RECVRID
static java.lang.String	SENDERCORP
static java.lang.String	SENDERID
static java.lang.String	SENDERPROFILEGROUP
static java.lang.String	STATSYS
static java.lang.String	STATUSR
static java.lang.String	TASKSTATUS
static java.lang.String	TIMESTAMP
static java.lang.String	TYPENAME

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

SimpleDocQuery()
Create a SimpleDocQuery.

Method Summary

void	clearSortColumn() Deprecated. As of TN 7.0, replaced by clearSortColumns()
void	clearSortColumns() Clear sort order
static com.wm.data.IData	create() For internal use only
java.lang.Object	getComments()
java.lang.Object	getConversationId()
com.wm.data.IDataCursor	getCursor() For internal use only
java.lang.Object	getDocumentId()
java.lang.Object	getGroupId()
com.wm.data.IDataHashCursor	getHashCursor() For internal use only
com.wm.data.IDataIndexCursor	getIndexCursor() For internal use only
java.lang.Object	getInternalId()
java.lang.Object	getMessageType()
java.lang.Object	getReceiver()
java.lang.Object	getReceiverProfileGroup()
java.lang.Object	getRoutingStatus()
java.lang.Object	getSender()
java.lang.Object	getSenderProfileGroup()
com.wm.data.IDataSharedCursor	getSharedCursor() For internal use only
java.lang.String	getSortColumn() Deprecated. As of TN 7.0, replaced by getSortColumns()
java.lang.String[][]	getSortColumns() returns sort columns (may be null)
java.lang.Object	getTaskStatus()
java.sql.Timestamp[]	getTimeInterval()
int	getTimeIntervalType()
com.wm.data.IDataTreeCursor	getTreeCursor() For internal use only
java.lang.Object	getUserStatus()
java.util.Enumeration	getVisibleColumns(boolean agg) For internal use only
boolean	isCommentsVisible()
boolean	isConversationIdVisible()
boolean	isDocumentIdVisible()
boolean	isGroupIdVisible()
boolean	isMessageTypeVisible()
boolean	isReceiverProfileGroupVisible()
boolean	isReceiverVisible()
boolean	isRoutingStatusVisible()
boolean	isSenderProfileGroupVisible()
boolean	isSenderVisible()
boolean	isSortAscending() Deprecated. As of TN 7.0, replaced by setSortColumns(String[][])
boolean	isTaskStatusVisible()
boolean	isTimestampVisible()
boolean	isUserStatusVisible()
static void	main(java.lang.String[] args) For internal use only
void	preSql() For internal use only
void	setComments(java.lang.String comments) Search for documents with a specific comment
void	setComments(java.lang.String[][] opValue, boolean isORquery) Search for documents using multiple criterias on comment
void	setCommentsVisible(boolean b)
void	setConversationId(java.lang.String id) Search for documents with a particular conversation ID
void	setConversationId(java.lang.String[][] opValue, boolean isORquery) Search for documents using multiple criterias on conversation id.
void	setConversationIdVisible(boolean b)
void	setDaysAgo(int ago) Query by document timestamp, based on "number of days ago".
void	setDocumentId(java.lang.String id) Search for documents with a particular document ID
void	setDocumentId(java.lang.String[][] opValue, boolean isORquery) Search for documents using multiple criterias on document id.
void	setDocumentIdVisible(boolean b)
void	setGroupId(java.lang.String id) Search for documents with a particular group ID
void	setGroupId(java.lang.String[][] opValue, boolean isORquery) Search for documents using multiple criterias on group id.
void	setGroupIdVisible(boolean b)
void	setInternalId(java.lang.String id) Search for documents using internal id.
void	setInternalId(java.lang.String[][] opValue, boolean isORquery) Search for documents using multiple criterias on internal id.
void	setMessageType(java.lang.String typeId) Search for documents of a particular type
void	setMessageType(java.lang.String[] typeId) Search for documents with a group of types
void	setMessageType(java.lang.String[][] opValue, boolean isORquery) Search for documents using multiple criterias on doc types
void	setMessageTypeVisible(boolean b)
void	setReceiver(com.wm.data.IData criteria) Search for documents from a list of receiver ids or a profile sub query
void	setReceiver(ProfileQuery query) Search for documents from a group of receivers using a IN sub query e.g.
void	setReceiver(java.lang.String id) Search for documents for a single receiver
void	setReceiver(java.lang.String[] id) Search for documents for a group of receivers
void	setReceiverProfileGroup(java.lang.String[][] opValue, boolean isORquery) Search for documents using multiple criterias on Recevier Profile group.
void	setReceiverProfileGroupVisible(boolean b)
void	setReceiverVisible(boolean b)
void	setRecevierProfileGroup(java.lang.String receiverProfileGroup) Search for documents with a particular Recevier Profile group
void	setRoutingStatus(java.lang.String status) Search for documents in a particular routing status
void	setRoutingStatus(java.lang.String[] status) Search for documents with a group of routing statuses
void	setRoutingStatus(java.lang.String[][] opValue, boolean isORquery) Search for documents using multiple criterias on routing status.
void	setRoutingStatusVisible(boolean b)
void	setSender(com.wm.data.IData criteria) Search for documents from a list of sender ids or a profile sub query
void	setSender(ProfileQuery query) Search for documents from a group of senders using a profile sub query e.g.
void	setSender(java.lang.String id) Search for documents from a single sender.
void	setSender(java.lang.String[] id) Search for documents from a group of senders
void	setSenderProfileGroup(java.lang.String senderProfileGroup) Search for documents with a particular Sender Profile group
void	setSenderProfileGroup(java.lang.String[][] opValue, boolean isORquery) Search for documents using multiple criterias on Sender Profile group.
void	setSenderProfileGroupVisible(boolean b)
void	setSenderVisible(boolean b)
void	setSortColumn(java.lang.String col, boolean asc) Deprecated. As of TN 7.0, replaced by setSortColumns(String[][])
void	setSortColumns(java.lang.String[][] columnOrder) Set the sort columns and order for this query.
void	setTaskStatus(java.lang.String status) Search for documents based on task satus
void	setTaskStatus(java.lang.String[][] opValue, boolean isORquery) Search for documents using multiple criterias on task status
void	setTaskStatusVisible(boolean b)
void	setTimeInterval(int which) Set the time interval based on simple codes.
void	setTimeInterval(java.sql.Timestamp since, java.sql.Timestamp until) Set the time interval based on absolute times.
void	setTimestampVisible(boolean b)
void	setUserStatus(java.lang.String status) Search for documents in a particular user status
void	setUserStatus(java.lang.String[][] opValue, boolean isORquery) Search for documents using multiple criterias on user status.
void	setUserStatusVisible(boolean b)
java.lang.String	toSql()
java.lang.String	toSql(boolean agg) For internal use only
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

Methods inherited from class java.lang.Object

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

Field Detail

TIMESTAMP

public static final java.lang.String TIMESTAMP

See Also:

Constant Field Values

INTERNALID

public static final java.lang.String INTERNALID

See Also:

Constant Field Values

SENDERID

public static final java.lang.String SENDERID

See Also:

Constant Field Values

RECVRID

public static final java.lang.String RECVRID

See Also:

Constant Field Values

MSGTYPE

public static final java.lang.String MSGTYPE

See Also:

Constant Field Values

STATSYS

public static final java.lang.String STATSYS

See Also:

Constant Field Values

STATUSR

public static final java.lang.String STATUSR

See Also:

Constant Field Values

NATIVEID

public static final java.lang.String NATIVEID

See Also:

Constant Field Values

GROUPID

public static final java.lang.String GROUPID

See Also:

Constant Field Values

SENDERPROFILEGROUP

public static final java.lang.String SENDERPROFILEGROUP

See Also:

Constant Field Values

RECEIVERPROFILEGROUP

public static final java.lang.String RECEIVERPROFILEGROUP

See Also:

Constant Field Values

CONVID

public static final java.lang.String CONVID

See Also:

Constant Field Values

COMMENTS

public static final java.lang.String COMMENTS

See Also:

Constant Field Values

TASKSTATUS

public static final java.lang.String TASKSTATUS

See Also:

Constant Field Values

SENDERCORP

public static final java.lang.String SENDERCORP

See Also:

Constant Field Values

RECEIVERCORP

public static final java.lang.String RECEIVERCORP

See Also:

Constant Field Values

TYPENAME

public static final java.lang.String TYPENAME

See Also:

Constant Field Values

Constructor Detail

SimpleDocQuery

public SimpleDocQuery()

Create a SimpleDocQuery. The default query is

SELECT * FROM BizDoc

Method Detail

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

setInternalId

public void setInternalId(java.lang.String id)

Search for documents using internal id.

Parameters:

id - the internal id of the document to look for

setInternalId

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

Search for documents using multiple criterias on internal id.

Parameters:

opValue - is the operator and value pair in String[][] (e.g. {{Query.OP_COMP_CONTAINS, "123"}, {Query.OP_COMP_NEQ, "123456789012345678901234"}})

isORquery - should OR operator be used between these criterias?

setSender

public void setSender(java.lang.String id)

Search for documents from a single sender.

Parameters:

id - the id of the sender to look for

setSender

public void setSender(java.lang.String[] id)

Search for documents from a group of senders

Parameters:

id - the ids of the senders

setSender

public void setSender(ProfileQuery query)

Search for documents from a group of senders using a profile sub query e.g. WHERE SenderID IN (SELECT * FROM Partner)

Parameters:

query - the profile query that serves as the subquery in ()

setSender

public void setSender(com.wm.data.IData criteria)

Search for documents from a list of sender ids or a profile sub query

Parameters:

criteria - IData key="ids" value=String[] ids key="profileQuery" value=ProfileQuery query

setReceiver

public void setReceiver(java.lang.String id)

Search for documents for a single receiver

Parameters:

id - the id of the receiver to look for

setReceiver

public void setReceiver(java.lang.String[] id)

Search for documents for a group of receivers

Parameters:

id - the ids of the receivers

setReceiver

public void setReceiver(ProfileQuery query)

Search for documents from a group of receivers using a IN sub query e.g. WHERE ReceiverID IN (SELECT * FROM Partner)

Parameters:

query - the profile query that serves as the subquery in ()

setReceiver

public void setReceiver(com.wm.data.IData criteria)

Search for documents from a list of receiver ids or a profile sub query

Parameters:

criteria - IData key="ids" value=String[] ids key="profileQuery" value=ProfileQuery query

setMessageType

public void setMessageType(java.lang.String typeId)

Search for documents of a particular type

Parameters:

type - the type name to look for

contains - should this be a CONTAINS query (as opposed to a simple EQ)?

setMessageType

public void setMessageType(java.lang.String[] typeId)

Search for documents with a group of types

Parameters:

type - the type names to look for

setMessageType

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

Search for documents using multiple criterias on doc types

Parameters:

opValue - is the operator and value pair in String[][] (e.g. {{Query.OP_COMP_CONTAINS, "1234"}, {Query.OP_COMP_NEQ, "5678"}})

isORquery - should OR operator be used between these criterias?

setRoutingStatus

public void setRoutingStatus(java.lang.String status)

Search for documents in a particular routing status

Parameters:

status - the status to look for

contains - should this be a CONTAINS query (as opposed to a simple EQ)?

setRoutingStatus

public void setRoutingStatus(java.lang.String[] status)

Search for documents with a group of routing statuses

Parameters:

status - the statuses to look for

setRoutingStatus

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

Search for documents using multiple criterias on routing status.

Parameters:

opValue - is the operator and value pair in String[][] (e.g. {{Query.OP_COMP_CONTAINS, "Route"}, {Query.OP_COMP_NEQ, "Routing Complete"}})

isORquery - should OR operator be used between these criterias?

setUserStatus

public void setUserStatus(java.lang.String status)

Search for documents in a particular user status

Parameters:

status - the status to look for

setUserStatus

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

Search for documents using multiple criterias on user status.

Parameters:

opValue - is the operator and value pair in String[][] (e.g. {{Query.OP_COMP_CONTAINS, "Route"}, {Query.OP_COMP_NEQ, "Routing Complete"}})

isORquery - should OR operator be used between these criterias?

setDocumentId

public void setDocumentId(java.lang.String id)

Search for documents with a particular document ID

Parameters:

id - the ID to look for

setDocumentId

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

Search for documents using multiple criterias on document id.

Parameters:

opValue - is the operator and value pair in String[][] (e.g. {{Query.OP_COMP_CONTAINS, "123"}, {Query.OP_COMP_NEQ, "123456789012345678901234"}})

isORquery - should OR operator be used between these criterias?

setGroupId

public void setGroupId(java.lang.String id)

Search for documents with a particular group ID

Parameters:

id - the ID to look for

setGroupId

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

Search for documents using multiple criterias on group id.

Parameters:

opValue - is the operator and value pair in String[][] (e.g. {{Query.OP_COMP_CONTAINS, "123"}, {Query.OP_COMP_NEQ, "123456789012345678901234"}})

isORquery - should OR operator be used between these criterias?

setConversationId

public void setConversationId(java.lang.String id)

Search for documents with a particular conversation ID

Parameters:

id - the ID to look for

setConversationId

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

Search for documents using multiple criterias on conversation id.

Parameters:

opValue - is the operator and value pair in String[][] (e.g. {{Query.OP_COMP_CONTAINS, "123"}, {Query.OP_COMP_NEQ, "123456789012345678901234"}})

isORquery - should OR operator be used between these criterias?

setComments

public void setComments(java.lang.String comments)

Search for documents with a specific comment

Parameters:

comments - the Comments to look for

setComments

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

Search for documents using multiple criterias on comment

Parameters:

opValue - is the operator and value pair in String[][] (e.g. {{Query.OP_COMP_CONTAINS, "123"}, {Query.OP_COMP_NEQ, "123456789012345678901234"}})

isORquery - should OR operator be used between these criterias?

setTaskStatus

public void setTaskStatus(java.lang.String status)

Search for documents based on task satus

Parameters:

status - the task status to look for

setTaskStatus

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

Search for documents using multiple criterias on task status

Parameters:

opValue - is the operator and value pair in String[][] (e.g. {{Query.OP_COMP_CONTAINS, "123"}, {Query.OP_COMP_NEQ, "123456789012345678901234"}})

isORquery - should OR operator be used between these criterias?

setDaysAgo

public void setDaysAgo(int ago)

Query by document 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 since,
                            java.sql.Timestamp until)

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)

setSenderProfileGroup

public void setSenderProfileGroup(java.lang.String senderProfileGroup)

Search for documents with a particular Sender Profile group

Parameters:

senderProfileGroup - the ID to look for

setSenderProfileGroup

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

Search for documents using multiple criterias on Sender Profile group.

Parameters:

opValue - is the operator and value pair in String[][] (e.g. {{Query.OP_COMP_CONTAINS, "123"}, {Query.OP_COMP_NEQ, "123456789012345678901234"}})

isORquery - should OR operator be used between these criterias?

setRecevierProfileGroup

public void setRecevierProfileGroup(java.lang.String receiverProfileGroup)

Search for documents with a particular Recevier Profile group

Parameters:

senderProfileGroup - the ID to look for

setReceiverProfileGroup

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

Search for documents using multiple criterias on Recevier Profile group.

Parameters:

opValue - is the operator and value pair in String[][] (e.g. {{Query.OP_COMP_CONTAINS, "123"}, {Query.OP_COMP_NEQ, "123456789012345678901234"}})

isORquery - should OR operator be used between these criterias?

getInternalId

public java.lang.Object getInternalId()

Returns:

the internal id criterion (could be null, String or String[])

getSender

public java.lang.Object getSender()

Returns:

the sender criterion (could be null, String or String[])

getSenderProfileGroup

public java.lang.Object getSenderProfileGroup()

Returns:

the senderProfileGroup criterion (could be null, String or String[])

getReceiver

public java.lang.Object getReceiver()

Returns:

the receiver criterion (could be null, String or String[])

getReceiverProfileGroup

public java.lang.Object getReceiverProfileGroup()

Returns:

the receiverProfileGroup criterion (could be null, String or String[])

getMessageType

public java.lang.Object getMessageType()

Returns:

the msg. type criterion (could be null, String or String[])

getRoutingStatus

public java.lang.Object getRoutingStatus()

Returns:

the sys. status criterion (could be null, String or String[])

getUserStatus

public java.lang.Object getUserStatus()

Returns:

the user status criterion (could be null, String or IData)

getDocumentId

public java.lang.Object getDocumentId()

Returns:

the external document id criterion (could be null, String or IData)

getGroupId

public java.lang.Object getGroupId()

Returns:

the group id criterion (could be null, String or IData)

getConversationId

public java.lang.Object getConversationId()

Returns:

the conversation id criterion (could be null, String or IData)

getComments

public java.lang.Object getComments()

Returns:

the comments criterion (could be null, String or IData)

getTaskStatus

public java.lang.Object getTaskStatus()

Returns:

the task satus criterion (could be null, String or IData)

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)

setTimestampVisible

public void setTimestampVisible(boolean b)

setSenderVisible

public void setSenderVisible(boolean b)

setReceiverVisible

public void setReceiverVisible(boolean b)

setMessageTypeVisible

public void setMessageTypeVisible(boolean b)

setRoutingStatusVisible

public void setRoutingStatusVisible(boolean b)

setUserStatusVisible

public void setUserStatusVisible(boolean b)

setDocumentIdVisible

public void setDocumentIdVisible(boolean b)

setGroupIdVisible

public void setGroupIdVisible(boolean b)

setConversationIdVisible

public void setConversationIdVisible(boolean b)

setCommentsVisible

public void setCommentsVisible(boolean b)

setTaskStatusVisible

public void setTaskStatusVisible(boolean b)

setSenderProfileGroupVisible

public void setSenderProfileGroupVisible(boolean b)

setReceiverProfileGroupVisible

public void setReceiverProfileGroupVisible(boolean b)

isTimestampVisible

public boolean isTimestampVisible()

isSenderVisible

public boolean isSenderVisible()

isReceiverVisible

public boolean isReceiverVisible()

isMessageTypeVisible

public boolean isMessageTypeVisible()

isRoutingStatusVisible

public boolean isRoutingStatusVisible()

isUserStatusVisible

public boolean isUserStatusVisible()

isDocumentIdVisible

public boolean isDocumentIdVisible()

isGroupIdVisible

public boolean isGroupIdVisible()

isConversationIdVisible

public boolean isConversationIdVisible()

isCommentsVisible

public boolean isCommentsVisible()

isTaskStatusVisible

public boolean isTaskStatusVisible()

isSenderProfileGroupVisible

public boolean isSenderProfileGroupVisible()

isReceiverProfileGroupVisible

public boolean isReceiverProfileGroupVisible()

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: TIMESTAMP, SENDERID, 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

setSortColumn

public void setSortColumn(java.lang.String col,
                          boolean asc)

Deprecated. As of TN 7.0, replaced by setSortColumns(String[][])

getSortColumn

public java.lang.String getSortColumn()

Deprecated. As of TN 7.0, replaced by getSortColumns()

isSortAscending

public boolean isSortAscending()

Deprecated. As of TN 7.0, replaced by setSortColumns(String[][])

clearSortColumn

public void clearSortColumn()

Deprecated. As of TN 7.0, replaced by clearSortColumns()

preSql

public void preSql()

For internal use only

Overrides:

preSql in class Query

toSql

public java.lang.String toSql()

Overrides:

toSql in class Query

Returns:

the SQL statement generated by this query

toSql

public java.lang.String toSql(boolean agg)

For internal use only

getVisibleColumns

public java.util.Enumeration getVisibleColumns(boolean agg)

For internal use only

create

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

For internal use only

main

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

For internal use only

Throws:

java.lang.Exception