Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/libo_help-24-2/textsdatabase/fr/units/?format=api&page=3
https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/fr/units/?format=api&page=4", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/fr/units/?format=api&page=2", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/fr/?format=api", "source": [ "For example:" ], "previous_source": "", "target": [ "Par exemple :" ], "id_hash": 8995234995823052801, "content_hash": 8995234995823052801, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3159335\nhelp.text", "note": "TWexq", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 101, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/107515828/?format=api", "priority": 100, "id": 107738105, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/fr/?checksum=fcd57e91e5320801", "url": "https://translations.documentfoundation.org/api/units/107738105/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:30.402996Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/fr/?format=api", "source": [ "Table" ], "previous_source": "", "target": [ "Table" ], "id_hash": -5757111159800539212, "content_hash": -5757111159800539212, "location": "02010100.xhp", "context": "02010100.xhp\nhd_id3148485\nhelp.text", "note": "roTzi", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 102, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/107515831/?format=api", "priority": 100, "id": 107738107, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/fr/?checksum=301aa1e713a6d7b4", "url": "https://translations.documentfoundation.org/api/units/107738107/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:30.404877Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/fr/?format=api", "source": [ "<ahelp hid=\"HID_QRYDGN_ROW_TABLE\">The corresponding database table of the selected data field is listed here.</ahelp> If you activate this cell with a mouse click, an arrow will appear which enables you to select a different table for the current query." ], "previous_source": "", "target": [ "<ahelp hid=\"HID_QRYDGN_ROW_TABLE\">La table de base de données correspondante du champ de données sélectionné est listée ici.</ahelp> Si vous activez une cellule à l'aide d'un clic de souris, une flèche apparaîtra qui vous permettra de sélectionner une autre table pour la requête active." ], "id_hash": -8607992337364229760, "content_hash": -8607992337364229760, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3163665\nhelp.text", "note": "GM9Sp", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 103, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 38, "source_unit": "https://translations.documentfoundation.org/api/units/107515833/?format=api", "priority": 100, "id": 107738108, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/fr/?checksum=088a4493861ee180", "url": "https://translations.documentfoundation.org/api/units/107738108/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:30.406632Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/fr/?format=api", "source": [ "Sort" ], "previous_source": "", "target": [ "Trier" ], "id_hash": -2339764603938987521, "content_hash": -2339764603938987521, "location": "02010100.xhp", "context": "02010100.xhp\nhd_id3154207\nhelp.text", "note": "JGcfa", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 104, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/107515836/?format=api", "priority": 100, "id": 107738113, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/fr/?checksum=5f877c7d442f21ff", "url": "https://translations.documentfoundation.org/api/units/107738113/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:30.412273Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/fr/?format=api", "source": [ "<ahelp hid=\"HID_QRYDGN_ROW_ORDER\">If you click on this cell, you can choose a sort option: ascending, descending and unsorted.</ahelp> Text fields will be sorted alphabetically and numerical fields numerically. For most databases, administrators can set the sorting options at the database level." ], "previous_source": "", "target": [ "<ahelp hid=\"HID_QRYDGN_ROW_ORDER\">Si vous cliquez sur cette cellule, vous pouvez choisir parmi les options de tri suivantes : croissant, décroissant et non trié.</ahelp> Les champs de texte seront triés par ordre alphabétique et les champs numériques par ordre numérique. Pour la plupart des bases de données, les administrateurs peuvent paramétrer les options de tri au niveau de la base de données." ], "id_hash": -1031038218170177832, "content_hash": -1031038218170177832, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3150979\nhelp.text", "note": "uXuDt", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 105, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 40, "source_unit": "https://translations.documentfoundation.org/api/units/107515838/?format=api", "priority": 100, "id": 107738116, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/fr/?checksum=71b10434081d66d8", "url": "https://translations.documentfoundation.org/api/units/107738116/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:30.415360Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/fr/?format=api", "source": [ "Visible" ], "previous_source": "", "target": [ "Visible" ], "id_hash": 6896535723236492576, "content_hash": 6896535723236492576, "location": "02010100.xhp", "context": "02010100.xhp\nhd_id3150384\nhelp.text", "note": "XsqW8", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 106, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/107515842/?format=api", "priority": 100, "id": 107738118, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/fr/?checksum=dfb56ab36c4d8520", "url": "https://translations.documentfoundation.org/api/units/107738118/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:30.417873Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/fr/?format=api", "source": [ "<ahelp hid=\"HID_QRYDGN_ROW_VISIBLE\">If you mark the <emph>Visible</emph> property for a data field, that field will be visibly displayed in the resulting query</ahelp>. If you are only using a data field to formulate a condition or make a calculation, you do not necessarily need to display it." ], "previous_source": "", "target": [ "<ahelp hid=\"HID_QRYDGN_ROW_VISIBLE\">Si vous cochez la propriété <emph>Visible</emph> pour un champ de données, ce champ est visible dans la requête résultante</ahelp>. Si un champ de données est utilisé dans le seul but de formuler une condition ou de faire un calcul, son affichage n'est pas indispensable." ], "id_hash": -5614781346581602478, "content_hash": -5614781346581602478, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3146133\nhelp.text", "note": "AAZfA", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 107, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 45, "source_unit": "https://translations.documentfoundation.org/api/units/107515854/?format=api", "priority": 100, "id": 107738120, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/fr/?checksum=32144a1d19839f52", "url": "https://translations.documentfoundation.org/api/units/107738120/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:30.419795Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/fr/?format=api", "source": [ "Criteria" ], "previous_source": "", "target": [ "Critères" ], "id_hash": 469406007502932698, "content_hash": 469406007502932698, "location": "02010100.xhp", "context": "02010100.xhp\nhd_id3154714\nhelp.text", "note": "eQFRR", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 108, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/107515869/?format=api", "priority": 100, "id": 107738121, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/fr/?checksum=8683aa46dca58ada", "url": "https://translations.documentfoundation.org/api/units/107738121/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:30.422499Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/fr/?format=api", "source": [ "<ahelp hid=\"HID_QRYDGN_ROW_CRIT\">Specifies a first criteria by which the content of the data field is to be filtered.</ahelp>" ], "previous_source": "", "target": [ "<ahelp hid=\"HID_QRYDGN_ROW_CRIT\">Spécifie un premier critère selon lequel le contenu du champ de données doit être filtré.</ahelp>" ], "id_hash": 4919040097694507359, "content_hash": 4919040097694507359, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3145134\nhelp.text", "note": "fWRgB", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 109, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 17, "source_unit": "https://translations.documentfoundation.org/api/units/107515884/?format=api", "priority": 100, "id": 107738123, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/fr/?checksum=c443f0e81afbe15f", "url": "https://translations.documentfoundation.org/api/units/107738123/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:30.424582Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/fr/?format=api", "source": [ "or" ], "previous_source": "", "target": [ "ou" ], "id_hash": -2192449250051491563, "content_hash": -2192449250051491563, "location": "02010100.xhp", "context": "02010100.xhp\nhd_id3152477\nhelp.text", "note": "qpADC", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 110, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/107515951/?format=api", "priority": 100, "id": 107738125, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/fr/?checksum=6192db05ee9bf915", "url": "https://translations.documentfoundation.org/api/units/107738125/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:30.426867Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/fr/?format=api", "source": [ "Here you can enter one additional filter criterion for each line. Multiple criteria in a single column will be interpreted as boolean OR." ], "previous_source": "", "target": [ "Sur chaque ligne vous pouvez saisir un critère de filtre supplémentaire. Plusieurs critères dans une colonne seront interprétés par un OU." ], "id_hash": -5948053012660454605, "content_hash": -5948053012660454605, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3154585\nhelp.text", "note": "KFVy8", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 111, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 23, "source_unit": "https://translations.documentfoundation.org/api/units/107515974/?format=api", "priority": 100, "id": 107738127, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/fr/?checksum=2d74454c932e7b33", "url": "https://translations.documentfoundation.org/api/units/107738127/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:30.429959Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/fr/?format=api", "source": [ "You can also use the context menu of the line headers in the lower area of the query design window to insert a filter based on a function:" ], "previous_source": "", "target": [ "Vous pouvez également utiliser le menu contextuel des en-têtes de ligne dans la partie inférieure de la fenêtre de conception de la requête pour insérer un filtre basé sur une fonction :" ], "id_hash": -4995871244841271865, "content_hash": -4995871244841271865, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3148800\nhelp.text", "note": "eXvp7", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 112, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 28, "source_unit": "https://translations.documentfoundation.org/api/units/107515995/?format=api", "priority": 100, "id": 107738129, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/fr/?checksum=3aab199273a5bdc7", "url": "https://translations.documentfoundation.org/api/units/107738129/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:30.432328Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/fr/?format=api", "source": [ "Functions" ], "previous_source": "", "target": [ "Fonctions" ], "id_hash": -3778155876137593813, "content_hash": -3778155876137593813, "location": "02010100.xhp", "context": "02010100.xhp\nhd_id3148419\nhelp.text", "note": "5x8LE", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 113, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/107516016/?format=api", "priority": 100, "id": 107738133, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/fr/?checksum=4b914b3f88c3942b", "url": "https://translations.documentfoundation.org/api/units/107738133/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:30.438675Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/fr/?format=api", "source": [ "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\" visibility=\"hidden\">Select a function to run in the query.</ahelp> The functions which are available here depend on those provided by the database engine." ], "previous_source": "", "target": [ "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\" visibility=\"hidden\">Sélectionnez une fonction à exécuter dans la requête.</ahelp> Les fonctions que vous pouvez exécuter ici dépendent de celles fournies par le moteur de base de données." ], "id_hash": 1942541461262905934, "content_hash": 1942541461262905934, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3153233\nhelp.text", "note": "Cxhjn", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 114, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 24, "source_unit": "https://translations.documentfoundation.org/api/units/107516037/?format=api", "priority": 100, "id": 107738134, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/fr/?checksum=9af54b2ac00b324e", "url": "https://translations.documentfoundation.org/api/units/107738134/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:30.440645Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/fr/?format=api", "source": [ "If you are working with the embedded HSQL database, the list box in the <emph>Function</emph> row offers you the following options:" ], "previous_source": "", "target": [ "Si vous utilisez la base de données HSQL intégrée, la zone de liste dans la ligne <emph>Fonction</emph> propose les options suivantes :" ], "id_hash": -4919950466613680551, "content_hash": -4919950466613680551, "location": "02010100.xhp", "context": "02010100.xhp\npar_id8760818\nhelp.text", "note": "qFuqw", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 115, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 21, "source_unit": "https://translations.documentfoundation.org/api/units/107516052/?format=api", "priority": 100, "id": 107738138, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/fr/?checksum=3bb8d31e1cf96659", "url": "https://translations.documentfoundation.org/api/units/107738138/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:30.445283Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/fr/?format=api", "source": [ "Option" ], "previous_source": "", "target": [ "Option" ], "id_hash": -772347665347452252, "content_hash": -772347665347452252, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3150307\nhelp.text", "note": "9tdDn", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 116, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/107516083/?format=api", "priority": 100, "id": 107738140, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/fr/?checksum=754811e3f3dce2a4", "url": "https://translations.documentfoundation.org/api/units/107738140/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:30.448844Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/fr/?format=api", "source": [ "Effect" ], "previous_source": "", "target": [ "Effet" ], "id_hash": -7801313243572344229, "content_hash": -7801313243572344229, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3152993\nhelp.text", "note": "kBvXF", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 117, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/107516106/?format=api", "priority": 100, "id": 107738146, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/fr/?checksum=13bc2af02751ea5b", "url": "https://translations.documentfoundation.org/api/units/107738146/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:30.456794Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/fr/?format=api", "source": [ "No function" ], "previous_source": "", "target": [ "Aucune fonction" ], "id_hash": -7324759229702383126, "content_hash": -7324759229702383126, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3155377\nhelp.text", "note": "zCunm", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 118, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/107516121/?format=api", "priority": 100, "id": 107738150, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/fr/?checksum=1a593a49f05359ea", "url": "https://translations.documentfoundation.org/api/units/107738150/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:30.464712Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/fr/?format=api", "source": [ "No function will be executed." ], "previous_source": "", "target": [ "Aucune fonction n'est exécutée." ], "id_hash": -619848378788163284, "content_hash": -619848378788163284, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3155533\nhelp.text", "note": "kZMTN", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 119, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/107516133/?format=api", "priority": 100, "id": 107738152, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/fr/?checksum=7765db2effbad12c", "url": "https://translations.documentfoundation.org/api/units/107738152/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:30.467575Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/fr/?format=api", "source": [ "Average" ], "previous_source": "", "target": [ "Moyenne" ], "id_hash": -3393985297947577142, "content_hash": -3393985297947577142, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3166420\nhelp.text", "note": "6dWZZ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 120, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/107516159/?format=api", "priority": 100, "id": 107738158, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/fr/?checksum=50e6245a86efb4ca", "url": "https://translations.documentfoundation.org/api/units/107738158/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:30.475784Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/fr/?format=api", "source": [ "Calculates the arithmetic mean of a field." ], "previous_source": "", "target": [ "Calcule la moyenne arithmétique d'un champ." ], "id_hash": 3066656777709062648, "content_hash": 3066656777709062648, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3154486\nhelp.text", "note": "NfRNs", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 121, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/107516172/?format=api", "priority": 100, "id": 107738160, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/fr/?checksum=aa8ef4176b6489f8", "url": "https://translations.documentfoundation.org/api/units/107738160/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:30.478177Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/fr/?format=api", "source": [ "Count" ], "previous_source": "", "target": [ "NB" ], "id_hash": -5772603136064988624, "content_hash": -5772603136064988624, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3149979\nhelp.text", "note": "6z2Kj", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 122, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/107516190/?format=api", "priority": 100, "id": 107738162, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/fr/?checksum=2fe39808458a5a30", "url": "https://translations.documentfoundation.org/api/units/107738162/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:30.480378Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/fr/?format=api", "source": [ "Determines the number of records in the table. Empty fields can either be counted (a) or excluded (b)." ], "previous_source": "", "target": [ "Détermine le nombre d'enregistrements dans la table. Les champs vides peuvent être comptés (a) ou exclus (b)." ], "id_hash": -6730459759722231728, "content_hash": -6730459759722231728, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3155810\nhelp.text", "note": "rvWA5", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 123, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/107516224/?format=api", "priority": 100, "id": 107738167, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/fr/?checksum=22989a820eb20850", "url": "https://translations.documentfoundation.org/api/units/107738167/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:30.487413Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/fr/?format=api", "source": [ "a) COUNT(*): Passing an asterisk as the argument counts all records in the table." ], "previous_source": "", "target": [ "a) NB(*) : Lorsque vous fournissez un astérisque en guise d'argument, tous les enregistrements de la table sont comptés." ], "id_hash": -6577677318719850332, "content_hash": -6577677318719850332, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3151333\nhelp.text", "note": "UyAx2", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 124, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/107516242/?format=api", "priority": 100, "id": 107738169, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/fr/?checksum=24b76554228f38a4", "url": "https://translations.documentfoundation.org/api/units/107738169/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:30.492265Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/fr/?format=api", "source": [ "b) COUNT(column): Passing a field name as an argument counts only the records in which the specified field contains a value. Records in which the field has a Null value (i.e. contains no textual or numeric value) will not be counted." ], "previous_source": "", "target": [ "b) NB(colonne) : passer un nom de champ comme argument compte uniquement les enregistrements dans lesquels le champ spécifié contient une valeur. Les enregistrements pour lesquels le champ a une valeur Null (i.e. ne contient ni de valeur textuelle ou numérique) ne seront pas comptés." ], "id_hash": -3702508971976732456, "content_hash": -3702508971976732456, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3152889\nhelp.text", "note": "FNCC8", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 125, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 41, "source_unit": "https://translations.documentfoundation.org/api/units/107516293/?format=api", "priority": 100, "id": 107738192, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/fr/?checksum=4c9e0bb4eba150d8", "url": "https://translations.documentfoundation.org/api/units/107738192/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:30.519173Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/fr/?format=api", "source": [ "Maximum" ], "previous_source": "", "target": [ "Maximum" ], "id_hash": -3013235731327700788, "content_hash": -3013235731327700788, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3153067\nhelp.text", "note": "2ubvb", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 126, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/107516309/?format=api", "priority": 100, "id": 107738204, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/fr/?checksum=562ed61131b2b0cc", "url": "https://translations.documentfoundation.org/api/units/107738204/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:30.530256Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/fr/?format=api", "source": [ "Determines the highest value of a record for that field." ], "previous_source": "", "target": [ "Détermine la plus grande valeur d'un enregistrement pour ce champ." ], "id_hash": -1271906049264834213, "content_hash": -1271906049264834213, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3159221\nhelp.text", "note": "ds4ey", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 127, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/107516343/?format=api", "priority": 100, "id": 107738208, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/fr/?checksum=6e59482fe1e6295b", "url": "https://translations.documentfoundation.org/api/units/107738208/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:30.533842Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/fr/?format=api", "source": [ "Minimum" ], "previous_source": "", "target": [ "Minimum" ], "id_hash": -3369143774484625893, "content_hash": -3369143774484625893, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3146866\nhelp.text", "note": "EhSWy", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 128, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/107516351/?format=api", "priority": 100, "id": 107738222, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/fr/?checksum=513e65966ca0061b", "url": "https://translations.documentfoundation.org/api/units/107738222/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:30.554631Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/fr/?format=api", "source": [ "Determines the lowest value of a record for that field." ], "previous_source": "", "target": [ "Détermine la plus petite valeur d'un enregistrement pour ce champ." ], "id_hash": 7910640238210885664, "content_hash": 7910640238210885664, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3157982\nhelp.text", "note": "VxmeB", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 129, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/107516366/?format=api", "priority": 100, "id": 107738224, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/fr/?checksum=edc83d626078a820", "url": "https://translations.documentfoundation.org/api/units/107738224/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:30.556757Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/fr/?format=api", "source": [ "Sum" ], "previous_source": "", "target": [ "Somme" ], "id_hash": -3951253331645022563, "content_hash": -3951253331645022563, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3154828\nhelp.text", "note": "CvkuF", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 130, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/107516372/?format=api", "priority": 100, "id": 107738228, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/fr/?checksum=492a54078db83e9d", "url": "https://translations.documentfoundation.org/api/units/107738228/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:30.559387Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/fr/?format=api", "source": [ "Calculates the sum of the values of records for the associated fields." ], "previous_source": "", "target": [ "Calcule la somme des valeurs des enregistrements pour les champs associés." ], "id_hash": -1293247112796432643, "content_hash": -1293247112796432643, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3154536\nhelp.text", "note": "82gAC", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 131, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/107516382/?format=api", "priority": 100, "id": 107738232, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/fr/?checksum=6e0d769a52f816fd", "url": "https://translations.documentfoundation.org/api/units/107738232/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:30.563966Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/fr/?format=api", "source": [ "Group" ], "previous_source": "", "target": [ "Grouper" ], "id_hash": 5611092234196237787, "content_hash": 5611092234196237787, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3148820\nhelp.text", "note": "zCzVC", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 132, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/107516389/?format=api", "priority": 100, "id": 107738237, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/fr/?checksum=cdde9aa87d383ddb", "url": "https://translations.documentfoundation.org/api/units/107738237/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:30.569010Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/fr/?format=api", "source": [ "Groups query data according to the selected field name. Functions are executed according to the specified groups. In SQL, this option corresponds to the GROUP BY clause. If a criterion is added, this entry appears in the SQL HAVING sub-clause." ], "previous_source": "", "target": [ "Regroupe les données de la requête en fonction du nom de champ sélectionné. Les fonctions sont exécutées selon les groupes spécifiés. En SQL, cette commande correspond à la clause GROUP BY (grouper par). Si un critère est ajouté, cette entrée s'affiche dans la sous-clause SQL HAVING." ], "id_hash": -7409234191239514324, "content_hash": -7409234191239514324, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3149438\nhelp.text", "note": "tSPNG", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 133, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 40, "source_unit": "https://translations.documentfoundation.org/api/units/107516410/?format=api", "priority": 100, "id": 107738240, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/fr/?checksum=192d1cc2457d772c", "url": "https://translations.documentfoundation.org/api/units/107738240/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:30.572287Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/fr/?format=api", "source": [ "You can also enter function calls directly into the SQL statement. The syntax is:" ], "previous_source": "", "target": [ "Vous pouvez également saisir des appels de fonctions directement dans l'instruction SQL. La syntaxe est la suivante :" ], "id_hash": -3806082811502480015, "content_hash": -3806082811502480015, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3156038\nhelp.text", "note": "qHfpD", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 134, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/107516415/?format=api", "priority": 100, "id": 107738241, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/fr/?checksum=4b2e13d932acb571", "url": "https://translations.documentfoundation.org/api/units/107738241/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:30.575737Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/fr/?format=api", "source": [ "SELECT FUNCTION(column) FROM table." ], "previous_source": "", "target": [ "SELECT FUNCTION(column) FROM table." ], "id_hash": -1305221081140801602, "content_hash": -1305221081140801602, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3156340\nhelp.text", "note": "Qg6Ue", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 135, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/107516420/?format=api", "priority": 100, "id": 107738244, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/fr/?checksum=6de2ec5791404fbe", "url": "https://translations.documentfoundation.org/api/units/107738244/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:30.578440Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/fr/?format=api", "source": [ "For example, the function call in SQL for calculating a sum is:" ], "previous_source": "", "target": [ "Par exemple, l'appel de fonction permettant de calculer une somme se présentera comme suit dans SQL :" ], "id_hash": -7092442938933433496, "content_hash": -7092442938933433496, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3155075\nhelp.text", "note": "qAAoF", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 136, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/107516436/?format=api", "priority": 100, "id": 107738246, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/fr/?checksum=1d9294b973252b68", "url": "https://translations.documentfoundation.org/api/units/107738246/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:30.581475Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/fr/?format=api", "source": [ "SELECT SUM(\"Price\") FROM \"Article\"." ], "previous_source": "", "target": [ "SELECT SUM(\"Prix\") FROM \"Articles\"." ], "id_hash": 6764390312089837957, "content_hash": 6764390312089837957, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3154591\nhelp.text", "note": "VrHLf", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 137, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/107516457/?format=api", "priority": 100, "id": 107738249, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/fr/?checksum=dddff1264a356185", "url": "https://translations.documentfoundation.org/api/units/107738249/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:30.584009Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/fr/?format=api", "source": [ "Except for the <emph>Group</emph> function, the above functions are called Aggregate functions. These are functions that calculate data to create summaries from the results. Additional functions that are not listed in the list box might be also possible. These depend on the specific database engine in use and on the current functionality provided by the Base driver used to connect to that database engine." ], "previous_source": "", "target": [ "Sauf pour la fonction <emph>Grouper</emph>, les fonctions ci-dessus sont appelées fonctions consolidées. Ce sont des fonctions calculant des données afin de créer des récapitulatifs des résultats. D'autres fonctions que celles listées dans la zone de liste sont également disponibles. Elles dépendent du moteur de base de données spécifique utilisé et de l'état des fonctionnalités fournies par le pilote Base utilisé pour se connecter à ce moteur de base de données." ], "id_hash": -5781971165104475833, "content_hash": -5781971165104475833, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3159205\nhelp.text", "note": "dABCo", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 138, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 64, "source_unit": "https://translations.documentfoundation.org/api/units/107516464/?format=api", "priority": 100, "id": 107738251, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/fr/?checksum=2fc24fdc0a657147", "url": "https://translations.documentfoundation.org/api/units/107738251/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:30.586523Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/fr/?format=api", "source": [ "To use other functions not listed in the list box, you must enter them manually under <emph>Field</emph>." ], "previous_source": "", "target": [ "Pour utiliser d'autres fonctions qui ne sont pas listées dans la zone de liste, vous devez les saisir manuellement sous <emph>Champ</emph>." ], "id_hash": -2209269641612400515, "content_hash": -2209269641612400515, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3148651\nhelp.text", "note": "BVC6J", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 139, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 17, "source_unit": "https://translations.documentfoundation.org/api/units/107516486/?format=api", "priority": 100, "id": 107738254, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/fr/?checksum=615718f756a3687d", "url": "https://translations.documentfoundation.org/api/units/107738254/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:30.590520Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/fr/?format=api", "source": [ "You can also assign aliases to function calls. If you do not want to display the query string in the column header, enter a desired substitute name under <emph>Alias</emph>." ], "previous_source": "", "target": [ "Pour les appels de fonctions, vous pouvez également utiliser des alias. Pour que les noms de fonctions n'apparaissent pas dans l'en-tête de colonne, saisissez le nom de substitution souhaité sous <emph>Alias</emph>." ], "id_hash": 4139553630722688505, "content_hash": 4139553630722688505, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3155098\nhelp.text", "note": "WkboS", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 140, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 29, "source_unit": "https://translations.documentfoundation.org/api/units/107516500/?format=api", "priority": 100, "id": 107738258, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/fr/?checksum=b972a61847e785f9", "url": "https://translations.documentfoundation.org/api/units/107738258/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:30.593451Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/fr/?format=api", "source": [ "The corresponding function in an SQL statement is:" ], "previous_source": "", "target": [ "Dans une instruction SQL, l'appel de fonction correspondant se présente comme suit :" ], "id_hash": 9037870816902336553, "content_hash": 9037870816902336553, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3155539\nhelp.text", "note": "98GCC", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 141, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/107516540/?format=api", "priority": 100, "id": 107738261, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/fr/?checksum=fd6cf79f8f555029", "url": "https://translations.documentfoundation.org/api/units/107738261/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:30.596278Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/fr/?format=api", "source": [ "SELECT FUNCTION() AS alias FROM table" ], "previous_source": "", "target": [ "SELECT FUNCTION() AS alias FROM table" ], "id_hash": 3137508638940812960, "content_hash": 3137508638940812960, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3149425\nhelp.text", "note": "WACG9", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 142, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/107516555/?format=api", "priority": 100, "id": 107738267, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/fr/?checksum=ab8aab7bdfc956a0", "url": "https://translations.documentfoundation.org/api/units/107738267/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:30.601966Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/fr/?format=api", "source": [ "Example:" ], "previous_source": "", "target": [ "Exemple :" ], "id_hash": 3538033891106052086, "content_hash": 3538033891106052086, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3144431\nhelp.text", "note": "EjzuD", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 143, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/107516563/?format=api", "priority": 100, "id": 107738271, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/fr/?checksum=b1199f1422ab57f6", "url": "https://translations.documentfoundation.org/api/units/107738271/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:30.605046Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/fr/?format=api", "source": [ "SELECT COUNT(*) AS count FROM \"Item\"" ], "previous_source": "", "target": [ "SELECT COUNT(*) AS Nombre FROM \"Articles\"" ], "id_hash": -5763803079986489729, "content_hash": -5763803079986489729, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3154614\nhelp.text", "note": "G9URE", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 144, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/107516591/?format=api", "priority": 100, "id": 107738274, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/fr/?checksum=3002dba2fe1a567f", "url": "https://translations.documentfoundation.org/api/units/107738274/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:30.607767Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/fr/?format=api", "source": [ "If you run such a function, you cannot insert any additional columns for the query other than as an argument in a \"Group\" function." ], "previous_source": "", "target": [ "Lorsque vous exécutez une telle fonction, vous ne pouvez pas insérer de colonnes additionnelles pour la requête autres que celles incluses dans la fonction \"Grouper\"." ], "id_hash": 5156466470725607062, "content_hash": 5156466470725607062, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3154610\nhelp.text", "note": "xiNnR", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 145, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 24, "source_unit": "https://translations.documentfoundation.org/api/units/107516617/?format=api", "priority": 100, "id": 107738276, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/fr/?checksum=c78f72ef5bcfde96", "url": "https://translations.documentfoundation.org/api/units/107738276/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:30.610201Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/fr/?format=api", "source": [ "<emph>Examples</emph>" ], "previous_source": "", "target": [ "<emph>Exemples</emph>" ], "id_hash": 8201778419404166585, "content_hash": 8201778419404166585, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3154644\nhelp.text", "note": "EHACK", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 146, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/107516631/?format=api", "priority": 100, "id": 107738279, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/fr/?checksum=f1d292047f0cd5b9", "url": "https://translations.documentfoundation.org/api/units/107738279/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:30.613331Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/fr/?format=api", "source": [ "In the following example, a query is run through two tables: an \"Item\" table with the \"Item_No\" field and a \"Suppliers\" table with the \"Supplier_Name\" field. In addition, both tables have a common field name \"Supplier_No.\"" ], "previous_source": "", "target": [ "Dans l'exemple suivant, une requête portant sur deux tables est exécutée : une table \"Articles\" contenant le champ \"No_article\" et une table \"Fournisseurs\" contenant le champ \"Nom_fournisseur\". Par ailleurs, les deux tables possèdent un champ commun, en l'occurrence \"No_fournisseur\"" ], "id_hash": 5859342271891411772, "content_hash": 5859342271891411772, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3151120\nhelp.text", "note": "N5CBE", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 147, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 36, "source_unit": "https://translations.documentfoundation.org/api/units/107516674/?format=api", "priority": 100, "id": 107738281, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/fr/?checksum=d15090c08d84933c", "url": "https://translations.documentfoundation.org/api/units/107738281/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:30.616399Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/fr/?format=api", "source": [ "The following steps are required to create a query containing all suppliers who deliver more than three items." ], "previous_source": "", "target": [ "Pour créer une requête contenant tous les fournisseurs qui livrent plus de trois articles, les étapes suivantes sont nécessaires." ], "id_hash": -4011807035459456714, "content_hash": -4011807035459456714, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3155144\nhelp.text", "note": "P5hJD", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 148, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/107516687/?format=api", "priority": 100, "id": 107738287, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/fr/?checksum=485332c1b806b136", "url": "https://translations.documentfoundation.org/api/units/107738287/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:30.623537Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/fr/?format=api", "source": [ "Insert the \"Item\" and \"Suppliers\" tables into the query design." ], "previous_source": "", "target": [ "Insérer les tables \"Articles\" et \"Fournisseurs\" dans l'ébauche de requête." ], "id_hash": 1435240278817732818, "content_hash": 1435240278817732818, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3153240\nhelp.text", "note": "ZhRQD", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 149, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/107516695/?format=api", "priority": 100, "id": 107738289, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/fr/?checksum=93eaff6dea4378d2", "url": "https://translations.documentfoundation.org/api/units/107738289/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:30.626525Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/fr/?format=api", "source": [ "Link the \"Supplier_No\" fields of the two tables if there is not already a relation of this type." ], "previous_source": "", "target": [ "Lier les champs \"No_fournisseur\" des deux tables, au cas où il n'existe pas déjà de relation de ce type entre les deux tables." ], "id_hash": 2905548939711794635, "content_hash": 2905548939711794635, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3148807\nhelp.text", "note": "LMRUV", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 150, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/107516703/?format=api", "priority": 100, "id": 107738293, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/fr/?checksum=a852955dcd08cdcb", "url": "https://translations.documentfoundation.org/api/units/107738293/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:30.632096Z" } ] }{ "count": 1739, "next": "