1 <?xml version=
"1.0" encoding=
"UTF-8"?>
4 <!--***********************************************************************
6 * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
8 * Copyright 2008 by Sun Microsystems, Inc.
10 * OpenOffice.org - a multi-platform office productivity suite
12 * $RCSfile: querywizard06.xhp,v $
15 * This file is part of OpenOffice.org.
17 * OpenOffice.org is free software: you can redistribute it and/or modify
18 * it under the terms of the GNU Lesser General Public License version 3
19 * only, as published by the Free Software Foundation.
21 * OpenOffice.org is distributed in the hope that it will be useful,
22 * but WITHOUT ANY WARRANTY; without even the implied warranty of
23 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
24 * GNU Lesser General Public License version 3 for more details
25 * (a copy is included in the LICENSE file that accompanied this code).
27 * You should have received a copy of the GNU Lesser General Public License
28 * version 3 along with OpenOffice.org. If not, see
29 * <http://www.openoffice.org/license.html>
30 * for a copy of the LGPLv3 License.
32 ************************************************************************-->
34 <helpdocument version=
"1.0">
36 <topic id=
"textsharedexplorerdatabasequerywizard06xml" indexer=
"include" status=
"PUBLISH">
37 <title id=
"tit" xml-lang=
"en-US">Query Wizard - Grouping Conditions
</title>
38 <filename>/text/shared/explorer/database/querywizard06.xhp
</filename>
41 <created date=
"2004-07-06T10:00:57">UFI: new Query Wizard page
6</created>
42 <lastedited date=
"2005-03-02T10:11:27">YJ: checked
</lastedited>
46 <section id=
"groupingconditions">
47 <paragraph role=
"heading" id=
"par_idN10546" xml-lang=
"en-US" level=
"1" l10n=
"NEW"><link href=
"text/shared/explorer/database/querywizard06.xhp">Query Wizard - Grouping Conditions
</link></paragraph>
48 <paragraph role=
"paragraph" id=
"par_idN10556" xml-lang=
"en-US" l10n=
"NEW">Specifies the conditions to group the query. The data source must support the SQL statement
"Order by clauses" to enable this page of the Wizard.
</paragraph>
50 <bookmark xml-lang=
"en-US" branch=
"hid/HID_QUERYWIZARD_OPTGROUPMATCHALL" id=
"bm_id8115176" localize=
"false"/>
51 <paragraph role=
"heading" id=
"par_idN10559" xml-lang=
"en-US" level=
"2" l10n=
"NEW">Match all of the following
</paragraph>
52 <paragraph role=
"paragraph" id=
"par_idN1055D" xml-lang=
"en-US" l10n=
"NEW"><ahelp hid=
".">Select to group the query by all the conditions using a logical AND.
</ahelp></paragraph>
53 <bookmark xml-lang=
"en-US" branch=
"hid/HID_QUERYWIZARD_OPTGROUPMATCHANY" id=
"bm_id8760948" localize=
"false"/>
54 <paragraph role=
"heading" id=
"par_idN10560" xml-lang=
"en-US" level=
"2" l10n=
"NEW">Match any of the following
</paragraph>
55 <paragraph role=
"paragraph" id=
"par_idN10564" xml-lang=
"en-US" l10n=
"NEW"><ahelp hid=
".">Select to group the query by any of the conditions using a logical OR.
</ahelp></paragraph>
56 <bookmark xml-lang=
"en-US" branch=
"hid/HID_QUERYWIZARD_LSTFILTERFIELDNAME_1" id=
"bm_id9920041.00000001" localize=
"false"/>
57 <bookmark xml-lang=
"en-US" branch=
"hid/HID_QUERYWIZARD_LSTFILTERFIELDNAME_2" id=
"bm_id9279457" localize=
"false"/>
58 <bookmark xml-lang=
"en-US" branch=
"hid/HID_QUERYWIZARD_LSTFILTERFIELDNAME_3" id=
"bm_id1897946" localize=
"false"/>
59 <paragraph role=
"heading" id=
"par_idN10567" xml-lang=
"en-US" level=
"3" l10n=
"NEW">Field name
</paragraph>
60 <paragraph role=
"paragraph" id=
"par_idN1056B" xml-lang=
"en-US" l10n=
"NEW"><ahelp hid=
".">Select the field name for the grouping condition.
</ahelp></paragraph>
61 <bookmark xml-lang=
"en-US" branch=
"hid/HID_QUERYWIZARD_LSTFILTEROPERATOR_1" id=
"bm_id6163823" localize=
"false"/>
62 <bookmark xml-lang=
"en-US" branch=
"hid/HID_QUERYWIZARD_LSTFILTEROPERATOR_2" id=
"bm_id2742088" localize=
"false"/>
63 <bookmark xml-lang=
"en-US" branch=
"hid/HID_QUERYWIZARD_LSTFILTEROPERATOR_3" id=
"bm_id465102" localize=
"false"/>
64 <paragraph role=
"heading" id=
"par_idN1056E" xml-lang=
"en-US" level=
"3" l10n=
"NEW">Condition
</paragraph>
65 <paragraph role=
"paragraph" id=
"par_idN10572" xml-lang=
"en-US" l10n=
"NEW"><ahelp hid=
".">Select the condition for the grouping.
</ahelp></paragraph>
66 <bookmark xml-lang=
"en-US" branch=
"hid/HID_QUERYWIZARD_TXTFILTERVALUE_1" id=
"bm_id1756340" localize=
"false"/>
67 <bookmark xml-lang=
"en-US" branch=
"hid/HID_QUERYWIZARD_TXTFILTERVALUE_2" id=
"bm_id8361766" localize=
"false"/>
68 <bookmark xml-lang=
"en-US" branch=
"hid/HID_QUERYWIZARD_TXTFILTERVALUE_3" id=
"bm_id2075563" localize=
"false"/>
69 <paragraph role=
"heading" id=
"par_idN10575" xml-lang=
"en-US" level=
"3" l10n=
"NEW">Value
</paragraph>
70 <paragraph role=
"paragraph" id=
"par_idN10579" xml-lang=
"en-US" l10n=
"NEW"><ahelp hid=
".">Enter the value for the grouping condition.
</ahelp></paragraph>
71 <paragraph role=
"paragraph" id=
"par_idN1057C" xml-lang=
"en-US" l10n=
"NEW"><link href=
"text/shared/explorer/database/querywizard07.xhp" name=
"Query Wizard - Aliases">Query Wizard - Aliases
</link></paragraph>