|
||||||||||
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.BDTypeAttributeQuery
public class BDTypeAttributeQuery
Field Summary | |
---|---|
static java.lang.String |
ATTRIBUTEDESCRIPTION
|
static java.lang.String |
ATTRIBUTEID
|
static java.lang.String |
ATTRIBUTENAME
|
static java.lang.String |
ATTRIBUTETYPE
|
static java.lang.String |
BD_ATTR__DEF_TBL
|
static java.lang.String |
BD_TBL
|
static java.lang.String |
BD_TYPEID
|
static java.lang.String |
BD_TYPENAME
|
static java.lang.String |
BDT_ATTR_TBL
|
static java.lang.String |
BIZDOCATTRIBUTEDEF_TBL
|
static java.lang.String |
BIZDOCTYPEATTRIBUTE_TBL
|
static java.lang.String |
BIZDOCTYPEDEF_TBL
|
static java.lang.String |
DELETED
|
static java.lang.String |
INCL_UNKNOWN
|
static java.lang.String |
PERSIST
|
static java.lang.String |
RELATEDDOCTYPEID
|
static java.lang.String |
RELATEDDOCTYPENAME
|
static java.lang.String |
TIMESTAMP
|
Constructor Summary | |
---|---|
BDTypeAttributeQuery()
Default query is "select * from BizDocAttributeDef". |
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 |
getAttributeDescription()
|
java.lang.Object |
getAttributeID()
|
java.lang.Object |
getAttributeName()
|
java.lang.Object |
getAttributeType()
|
com.wm.data.IDataCursor |
getCursor()
|
java.lang.Object |
getDeleted()
|
com.wm.data.IDataHashCursor |
getHashCursor()
For internal use only |
com.wm.data.IDataIndexCursor |
getIndexCursor()
For internal use only |
java.lang.Object |
getPersist()
|
java.lang.Object |
getRelatedDocTypeID()
|
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.String[] |
getVisibleColumns()
For internal use only |
boolean |
isAttributeDescriptionVisible()
|
boolean |
isAttributeIDVisible()
|
boolean |
isAttributeNameVisible()
|
boolean |
isAttributeTypeVisible()
|
boolean |
isDeletedVisible()
|
boolean |
isPersistVisible()
|
boolean |
isSortAscending()
Deprecated. As of TN 7.0, replaced by setSortColumns(String[][]) |
boolean |
isTimestampVisible()
|
void |
preSql()
For internal use only |
void |
setAttributeDescription(java.lang.String s)
Search for attribute from attribute description. |
void |
setAttributeDescription(java.lang.String[][] opVal,
boolean isORquery)
Search for attribute using multiple criteria on attribute description. |
void |
setAttributeDescriptionVisible(boolean b)
|
void |
setAttributeID(java.lang.String s)
Search for attribute by attribute ID. |
void |
setAttributeID(java.lang.String[][] opVal,
boolean isORquery)
Search for attribute using multiple criteria on attribute ID. |
void |
setAttributeIDVisible(boolean b)
|
void |
setAttributeName(java.lang.String s)
Search for attribute from type name. |
void |
setAttributeName(java.lang.String[][] opVal,
boolean isORquery)
Search for attribute using multiple criteria on type name. |
void |
setAttributeNameVisible(boolean b)
|
void |
setAttributeType(java.lang.String s)
Search for attribute from attribute type. |
void |
setAttributeType(java.lang.String[][] opVal,
boolean isORquery)
Search for attribute using multiple criteria on attribute type. |
void |
setAttributeTypeVisible(boolean b)
|
void |
setDeleted(java.lang.String s)
Search for attribute based on deleted status. |
void |
setDeleted(java.lang.String[][] opVal,
boolean isORquery)
Search for attribute using multiple criteria on deleted status. |
void |
setDeletedVisible(boolean b)
|
void |
setPersist(java.lang.String s)
Search for attribute based on Persist status. |
void |
setPersist(java.lang.String[][] opVal,
boolean isORquery)
Search for attribute using multiple criteria on deleted status. |
void |
setPersistVisible(boolean b)
|
void |
setRelatedDocTypeID(java.lang.String s)
Search for attribute based on related doc type ID. |
void |
setRelatedDocTypeID(java.lang.String[][] opVal,
boolean isORquery)
Search for attribute using multiple criteria on related doc type ID(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)
|
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 ATTRIBUTENAME
public static final java.lang.String ATTRIBUTEID
public static final java.lang.String ATTRIBUTEDESCRIPTION
public static final java.lang.String ATTRIBUTETYPE
public static final java.lang.String DELETED
public static final java.lang.String PERSIST
public static final java.lang.String TIMESTAMP
public static final java.lang.String BIZDOCATTRIBUTEDEF_TBL
public static final java.lang.String BD_ATTR__DEF_TBL
public static final java.lang.String RELATEDDOCTYPEID
public static final java.lang.String BD_TYPEID
public static final java.lang.String RELATEDDOCTYPENAME
public static final java.lang.String BD_TYPENAME
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 INCL_UNKNOWN
Constructor Detail |
---|
public BDTypeAttributeQuery()
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 setAttributeID(java.lang.String s)
public void setAttributeID(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 bdadef.AttributeID = 'AAA' OR bd.TypeID <> 'BBB' else if isORquery = false WHERE bdadef.AttributeID
= 'AAA' AND bd.TypeID <> 'BBB' )public void setAttributeName(java.lang.String s)
public void setAttributeName(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 bdadef.AttributeName = 'AAA' OR bdadef.AttributeName <> 'BBB' else if isORquery = false WHERE
bdadef.AttributeName = 'AAA' AND bdadef.AttributeName <> 'BBB' )public void setAttributeDescription(java.lang.String s)
public void setAttributeDescription(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 bdadef.AttributeDescription = 'AAA' OR bdadef.AttributeDescription <> 'BBB' else if isORquery =
false WHERE bdadef.AttributeDescription = 'AAA' AND bdadef.AttributeDescription <> 'BBB' )public void setAttributeType(java.lang.String s)
public void setAttributeType(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 bdadef.AttributeType = 'AAA' OR bdadef.AttributeType <> 'BBB' else if isORquery = false WHERE
bdadef.AttributeType = 'AAA' AND bdadef.AttributeType <> '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 bdadef.Deleted = 'AAA' OR bdadef.Deleted <> 'BBB' else if isORquery = false WHERE bdadef.Deleted =
'AAA' AND bdadef.Deleted <> 'BBB' )public void setPersist(java.lang.String s)
public void setPersist(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 bdadef.Persist = 'AAA' OR bdadef.Persist <> 'BBB' else if isORquery = false WHERE bdadef.Persist =
'AAA' AND bdadef.Persist <> '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 setRelatedDocTypeID(java.lang.String s)
public void setRelatedDocTypeID(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 java.lang.Object getAttributeID()
public java.lang.Object getAttributeName()
public java.lang.Object getAttributeDescription()
public java.lang.Object getAttributeType()
public java.lang.Object getDeleted()
public java.lang.Object getPersist()
public java.lang.Object getRelatedDocTypeID()
public java.sql.Timestamp[] getTimeInterval()
public int getTimeIntervalType()
public void setAttributeNameVisible(boolean b)
public void setAttributeIDVisible(boolean b)
public void setAttributeDescriptionVisible(boolean b)
public void setAttributeTypeVisible(boolean b)
public void setTimestampVisible(boolean b)
public void setDeletedVisible(boolean b)
public void setPersistVisible(boolean b)
public boolean isAttributeNameVisible()
public boolean isAttributeIDVisible()
public boolean isAttributeDescriptionVisible()
public boolean isAttributeTypeVisible()
public boolean isDeletedVisible()
public boolean isPersistVisible()
public boolean isTimestampVisible()
public void setSortColumns(java.lang.String[][] columnOrder)
setSortColumns
in class Query
columnOrder
- takes column names and sort orders (e.g. {{TIMESTAMP, "ASC"}, {ATTRIBUTEID, "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 |