com.wm.app.tn.db
Class TPAQuery

java.lang.Object
  extended by com.wm.app.tn.db.Query
      extended by com.wm.app.tn.db.TPAQuery
All Implemented Interfaces:
com.wm.data.IData

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

Simple queries on TPA in the datastore. This class provides matching on the fields of a TPA (senderID, receiverID, agreementID, etc.), and control over the results that are returned. tpaData will never be queried. 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 int AGREEMENT_ID_IDX
           
static java.lang.String AGREEMENTID
           
static java.lang.String CREATED
           
static int CREATED_IDX
           
static int DATA_SCHEMA_IDX
           
static java.lang.String DATASCHEMA
           
static java.lang.String DESCRIPTION
           
static int DESCRIPTION_IDX
           
static int EXPORT_SERVICE_IDX
           
static java.lang.String EXPORTSERVICE
           
static int INIT_SERVICE_IDX
           
static java.lang.String INITSERVICE
           
static java.lang.String[] KEYS
           
static java.lang.String LASTMODIFIED
           
static int LASTMODIFIED_IDX
           
static int RECEIVER_ID_IDX
           
static java.lang.String RECEIVERID
           
static java.lang.String RECEIVERNAME
           
static java.lang.String RECEIVERUNITNAME
           
static int SENDER_ID_IDX
           
static java.lang.String SENDERID
           
static java.lang.String SENDERNAME
           
static java.lang.String SENDERUNITNAME
           
static java.lang.String STATUS
           
static int STATUS_IDX
           
static int TPA_ID_IDX
           
static java.lang.String TPAID
           
 
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
 
Constructor Summary
TPAQuery()
           
 
Method Summary
 void clearSortColumns()
          Clear sort order
static com.wm.data.IData create()
          For internal use only
 java.lang.String getAgreementID()
           
 com.wm.data.IDataCursor getCursor()
          For internal use only
 java.lang.String getDataSchema()
           
 java.lang.String getDescription()
           
 java.lang.String getExportService()
           
 com.wm.data.IDataHashCursor getHashCursor()
          For internal use only
 com.wm.data.IDataIndexCursor getIndexCursor()
          For internal use only
 java.lang.String getInitService()
           
 java.lang.String[] getReceiverID()
           
 java.lang.String[] getReceiverName()
           
 java.lang.String[] getSenderID()
           
 java.lang.String[] getSenderName()
           
 com.wm.data.IDataSharedCursor getSharedCursor()
          For internal use only
 java.lang.String getSortColumn()
           
 java.lang.String[][] getSortColumns()
          returns sort columns (may be null)
 java.lang.String getStatus()
           
 java.sql.Timestamp[] getTimeInterval()
           
 int getTimeIntervalType()
           
 java.lang.String getTpaID()
           
 com.wm.data.IDataTreeCursor getTreeCursor()
          For internal use only
 java.lang.String[] getVisibleColumns()
          For internal use only
 boolean isAgreementIDVisible()
           
 boolean isDataschemaVisible()
           
 boolean isDescriptionVisible()
           
 boolean isLastModifiedVisible()
           
 boolean isReceiverIDVisible()
           
 boolean isReceiverNameVisible()
           
 boolean isReceiverUnitNameVisible()
           
 boolean isSenderIDVisible()
           
 boolean isSenderNameVisible()
           
 boolean isSenderUnitNameVisible()
           
 boolean isSortAscending()
           
 boolean isStatusVisible()
           
 boolean isTPAIDVisible()
           
 void preSql()
          For internal use only
 void setAgreementID(java.lang.String agreementID)
          Search for TPAs of a particular agrrementID
 void setAgreementID(java.lang.String[] agreementID)
          Search for TPAs with a group of types
 void setAgreementID(java.lang.String[][] opVal, boolean isORquery)
          Search for TPA using multiple criteria on Agreement ID.
 void setAgreementIDVisible(boolean b)
           
 void setDataSchema(java.lang.String dataSchema)
          Search for TPAs in a particular dataSchema
 void setDataSchema(java.lang.String[][] opVal, boolean isORquery)
          Search for TPA using multiple criteria on Data Schema.
 void setDataschemaVisible(boolean b)
           
 void setDaysAgo(int ago)
          Query by TPA timestamp, based on "number of days ago".
 void setDescription(java.lang.String[][] opVal, boolean isORquery)
          Search for TPA using multiple criteria on Description.
 void setDescriptionVisible(boolean b)
           
 void setExportService(java.lang.String exportService)
          Search for TPAs with a particular exportService
 void setInitService(java.lang.String initService)
          Search for TPAs with a particular initService
 void setLastModifiedVisible(boolean b)
           
 void setReceiverID(java.lang.String id)
          Search for TPAs for a single receiver
 void setReceiverID(java.lang.String[] id)
          Search for TPAs for a group of receivers
 void setReceiverID(java.lang.String[][] opVal, boolean isORquery)
          Search for TPA using multiple criteria on Receiver ID.
 void setReceiverIDVisible(boolean b)
           
 void setReceiverName(java.lang.String name)
          Search for TPAs from a single Receiver name.
 void setReceiverName(java.lang.String[] name)
          Search for TPAs from a group of Receivers
 void setReceiverName(java.lang.String[][] opVal, boolean isORquery)
          Search for TPA using multiple criteria on Receiver NAME.
 void setReceiverNameVisible(boolean b)
           
 void setReceiverUnitNameVisible(boolean b)
           
 void setSenderID(java.lang.String id)
          Search for TPAs from a single sender.
 void setSenderID(java.lang.String[] id)
          Search for TPAs from a group of senders
 void setSenderID(java.lang.String[][] opVal, boolean isORquery)
          Search for TPA using multiple criteria on Sender ID.
 void setSenderIDVisible(boolean b)
           
 void setSenderName(java.lang.String name)
          Search for TPAs from a single sender name.
 void setSenderName(java.lang.String[] name)
          Search for TPAs from a group of senders
 void setSenderName(java.lang.String[][] opVal, boolean isORquery)
          Search for TPA using multiple criteria on Sender NAME.
 void setSenderNameVisible(boolean b)
           
 void setSenderUnitNameVisible(boolean b)
           
 void setSortColumn(java.lang.String col, boolean asc)
          Set the sort column and order for this query.
 void setSortColumns(java.lang.String[][] columnOrder)
          Set the sort columns and order for this query.
 void setStatus(java.lang.String status)
          Search for TPAs in a particular status
 void setStatus(java.lang.String[][] opVal, boolean isORquery)
          Search for TPA using multiple criteria on STATUS.
 void setStatusVisible(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 setTpaID(java.lang.String s)
          Search for TPA from internal TPA ID.
 void setTpaID(java.lang.String[][] opVal, boolean isORquery)
          Search for TPA using multiple criteria on internal TPA ID.
 void setTPAIDVisible(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, setAlertTimeInterval, setDistinct, setExpiryTimeInterval, setIndentSql, setLastReminderInterval, setOR, setViewPermission
 
Methods inherited from class java.lang.Object
equals, getClass, hashCode, notify, notifyAll, wait, wait, wait
 

Field Detail

SENDERID

public static final java.lang.String SENDERID
See Also:
Constant Field Values

SENDERNAME

public static final java.lang.String SENDERNAME
See Also:
Constant Field Values

SENDERUNITNAME

public static final java.lang.String SENDERUNITNAME
See Also:
Constant Field Values

RECEIVERID

public static final java.lang.String RECEIVERID
See Also:
Constant Field Values

RECEIVERNAME

public static final java.lang.String RECEIVERNAME
See Also:
Constant Field Values

RECEIVERUNITNAME

public static final java.lang.String RECEIVERUNITNAME
See Also:
Constant Field Values

AGREEMENTID

public static final java.lang.String AGREEMENTID
See Also:
Constant Field Values

CREATED

public static final java.lang.String CREATED
See Also:
Constant Field Values

LASTMODIFIED

public static final java.lang.String LASTMODIFIED
See Also:
Constant Field Values

STATUS

public static final java.lang.String STATUS
See Also:
Constant Field Values

DATASCHEMA

public static final java.lang.String DATASCHEMA
See Also:
Constant Field Values

EXPORTSERVICE

public static final java.lang.String EXPORTSERVICE
See Also:
Constant Field Values

INITSERVICE

public static final java.lang.String INITSERVICE
See Also:
Constant Field Values

DESCRIPTION

public static final java.lang.String DESCRIPTION
See Also:
Constant Field Values

TPAID

public static final java.lang.String TPAID
See Also:
Constant Field Values

SENDER_ID_IDX

public static final int SENDER_ID_IDX
See Also:
Constant Field Values

RECEIVER_ID_IDX

public static final int RECEIVER_ID_IDX
See Also:
Constant Field Values

AGREEMENT_ID_IDX

public static final int AGREEMENT_ID_IDX
See Also:
Constant Field Values

CREATED_IDX

public static final int CREATED_IDX
See Also:
Constant Field Values

STATUS_IDX

public static final int STATUS_IDX
See Also:
Constant Field Values

DATA_SCHEMA_IDX

public static final int DATA_SCHEMA_IDX
See Also:
Constant Field Values

EXPORT_SERVICE_IDX

public static final int EXPORT_SERVICE_IDX
See Also:
Constant Field Values

INIT_SERVICE_IDX

public static final int INIT_SERVICE_IDX
See Also:
Constant Field Values

DESCRIPTION_IDX

public static final int DESCRIPTION_IDX
See Also:
Constant Field Values

TPA_ID_IDX

public static final int TPA_ID_IDX
See Also:
Constant Field Values

LASTMODIFIED_IDX

public static final int LASTMODIFIED_IDX
See Also:
Constant Field Values

KEYS

public static final java.lang.String[] KEYS
Constructor Detail

TPAQuery

public TPAQuery()
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

toString

public java.lang.String toString()
For internal use only

Overrides:
toString in class java.lang.Object

setSenderID

public void setSenderID(java.lang.String id)
Search for TPAs from a single sender.

Parameters:
id - the id of the sender to look for

setSenderID

public void setSenderID(java.lang.String[] id)
Search for TPAs from a group of senders

Parameters:
id - the ids of the senders

setSenderID

public void setSenderID(java.lang.String[][] opVal,
                        boolean isORquery)
Search for TPA using multiple criteria on Sender ID.

Parameters:
opValue - is the operator and value pair in String[][] (e.g. {{Query.OP_COMP_EQ, "AAA"}, {Query.OP_COMP_NEQ, "BBB"}})
isORquery - should OR operator be used between these criteria (e.g. if isORquery = true, the where clause will be WHERE bd.TypeID = 'AAA' OR TPA.SenderID <> 'BBB' else if isORquery = false WHERE bd.TypeID = 'AAA' AND TPA.SenderID <> 'BBB' )

setSenderName

public void setSenderName(java.lang.String name)
Search for TPAs from a single sender name.

Parameters:
name - the name of the sender to look for

setSenderName

public void setSenderName(java.lang.String[] name)
Search for TPAs from a group of senders

Parameters:
name - the name of the senders

setSenderName

public void setSenderName(java.lang.String[][] opVal,
                          boolean isORquery)
Search for TPA using multiple criteria on Sender NAME.

Parameters:
opValue - is the operator and value pair in String[][] (e.g. {{Query.OP_COMP_EQ, "AAA"}, {Query.OP_COMP_NEQ, "BBB"}})
isORquery - should OR operator be used between these criteria (e.g. if isORquery = true, the where clause will be WHERE bd.TypeID = 'AAA' OR s.CorporationName <> 'BBB' else if isORquery = false WHERE bd.TypeID = 'AAA' AND s.CorporationName <> 'BBB' )

setReceiverID

public void setReceiverID(java.lang.String id)
Search for TPAs for a single receiver

Parameters:
id - the id of the receiver to look for

setReceiverID

public void setReceiverID(java.lang.String[] id)
Search for TPAs for a group of receivers

Parameters:
id - the ids of the receivers

setReceiverID

public void setReceiverID(java.lang.String[][] opVal,
                          boolean isORquery)
Search for TPA using multiple criteria on Receiver ID.

Parameters:
opValue - is the operator and value pair in String[][] (e.g. {{Query.OP_COMP_EQ, "AAA"}, {Query.OP_COMP_NEQ, "BBB"}})
isORquery - should OR operator be used between these criteria (e.g. if isORquery = true, the where clause will be WHERE bd.TypeID = 'AAA' OR TPA.ReceiverID <> 'BBB' else if isORquery = false WHERE bd.TypeID = 'AAA' AND TPA.ReceiverID <> 'BBB' )

setReceiverName

public void setReceiverName(java.lang.String name)
Search for TPAs from a single Receiver name.

Parameters:
name - the name of the sender to look for

setReceiverName

public void setReceiverName(java.lang.String[] name)
Search for TPAs from a group of Receivers

Parameters:
name - the name of the Receivers

setReceiverName

public void setReceiverName(java.lang.String[][] opVal,
                            boolean isORquery)
Search for TPA using multiple criteria on Receiver NAME.

Parameters:
opValue - is the operator and value pair in String[][] (e.g. {{Query.OP_COMP_EQ, "AAA"}, {Query.OP_COMP_NEQ, "BBB"}})
isORquery - should OR operator be used between these criteria (e.g. if isORquery = true, the where clause will be WHERE bd.TypeID = 'AAA' OR r.CorporationName <> 'BBB' else if isORquery = false WHERE bd.TypeID = 'AAA' AND r.CorporationName <> 'BBB' )

setAgreementID

public void setAgreementID(java.lang.String agreementID)
Search for TPAs of a particular agrrementID

Parameters:
agreementID - the agreementID to look for

setAgreementID

public void setAgreementID(java.lang.String[] agreementID)
Search for TPAs with a group of types

Parameters:
agreementID - the agreementIDs to look for

setAgreementID

public void setAgreementID(java.lang.String[][] opVal,
                           boolean isORquery)
Search for TPA using multiple criteria on Agreement ID.

Parameters:
opValue - is the operator and value pair in String[][] (e.g. {{Query.OP_COMP_EQ, "AAA"}, {Query.OP_COMP_NEQ, "BBB"}})
isORquery - should OR operator be used between these criteria (e.g. if isORquery = true, the where clause will be WHERE bd.TypeID = 'AAA' OR TPA.AgreementID <> 'BBB' else if isORquery = false WHERE bd.TypeID = 'AAA' AND TPA.AgreementID <> 'BBB' )

setDataSchema

public void setDataSchema(java.lang.String dataSchema)
Search for TPAs in a particular dataSchema

Parameters:
dataSchema - the data schema to look for

setDataSchema

public void setDataSchema(java.lang.String[][] opVal,
                          boolean isORquery)
Search for TPA using multiple criteria on Data Schema.

Parameters:
opValue - is the operator and value pair in String[][] (e.g. {{Query.OP_COMP_EQ, "AAA"}, {Query.OP_COMP_NEQ, "BBB"}})
isORquery - should OR operator be used between these criteria (e.g. if isORquery = true, the where clause will be WHERE bd.TypeID = 'AAA' OR TPA.DataSchema <> 'BBB' else if isORquery = false WHERE bd.TypeID = 'AAA' AND TPA.DataSchema <> 'BBB' )

setStatus

public void setStatus(java.lang.String status)
Search for TPAs in a particular status

Parameters:
status - the status to look for

setStatus

public void setStatus(java.lang.String[][] opVal,
                      boolean isORquery)
Search for TPA using multiple criteria on STATUS.

Parameters:
opValue - is the operator and value pair in String[][] (e.g. {{Query.OP_COMP_EQ, "AAA"}, {Query.OP_COMP_NEQ, "BBB"}})
isORquery - should OR operator be used between these criteria (e.g. if isORquery = true, the where clause will be WHERE bd.TypeID = 'AAA' OR TPA.Status <> 'BBB' else if isORquery = false WHERE bd.TypeID = 'AAA' AND TPA.Status <> 'BBB' )

setExportService

public void setExportService(java.lang.String exportService)
Search for TPAs with a particular exportService

Parameters:
exportService - the exportService to look for

setInitService

public void setInitService(java.lang.String initService)
Search for TPAs with a particular initService

Parameters:
initService - the initService to look for

setDescription

public void setDescription(java.lang.String[][] opVal,
                           boolean isORquery)
Search for TPA using multiple criteria on Description.

Parameters:
opValue - is the operator and value pair in String[][] (e.g. {{Query.OP_COMP_EQ, "AAA"}, {Query.OP_COMP_NEQ, "BBB"}})
isORquery - should OR operator be used between these criteria (e.g. if isORquery = true, the where clause will be WHERE bd.TypeID = 'AAA' OR TPA.Description <> 'BBB' else if isORquery = false WHERE bd.TypeID = 'AAA' AND TPA.Description <> 'BBB' )

setTpaID

public void setTpaID(java.lang.String s)
Search for TPA from internal TPA ID.


setTpaID

public void setTpaID(java.lang.String[][] opVal,
                     boolean isORquery)
Search for TPA using multiple criteria on internal TPA ID.

Parameters:
opValue - is the operator and value pair in String[][] (e.g. {{Query.OP_COMP_EQ, "AAA"}, {Query.OP_COMP_NEQ, "BBB"}})
isORquery - should OR operator be used between these criteria (e.g. if isORquery = true, the where clause will be WHERE bd.TypeID = 'AAA' OR tpa.TPAID <> 'BBB' else if isORquery = false WHERE bd.TypeID = 'AAA' AND tpa.TPAID <> 'BBB' )

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 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)

getSenderID

public java.lang.String[] getSenderID()
Returns:
the sender criterion (could be null or String[])

getSenderName

public java.lang.String[] getSenderName()
Returns:
the sender name criterion (could be null or String[])

getReceiverID

public java.lang.String[] getReceiverID()
Returns:
the receiver criterion (could be null or String[])

getReceiverName

public java.lang.String[] getReceiverName()
Returns:
the receiver criterion (could be null or String[])

getAgreementID

public java.lang.String getAgreementID()
Returns:
the agreementID criterion (could be null, String or String[])

getStatus

public java.lang.String getStatus()
Returns:
the status criterion (could be null, String or String[])

getDataSchema

public java.lang.String getDataSchema()
Returns:
the dataSchema criterion (could be null)

getExportService

public java.lang.String getExportService()
Returns:
the exportService criterion (could be null)

getInitService

public java.lang.String getInitService()
Returns:
the initService criterion (could be null)

getDescription

public java.lang.String getDescription()
Returns:
the Description criterion (could be null)

getTpaID

public java.lang.String getTpaID()
Returns:
the TPAID criterion (could be null)

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)

setSenderIDVisible

public void setSenderIDVisible(boolean b)

setSenderNameVisible

public void setSenderNameVisible(boolean b)

setSenderUnitNameVisible

public void setSenderUnitNameVisible(boolean b)

setReceiverIDVisible

public void setReceiverIDVisible(boolean b)

setReceiverNameVisible

public void setReceiverNameVisible(boolean b)

setReceiverUnitNameVisible

public void setReceiverUnitNameVisible(boolean b)

setAgreementIDVisible

public void setAgreementIDVisible(boolean b)

setLastModifiedVisible

public void setLastModifiedVisible(boolean b)

setStatusVisible

public void setStatusVisible(boolean b)

setDataschemaVisible

public void setDataschemaVisible(boolean b)

setDescriptionVisible

public void setDescriptionVisible(boolean b)

setTPAIDVisible

public void setTPAIDVisible(boolean b)

isSenderIDVisible

public boolean isSenderIDVisible()

isSenderNameVisible

public boolean isSenderNameVisible()

isSenderUnitNameVisible

public boolean isSenderUnitNameVisible()

isReceiverIDVisible

public boolean isReceiverIDVisible()

isReceiverNameVisible

public boolean isReceiverNameVisible()

isReceiverUnitNameVisible

public boolean isReceiverUnitNameVisible()

isAgreementIDVisible

public boolean isAgreementIDVisible()

isLastModifiedVisible

public boolean isLastModifiedVisible()

isStatusVisible

public boolean isStatusVisible()

isDataschemaVisible

public boolean isDataschemaVisible()

isDescriptionVisible

public boolean isDescriptionVisible()

isTPAIDVisible

public boolean isTPAIDVisible()

getVisibleColumns

public java.lang.String[] getVisibleColumns()
For internal use only


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)
Set the sort column 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.


getSortColumn

public java.lang.String getSortColumn()

isSortAscending

public boolean isSortAscending()

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


preSql

public void preSql()
For internal use only

Overrides:
preSql in class Query

create

public static com.wm.data.IData create()
For internal use only