Changes
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/libo_help-7-6/textsdatabase/de/changes/?format=api&page=32
{ "count": 1855, "next": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/de/changes/?format=api&page=33", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/de/changes/?format=api&page=31", "results": [ { "unit": "https://translations.documentfoundation.org/api/units/96068053/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/de/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:35:56.191861Z", "action": 59, "target": "Formulare", "id": 33445544, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33445544/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96068049/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/de/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:35:56.191811Z", "action": 59, "target": "<ahelp hid=\".\">Bei einer natürlichen Verknüpfung wird das Schlüsselwort <literal>NATURAL</literal> in die SQL-Anweisung eingefügt, welche die Beziehung definiert. Die Relation verbindet alle Spalten, die in beiden Tabellen denselben Spaltennamen haben. Die resultierende verknüpfte Tabelle enthält nur eine Spalte für jedes Paar gleichnamiger Spalten.</ahelp>", "id": 33445543, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33445543/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96068046/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/de/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:35:56.191762Z", "action": 59, "target": "Natürlicher Verbund", "id": 33445542, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33445542/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96068041/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/de/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:35:56.191712Z", "action": 59, "target": "<ahelp hid=\"dbaccess/ui/joindialog/type\">Bei einem vollständigen Verbund enthält die Ergebnistabelle alle Datensätze der gesuchten Felder der linken und der rechten Tabelle.</ahelp> In $[officename]-SQL entspricht ein solcher Verbund dem Befehl FULL OUTER JOIN.", "id": 33445541, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33445541/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96068038/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/de/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:35:56.191664Z", "action": 59, "target": "Vollständiger Verbund", "id": 33445540, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33445540/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96068029/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/de/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:35:56.191614Z", "action": 59, "target": "<ahelp hid=\"dbaccess/ui/joindialog/type\">Die Ergebnistabelle einer Abfrage mit rechtem Verbund enthält alle Datensätze des Abfragefeldes der rechten Tabelle und nur jene Datensätze des Abfragefeldes der linken Tabelle, bei denen der Inhalt des verknüpften Feldes identisch ist.</ahelp> In $[officename]-SQL entspricht dieser Verknüpfungstyp dem Befehl RIGHT OUTER JOIN.", "id": 33445539, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33445539/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96068022/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/de/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:35:56.191568Z", "action": 59, "target": "Rechter Verbund", "id": 33445538, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33445538/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96068014/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/de/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:35:56.191520Z", "action": 59, "target": "<ahelp hid=\"dbaccess/ui/joindialog/type\">Die Ergebnistabelle einer Abfrage mit linkem Verbund enthält alle Datensätze des Abfragefeldes der linken Tabelle und nur jene Datensätze des Abfragefeldes der rechten Tabelle, bei denen der Inhalt des verknüpften Feldes identisch ist.</ahelp> In $[officename]-SQL entspricht dieser Verknüpfungstyp dem Befehl LEFT OUTER JOIN.", "id": 33445537, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33445537/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96068005/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/de/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:35:56.191477Z", "action": 59, "target": "Linker Verbund", "id": 33445536, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33445536/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96067992/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/de/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:35:56.191431Z", "action": 59, "target": "<ahelp hid=\"dbaccess/ui/joindialog/type\">Die Ergebnistabelle einer Abfrage mit innerem Verbund enthält ausschließlich solche Datensätze, die in den verknüpften Feldern identische Inhalte aufweisen.</ahelp> In $[officename]-SQL stellen Sie diese Art von Verbindung mit der entsprechenden WHERE-Klausel her.", "id": 33445535, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33445535/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96067984/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/de/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:35:56.191387Z", "action": 59, "target": "Innerer Verbund", "id": 33445534, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33445534/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96067966/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/de/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:35:56.191347Z", "action": 59, "target": "<ahelp hid=\"dbaccess/ui/joindialog/type\">Bestimmt den Verbindungstyp der ausgewählten Verbindung.</ahelp> Einige Datenbanken unterstützen nur eine Teilmenge der verschiedenen möglichen Typen.", "id": 33445533, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33445533/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96067963/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/de/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:35:56.191306Z", "action": 59, "target": "Typ", "id": 33445532, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33445532/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96067959/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/de/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:35:56.191264Z", "action": 59, "target": "Optionen", "id": 33445531, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33445531/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96067951/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/de/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:35:56.191219Z", "action": 59, "target": "<ahelp hid=\".\">Hier geben Sie zwei Datenfelder an, die durch eine Relation verbunden werden sollen.</ahelp>", "id": 33445530, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33445530/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96067948/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/de/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:35:56.191173Z", "action": 59, "target": "Beteiligte Felder", "id": 33445529, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33445529/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96067943/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/de/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:35:56.191126Z", "action": 59, "target": "<ahelp hid=\"dbaccess/ui/joindialog/table2\">Hier geben Sie zwei Tabellen an, die verbunden werden sollen.</ahelp>", "id": 33445528, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33445528/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96067934/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/de/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:35:56.191078Z", "action": 59, "target": "Beteiligte Tabellen", "id": 33445527, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33445527/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96067922/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/de/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:35:56.191030Z", "action": 59, "target": "Wenn Sie im Abfrageentwurf auf die Verbindungslinie zwischen zwei verknüpften Feldern doppelklicken oder <emph>Einfügen – Neue Relation…</emph> wählen, öffnet sich der Dialog <emph>Verbundeigenschaften</emph>. Diese Eigenschaften werden auf alle künftig erstellten Abfragen übertragen.", "id": 33445526, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33445526/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96067914/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/de/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:35:56.190985Z", "action": 59, "target": "Verbundeigenschaften", "id": 33445525, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33445525/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96067910/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/de/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:35:56.190942Z", "action": 59, "target": "<bookmark_value>Verknüpfungen; relationale Datenbanken (Base)</bookmark_value><bookmark_value>Innerer Verbund (Base)</bookmark_value><bookmark_value>Verknüpfungen in Datenbanken (Base)</bookmark_value><bookmark_value>Linker Verbund (Base)</bookmark_value><bookmark_value>Rechter Verbund (Base)</bookmark_value><bookmark_value>Vollständiger Verbund (Base)</bookmark_value>", "id": 33445524, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33445524/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96067906/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/de/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:35:56.190900Z", "action": 59, "target": "Verbundeigenschaften", "id": 33445523, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33445523/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96067902/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/de/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:35:56.190858Z", "action": 59, "target": "Indem Sie auf das Symbol <link href=\"text/shared/02/14030000.xhp\"><emph>SQL-Befehl direkt ausführen</emph></link> in der SQL-Ansicht klicken, haben Sie die Möglichkeit, eine Abfrage zu formulieren, die nicht von $[officename] verarbeitet, sondern direkt an das Datenbankmodul gesendet wird.", "id": 33445522, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33445522/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96067900/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/de/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:35:56.190812Z", "action": 59, "target": "Wenn Sie den SQL-Code von Hand eingeben, können Sie SQL-spezifische Abfragen anlegen, die nicht von der grafischen Oberfläche im <emph>Abfrageentwurf</emph> unterstützt werden. Diese Abfragen müssen im Native-SQL-Modus ausgeführt werden.", "id": 33445521, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33445521/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96067889/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/de/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:35:56.190727Z", "action": 59, "target": "Sie können Ihre Abfrage direkt in SQL-Code formulieren. Dabei ist jedoch zu beachten, dass die spezielle Syntax von Ihrem verwendeten Datenbanksystem abhängt.", "id": 33445520, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33445520/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96067883/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/de/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:35:56.180255Z", "action": 59, "target": "Da $[officename] nicht die Eingabe des SQL-Codes verlangt, können Sie die meisten Abfragen auch ohne SQL-Kenntnisse durchführen. Während Sie eine Abfrage im Abfrageentwurf erstellen, setzt $[officename] Ihre Anweisungen automatisch in die entsprechende SQL-Syntax um. Wenn Sie mit der Schaltfläche <emph>Entwurfsansicht ein/aus</emph> in die SQL-Ansicht wechseln, sehen Sie die SQL-Befehle einer bereits erstellten Abfrage.", "id": 33445519, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33445519/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96067879/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/de/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:35:56.180210Z", "action": 59, "target": "SQL steht für \"Structured Query Language\" und beschreibt Anweisungen, um relationale Datenbanken abzufragen, zu aktualisieren und zu verwalten.", "id": 33445518, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33445518/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96067873/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/de/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:35:56.180163Z", "action": 59, "target": "SQL-Modus", "id": 33445517, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33445517/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96067868/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/de/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:35:56.180120Z", "action": 59, "target": "Der Benutzer kann die SQL-Platzhalter \"%\" (beliebige Zeichenfolge) oder \"_\" (beliebiges einzelne Zeichen) als Teil des Werts verwenden, um Datensätze mit komplexeren Kriterien abzufragen.", "id": 33445516, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33445516/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96067862/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/de/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:35:56.180076Z", "action": 59, "target": "Die eingegebenen Werte des Benutzers können jegliche Zeichen enthalten, die für SQL für das relevante Kriterium zulässig sind; dies kann vom zugrundeliegenden Datenbanksystem abhängen.", "id": 33445515, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33445515/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96067854/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/de/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:35:56.180032Z", "action": 59, "target": "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\">Der Dialog <emph>Parametereingabe</emph> fordert den Benutzer zur Eingabe der Parameterwerte auf. Geben Sie einen Wert für jeden Abfrageparameter ein und bestätigen mit einem Klick auf <emph>OK</emph> oder durch Drücken von <emph>Eingabe</emph>.</ahelp>", "id": 33445514, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33445514/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96067849/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/de/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:35:56.179987Z", "action": 59, "target": "Parameter-Eingabe", "id": 33445513, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33445513/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96067844/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/de/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:35:56.179942Z", "action": 59, "target": "Parameterabfragen können als Datenquelle für <link href=\"text/shared/02/01170203.xhp\">Unterformulare</link> verwendet werden, um es dem Benutzer zu erlauben, die angezeigten Datensätze einzuschränken.", "id": 33445512, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33445512/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96067833/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/de/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:35:56.179895Z", "action": 59, "target": "Eine nützliche Konstruktion zum Auswählen von Datensätzen basierend auf Teilen des Inhalts eines Textfelds ist das Hinzufügen einer versteckten Spalte mit <item type=\"input\">\"LIKE '%' || :Teil_des_Feldes || '%'\"</item> als Kriterium. Dadurch werden Datensätze mit einer genauen Übereinstimmung ausgewählt. Wenn ein Test ohne Berücksichtigung der Groß-/Kleinschreibung erwünscht ist, besteht eine Lösung darin, <item type=\"input\">LOWER (Feldname)</item> als Feld und <item type=\"input\">LIKE LOWER ( '%' || :Teil_des_Feldes || '%' )</item> als Kriterium zu verwenden. Beachten Sie, dass die Leerzeichen im Kriterium wichtig sind; Wenn sie weggelassen werden, interpretiert der SQL-Parser das gesamte Kriterium als zu vergleichende Zeichenfolge. Im <link href=\"text/sdatabase/02010100.xhp#sqlmode\">SQL-Modus</link> sollte dies als <item type=\"input\">LOWER ( \"Feldname\" ) WIKE LOWER ( '%' || :Teil_des_Feldes || '%' )</item> eingegeben werden.", "id": 33445511, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33445511/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96067827/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/de/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:35:56.179853Z", "action": 59, "target": "Parameternamen dürfen keines der Zeichen <item type=\"input\"><Leerstelle>`!\"$%^*()+={}[]@'~#<>?/,</item> enthalten. Sie dürfen nicht gleich Feldnamen oder für SQL reservierten Wörter sein. Sie können aber gleich Aliasen sein.", "id": 33445510, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33445510/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96067820/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/de/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:35:56.179811Z", "action": 59, "target": "Im einfachsten Fall, wenn der Benutzer einen Wert eingibt, der auf Gleichheit prüft, wird einfach der Parametername mit vorangestelltem Doppelpunkt in die Zeile Kriterium eingetragen. Im <link href=\"text/sdatabase/02010100.xhp#sqlmode\">SQL-Modus</link> sollte dies als <item type=\"input\">WHERE \"Field\" = :Parametername</item> eingegeben werden.", "id": 33445509, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33445509/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96067812/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/de/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:35:56.179769Z", "action": 59, "target": "Parameternamen wird sowohl in der Entwurfs- als auch in der SQL-Ansicht einer Abfrage ein Doppelpunkt vorangestellt. Dies kann immer dort geschehen, wo ein Wert erscheinen kann. Falls derselbe Wert mehr als einmal in der Abfrage erscheint, wird derselbe Parametername verwendet.", "id": 33445508, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33445508/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96067807/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/de/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:35:56.179729Z", "action": 59, "target": "Parameterabfragen erlauben es dem Benutzer, während der Laufzeit Werte einzugeben. Diese Werte werden innerhalb der Kriterien zur Auswahl der anzuzeigenden Datensätze verwendet. Jeder dieser Werte hat einen damit verbundenen Parameternamen, welcher dazu verwendet wird, den Benutzer während der Abfrage zur Eingabe aufzufordern.", "id": 33445507, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33445507/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96067803/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/de/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:35:56.179690Z", "action": 59, "target": "Parameterabfragen", "id": 33445506, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33445506/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96067798/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/de/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:35:56.179649Z", "action": 59, "target": "Die Syntax ist von dem jeweiligen Datenbanksystem abhängig. Beachten Sie außerdem, dass Ja/Nein-Felder unterschiedlich definiert sein können (nur zwei anstelle von 3 Zuständen).", "id": 33445505, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33445505/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96067795/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/de/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:35:56.179607Z", "action": 59, "target": "IS NULL liefert alle Datensätze, bei denen das Ja/Nein-Feld keinen der beiden Zustände Ja oder Nein hat (graue Markierung).", "id": 33445504, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33445504/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96067791/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/de/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:35:56.179565Z", "action": 59, "target": "IS NULL", "id": 33445503, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33445503/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96067787/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/de/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:35:56.179523Z", "action": 59, "target": "Leer", "id": 33445502, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33445502/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96067781/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/de/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:35:56.179480Z", "action": 59, "target": "=0 liefert alle Datensätze, bei denen das Ja/Nein-Feld den Zustand \"Nein\" oder \"aus\" hat (keine Markierung).", "id": 33445501, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33445501/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96067778/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/de/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:35:56.179440Z", "action": 59, "target": ".", "id": 33445500, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33445500/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96067773/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/de/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:35:56.179401Z", "action": 59, "target": "Nein", "id": 33445499, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33445499/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96067768/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/de/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:35:56.179359Z", "action": 59, "target": "=1 liefert alle Datensätze, bei denen das Ja/Nein-Feld den Zustand \"Ja\" oder \"an\" hat (schwarze Markierung).", "id": 33445498, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33445498/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96067764/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/de/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:35:56.179317Z", "action": 59, "target": "bei dBase-Tabellen: ungleich zu jedem Wert", "id": 33445497, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33445497/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96067760/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/de/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:35:56.179276Z", "action": 59, "target": "Ja", "id": 33445496, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33445496/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96067753/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/de/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:35:56.179235Z", "action": 59, "target": "Beispiel", "id": 33445495, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33445495/?format=api" } ] }