com.wm.app.tn.db
Class TPAQuery

java.lang.Object
  com.wm.app.tn.db.Query
      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