|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Objectcom.wm.app.tn.db.Query
com.wm.app.tn.db.BDTypeQuery
public class BDTypeQuery
Field Summary | |
---|---|
static java.lang.String |
ATTRIBUTEID
|
static java.lang.String |
BD_TBL
|
static java.lang.String |
BDT_ATTR_TBL
|
static java.lang.String |
BIZDOCTYPEATTRIBUTE_TBL
|
static java.lang.String |
BIZDOCTYPEDEF_TBL
|
static java.lang.String |
COL_TYPE
|
static java.lang.String |
DELETED
|
static java.lang.String |
EXTRACTEDATTRIBUTE
|
static java.lang.String |
INCL_UNKNOWN
|
static java.lang.String |
TIMESTAMP
|
static java.lang.String |
TYPE
|
static java.lang.String |
TYPEDESCRIPTION
|
static java.lang.String |
TYPEID
|
static java.lang.String |
TYPENAME
|
static java.lang.String |
VIEW_PERMISSION
|
Constructor Summary | |
---|---|
BDTypeQuery()
Default query is "select * from documenttypedef". |
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 |
com.wm.data.IDataCursor |
getCursor()
|
java.lang.Object |
getDeleted()
|
java.lang.Object |
getExtractedAttributes()
|
com.wm.data.IDataHashCursor |
getHashCursor()
For internal use only |
com.wm.data.IDataIndexCursor |
getIndexCursor()
For internal use only |
com.wm.data.IDataSharedCursor |
getSharedCursor()
|
java.lang.String |
getSortColumn()
Deprecated. As of TN 7.0, replaced by getSortColumns() |
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.Object |
getType()
|
java.lang.Object |
getTypeDescription()
|
java.lang.Object |
getTypeID()
|
java.lang.Object |
getTypeName()
|
java.lang.String[] |
getVisibleColumns()
For internal use only |
boolean |
isDeletedVisible()
|
boolean |
isSortAscending()
Deprecated. As of TN 7.0, replaced by setSortColumns(String[][]) |
boolean |
isTimestampVisible()
|
boolean |
isTypeDescriptionVisible()
|
boolean |
isTypeIDVisible()
|
boolean |
isTypeNameVisible()
|
boolean |
isTypeVisible()
|
void |
preSql()
For internal use only |
void |
setDeleted(java.lang.String s)
Search for doctype based on deleted. |
void |
setDeleted(java.lang.String[][] opVal,
boolean isORquery)
Search for doctype using multiple criteria on type description. |
void |
setDeletedVisible(boolean b)
|
void |
setExtractedAttributes(java.lang.String s)
Search for doctype from extracted attributes. |
void |
setExtractedAttributes(java.lang.String[][] opVal,
boolean isORquery)
Search for doctype using multiple criteria on ExtractedAttribute(s). |
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 |
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 |
setType(java.lang.String s)
Search for doctype from Type (Unknown - 0, XML - 1, FF - 2, EDI - 3). |
void |
setType(java.lang.String[][] opVal,
boolean isORquery)
Search for doctype using multiple criteria on type. |
void |
setTypeDescription(java.lang.String s)
Search for doctype from type description. |
void |
setTypeDescription(java.lang.String[][] opVal,
boolean isORquery)
Search for doctype using multiple criteria on type description. |
void |
setTypeDescriptionVisible(boolean b)
|
void |
setTypeID(java.lang.String s)
Search for doctype from type name. |
void |
setTypeID(java.lang.String[][] opVal,
boolean isORquery)
Search for doctype using multiple criteria on type ID. |
void |
setTypeIDVisible(boolean b)
|
void |
setTypeName(java.lang.String s)
Search for doctype from type name. |
void |
setTypeName(java.lang.String[][] opVal,
boolean isORquery)
Search for doctype using multiple criteria on type name. |
void |
setTypeNameVisible(boolean b)
|
void |
setTypeVisible(boolean b)
|
java.lang.String |
toSql()
|
java.lang.String |
toSql(boolean agg)
For internal use only |
Methods inherited from class java.lang.Object |
---|
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Field Detail |
---|
public static final java.lang.String TYPEID
public static final java.lang.String TYPENAME
public static final java.lang.String TYPEDESCRIPTION
public static final java.lang.String DELETED
public static final java.lang.String TIMESTAMP
public static final java.lang.String TYPE
public static final java.lang.String COL_TYPE
public static final java.lang.String EXTRACTEDATTRIBUTE
public static final java.lang.String BIZDOCTYPEDEF_TBL
public static final java.lang.String BD_TBL
public static final java.lang.String BIZDOCTYPEATTRIBUTE_TBL
public static final java.lang.String BDT_ATTR_TBL
public static final java.lang.String ATTRIBUTEID
public static java.lang.String VIEW_PERMISSION
public static final java.lang.String INCL_UNKNOWN
Constructor Detail |
---|
public BDTypeQuery()
Method Detail |
---|
public com.wm.data.IDataCursor getCursor()
getCursor
in interface com.wm.data.IData
public com.wm.data.IDataSharedCursor getSharedCursor()
getSharedCursor
in interface com.wm.data.IData
public com.wm.data.IDataIndexCursor getIndexCursor()
getIndexCursor
in interface com.wm.data.IData
public com.wm.data.IDataTreeCursor getTreeCursor()
getTreeCursor
in interface com.wm.data.IData
public com.wm.data.IDataHashCursor getHashCursor()
getHashCursor
in interface com.wm.data.IData
public static com.wm.data.IData create()
public void setTypeID(java.lang.String s)
public void setTypeID(java.lang.String[][] opVal, boolean isORquery)
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 bd.TypeID <> 'BBB' else if isORquery = false WHERE bd.TypeID = 'AAA' AND
bd.TypeID <> 'BBB' )public void setType(java.lang.String s)
public void setType(java.lang.String[][] opVal, boolean isORquery)
opValue
- is the operator and value pair in String[][] (e.g. {{Query.OP_COMP_EQ, "0}, {Query.OP_COMP_NEQ,
"0"}})isORquery
- should OR operator be used between these criteria (e.g. if isORquery = true, the where clause
will be WHERE bd.BDType = '0' OR bd.BDType <> '1' else if isORquery = false WHERE bd.BDType = '0' AND bd.BDType
<> '1' )public void setTypeName(java.lang.String s)
public void setTypeName(java.lang.String[][] opVal, boolean isORquery)
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.TypeName = 'AAA' OR bd.TypeName <> 'BBB' else if isORquery = false WHERE bd.TypeName = 'AAA' AND
bd.TypeName <> 'BBB' )public void setTypeDescription(java.lang.String s)
public void setTypeDescription(java.lang.String[][] opVal, boolean isORquery)
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.TypeDescription = 'AAA' OR bd.TypeDescription <> 'BBB' else if isORquery = false WHERE
bd.TypeDescription = 'AAA' AND bd.TypeDescription <> 'BBB' )public void setDeleted(java.lang.String s)
public void setDeleted(java.lang.String[][] opVal, boolean isORquery)
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.TypeDescription = 'AAA' OR bd.TypeDescription <> 'BBB' else if isORquery = false WHERE
bd.TypeDescription = 'AAA' AND bd.TypeDescription <> 'BBB' )public void setTimeInterval(int which)
which
- the interval to usepublic void setTimeInterval(java.sql.Timestamp since, java.sql.Timestamp until)
setTimeInterval
in class Query
since
- the start of the interval (null means open-ended)until
- the end of the interval (null means open-ended)public void setExtractedAttributes(java.lang.String s)
public void setExtractedAttributes(java.lang.String[][] opVal, boolean isORquery)
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 bdta.AttributeID = 'AAA' OR bdta.AttributeID <> 'BBB' else if isORquery = false WHERE
bdta.AttributeID = 'AAA' AND bdta.AttributeID <> 'BBB' )public java.lang.Object getTypeID()
public java.lang.Object getType()
public java.lang.Object getTypeName()
public java.lang.Object getTypeDescription()
public java.lang.Object getDeleted()
public java.sql.Timestamp[] getTimeInterval()
public int getTimeIntervalType()
public java.lang.Object getExtractedAttributes()
public void setTimestampVisible(boolean b)
public void setTypeVisible(boolean b)
public void setTypeIDVisible(boolean b)
public void setTypeNameVisible(boolean b)
public void setTypeDescriptionVisible(boolean b)
public void setDeletedVisible(boolean b)
public boolean isTimestampVisible()
public boolean isTypeVisible()
public boolean isTypeIDVisible()
public boolean isTypeNameVisible()
public boolean isTypeDescriptionVisible()
public boolean isDeletedVisible()
public void setSortColumns(java.lang.String[][] columnOrder)
setSortColumns
in class Query
columnOrder
- takes column names and sort orders (e.g. {{TIMESTAMP, "ASC"}, {SENDERID, "DESC"}} )public java.lang.String[][] getSortColumns()
public void clearSortColumns()
public void setSortColumn(java.lang.String col, boolean asc)
setSortColumns(String[][])
public java.lang.String getSortColumn()
getSortColumns()
public boolean isSortAscending()
setSortColumns(String[][])
public void clearSortColumn()
clearSortColumns()
public void preSql()
preSql
in class Query
public java.lang.String toSql()
toSql
in class Query
public java.lang.String toSql(boolean agg)
public java.lang.String[] getVisibleColumns()
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |