LibreOffice
LibreOffice 4.2 SDK API Reference
 All Classes Namespaces Files Functions Variables Typedefs Enumerations Enumerator Macros Pages
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 
23 
25 
27 
29 
30 
31  module com { module sun { module star { module sdb {
32 
33 
44 {
45  // FILTER
46 
55  void setFilter([in] string filter)
57 
68  void setStructuredFilter([in] sequence< sequence<com::sun::star::beans::PropertyValue> > filter)
70 
86  void appendFilterByColumn([in] com::sun::star::beans::XPropertySet column,[in] boolean andCriteria,[in] long filterOperator)
88 
89  // GROUP BY
90 
91 
100  void setGroup([in] string group)
102 
103 
111  void appendGroupByColumn([in] com::sun::star::beans::XPropertySet column)
113 
114  // HAVING
115 
124  void setHavingClause([in] string filter)
126 
127 
138  void setStructuredHavingClause([in] sequence< sequence<com::sun::star::beans::PropertyValue> > filter)
140 
155  void appendHavingClauseByColumn([in] com::sun::star::beans::XPropertySet column,[in] boolean andCriteria,[in] long filterOperator)
157 
158  // ORDER BY
159 
168  void setOrder([in] string order)
170 
171 
181  void appendOrderByColumn([in] com::sun::star::beans::XPropertySet column,
182  [in] boolean ascending)
184 
185  // cumulative composing
186 
226  [attribute] string ElementaryQuery
227  {
229  };
230 };
231 
232 
233 }; }; }; };
234 
235 #endif
236 
237 /* vim:set shiftwidth=4 softtabstop=4 expandtab: */
simplifies the analyzing of single select statements.
Definition: XSingleSelectQueryAnalyzer.idl:40
const short set
specifies that the property is currently in a set state.
Definition: ItemState.idl:62
simplifies the composing of single select statements.
Definition: XSingleSelectQueryComposer.idl:43
This exception is thrown to indicate that a method has passed an illegal or inappropriate argument...
Definition: IllegalArgumentException.idl:29
is an exception that provides information on a database access error.
Definition: SQLException.idl:44
provides information about and access to the properties from an implementation.
Definition: XPropertySet.idl:63