Changes
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/libo_help-24-2/textsdatabase/de/changes/?format=api&page=33
{ "count": 1774, "next": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/de/changes/?format=api&page=34", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/de/changes/?format=api&page=32", "results": [ { "unit": "https://translations.documentfoundation.org/api/units/107643503/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/de/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T16:59:50.794692Z", "action": 59, "target": "Limit", "id": 45382020, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45382020/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107643502/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/de/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T16:59:50.794648Z", "action": 59, "target": "Dieser Befehl entspricht in SQL dem Prädikat DISTINCT.", "id": 45382019, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45382019/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107643500/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/de/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T16:59:50.794610Z", "action": 59, "target": "Bei Abfragen über mehrere Felder muss die Kombination der Werte aus allen Feldern eindeutig sein, damit das Ergebnis eines Datensatzes aufgenommen wird. Nehmen wir an, das Adressbuch enthält einmal \"Schmidt in Hamburg\" und zweimal \"Schmidt in Mainz\". Mit dem Befehl <emph>Eindeutige Werte</emph> liefert die Abfrage über die Felder \"Nachname\" und \"Stadt\" als Ergebnis einmal \"Schmidt in Hamburg\" und einmal \"Schmidt in Mainz\".", "id": 45382018, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45382018/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107643499/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/de/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T16:59:50.794571Z", "action": 59, "target": "Wenn beispielsweise der Name \"Schmidt\" mehrmals in der Adressendatenbank vorkommt, können Sie mithilfe des Befehls <emph>Eindeutige Werte</emph> festlegen, dass er in der Abfrage nur einmal erscheinen soll.", "id": 45382017, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45382017/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107643496/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/de/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T16:59:50.794528Z", "action": 59, "target": "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\">Ruft nur eindeutige Werte über die Abfrage ab.</ahelp> Dies gilt für mehrere Datensätze, welche mehrere wiederholt vorkommende Daten in den ausgewählten Feldern enthalten könnten. Ist der Befehl <emph>Eindeutige Werte</emph> aktiv, wird nur ein Datensatz in der Abfrage angezeigt (DISTINCT). Anderenfalls sind alle die Abfragekriterien erfüllenden Datensätze sichtbar (ALL).", "id": 45382016, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45382016/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107643494/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/de/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T16:59:50.794484Z", "action": 59, "target": "Eindeutige Werte", "id": 45382015, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45382015/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107643492/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/de/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T16:59:50.794440Z", "action": 59, "target": "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\">Blendet die Zeile für den Aliasnamen ein oder aus.</ahelp>", "id": 45382014, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45382014/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107643491/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/de/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T16:59:50.794392Z", "action": 59, "target": "Aliasname", "id": 45382013, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45382013/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107643489/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/de/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T16:59:50.794349Z", "action": 59, "target": "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\">Blendet die Zeile für den Tabellennamen ein oder aus.</ahelp>", "id": 45382012, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45382012/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107643486/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/de/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T16:59:50.794303Z", "action": 59, "target": "Tabellenname", "id": 45382011, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45382011/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107643484/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/de/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T16:59:50.794264Z", "action": 59, "target": "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\">Blendet eine Zeile für die Auswahl von Funktionen ein oder aus.</ahelp>", "id": 45382010, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45382010/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107643482/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/de/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T16:59:50.794226Z", "action": 59, "target": "Funktionen", "id": 45382009, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45382009/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107643480/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/de/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T16:59:50.794185Z", "action": 59, "target": "Folgende Kontextmenübefehle und Symbole sind vorhanden:", "id": 45382008, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45382008/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107643479/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/de/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T16:59:50.794135Z", "action": 59, "target": "Die Abfrage ausführen.", "id": 45382007, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45382007/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107643477/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/de/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T16:59:50.793819Z", "action": 59, "target": "Bei dem Feld \"Lieferanten_Nr\" die Gruppierung auswählen.", "id": 45382006, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45382006/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107643475/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/de/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T16:59:50.793777Z", "action": 59, "target": "Auf Wunsch in der Zeile für den Aliasnamen \"Durchschnitt\" eintragen (ohne Anführungsstriche).", "id": 45382005, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45382005/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107643473/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/de/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T16:59:50.793735Z", "action": 59, "target": "Die Zeile <emph>Funktion</emph> einschalten und bei dem Feld \"Preis\" die Funktion Durchschnitt auswählen.", "id": 45382004, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45382004/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107643470/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/de/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T16:59:50.793692Z", "action": 59, "target": "Die Felder \"Preis\" und \"Lieferanten_Nr\" doppelt anklicken.", "id": 45382003, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45382003/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107643467/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/de/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T16:59:50.793654Z", "action": 59, "target": "Die Tabelle \"Artikel\" in den Abfrageentwurf einfügen.", "id": 45382002, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45382002/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107643465/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/de/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T16:59:50.793614Z", "action": 59, "target": "Wenn in der Tabelle \"Artikel\" die Felder \"Preis\" (für den Einzelpreis eines Artikels) und \"Lieferanten_Nr\" (für den Lieferanten des Artikels) existieren, können Sie mit folgender Abfrage den Durchschnittspreis der Artikel erhalten, die ein Lieferant bereitstellt:", "id": 45382001, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45382001/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107643463/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/de/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T16:59:50.793572Z", "action": 59, "target": "Die Abfrage ausführen.", "id": 45382000, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45382000/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107643461/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/de/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T16:59:50.793530Z", "action": 59, "target": "Das Feld \"Lieferanten_Name\" aus der Tabelle \"Lieferanten\" doppelt anklicken und die Funktion Gruppierung auswählen.", "id": 45381999, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45381999/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107643460/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/de/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T16:59:50.793486Z", "action": 59, "target": "Als Kriterium >3 eingeben und das Feld Sichtbar deaktivieren.", "id": 45381998, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45381998/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107643458/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/de/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T16:59:50.793443Z", "action": 59, "target": "Doppelt auf das Feld \"Artikel_Nr\" in der Tabelle \"Artikel\" klicken. Die Zeile <emph>Funktion</emph> über das Kontextmenü einblenden und die Funktion Anzahl auswählen.", "id": 45381997, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45381997/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107643457/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/de/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T16:59:50.793400Z", "action": 59, "target": "Die Felder \"Lieferanten_Nr\" beider Tabellen verbinden, falls es nicht schon eine entsprechende Relation zwischen den Tabellen gibt.", "id": 45381996, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45381996/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107643455/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/de/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T16:59:50.793355Z", "action": 59, "target": "Die Tabelle \"Artikel\" und \"Lieferanten\" in den Abfrageentwurf einfügen.", "id": 45381995, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45381995/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107643454/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/de/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T16:59:50.793314Z", "action": 59, "target": "Um eine Abfrage zu erstellen, welche alle Lieferanten beinhaltet, die mehr als drei Artikel liefern, sind folgende Schritte nötig:", "id": 45381994, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45381994/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107643452/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/de/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T16:59:50.793274Z", "action": 59, "target": "Im folgenden Beispiel wird eine Abfrage über zwei Tabellen ausgeführt: eine Tabelle \"Artikel\" mit dem Feld \"Artikel_Nr\" und eine Tabelle \"Lieferanten\" mit dem Feld \"Lieferanten_Name\". Außerdem besitzen beide Tabellen ein gemeinsames Datenfeld \"Lieferanten_Nr\".", "id": 45381993, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45381993/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107643450/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/de/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T16:59:50.793232Z", "action": 59, "target": "<emph>Beispiele</emph>", "id": 45381992, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45381992/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107643448/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/de/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T16:59:50.793191Z", "action": 59, "target": "Wenn Sie eine solche Funktion ausführen, können Sie keine weiteren Spalten für die Abfrage einfügen, außer als ein Argument in einer Funktion \"Gruppierung\".", "id": 45381991, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45381991/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107643446/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/de/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T16:59:50.793153Z", "action": 59, "target": "SELECT COUNT(*) AS count FROM \"Artikel\"", "id": 45381990, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45381990/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107643444/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/de/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T16:59:50.793115Z", "action": 59, "target": "Beispiel:", "id": 45381989, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45381989/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107643442/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/de/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T16:59:50.793078Z", "action": 59, "target": "SELECT FUNCTION() AS Alias FROM Tabelle", "id": 45381988, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45381988/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107643440/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/de/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T16:59:50.793038Z", "action": 59, "target": "Im SQL-Statement lautet ein entsprechender Funktionsaufruf:", "id": 45381987, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45381987/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107643439/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/de/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T16:59:50.792996Z", "action": 59, "target": "Für Funktionsaufrufe können Sie ebenfalls Aliasnamen zuweisen. Wenn die Abfragezeichenfolge nicht im Spaltenkopf anzeigen werden soll, geben Sie den gewünschten Namen unter <emph>Alias</emph> ein.", "id": 45381986, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45381986/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107643437/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/de/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T16:59:50.792952Z", "action": 59, "target": "Um andere Funktionen zu verwenden, die nicht im Listenfeld aufgeführt sind, müssen Sie sie manuelle unter <emph>Feld</emph> eingeben.", "id": 45381985, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45381985/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107643435/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/de/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T16:59:50.792911Z", "action": 59, "target": "Bis auf die Funktion <emph>Gruppierung</emph> heißen die obigen Funktionen alle Aggregatfunktionen. Das sind Funktionen, die Daten durch Berechnungen zu Ergebnissen zusammenfassen. Weitere Funktionen sind möglich, die nicht im Listenfeld aufgeführt sind. Diese hängen spezifisch vom verwendeten Datenbanksystem und von der vom aktuellen Base-Treiber für die Verbindung zum Datenbanksystem zur Verfügung gestellten Funktionalität ab.", "id": 45381984, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45381984/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107643434/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/de/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T16:59:50.792869Z", "action": 59, "target": "SELECT SUM(\"Preis\") FROM \"Artikel\".", "id": 45381983, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45381983/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107643432/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/de/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T16:59:50.792820Z", "action": 59, "target": "Beispielsweise lautet der Funktionsaufruf in SQL zum Berechnen einer Summe:", "id": 45381982, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45381982/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107643430/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/de/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T16:59:50.792781Z", "action": 59, "target": "SELECT FUNCTION(Spalte) FROM Tabelle.", "id": 45381981, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45381981/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107643428/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/de/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T16:59:50.792743Z", "action": 59, "target": "Sie können Funktionsaufrufe auch direkt in die SQL-Anweisung eingeben. Die Syntax lautet:", "id": 45381980, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45381980/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107643427/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/de/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T16:59:50.792703Z", "action": 59, "target": "Gruppiert Abfragedaten nach dem ausgewählten Feldnamen. Funktionen werden gemäß den angegebenen Gruppen ausgeführt. In SQL entspricht diese Option der GROUP BY-Klausel. Wenn ein Kriterium hinzugefügt wird, erscheint dieser Eintrag in der SQL HAVING-Unterklausel.", "id": 45381979, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45381979/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107643426/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/de/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T16:59:50.792663Z", "action": 59, "target": "Gruppierung", "id": 45381978, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45381978/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107643425/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/de/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T16:59:50.792623Z", "action": 59, "target": "Berechnet die Summe der Werte der Datensätze für die zugeordneten Felder.", "id": 45381977, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45381977/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107643423/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/de/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T16:59:50.792583Z", "action": 59, "target": "Summe", "id": 45381976, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45381976/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107643422/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/de/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T16:59:50.792543Z", "action": 59, "target": "Bestimmt den niedrigsten Wert eines Datensatzes für dieses Feld.", "id": 45381975, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45381975/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107643420/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/de/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T16:59:50.792503Z", "action": 59, "target": "Minimum", "id": 45381974, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45381974/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107643419/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/de/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T16:59:50.792460Z", "action": 59, "target": "Bestimmt den höchsten Wert eines Datensatzes für dieses Feld.", "id": 45381973, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45381973/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107643417/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/de/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T16:59:50.792423Z", "action": 59, "target": "Maximum", "id": 45381972, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45381972/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107643414/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/de/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T16:59:50.792383Z", "action": 59, "target": "b) COUNT(Spalte): Die Übergabe eines Feldnamens als Argument zählt nur die Datensätze, in denen das angegebene Feld einen Wert enthält. Datensätze, bei denen das Feld einen Nullwert hat (das heißt keinen Text- oder Zahlenwert enthält), werden nicht gezählt.", "id": 45381971, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45381971/?format=api" } ] }