19 #ifndef __com_sun_star_sdb_XSingleSelectQueryComposer_idl__
20 #define __com_sun_star_sdb_XSingleSelectQueryComposer_idl__
29 module
com { module sun { module star { module sdb {
180 [in]
boolean ascending)
224 [attribute]
string ElementaryQuery
This exception is thrown to indicate that a method has passed an illegal or inappropriate argument.
Definition: IllegalArgumentException.idl:31
This is a checked exception that wraps an exception thrown by the original target.
Definition: WrappedTargetException.idl:38
is an exception that provides information on a database access error.
Definition: SQLException.idl:45
provides information about and access to the properties from an implementation.
Definition: XPropertySet.idl:64
simplifies the analyzing of single select statements.
Definition: XSingleSelectQueryAnalyzer.idl:41
simplifies the composing of single select statements.
Definition: XSingleSelectQueryComposer.idl:42
void setStructuredFilter([in] sequence< sequence< com::sun::star::beans::PropertyValue > > filter)
appends a new set of filter criteria which is split into levels.
void setFilter([in] string filter)
makes it possible to set a filter condition for the query.
void appendGroupByColumn([in] com::sun::star::beans::XPropertySet column)
appends an additional part to the group criteria of the select statement.
void setHavingClause([in] string filter)
makes it possible to set a HAVING filter condition for the query.
void setGroup([in] string group)
makes it possible to set a group for the query.
void appendHavingClauseByColumn([in] com::sun::star::beans::XPropertySet column,[in] boolean andCriteria,[in] long filterOperator)
appends a new HAVING filter condition by a com::sun::star::sdb::DataColumn providing the name and the...
void appendOrderByColumn([in] com::sun::star::beans::XPropertySet column, [in] boolean ascending)
appends an additional part to the sort order criteria of the select statement.
void setOrder([in] string order)
makes it possible to set a sort condition for the query.
void setStructuredHavingClause([in] sequence< sequence< com::sun::star::beans::PropertyValue > > filter)
appends a new set of HAVING filter criteria which is split into levels.
void appendFilterByColumn([in] com::sun::star::beans::XPropertySet column,[in] boolean andCriteria,[in] long filterOperator)
appends a new filter condition by a com::sun::star::sdb::DataColumn providing the name and the value ...
Definition: Ambiguous.idl:22