blob: 9bb2ad3447188346eaab986b4692da9b5c918ebe (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
|
<?xml version="1.0" encoding="UTF-8"?>
<helpdocument version="1.0">
<!--
* This file is part of the LibreOffice project.
*
* This Source Code Form is subject to the terms of the Mozilla Public
* License, v. 2.0. If a copy of the MPL was not distributed with this
* file, You can obtain one at http://mozilla.org/MPL/2.0/.
*
* This file incorporates work covered by the following license notice:
*
* Licensed to the Apache Software Foundation (ASF) under one or more
* contributor license agreements. See the NOTICE file distributed
* with this work for additional information regarding copyright
* ownership. The ASF licenses this file to you under the Apache
* License, Version 2.0 (the "License"); you may not use this file
* except in compliance with the License. You may obtain a copy of
* the License at http://www.apache.org/licenses/LICENSE-2.0 .
-->
<meta>
<topic id="textshared0212100100xml" indexer="include" status="PUBLISH">
<title id="tit" xml-lang="en-US">Sort Order</title>
<filename>/text/shared/02/12100100.xhp</filename>
</topic>
</meta>
<body>
<bookmark xml-lang="en-US" branch="index" id="bm_id3147000"><bookmark_value>sorting; databases</bookmark_value>
<bookmark_value>databases; sorting</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/sortdialog/SortDialog" id="bm_id3154788" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/sortdialog/@@nowidget@@" id="bm_id3451788" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/.uno:OrderCrit" id="bm_id3154682" localize="false"/><section id="sortorder">
<h1 id="hd_id3147000"><variable id="sortierung"><link href="text/shared/02/12100100.xhp" name="Sort Order">Sort Order</link></variable></h1>
<paragraph role="paragraph" id="par_id3163829" xml-lang="en-US"><variable id="sortierentext"><ahelp hid=".uno:OrderCrit">Specifies the sort criteria for the data display.</ahelp></variable></paragraph>
</section>
<section id="howtoget">
<embed href="text/shared/00/00000450.xhp#sort_order"/>
</section>
<paragraph role="paragraph" id="par_id3149549" xml-lang="en-US">While the functions <link href="text/shared/02/12010000.xhp" name="Sort in Ascending Order"><emph>Sort in Ascending Order</emph></link> and <link href="text/shared/02/12020000.xhp" name="Sort in Descending Order"><emph>Sort in Descending Order</emph></link> sort by one criterion only, you can combine several criteria in the <emph>Sort Order</emph> dialog.</paragraph>
<paragraph role="paragraph" id="par_id3145136" xml-lang="en-US">You can remove a sorting that has been performed with the <link href="text/shared/02/12040000.xhp" name="Reset Filter/Sorting"><emph>Reset Filter/Sorting</emph></link> icon.</paragraph>
<h2 id="hd_id3148548">Sorting</h2>
<paragraph role="paragraph" id="par_id3155941" xml-lang="en-US">Use this area to enter sorting criteria. If you enter additional sorting criteria under <emph>and then</emph>, the data matching the content of the higher-order criterion is ordered according to the next criterion.</paragraph>
<paragraph role="paragraph" id="par_id3148620" xml-lang="en-US">If you sort the field name "First name" in ascending order and the field name "Last name" in descending order, all records will be sorted in ascending order by first name, and then within the first names, in descending order by last name.</paragraph>
<h3 id="hd_id3145345">Field name</h3>
<paragraph role="paragraph" id="par_id3159233" xml-lang="en-US"><ahelp hid=".uno:OrderCrit">Specifies the data field name whose content will determine the sort order.</ahelp></paragraph>
<h3 id="hd_id3150774">Order</h3>
<paragraph role="paragraph" id="par_id3149177" xml-lang="en-US"><ahelp hid=".uno:OrderCrit">Specifies the sort order (either ascending or descending).</ahelp></paragraph>
<h3 id="hd_id3147275">and then</h3>
<paragraph role="paragraph" id="par_id3166460" xml-lang="en-US">Specifies additional subordinate sort criteria from the other fields.</paragraph>
</body>
</helpdocument>
|
