Files
help/source/text/shared/02/limit.xhp
Christian Lohmaier 77cb682cd1 convert plain paragraphs with role="heading" → h<level>
i.e. without child elements and also drop the language that was changed
to implied in the dtd previously/defaults to en-US unless specified.

This change doesn't affect translations, only the content of the
paragraph/headings is extracted.

done with:
perl -CSD -pi -e 'BEGIN {$base = qr/role="heading"|level="(?<level>\d+)"|(?<id>id="[^"]+")/;} s#<paragraph(((\s+($base)){3})|(\s+($base|xml-lang="en-US")){4})>(?<body>[^<]+)</paragraph>#<h$+{level} $+{id}>$+{body}</h$+{level}>#g'

(all permutations re order of attributes, and xml-lang="en-US" being
optional / implied)

Change-Id: I365a2bb983a3969af9390753fce7b7f3597c7b8b
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/148795
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
2023-03-16 15:18:10 +00:00

27 lines
1.1 KiB
XML

<?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/.
*
-->
<meta>
<topic id="textshared02limitxml" indexer="include">
<title id="tit" xml-lang="en-US">Limit</title>
<filename>/text/shared/02/limit.xhp</filename>
</topic>
</meta>
<body>
<bookmark xml-lang="en-US" branch="index" id="bm_id3149991"><bookmark_value>SQL; LIMIT clause</bookmark_value>
</bookmark>
<h1 id="hd_id3149991">Limit</h1>
<bookmark xml-lang="en-US" branch="hid/.uno:DBLimit" id="bm_id3147588" localize="false"/>
<paragraph role="paragraph" id="par_id3154894" xml-lang="en-US"><ahelp hid=".">Expands the created select statement of the <link href="text/sdatabase/02010100.xhp">SQL Query</link> by the LIMIT X clause</ahelp>. This can be used to limit your SQL Query results to those that fall within the first X number of it.</paragraph>
</body>
</helpdocument>