1<?xml version="1.0" encoding="UTF-8"?> 2 3<!--*********************************************************** 4 * 5 * Licensed to the Apache Software Foundation (ASF) under one 6 * or more contributor license agreements. See the NOTICE file 7 * distributed with this work for additional information 8 * regarding copyright ownership. The ASF licenses this file 9 * to you under the Apache License, Version 2.0 (the 10 * "License"); you may not use this file except in compliance 11 * with the License. You may obtain a copy of the License at 12 * 13 * http://www.apache.org/licenses/LICENSE-2.0 14 * 15 * Unless required by applicable law or agreed to in writing, 16 * software distributed under the License is distributed on an 17 * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 18 * KIND, either express or implied. See the License for the 19 * specific language governing permissions and limitations 20 * under the License. 21 * 22 ***********************************************************--> 23 24<helpdocument version="1.0"> 25<meta> 26<topic id="textshared0212100100xml" indexer="include" status="PUBLISH"> 27<title id="tit" xml-lang="en-US">Sort Order</title> 28<filename>/text/shared/02/12100100.xhp</filename> 29</topic> 30</meta> 31<body> 32<bookmark xml-lang="en-US" branch="index" id="bm_id3147000"> 33<bookmark_value>sorting; databases</bookmark_value> 34<bookmark_value>databases; sorting</bookmark_value> 35</bookmark> 36<bookmark xml-lang="en-US" branch="hid/DBACCESS_HID_DLG_ORDERCRIT" id="bm_id3154788" localize="false"/> 37<bookmark xml-lang="en-US" branch="hid/.uno:OrderCrit" id="bm_id3154682" localize="false"/><section id="sortorder"> 38<paragraph role="heading" id="hd_id3147000" xml-lang="en-US" level="1" l10n="U" oldref="1"><variable id="sortierung"><link href="text/shared/02/12100100.xhp" name="Sort Order">Sort Order</link> 39</variable></paragraph> 40<paragraph role="paragraph" id="par_id3163829" xml-lang="en-US" l10n="U" oldref="2"><variable id="sortierentext"><ahelp hid=".uno:OrderCrit">Specifies the sort criteria for the data display.</ahelp> 41</variable></paragraph> 42</section> 43<section id="howtoget"> 44<embed href="text/shared/00/00000450.xhp#sortieren"/> 45</section> 46<paragraph role="paragraph" id="par_id3149549" xml-lang="en-US" l10n="U" oldref="12">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> 47<paragraph role="paragraph" id="par_id3145136" xml-lang="en-US" l10n="U" oldref="13">You can remove a sorting that has been performed with the <link href="text/shared/02/12040000.xhp" name="Remove Filter/Sorting"><emph>Remove Filter/Sorting</emph></link> icon.</paragraph> 48<paragraph role="heading" id="hd_id3148548" xml-lang="en-US" level="2" l10n="U" oldref="4">Sorting</paragraph> 49<paragraph role="paragraph" id="par_id3155941" xml-lang="en-US" l10n="U" oldref="5">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> 50<paragraph role="paragraph" id="par_id3148620" xml-lang="en-US" l10n="U" oldref="14">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> 51<paragraph role="heading" id="hd_id3145345" xml-lang="en-US" level="3" l10n="U" oldref="6">Field name</paragraph> 52<paragraph role="paragraph" id="par_id3159233" xml-lang="en-US" l10n="U" oldref="7"><ahelp hid=".uno:OrderCrit">Specifies the data field name whose content will determine the sort order.</ahelp></paragraph> 53<paragraph role="heading" id="hd_id3150774" xml-lang="en-US" level="3" l10n="U" oldref="8">Order</paragraph> 54<paragraph role="paragraph" id="par_id3149177" xml-lang="en-US" l10n="U" oldref="9"><ahelp hid=".uno:OrderCrit">Specifies the sort order (either ascending or descending).</ahelp></paragraph> 55<paragraph role="heading" id="hd_id3147275" xml-lang="en-US" level="3" l10n="U" oldref="10">and then</paragraph> 56<paragraph role="paragraph" id="par_id3166460" xml-lang="en-US" l10n="U" oldref="11">Specifies additional subordinate sort criteria from the other fields.</paragraph> 57</body> 58</helpdocument> 59