LibreOffice
LibreOffice 7.4 SDK API Reference
XSingleSelectQueryComposer.idl
Go to the documentation of this file.
1 /* -*- Mode: C++; tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 4 -*- */
2 /*
3  * This file is part of the LibreOffice project.
4  *
5  * This Source Code Form is subject to the terms of the Mozilla Public
6  * License, v. 2.0. If a copy of the MPL was not distributed with this
7  * file, You can obtain one at http://mozilla.org/MPL/2.0/.
8  *
9  * This file incorporates work covered by the following license notice:
10  *
11  * Licensed to the Apache Software Foundation (ASF) under one or more
12  * contributor license agreements. See the NOTICE file distributed
13  * with this work for additional information regarding copyright
14  * ownership. The ASF licenses this file to you under the Apache
15  * License, Version 2.0 (the "License"); you may not use this file
16  * except in compliance with the License. You may obtain a copy of
17  * the License at http://www.apache.org/licenses/LICENSE-2.0 .
18  */
19 #ifndef __com_sun_star_sdb_XSingleSelectQueryComposer_idl__
20 #define __com_sun_star_sdb_XSingleSelectQueryComposer_idl__
21 
27 
28 
29  module com { module sun { module star { module sdb {
30 
31 
42 {
43  // FILTER
44 
53  void setFilter([in] string filter)
55 
66  void setStructuredFilter([in] sequence< sequence<com::sun::star::beans::PropertyValue> > filter)
68 
84  void appendFilterByColumn([in] com::sun::star::beans::XPropertySet column,[in] boolean andCriteria,[in] long filterOperator)
86 
87  // GROUP BY
88 
89 
98  void setGroup([in] string group)
100 
101 
111 
112  // HAVING
113 
122  void setHavingClause([in] string filter)
124 
125 
136  void setStructuredHavingClause([in] sequence< sequence<com::sun::star::beans::PropertyValue> > filter)
138 
153  void appendHavingClauseByColumn([in] com::sun::star::beans::XPropertySet column,[in] boolean andCriteria,[in] long filterOperator)
155 
156  // ORDER BY
157 
166  void setOrder([in] string order)
168 
169 
180  [in] boolean ascending)
182 
183  // cumulative composing
184 
224  [attribute] string ElementaryQuery
225  {
227  };
228 };
229 
230 
231 }; }; }; };
232 
233 #endif
234 
235 /* vim:set shiftwidth=4 softtabstop=4 expandtab: */
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