|
Novell exteNd Director 5.2 API |
||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: INNER | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
Objects that implement this interface represent queries that are used to search for Documents maintained by the Content Manager.
The queries are executed against the Document metadata of two kinds:
The user is expected to create the Query in three steps:
select...
methods;
where...
methods,
combining various WHERE subclauses via the
EbiQueryExpression.andExpression
, orExpression
,
and negateExpression
methods, and then using the
setWhere
method off
com.sssw.fw.api.EbiQueryExpression
;
orderBy...
methods.
Example:
// Get the Content Manager Delegate EbiContentMgmtDelegate cmgr = com.sssw.cm.client.EboFactory.getDefaultContentMgmtDelegate(); // Create a Document Metadata Query object EbiDocQuery docQuery = (EbiDocQuery)cmgr.createQuery(EbiDocQuery.DOC_QUERY); // We're interested in Movie Reviews EbiDocType type = cmgr.getDocumentType(ctx, "Movie Review"); EbiQueryExpression queryExpr = docQuery.whereDocTypeID( type.getDocTypeID(), EbiDocQuery.ROP_EQUAL, false); // The author we're interested in is Smith EbiQueryExpression authorExpr = docQuery.whereAuthor("Smith", EbiDocQuery.ROP_EQUAL, false); // We want movie reviews whose author is "Smith" queryExpr.andExpression(authorExpr); // We want reviews of movies whose Genre is "Action"... EbiQueryExpression fieldExpr = docQuery.whereFieldValue_ByName( "Genre", "Action", EbiDocQuery.ROP_EQUAL, false); // ... or whose Genre is "Thriller" EbiQueryExpression fieldExpr2 = docQuery.whereFieldValue_ByName( "Genre", "Thriller", EbiDocQuery.ROP_EQUAL, false); // Field value = "Action" or Field value = "Thriller" fieldExpr.orExpression(fieldExpr2); fieldExpr.parenthesize(); // Movie reviews whose author is "Smith", and Genre is Action or Thriller queryExpr.andExpression(fieldExpr); // The WHERE clause is ready, set it into the Query docQuery.setWhere(queryExpr); // Execute the query Iterator iterResults = cmgr.query(context, docQuery).iterator(); // Process the query results while (iterResults.hasNext()) { EbiDocument doc = (EbiDocument)iterResults.next(); System.out.println(doc); }
EbiQueryExpression
,
EbiContentMgmtDelegate.findElements(EbiContext, EbiQuery)
,
EbiContentMgmtDelegate.findElements(EbiContext, EbiQuery, boolean)
,
EbiContentMgmtDelegate.findElementsFiltered(EbiContext, EbiQuery)
,
EbiContentMgmtDelegate.findElementsFiltered(EbiContext, EbiQuery, boolean)
Field Summary | |
static String |
DOC_QUERY
The query type of "Document Query" |
Fields inherited from interface com.sssw.fw.api.EbiMetaDataQuery |
LDAP_APPROX,
LDAP_BETWEEN,
LDAP_ENDS_WITH,
LDAP_EQUAL,
LDAP_GEQ,
LDAP_GREATER,
LDAP_IN,
LDAP_LEQ,
LDAP_LESS,
LDAP_MATCH,
LDAP_PRESENCE,
LDAP_STARTS_WITH,
OP_BETWEEN,
OP_IN,
OP_IS_NULL,
ROP_EQUAL,
ROP_GEQ,
ROP_GREATER,
ROP_LEQ,
ROP_LESS,
SOP_ENDS_WITH,
SOP_EQUALS_IGNORE_CASE,
SOP_LIKE,
SOP_LIKE_IGNORE_CASE,
SOP_STARTS_WITH |
Method Summary | |
Integer |
getMaxRows()
Gets the MaxRows attribute for the query. |
String |
getRepositoryID()
Gets the repository id associated with the query |
void |
setMaxRows(Integer maxRows)
Specifies a maximum number of rows to be returned by the query. |
EbiQueryExpression |
whereAuthor(String value,
int op,
boolean not)
Specifies the seach condition of "where document author..." |
EbiQueryExpression |
whereAuthorBetween(String first,
String last,
boolean not)
Specifies the search condition of "where document author between..." |
EbiQueryExpression |
whereAuthorIn(String[] values,
boolean not)
Specifies the search condition of "where document author in..." |
EbiQueryExpression |
whereCategoryID(String value,
int op,
boolean not)
Specifies the seach condition of "where category ID..." |
EbiQueryExpression |
whereCategoryIDBetween(String first,
String last,
boolean not)
Specifies the search condition of "where category ID between..." |
EbiQueryExpression |
whereCategoryIDIn(String[] values,
boolean not)
Specifies the search condition of "where category ID in..." |
EbiQueryExpression |
whereContentSize(int value,
int op,
boolean not)
Specifies the search condition of "where document's content size..." |
EbiQueryExpression |
whereContentSizeBetween(int first,
int last,
boolean not)
Specifies the search condition of "where content size between..." |
EbiQueryExpression |
whereContentSizeIn(int[] values,
boolean not)
Specifies the search condition of "where document's content size is in..." |
EbiQueryExpression |
whereCreateDate(Timestamp value,
int op,
boolean not)
Specifies the search condition of "where document's creation date/time..." |
EbiQueryExpression |
whereCreateDateBetween(Timestamp first,
Timestamp last,
boolean not)
Specifies the search condition of "where document creation date/time between..." |
EbiQueryExpression |
whereCreateDateIn(Timestamp[] values,
boolean not)
Specifies the search condition of "where document creation date/time in..." |
EbiQueryExpression |
whereDocAbstract(String value,
int op,
boolean not)
Specifies the search condition of "where document's abstract..." Note: this method will only work if the database platform for the database where Portal is deployed, is Sybase Adaptive Server Anywhere. |
EbiQueryExpression |
whereDocAbstractBetween(String first,
String last,
boolean not)
Specifies the search condition of "where document abstract between..." Note: this method will only work if the database platform for the database where Portal is deployed, is Sybase Adaptive Server Anywhere. |
EbiQueryExpression |
whereDocAbstractIn(String[] values,
boolean not)
Specifies the search condition of "where document abstract in..." Note: this method will only work if the database platform for the database where Portal is deployed, is Sybase Adaptive Server Anywhere. |
EbiQueryExpression |
whereDocID(String value,
int op,
boolean not)
Specifies the search condition of "where document ID..." |
EbiQueryExpression |
whereDocIDBetween(String first,
String last,
boolean not)
Specifies the search condition of "where document ID between..." |
EbiQueryExpression |
whereDocIDIn(String[] values,
boolean not)
Specifies the search condition of "where document ID in..." |
EbiQueryExpression |
whereDocTypeID(String value,
int op,
boolean not)
Specifies the search condition of "where document type ID..." |
EbiQueryExpression |
whereDocTypeIDBetween(String first,
String last,
boolean not)
Specifies the search condition of "where document type ID between..." |
EbiQueryExpression |
whereDocTypeIDIn(String[] values,
boolean not)
Specifies the search condition of "where document type ID in..." |
EbiQueryExpression |
whereDocTypeName(String value,
int op,
boolean not)
Specifies the search condition of "where document type name..." |
EbiQueryExpression |
whereDocTypeNameBetween(String first,
String last,
boolean not)
Specifies the search condition of "where document type name between..." |
EbiQueryExpression |
whereDocTypeNameIn(String[] values,
boolean not)
Specifies the search condition of "where document type name in..." |
EbiQueryExpression |
whereExpirationDate(Timestamp value,
int op,
boolean not)
Specifies the search condition of "where document's expiration date..." |
EbiQueryExpression |
whereExpirationDateBetween(Timestamp first,
Timestamp last,
boolean not)
Specifies the search condition of "where expiration date/time ID between..." |
EbiQueryExpression |
whereExpirationDateIn(Timestamp[] values,
boolean not)
Specifies the search condition of "where expiration date/time in..." |
EbiQueryExpression |
whereFieldID(String value,
int op,
boolean not)
Specifies the seach condition of "where extension metadata field ID..." |
EbiQueryExpression |
whereFieldIDBetween(String first,
String last,
boolean not)
Deprecated. |
EbiQueryExpression |
whereFieldIDIn(String[] values,
boolean not)
Specifies the seach condition of "where extension metadata field ID in..." |
EbiQueryExpression |
whereFieldValue_ByName(String fieldName,
Object fieldValue,
int op,
boolean not)
Specifies the seach condition of "where extension metadata field's value..." |
EbiQueryExpression |
whereFieldValue(Object fieldValue,
int op,
boolean not)
Specifies the seach condition of "where extension metadata field's value..." |
EbiQueryExpression |
whereFieldValue(String fieldID,
Object fieldValue,
int op,
boolean not)
Specifies the seach condition of "where extension metadata field's value..." |
EbiQueryExpression |
whereFieldValueBetween_ByName(String fieldName,
Object first,
Object last,
boolean not)
Specifies the search condition of "where extension metadata field's value between..." |
EbiQueryExpression |
whereFieldValueBetween(Object first,
Object last,
boolean not)
Specifies the search condition of "where extension metadata field's value between..." |
EbiQueryExpression |
whereFieldValueBetween(String fieldID,
Object first,
Object last,
boolean not)
Specifies the search condition of "where extension metadata field's value between..." |
EbiQueryExpression |
whereFieldValueIn_ByName(String fieldName,
Object[] values,
boolean not)
Specifies the search condition of "where extension metadata field's value in..." |
EbiQueryExpression |
whereFieldValueIn(Object[] values,
boolean not)
Specifies the search condition of "where extension metadata field's value in..." |
EbiQueryExpression |
whereFieldValueIn(String fieldID,
Object[] values,
boolean not)
Specifies the search condition of "where extension metadata field's value in..." |
EbiQueryExpression |
whereFolderID(String value,
int op,
boolean not)
Specifies the search condition of "where folder ID..." |
EbiQueryExpression |
whereFolderIDBetween(String first,
String last,
boolean not)
Specifies the search condition of "where folder ID between..." |
EbiQueryExpression |
whereFolderIDIn(String[] values,
boolean not)
Specifies the search condition of "where folder ID in..." |
EbiQueryExpression |
whereLinkChildren(EbiQueryExpression expr,
boolean not)
Deprecated. EbiJdbcMetaDataQuery |
EbiQueryExpression |
whereLinkParents(EbiQueryExpression expr,
boolean not)
Deprecated. EbiJdbcMetaDataQuery |
EbiQueryExpression |
whereLockedBy(String value,
int op,
boolean not)
Specifies the search condition of "where document's 'locked by' field..." |
EbiQueryExpression |
whereLockedByBetween(String first,
String last,
boolean not)
Specifies the search condition of "where document's 'locked by' field between..." |
EbiQueryExpression |
whereLockedByIn(String[] values,
boolean not)
Specifies the search condition of "where document's 'locked by' field in..." |
EbiQueryExpression |
whereLongVarCharFieldValue(String fieldValue,
int op,
boolean not)
Specifies the search condition of "where extension metadata field's value..." for a field whose data type is EbiDocField.FT_LONGVARCHAR . |
EbiQueryExpression |
whereMimeType(String value,
int op,
boolean not)
Specifies the search condition of "where document's MIME type..." |
EbiQueryExpression |
whereMimeTypeBetween(String first,
String last,
boolean not)
Specifies the search condition of "where MIME type between..." |
EbiQueryExpression |
whereMimeTypeIn(String[] values,
boolean not)
Specifies the search condition of "where document's MIME type is in..." |
EbiQueryExpression |
whereName(String value,
int op,
boolean not)
Specifies the seach condition of "where document name..." |
EbiQueryExpression |
whereNameBetween(String first,
String last,
boolean not)
Specifies the search condition of "where document name between..." |
EbiQueryExpression |
whereNameIn(String[] values,
boolean not)
Specifies the search condition of "where document name in..." |
EbiQueryExpression |
whereOriginator(int value,
int op,
boolean not)
Specifies the search condition of "where Originator..." |
EbiQueryExpression |
whereOriginatorBetween(int first,
int last,
boolean not)
Specifies the search condition of "where originator between..." |
EbiQueryExpression |
whereOriginatorIn(int[] values,
boolean not)
Specifies the search condition of "where Originator is in..." |
EbiQueryExpression |
whereParentDocID(String value,
int op,
boolean not)
Specifies the search condition of "where document's parent document ID..." |
EbiQueryExpression |
whereParentDocIDBetween(String first,
String last,
boolean not)
Specifies the search condition of "where document's parent document ID between..." |
EbiQueryExpression |
whereParentDocIDIn(String[] values,
boolean not)
Specifies the search condition of "where document's parent document ID in..." |
EbiQueryExpression |
wherePublishDate(Timestamp value,
int op,
boolean not)
Specifies the search condition of "where document's publish date..." |
EbiQueryExpression |
wherePublishDateBetween(Timestamp first,
Timestamp last,
boolean not)
Specifies the search condition of "where document publish date/time between..." |
EbiQueryExpression |
wherePublishDateIn(Timestamp[] values,
boolean not)
Specifies the search condition of "where document publish date/time in..." |
EbiQueryExpression |
wherePublishStatus(int value,
int op,
boolean not)
Specifies the search condition of "where document's publish status..." |
EbiQueryExpression |
wherePublishStatusBetween(int first,
int last,
boolean not)
Specifies the search condition of "where publish status between..." |
EbiQueryExpression |
wherePublishStatusIn(int[] values,
boolean not)
Specifies the search condition of "where document's publish status is in..." |
EbiQueryExpression |
whereRepositoryID(String value,
int op,
boolean not)
Specifies the seach condition of "where repository ID..." Note: by default, the query will search for documents that belong to the repository that the query is associated with. Note: this method does not provide the ability to run searches across multiple data sources. |
EbiQueryExpression |
whereRepositoryIDBetween(String first,
String last,
boolean not)
Specifies the search condition of "where repository ID between..." |
EbiQueryExpression |
whereRepositoryIDIn(String[] values,
boolean not)
Specifies the seach condition of "where repository ID in..." Note: by default, the query will search for documents that belong to the repository that the query is associated with. Note: this method does not provide the ability to run searches across multiple data sources. |
EbiQueryExpression |
whereStatus(String value,
int op,
boolean not)
Specifies the search condition of "where document's status..." |
EbiQueryExpression |
whereStatusBetween(String first,
String last,
boolean not)
Specifies the search condition of "where status between..." |
EbiQueryExpression |
whereStatusIn(String[] values,
boolean not)
Specifies the search condition of "where document status in..." |
EbiQueryExpression |
whereSubtitle(String value,
int op,
boolean not)
Specifies the search condition of "where document's subtitle..." |
EbiQueryExpression |
whereSubtitleBetween(String first,
String last,
boolean not)
Specifies the search condition of "where document subtitle between..." |
EbiQueryExpression |
whereSubtitleIn(String[] values,
boolean not)
Specifies the search condition of "where document subtitle in..." |
EbiQueryExpression |
whereTitle(String value,
int op,
boolean not)
Specifies the seach condition of "where document title..." |
EbiQueryExpression |
whereTitleBetween(String first,
String last,
boolean not)
Specifies the search condition of "where document title between..." |
EbiQueryExpression |
whereTitleIn(String[] values,
boolean not)
Specifies the search condition of "where document title in..." |
EbiQueryExpression |
whereUpdateTime(Timestamp value,
int op,
boolean not)
Specifies the search condition of "where document's update date/time..." |
EbiQueryExpression |
whereUpdateTimeBetween(Timestamp first,
Timestamp last,
boolean not)
Specifies the search condition of "where document update date/time between..." |
EbiQueryExpression |
whereUpdateTimeIn(Timestamp[] values,
boolean not)
Specifies the search condition of "where document update date/time in..." |
EbiQueryExpression |
whereUpdateUser(String value,
int op,
boolean not)
Specifies the seach condition of "where document update user..." |
EbiQueryExpression |
whereUpdateUserBetween(String first,
String last,
boolean not)
Specifies the search condition of "where document update user between..." |
EbiQueryExpression |
whereUpdateUserIn(String[] values,
boolean not)
Specifies the search condition of "where document update user in..." |
Methods implemented from interface com.sssw.fw.api.EbiMetaDataQuery |
getSelectedColumnIndices,
getWhere,
isHierarchical,
setWhere |
Field Detail |
public static final String DOC_QUERY
Method Detail |
public EbiQueryExpression whereDocID(String value, int op, boolean not)
value
- the value for the conditionop
- the operator (see EbiMetaDataQuery)not
- whether to negate the conditionpublic EbiQueryExpression whereDocIDIn(String[] values, boolean not)
values
- the values for the IN conditionnot
- whether to negate the conditionpublic EbiQueryExpression whereDocIDBetween(String first, String last, boolean not)
first
- the start expression for the rangelast
- the end expression for the rangenot
- whether to negate the conditionpublic EbiQueryExpression whereName(String value, int op, boolean not)
value
- the value for the conditionop
- the operator (see EbiMetaDataQuery)not
- whether to negate the conditionpublic EbiQueryExpression whereNameIn(String[] values, boolean not)
values
- the values for the IN conditionnot
- whether to negate the conditionpublic EbiQueryExpression whereNameBetween(String first, String last, boolean not)
first
- the start expression for the rangelast
- the end expression for the rangenot
- whether to negate the conditionpublic EbiQueryExpression whereAuthor(String value, int op, boolean not)
value
- the value for the conditionop
- the operator (see EbiMetaDataQuery)not
- whether to negate the conditionpublic EbiQueryExpression whereAuthorIn(String[] values, boolean not)
values
- the values for the IN conditionnot
- whether to negate the conditionpublic EbiQueryExpression whereAuthorBetween(String first, String last, boolean not)
first
- the start expression for the rangelast
- the end expression for the rangenot
- whether to negate the conditionpublic EbiQueryExpression whereTitle(String value, int op, boolean not)
value
- the value for the conditionop
- the operator (see EbiMetaDataQuery)not
- whether to negate the conditionpublic EbiQueryExpression whereTitleIn(String[] values, boolean not)
values
- the values for the IN conditionnot
- whether to negate the conditionpublic EbiQueryExpression whereTitleBetween(String first, String last, boolean not)
first
- the start expression for the rangelast
- the end expression for the rangenot
- whether to negate the conditionpublic EbiQueryExpression whereFieldID(String value, int op, boolean not)
value
- the value for the conditionop
- the operator (see EbiMetaDataQuery)not
- whether to negate the conditionpublic EbiQueryExpression whereFieldIDIn(String[] values, boolean not)
values
- the values for the IN conditionnot
- whether to negate the conditionpublic EbiQueryExpression whereFieldIDBetween(String first, String last, boolean not)
first
- the start expression for the rangelast
- the end expression for the rangenot
- whether to negate the conditionpublic EbiQueryExpression whereLongVarCharFieldValue(String fieldValue, int op, boolean not)
EbiDocField.FT_LONGVARCHAR
.
This method complements whereFieldValue(Object, int, boolean)
in order to make sure that if a String value is passed in, the right
type of expression is built.fieldValue
- the value for the conditionop
- the operator (see EbiMetaDataQuery)not
- whether to negate the conditionpublic EbiQueryExpression whereFieldValue(Object fieldValue, int op, boolean not)
fieldValue
- the value for the conditionop
- the operator (see EbiMetaDataQuery)not
- whether to negate the conditionpublic EbiQueryExpression whereFieldValueIn(Object[] values, boolean not)
values
- the values for the IN conditionnot
- whether to negate the conditionpublic EbiQueryExpression whereFieldValueBetween(Object first, Object last, boolean not)
first
- the start expression for the rangelast
- the end expression for the rangenot
- whether to negate the conditionpublic EbiQueryExpression whereFieldValue(String fieldID, Object fieldValue, int op, boolean not)
fieldID
- the ID of the fieldfieldValue
- the value for the conditionop
- the operator (see EbiMetaDataQuery)not
- whether to negate the conditionpublic EbiQueryExpression whereFieldValueIn(String fieldID, Object[] values, boolean not)
fieldID
- the ID of the fieldvalues
- the values for the IN conditionnot
- whether to negate the conditionpublic EbiQueryExpression whereFieldValueBetween(String fieldID, Object first, Object last, boolean not)
fieldID
- the ID of the fieldfirst
- the start expression for the rangelast
- the end expression for the rangenot
- whether to negate the conditionpublic EbiQueryExpression whereFieldValue_ByName(String fieldName, Object fieldValue, int op, boolean not)
fieldName
- the name of the fieldfieldValue
- the value for the conditionop
- the operator (see EbiMetaDataQuery)not
- whether to negate the conditionpublic EbiQueryExpression whereFieldValueIn_ByName(String fieldName, Object[] values, boolean not)
fieldName
- the name of the fieldvalues
- the values for the IN conditionnot
- whether to negate the conditionpublic EbiQueryExpression whereFieldValueBetween_ByName(String fieldName, Object first, Object last, boolean not)
fieldName
- the name of the fieldfirst
- the start expression for the rangelast
- the end expression for the rangenot
- whether to negate the conditionpublic EbiQueryExpression whereCategoryID(String value, int op, boolean not)
value
- the value for the conditionop
- the operator (see EbiMetaDataQuery)not
- whether to negate the conditionpublic EbiQueryExpression whereCategoryIDIn(String[] values, boolean not)
values
- the values for the IN conditionnot
- whether to negate the conditionpublic EbiQueryExpression whereCategoryIDBetween(String first, String last, boolean not)
first
- the start expression for the rangelast
- the end expression for the rangenot
- whether to negate the conditionpublic EbiQueryExpression whereDocTypeID(String value, int op, boolean not)
value
- the value for the conditionop
- the operator (see EbiMetaDataQuery)not
- whether to negate the conditionpublic EbiQueryExpression whereDocTypeIDIn(String[] values, boolean not)
values
- the values for the IN conditionnot
- whether to negate the conditionpublic EbiQueryExpression whereDocTypeIDBetween(String first, String last, boolean not)
first
- the start expression for the rangelast
- the end expression for the rangenot
- whether to negate the conditionpublic EbiQueryExpression whereDocTypeName(String value, int op, boolean not)
value
- the value for the conditionop
- the operator (see EbiMetaDataQuery)not
- whether to negate the conditionpublic EbiQueryExpression whereDocTypeNameIn(String[] values, boolean not)
values
- the values for the IN conditionnot
- whether to negate the conditionpublic EbiQueryExpression whereDocTypeNameBetween(String first, String last, boolean not)
first
- the start expression for the rangelast
- the end expression for the rangenot
- whether to negate the conditionpublic EbiQueryExpression whereCreateDate(Timestamp value, int op, boolean not)
value
- the value for the conditionop
- the operator (see EbiMetaDataQuery)not
- whether to negate the conditionpublic EbiQueryExpression whereCreateDateIn(Timestamp[] values, boolean not)
values
- the values for the IN conditionnot
- whether to negate the conditionpublic EbiQueryExpression whereCreateDateBetween(Timestamp first, Timestamp last, boolean not)
first
- the start expression for the rangelast
- the end expression for the rangenot
- whether to negate the conditionpublic EbiQueryExpression whereSubtitle(String value, int op, boolean not)
value
- the value for the conditionop
- the operator (see EbiMetaDataQuery)not
- whether to negate the conditionpublic EbiQueryExpression whereSubtitleIn(String[] values, boolean not)
values
- the values for the IN conditionnot
- whether to negate the conditionpublic EbiQueryExpression whereSubtitleBetween(String first, String last, boolean not)
first
- the start expression for the rangelast
- the end expression for the rangenot
- whether to negate the conditionpublic EbiQueryExpression whereDocAbstract(String value, int op, boolean not)
value
- the value for the conditionop
- the operator (see EbiMetaDataQuery)not
- whether to negate the conditionpublic EbiQueryExpression whereDocAbstractIn(String[] values, boolean not)
values
- the values for the IN conditionnot
- whether to negate the conditionpublic EbiQueryExpression whereDocAbstractBetween(String first, String last, boolean not)
first
- the start expression for the rangelast
- the end expression for the rangenot
- whether to negate the conditionpublic EbiQueryExpression wherePublishDate(Timestamp value, int op, boolean not)
value
- the value for the conditionop
- the operator (see EbiMetaDataQuery)not
- whether to negate the conditionpublic EbiQueryExpression wherePublishDateIn(Timestamp[] values, boolean not)
values
- the values for the IN conditionnot
- whether to negate the conditionpublic EbiQueryExpression wherePublishDateBetween(Timestamp first, Timestamp last, boolean not)
first
- the start expression for the rangelast
- the end expression for the rangenot
- whether to negate the conditionpublic EbiQueryExpression whereExpirationDate(Timestamp value, int op, boolean not)
value
- the value for the conditionop
- the operator (see EbiMetaDataQuery)not
- whether to negate the conditionpublic EbiQueryExpression whereExpirationDateIn(Timestamp[] values, boolean not)
values
- the values for the IN conditionnot
- whether to negate the conditionpublic EbiQueryExpression whereExpirationDateBetween(Timestamp first, Timestamp last, boolean not)
first
- the start expression for the rangelast
- the end expression for the rangenot
- whether to negate the conditionpublic EbiQueryExpression whereLockedBy(String value, int op, boolean not)
value
- the value for the conditionop
- the operator (see EbiMetaDataQuery)not
- whether to negate the conditionpublic EbiQueryExpression whereLockedByIn(String[] values, boolean not)
values
- the values for the IN conditionnot
- whether to negate the conditionpublic EbiQueryExpression whereLockedByBetween(String first, String last, boolean not)
first
- the start expression for the rangelast
- the end expression for the rangenot
- whether to negate the conditionpublic EbiQueryExpression whereStatus(String value, int op, boolean not)
value
- the value for the conditionop
- the operator (see EbiMetaDataQuery)not
- whether to negate the conditionpublic EbiQueryExpression whereStatusIn(String[] values, boolean not)
values
- the values for the IN conditionnot
- whether to negate the conditionpublic EbiQueryExpression whereStatusBetween(String first, String last, boolean not)
first
- the start expression for the rangelast
- the end expression for the rangenot
- whether to negate the conditionpublic EbiQueryExpression whereParentDocID(String value, int op, boolean not)
value
- the value for the conditionop
- the operator (see EbiMetaDataQuery)not
- whether to negate the conditionpublic EbiQueryExpression whereParentDocIDIn(String[] values, boolean not)
values
- the values for the IN conditionnot
- whether to negate the conditionpublic EbiQueryExpression whereParentDocIDBetween(String first, String last, boolean not)
first
- the start expression for the rangelast
- the end expression for the rangenot
- whether to negate the conditionpublic EbiQueryExpression whereFolderID(String value, int op, boolean not)
value
- the value for the conditionop
- the operator (see EbiMetaDataQuery)not
- whether to negate the conditionpublic EbiQueryExpression whereFolderIDIn(String[] values, boolean not)
values
- the values for the IN conditionnot
- whether to negate the conditionpublic EbiQueryExpression whereFolderIDBetween(String first, String last, boolean not)
first
- the start value for the rangelast
- the end value for the rangenot
- whether to negate the conditionpublic EbiQueryExpression whereLinkChildren(EbiQueryExpression expr, boolean not)
EbiJdbcMetaDataQuery
expr
- the expression specified for the link-childrennot
- whether to negate the conditionEbiDocQuery.whereLinkParents(EbiQueryExpression, boolean)
public EbiQueryExpression whereLinkParents(EbiQueryExpression expr, boolean not)
EbiJdbcMetaDataQuery
// assemble inner subquery com.sssw.fw.persist.jdbc.api.EbiJdbcQuery innerQuery = com.sssw.fw.factory.EboFactory.getJdbcQuery("com.sssw.fw.api.EbiJdbcQuery"); innerQuery.setPrimaryTable(EbiDocTypeMeta.DOCTYPES_TABLE); innerQuery.addSelect(EbiDocTypeMeta.DOCTYPES_DOCTYPEID); EbiQueryExpression innerExpr = innerQuery.whereColumnOp(EbiDocTypeMeta.DOCTYPENAME, "Book", EboSqlHelper.ROP_EQUAL, false); innerQuery.setWhere(innerExpr); // assemble outer subquery com.sssw.fw.persist.jdbc.api.EbiJdbcQuery outerQuery = com.sssw.fw.factory.EboFactory.getJdbcQuery("com.sssw.fw.api.EbiJdbcQuery"); outerQuery.setPrimaryTable(EbiDocLinkMeta.DOCLINKS_TABLE); outerQuery.addSelect(EbiDocLinkMeta.DOCLINKS_CHILDDOCID); String[] fromCols = {EbiDocLinkMeta.DOCLINKS_DOCID}; String[] toCols = {EbiDocumentMeta.DOCUMENTS_DOCID}; outerQuery.addJoin(EboSqlHelper.JOIN_INNER, EbiDocumentMeta.DOCUMENTS_TABLE, fromCols, toCols); EbiQueryExpression outerExpr = outerQuery.whereColumnOp(EbiDocumentMeta.DOCUMENTS_AUTHOR, "J.K. Rowling", EboSqlHelper.ROP_EQUAL, false); EbiQueryExpression temp = outerQuery.whereColumnIn(EbiDocumentMeta.DOCUMENTS_DOCTYPEID, innerQuery, false); outerExpr.andExpression(temp); outerQuery.setWhere(outerExpr); // obtain document meta for use in main query com.sssw.fw.persist.api.EbiElementMeta docMeta = com.sssw.cm.core.EboPersistenceHelper.getElementMeta(EbiDocument.EL_DOCUMENT); // assemble main query com.sssw.fw.persist.jdbc.api.EbiJdbcMetaDataQuery mainQuery = com.sssw.fw.factory.EboFactory.getJdbcMetaDataQuery("com.sssw.fw.api.EbiJdbcMetaDataQuery"); mainQuery.setPrimaryTable(EbiDocumentMeta.DOCUMENTS_TABLE); mainQuery.addElementType(EbiDocument.EL_DOCUMENT, docMeta); mainQuery.addSelect(EbiDocumentMeta.DOCUMENTS_DOCNAME, EbiDocument.EL_DOCUMENT, docMeta.getPropertyIndex(EbiDocumentMeta.DOCUMENTS_DOCNAME)); EbiQueryExpression mainExpr = mainQuery.whereColumnIn(EbiDocumentMeta.DOCUMENTS_DOCID, outerQuery, false); mainQuery.setWhere(mainExpr); Collection docs = cm.findElements(m_ctx, mainQuery);
expr
- the expression specified for the link-parentsnot
- whether to negate the conditionpublic EbiQueryExpression wherePublishStatus(int value, int op, boolean not)
value
- the value for the conditionop
- the operator (see EbiMetaDataQuery)not
- whether to negate the conditionpublic EbiQueryExpression wherePublishStatusIn(int[] values, boolean not)
values
- the values for the IN conditionnot
- whether to negate the conditionpublic EbiQueryExpression wherePublishStatusBetween(int first, int last, boolean not)
first
- the first value for the rangelast
- the last value for the rangenot
- whether to negate the conditionpublic EbiQueryExpression whereContentSize(int value, int op, boolean not)
value
- the value for the conditionop
- the operator (see EbiMetaDataQuery)not
- whether to negate the conditionpublic EbiQueryExpression whereContentSizeIn(int[] values, boolean not)
values
- the values for the IN conditionnot
- whether to negate the conditionpublic EbiQueryExpression whereContentSizeBetween(int first, int last, boolean not)
first
- the first value for the rangelast
- the last value for the rangenot
- whether to negate the conditionpublic EbiQueryExpression whereMimeType(String value, int op, boolean not)
value
- the value for the conditionop
- the operator (see EbiMetaDataQuery)not
- whether to negate the conditionpublic EbiQueryExpression whereMimeTypeIn(String[] values, boolean not)
values
- the values for the IN conditionnot
- whether to negate the conditionpublic EbiQueryExpression whereMimeTypeBetween(String first, String last, boolean not)
first
- the first value for the rangelast
- the last value for the rangenot
- whether to negate the conditionpublic EbiQueryExpression whereUpdateTime(Timestamp value, int op, boolean not)
value
- the value for the conditionop
- the operator (see EbiMetaDataQuery)not
- whether to negate the conditionpublic EbiQueryExpression whereUpdateTimeIn(Timestamp[] values, boolean not)
values
- the values for the IN conditionnot
- whether to negate the conditionpublic EbiQueryExpression whereUpdateTimeBetween(Timestamp first, Timestamp last, boolean not)
first
- the start expression for the rangelast
- the end expression for the rangenot
- whether to negate the conditionpublic EbiQueryExpression whereUpdateUser(String value, int op, boolean not)
value
- the value for the conditionop
- the operator (see EbiMetaDataQuery)not
- whether to negate the conditionpublic EbiQueryExpression whereUpdateUserIn(String[] values, boolean not)
values
- the values for the IN conditionnot
- whether to negate the conditionpublic EbiQueryExpression whereUpdateUserBetween(String first, String last, boolean not)
first
- the start expression for the rangelast
- the end expression for the rangenot
- whether to negate the conditionpublic EbiQueryExpression whereRepositoryID(String value, int op, boolean not)
value
- the value for the conditionop
- the operator (see EbiMetaDataQuery)not
- whether to negate the conditionpublic EbiQueryExpression whereRepositoryIDBetween(String first, String last, boolean not)
first
- the start expression for the rangelast
- the end expression for the rangenot
- whether to negate the conditionpublic EbiQueryExpression whereRepositoryIDIn(String[] values, boolean not)
values
- the values for the "in" clausenot
- whether to negate the conditionpublic EbiQueryExpression whereOriginator(int value, int op, boolean not)
value
- the value for the conditionop
- the operator (see EbiMetaDataQuery)not
- whether to negate the conditionpublic EbiQueryExpression whereOriginatorIn(int[] values, boolean not)
values
- the values for the IN conditionnot
- whether to negate the conditionpublic EbiQueryExpression whereOriginatorBetween(int first, int last, boolean not)
first
- the first value for the rangelast
- the last value for the rangenot
- whether to negate the conditionpublic void setMaxRows(Integer maxRows)
maxRows
- is an Integer containing the maximum rows to be returned.public Integer getMaxRows()
public String getRepositoryID()
|
Novell exteNd Director 5.2 API |
||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: INNER | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |