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=6
{ "count": 1739, "next": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/fr/units/?format=api&page=7", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/fr/units/?format=api&page=5", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/fr/?format=api", "source": [ "All date expressions (date literals) must be enclosed with single quotation marks. (Consult the reference for the particular database and connector you are using for more details.)" ], "previous_source": "", "target": [ "Toutes les expressions (littérales de date) doivent être placées entre guillemets simples (pour plus de détails, consultez la documentation de référence de la base de données et du connecteur que vous utilisez.)" ], "id_hash": -4673270034736519928, "content_hash": -4673270034736519928, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3150510\nhelp.text", "note": "CZdA4", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 251, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 27, "source_unit": "https://translations.documentfoundation.org/api/units/107518590/?format=api", "priority": 100, "id": 107738633, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/fr/?checksum=3f2535a9d80d6508", "url": "https://translations.documentfoundation.org/api/units/107738633/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:31.160062Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/fr/?format=api", "source": [ "Querying Yes/No fields" ], "previous_source": "", "target": [ "Interroger les champs Oui/Non" ], "id_hash": 8163855836227489271, "content_hash": 8163855836227489271, "location": "02010100.xhp", "context": "02010100.xhp\nhd_id3150427\nhelp.text", "note": "HXdKT", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 252, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/107518594/?format=api", "priority": 100, "id": 107738642, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/fr/?checksum=f14bd7a10bd6cdf7", "url": "https://translations.documentfoundation.org/api/units/107738642/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:31.177963Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/fr/?format=api", "source": [ "To query Yes/No fields, use the following syntax for dBASE tables:" ], "previous_source": "", "target": [ "Pour lancer une requête sur des champs Oui/Non, utilisez la syntaxe suivante pour des tables dBase :" ], "id_hash": 7542181489787428597, "content_hash": 7542181489787428597, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3149523\nhelp.text", "note": "xWzix", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 253, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/107518605/?format=api", "priority": 100, "id": 107738645, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/fr/?checksum=e8ab361ad24e5ef5", "url": "https://translations.documentfoundation.org/api/units/107738645/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:31.183787Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/fr/?format=api", "source": [ "Status" ], "previous_source": "", "target": [ "Statut" ], "id_hash": -1438940559154058398, "content_hash": -1438940559154058398, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3153180\nhelp.text", "note": "A4Uh7", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 254, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/107518619/?format=api", "priority": 100, "id": 107738648, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/fr/?checksum=6c07db2f6eb86b62", "url": "https://translations.documentfoundation.org/api/units/107738648/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:31.186929Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/fr/?format=api", "source": [ "Query criterion" ], "previous_source": "", "target": [ "Critères de requête" ], "id_hash": 8650453120847444098, "content_hash": 8650453120847444098, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3147481\nhelp.text", "note": "FnXiE", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 255, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/107518620/?format=api", "priority": 100, "id": 107738654, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/fr/?checksum=f80c95480647f882", "url": "https://translations.documentfoundation.org/api/units/107738654/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:31.191653Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/fr/?format=api", "source": [ "Example" ], "previous_source": "", "target": [ "Exemple" ], "id_hash": 8141292417662845597, "content_hash": 8141292417662845597, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3155187\nhelp.text", "note": "e6DJr", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 256, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/107518628/?format=api", "priority": 100, "id": 107738657, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/fr/?checksum=f0fbae51c760029d", "url": "https://translations.documentfoundation.org/api/units/107738657/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:31.193333Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/fr/?format=api", "source": [ "Yes" ], "previous_source": "", "target": [ "Oui" ], "id_hash": 4937219640899305490, "content_hash": 4937219640899305490, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3156092\nhelp.text", "note": "Guy7d", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 257, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/107518637/?format=api", "priority": 100, "id": 107738660, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/fr/?checksum=c484871ad9e28012", "url": "https://translations.documentfoundation.org/api/units/107738660/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:31.194579Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/fr/?format=api", "source": [ "for dBASE tables: not equal to any given value" ], "previous_source": "", "target": [ "pour les tables dBASE : différente d'une quelconque valeur donnée" ], "id_hash": -1485834374452513737, "content_hash": -1485834374452513737, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3152414\nhelp.text", "note": "p9WTn", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 258, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/107518651/?format=api", "priority": 100, "id": 107738663, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/fr/?checksum=6b6141823bb17437", "url": "https://translations.documentfoundation.org/api/units/107738663/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:31.195979Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/fr/?format=api", "source": [ "=1 returns all records where the Yes/No field has the status \"Yes\" or \"On\" (selected in black)," ], "previous_source": "", "target": [ "=1 renvoie tous les enregistrements pour lesquels le champ Oui/Non est de statut \"Oui\" ou \"activé\" (sélectionné en noir)," ], "id_hash": 4097363800793405340, "content_hash": 4097363800793405340, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3151265\nhelp.text", "note": "RFrvz", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 259, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 17, "source_unit": "https://translations.documentfoundation.org/api/units/107518672/?format=api", "priority": 100, "id": 107738666, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/fr/?checksum=b8dcc2ab05d5d79c", "url": "https://translations.documentfoundation.org/api/units/107738666/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:31.197980Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/fr/?format=api", "source": [ "No" ], "previous_source": "", "target": [ "Non" ], "id_hash": -1265902796848252916, "content_hash": -1265902796848252916, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3152450\nhelp.text", "note": "3P4ZB", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 260, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/107518708/?format=api", "priority": 100, "id": 107738669, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/fr/?checksum=6e6e9c1d01afb80c", "url": "https://translations.documentfoundation.org/api/units/107738669/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:31.200200Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/fr/?format=api", "source": [ "." ], "previous_source": "", "target": [ "." ], "id_hash": -1104976539801341283, "content_hash": -1104976539801341283, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3150997\nhelp.text", "note": "BzBAa", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 261, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/107518713/?format=api", "priority": 100, "id": 107738673, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/fr/?checksum=70aa55b10400329d", "url": "https://translations.documentfoundation.org/api/units/107738673/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:31.202210Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/fr/?format=api", "source": [ "=0 returns all records for which the Yes/No field has the status \"No\" or \"Off\" (no selection)." ], "previous_source": "", "target": [ "=0 renvoie tous les enregistrements pour lesquels le champ Oui/Non a l'état \"Non\" ou \"désactivé\" (aucune sélection)." ], "id_hash": -3974623853916560005, "content_hash": -3974623853916560005, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3155331\nhelp.text", "note": "TFsQG", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 262, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 17, "source_unit": "https://translations.documentfoundation.org/api/units/107518716/?format=api", "priority": 100, "id": 107738675, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/fr/?checksum=48d74ca9cf82657b", "url": "https://translations.documentfoundation.org/api/units/107738675/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:31.203980Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/fr/?format=api", "source": [ "Null" ], "previous_source": "", "target": [ "Null" ], "id_hash": -3383237762867038875, "content_hash": -3383237762867038875, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3154179\nhelp.text", "note": "9KXzK", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 263, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/107518722/?format=api", "priority": 100, "id": 107738678, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/fr/?checksum=510c532e099f7565", "url": "https://translations.documentfoundation.org/api/units/107738678/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:31.205983Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/fr/?format=api", "source": [ "IS NULL" ], "previous_source": "", "target": [ "IS NULL" ], "id_hash": 5893788471563971096, "content_hash": 5893788471563971096, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3147035\nhelp.text", "note": "CwGZv", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 264, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/107518728/?format=api", "priority": 100, "id": 107738680, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/fr/?checksum=d1caf16364dcea18", "url": "https://translations.documentfoundation.org/api/units/107738680/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:31.208089Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/fr/?format=api", "source": [ "IS NULL returns all records for which the Yes/No field has neither of the states Yes or No (selected in gray)." ], "previous_source": "", "target": [ "IS NULL renvoie tous les enregistrements pour lesquels le champ Oui/Non n'a ni l'état Oui ni l'état Non (sélectionné en gris)." ], "id_hash": 6584486709762292464, "content_hash": 6584486709762292464, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3159385\nhelp.text", "note": "dyXYc", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 265, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 21, "source_unit": "https://translations.documentfoundation.org/api/units/107518735/?format=api", "priority": 100, "id": 107738681, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/fr/?checksum=db60cbc6c3a97af0", "url": "https://translations.documentfoundation.org/api/units/107738681/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:31.210196Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/fr/?format=api", "source": [ "The syntax depends on the database system used. You should also note that Yes/No fields can be defined differently (only 2 states instead of 3)." ], "previous_source": "", "target": [ "La syntaxe dépend du système de base de données utilisé. Remarquez également que les champs Oui/Non peuvent être définis différemment (deux statuts seulement au lieu de trois)." ], "id_hash": 7229728358486624123, "content_hash": 7229728358486624123, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3157888\nhelp.text", "note": "YWk5J", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 266, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 25, "source_unit": "https://translations.documentfoundation.org/api/units/107518752/?format=api", "priority": 100, "id": 107738686, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/fr/?checksum=e45527a32629c77b", "url": "https://translations.documentfoundation.org/api/units/107738686/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:31.217554Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/fr/?format=api", "source": [ "Parameter queries" ], "previous_source": "", "target": [ "Requêtes avec paramètre" ], "id_hash": 450583529009372135, "content_hash": 450583529009372135, "location": "02010100.xhp", "context": "02010100.xhp\nhd_id3145772\nhelp.text", "note": "mmVa8", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 267, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/107518768/?format=api", "priority": 100, "id": 107738690, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/fr/?checksum=8640cb55143edbe7", "url": "https://translations.documentfoundation.org/api/units/107738690/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:31.224490Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/fr/?format=api", "source": [ "Parameter queries allow the user to input values at run-time. These values are used within the criteria for selecting the records to be displayed. Each such value has a parameter name associated with it, which is used to prompt the user when the query is run." ], "previous_source": "", "target": [ "Les requêtes paramétrées permettent à l'utilisateur de fournir des valeurs à l'exécution. Ces valeurs sont utilisées dans les critères pour sélectionner les enregistrement à afficher. Chacune de ces valeurs est associée à un nom de paramètre qui est utilisé pour demander à l'utilisateur de fournir cette valeur lorsque la requête est exécutée." ], "id_hash": -8140116745182247469, "content_hash": -8140116745182247469, "location": "02010100.xhp", "context": "02010100.xhp\npar_id191120151905346795\nhelp.text", "note": "ND7xd", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 268, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 46, "source_unit": "https://translations.documentfoundation.org/api/units/107518781/?format=api", "priority": 100, "id": 107738695, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/fr/?checksum=0f087ef2cd3405d3", "url": "https://translations.documentfoundation.org/api/units/107738695/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:31.228126Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/fr/?format=api", "source": [ "Parameter names are preceded by a colon in both the Design and SQL views of a query. This can be used wherever a value can appear. If the same value is to appear more than once in the query, the same parameter name is used." ], "previous_source": "", "target": [ "Les noms de paramètre sont précédés par un deux-points dans les deux modes Ébauche et SQL d'une requête. Ils peuvent être utilisés partout où une valeur peut apparaître. Si la même valeur doit apparaître plus d'une fois dans une requête, le même nom de paramètre sera utilisé." ], "id_hash": 4111393334921262894, "content_hash": 4111393334921262894, "location": "02010100.xhp", "context": "02010100.xhp\npar_id191120151905439551\nhelp.text", "note": "Be7XG", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 269, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 45, "source_unit": "https://translations.documentfoundation.org/api/units/107518803/?format=api", "priority": 100, "id": 107738697, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/fr/?checksum=b90e9a747be3f72e", "url": "https://translations.documentfoundation.org/api/units/107738697/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:31.230720Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/fr/?format=api", "source": [ "In the simplest case, where the user enters a value which is matched for equality, the parameter name with its preceding colon is simply entered in the Criterion row. In <link href=\"text/sdatabase/02010100.xhp#sqlmode\">SQL mode</link> this should be typed as <item type=\"input\">WHERE \"Field\" = :Parameter_name</item>" ], "previous_source": "", "target": [ "Dans le cas le plus simple où l'utilisateur saisit une valeur pour une relation d'égalité, le nom de paramètre précédé de son deux-points est simplement saisi dans la ligne du critère. En <link href=\"text/sdatabase/02010100.xhp#sqlmode\">mode SQL</link> cela devrait être saisi sous la forme <item type=\"input\">WHERE \"Field\" = :Parameter_name</item>" ], "id_hash": -8056140160250446947, "content_hash": -8056140160250446947, "location": "02010100.xhp", "context": "02010100.xhp\npar_id191120151905518123\nhelp.text", "note": "f2NMg", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 270, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 43, "source_unit": "https://translations.documentfoundation.org/api/units/107518814/?format=api", "priority": 100, "id": 107738707, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/fr/?checksum=1032d7351f837b9d", "url": "https://translations.documentfoundation.org/api/units/107738707/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:31.245183Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/fr/?format=api", "source": [ "Parameter names may not contain any of the characters <item type=\"input\"><space>`!\"$%^*()+={}[]@'~#<>?/,</item>. They may not be the same as field names or SQL reserved words. They may be the same as aliases." ], "previous_source": "", "target": [ "Les noms de paramètre ne peuvent contenir aucun des caractères <item type=\"input\"><space>`!\"$%^*()+={}[]@'~#<>?/,</item>. Ils ne peuvent pas être identiques à des noms de champs ni à des mots SQL réservés. Ils peuvent être identiques à des alias." ], "id_hash": 2239266726598408603, "content_hash": 2239266726598408603, "location": "02010100.xhp", "context": "02010100.xhp\npar_id191120151905584287\nhelp.text", "note": "DZCXm", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 271, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 31, "source_unit": "https://translations.documentfoundation.org/api/units/107518824/?format=api", "priority": 100, "id": 107738711, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/fr/?checksum=9f137939443ff99b", "url": "https://translations.documentfoundation.org/api/units/107738711/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:31.248949Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/fr/?format=api", "source": [ "A useful construction for selecting records based on parts of a text field's content is to add a hidden column with <item type=\"input\">\"LIKE '%' || :Part_of_field || '%'\"</item> as the criterion. This will select records with an exact match. If a case-insensitive test is wanted, one solution is to use <item type=\"input\">LOWER (Field_Name)</item> as the field and <item type=\"input\">LIKE LOWER ( '%' || :Part_of_field || '%' )</item> as the criterion. Note that the spaces in the criterion are important; if they are left out the SQL parser interprets the entire criterion as a string to be matched. In <link href=\"text/sdatabase/02010100.xhp#sqlmode\">SQL mode</link> this should be typed as <item type=\"input\">LOWER ( \"Field_Name\" ) LIKE LOWER ( '%' || :Part_of_field || '%' )</item>." ], "previous_source": "", "target": [ "Une construction utile pour sélectionner des enregistrements en fonction de parties du contenu d'un champ de texte consiste à ajouter une colonne masquée avec <item type=\"input\">\"LIKE '%' || :Part_of_field || '%'\"</item> comme critère. Cela sélectionnera les enregistrements avec une correspondance exacte. Si un test insensible à la casse est souhaité, une solution consiste à utiliser <item type=\"input\">LOWER (Field_Name)</item> comme champ et <item type=\"input\">LIKE LOWER ( '%' || :Part_of_field || '%' )</item> comme critère. Notez que les espaces dans le critère sont importants ; s'ils sont omis, l'analyseur SQL interprète le critère entier comme une chaîne à mettre en correspondance. En <link href=\"text/sdatabase/02010100.xhp#sqlmode\">mode SQL</link>, cela doit être saisi comme <item type=\"input\">LOWER ( \"Field_Name\" ) LIKE LOWER ( '%' || :Part_of_field || '%' )</item>." ], "id_hash": 7359674384784650935, "content_hash": 7359674384784650935, "location": "02010100.xhp", "context": "02010100.xhp\npar_id191120151931441881\nhelp.text", "note": "WBEtt", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 272, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 120, "source_unit": "https://translations.documentfoundation.org/api/units/107518840/?format=api", "priority": 100, "id": 107738714, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/fr/?checksum=e622d0dc17a172b7", "url": "https://translations.documentfoundation.org/api/units/107738714/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:31.252769Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/fr/?format=api", "source": [ "Parameter queries may be used as the data source for <link href=\"text/shared/02/01170203.xhp\">subforms</link>, to allow the user to restrict the displayed records." ], "previous_source": "", "target": [ "Les requêtes de paramètre peuvent être utilisées comme source de donnée pour <link href=\"text/shared/02/01170203.xhp\">sous-formulaire</link> afin de permettre à l'utilisateur de limiter les enregistrements affichés." ], "id_hash": 2107924860811531621, "content_hash": 2107924860811531621, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3150585\nhelp.text", "note": "EAESi", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 273, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 21, "source_unit": "https://translations.documentfoundation.org/api/units/107518861/?format=api", "priority": 100, "id": 107738716, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/fr/?checksum=9d40da7e1de2d565", "url": "https://translations.documentfoundation.org/api/units/107738716/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:31.256396Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/fr/?format=api", "source": [ "Parameter Input" ], "previous_source": "", "target": [ "Saisie de paramètre" ], "id_hash": 2456021578479157933, "content_hash": 2456021578479157933, "location": "02010100.xhp", "context": "02010100.xhp\nhd_id3151035\nhelp.text", "note": "DRj78", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 274, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/107518874/?format=api", "priority": 100, "id": 107738718, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/fr/?checksum=a2158a9cf1f1c2ad", "url": "https://translations.documentfoundation.org/api/units/107738718/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:31.259339Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/fr/?format=api", "source": [ "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\">The <emph>Parameter Input</emph> dialog asks the user to enter the parameter values. Enter a value for each query parameter and confirm by clicking <emph>OK</emph> or typing <emph>Enter</emph>.</ahelp>" ], "previous_source": "", "target": [ "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\">La boîte de dialogue <emph>Saisie de paramètre</emph> demande à l'utilisateur d'indiquer les valeurs des paramètres. Saisissez une valeur pour chaque paramètre de requête et confirmez en cliquant sur <emph>OK</emph> ou en appuyant sur <emph>Entrée</emph>.</ahelp>" ], "id_hash": 264425641860169309, "content_hash": 264425641860169309, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3153596\nhelp.text", "note": "BisCF", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 275, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 28, "source_unit": "https://translations.documentfoundation.org/api/units/107518886/?format=api", "priority": 100, "id": 107738723, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/fr/?checksum=83ab6db864947e5d", "url": "https://translations.documentfoundation.org/api/units/107738723/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:31.261749Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/fr/?format=api", "source": [ "The values entered by the user may consist of any characters which are allowable for the SQL for the relevant criterion; this may depend on the underlying database system." ], "previous_source": "", "target": [ "Pour la saisie des valeurs l'utilisateur peut utiliser n'importe quel caractère autorisé par le SQL pour le critère correspondant ; cela peut dépendre du système de base de données sous-jacent." ], "id_hash": -7615090312441786881, "content_hash": -7615090312441786881, "location": "02010100.xhp", "context": "02010100.xhp\npar_id191120151924165870\nhelp.text", "note": "eGETM", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 276, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 29, "source_unit": "https://translations.documentfoundation.org/api/units/107518905/?format=api", "priority": 100, "id": 107738728, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/fr/?checksum=1651c3b512638dff", "url": "https://translations.documentfoundation.org/api/units/107738728/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:31.265719Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/fr/?format=api", "source": [ "The user can use the SQL wild-card characters \"%\" (arbitrary string) or \"_\" (arbitrary single character) as part of the value to retrieve records with more complex criteria." ], "previous_source": "", "target": [ "L'utilisateur peut utiliser les caractères de substitution SQL \"%\" (chaîne de caractères arbitraire) ou \"_\" (caractère arbitraire) comme partie de la valeur pour extraire des enregistrements avec des critères plus complexes." ], "id_hash": 7455332244107640153, "content_hash": 7455332244107640153, "location": "02010100.xhp", "context": "02010100.xhp\npar_id191120151939594217\nhelp.text", "note": "seFhG", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 277, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 28, "source_unit": "https://translations.documentfoundation.org/api/units/107518948/?format=api", "priority": 100, "id": 107738731, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/fr/?checksum=e776a92d0c8d3d59", "url": "https://translations.documentfoundation.org/api/units/107738731/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:31.268599Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/fr/?format=api", "source": [ "SQL Mode" ], "previous_source": "", "target": [ "Mode SQL" ], "id_hash": 7952163570614096607, "content_hash": 7952163570614096607, "location": "02010100.xhp", "context": "02010100.xhp\nhd_id3145181\nhelp.text", "note": "wRe6v", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 278, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/107518962/?format=api", "priority": 100, "id": 107738733, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/fr/?checksum=ee5bc2a2964152df", "url": "https://translations.documentfoundation.org/api/units/107738733/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:31.269928Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/fr/?format=api", "source": [ "SQL stands for \"Structured Query Language\" and describes instructions for updating and administering relational databases." ], "previous_source": "", "target": [ "L'abréviation SQL signifie \"Structured Query Language\" (langage de requête structuré) et désigne un ensemble d'instructions destinées à interroger, actualiser et gérer des bases de données relationnelles." ], "id_hash": 2645544768060911837, "content_hash": 2645544768060911837, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3147013\nhelp.text", "note": "5avVu", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 279, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://translations.documentfoundation.org/api/units/107518974/?format=api", "priority": 100, "id": 107738736, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/fr/?checksum=a4b6dcf329a9f0dd", "url": "https://translations.documentfoundation.org/api/units/107738736/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:31.271110Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/fr/?format=api", "source": [ "In $[officename] you do not need any knowledge of SQL for most queries, since you do not have to enter the SQL code. If you create a query in the query designer, $[officename] automatically converts your instructions into the corresponding SQL syntax. If, with the help of the <emph>Switch Design View On/Off </emph>button, you change to the SQL view, you can see the SQL commands for a query that has already been created." ], "previous_source": "", "target": [ "Dans $[officename], vous n'avez pas besoin de connaître le SQL pour la plupart des requêtes, dans la mesure où vous n'avez pas à saisir le code SQL. Si vous créez une requête dans l'ébauche de requête, $[officename] convertit automatiquement les instructions dans la syntaxe SQL correspondante. Si vous passez en mode SQL à l'aide du bouton <emph>(Dés)activer le mode Ébauche</emph>, vous pouvez afficher les commandes SQL d'une requête ayant déjà été créée." ], "id_hash": 7941331124243750945, "content_hash": 7941331124243750945, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3152570\nhelp.text", "note": "wDAAY", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 280, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 73, "source_unit": "https://translations.documentfoundation.org/api/units/107518984/?format=api", "priority": 100, "id": 107738739, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/fr/?checksum=ee354695204d6021", "url": "https://translations.documentfoundation.org/api/units/107738739/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:31.272634Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/fr/?format=api", "source": [ "You can formulate your query directly in SQL code. Note, however, that the special syntax is dependent upon the database system that you use." ], "previous_source": "", "target": [ "Vous pouvez formuler votre requête directement en code SQL. Remarquez cependant que la syntaxe exacte dépend du système de base de données que vous utilisez." ], "id_hash": 1166373493807955969, "content_hash": 1166373493807955969, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3152412\nhelp.text", "note": "hBQFv", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 281, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 24, "source_unit": "https://translations.documentfoundation.org/api/units/107518992/?format=api", "priority": 100, "id": 107738744, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/fr/?checksum=902fca834ddac001", "url": "https://translations.documentfoundation.org/api/units/107738744/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:31.276528Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/fr/?format=api", "source": [ "If you enter the SQL code manually, you can create SQL-specific queries that are not supported by the graphical interface in the <emph>Query designer</emph>. These queries must be executed in native SQL mode." ], "previous_source": "", "target": [ "Lorsque vous saisissez le code SQL manuellement, vous pouvez créer des requêtes SQL spécifiques qui ne sont pas prises en charge par l'interface graphique dans l'<emph>ébauche de requête</emph>. De telles requêtes doivent être exécutées en mode SQL natif." ], "id_hash": 5642149963125379485, "content_hash": 5642149963125379485, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3146842\nhelp.text", "note": "kkuBG", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 282, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 33, "source_unit": "https://translations.documentfoundation.org/api/units/107518998/?format=api", "priority": 100, "id": 107738748, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/fr/?checksum=ce4cf17f8192519d", "url": "https://translations.documentfoundation.org/api/units/107738748/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:31.278946Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/fr/?format=api", "source": [ "By clicking the <link href=\"text/shared/02/14030000.xhp\"><emph>Run SQL command directly</emph></link> icon in the SQL view, you can formulate a query that is not processed by $[officename] and sent directly to the database engine." ], "previous_source": "", "target": [ "En cliquant sur l'icône <link href=\"text/shared/02/14030000.xhp\"><emph>Exécuter directement l'instruction SQL</emph></link> dans la vue SQL, vous pouvez formuler une requête n'étant pas traitée par $[officename]." ], "id_hash": -1013675299276706472, "content_hash": -1013675299276706472, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3149632\nhelp.text", "note": "LgvXF", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 283, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 31, "source_unit": "https://translations.documentfoundation.org/api/units/107519000/?format=api", "priority": 100, "id": 107738752, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/fr/?checksum=71eeb3af9d062d58", "url": "https://translations.documentfoundation.org/api/units/107738752/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:31.284217Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/fr/?format=api", "source": [ "Join Properties" ], "previous_source": "", "target": [ "Propriétés de la jointure" ], "id_hash": -6678692574290660760, "content_hash": -6678692574290660760, "location": "02010101.xhp", "context": "02010101.xhp\ntit\nhelp.text", "note": "fKBDD", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 284, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/107519013/?format=api", "priority": 100, "id": 107738757, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/fr/?checksum=2350847d295db268", "url": "https://translations.documentfoundation.org/api/units/107738757/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:31.296273Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/fr/?format=api", "source": [ "<bookmark_value>links;relational databases (Base)</bookmark_value> <bookmark_value>inner joins (Base)</bookmark_value> <bookmark_value>joins in databases (Base)</bookmark_value> <bookmark_value>left joins (Base)</bookmark_value> <bookmark_value>right joins (Base)</bookmark_value> <bookmark_value>full joins (Base)</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>Liens;bases de données relationnelles (Base)</bookmark_value><bookmark_value>Jointures internes (Base)</bookmark_value><bookmark_value>Jointures dans les bases de données (Base)</bookmark_value><bookmark_value>Jointures gauches (Base)</bookmark_value><bookmark_value>Jointures droites (Base)</bookmark_value><bookmark_value>Jointures complètes (Base)</bookmark_value>" ], "id_hash": 1301543985542803826, "content_hash": 1301543985542803826, "location": "02010101.xhp", "context": "02010101.xhp\nbm_id3154015\nhelp.text", "note": "TTCNB", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 285, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/107519029/?format=api", "priority": 100, "id": 107738759, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/fr/?checksum=9210035be5d33172", "url": "https://translations.documentfoundation.org/api/units/107738759/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:31.298227Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/fr/?format=api", "source": [ "Join Properties" ], "previous_source": "", "target": [ "Propriétés de la jointure" ], "id_hash": 2689996371133773814, "content_hash": 2689996371133773814, "location": "02010101.xhp", "context": "02010101.xhp\nhd_id3154015\nhelp.text", "note": "DG7RD", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 286, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/107519046/?format=api", "priority": 100, "id": 107738763, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/fr/?checksum=a554c9728484b7f6", "url": "https://translations.documentfoundation.org/api/units/107738763/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:31.300419Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/fr/?format=api", "source": [ "If you double-click a connection between two linked fields in the query design, or if you choose <emph>Insert - New Relation</emph>, the <emph>Join Properties</emph> dialog appears. These properties will be used in all queries created in the future." ], "previous_source": "", "target": [ "Si vous double-cliquez sur le lien connectant deux champs liés dans l'ébauche de requête, ou si vous choisissez <emph>Insertion - Nouvelle relation</emph>, la boîte de dialogue <emph>Propriétés de la jointure</emph> s'affiche. Ces propriétés sont utilisées dans toutes les requêtes créées par la suite." ], "id_hash": -8537690843307473250, "content_hash": -8537690843307473250, "location": "02010101.xhp", "context": "02010101.xhp\npar_id3151205\nhelp.text", "note": "MzpBt", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 287, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 38, "source_unit": "https://translations.documentfoundation.org/api/units/107519062/?format=api", "priority": 100, "id": 107738766, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/fr/?checksum=09840769a28d869e", "url": "https://translations.documentfoundation.org/api/units/107738766/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:31.302453Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/fr/?format=api", "source": [ "Tables involved" ], "previous_source": "", "target": [ "Tables impliquées" ], "id_hash": -36410145612706044, "content_hash": -36410145612706044, "location": "02010101.xhp", "context": "02010101.xhp\nhd_id3155066\nhelp.text", "note": "oszEF", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 288, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/107519089/?format=api", "priority": 100, "id": 107738771, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/fr/?checksum=7f7ea52a5c88cf04", "url": "https://translations.documentfoundation.org/api/units/107738771/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:31.305547Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/fr/?format=api", "source": [ "<ahelp hid=\"dbaccess/ui/joindialog/table2\">Specifies two different tables that you want to join.</ahelp>" ], "previous_source": "", "target": [ "<ahelp hid=\"dbaccess/ui/joindialog/table2\">Indique les deux tables différentes que vous souhaitez joindre.</ahelp>" ], "id_hash": 1333863119828857673, "content_hash": 1333863119828857673, "location": "02010101.xhp", "context": "02010101.xhp\npar_id3153924\nhelp.text", "note": "2AkcB", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 289, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/107519110/?format=api", "priority": 100, "id": 107738773, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/fr/?checksum=9282d570bc64b349", "url": "https://translations.documentfoundation.org/api/units/107738773/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:31.309487Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/fr/?format=api", "source": [ "Fields involved" ], "previous_source": "", "target": [ "Champs impliqués" ], "id_hash": -1789859163330594308, "content_hash": -1789859163330594308, "location": "02010101.xhp", "context": "02010101.xhp\nhd_id3155766\nhelp.text", "note": "X6wkD", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 290, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/107519134/?format=api", "priority": 100, "id": 107738774, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/fr/?checksum=67292492f3b3b9fc", "url": "https://translations.documentfoundation.org/api/units/107738774/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:31.312312Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/fr/?format=api", "source": [ "<ahelp hid=\".\">Specifies two data fields that will be joined by a relation.</ahelp>" ], "previous_source": "", "target": [ "<ahelp hid=\".\">Indique les deux champs de données qui seront joints par une relation.</ahelp>" ], "id_hash": 7574129023308213126, "content_hash": 7574129023308213126, "location": "02010101.xhp", "context": "02010101.xhp\npar_id3148994\nhelp.text", "note": "8bYEZ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 291, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/107519152/?format=api", "priority": 100, "id": 107738778, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/fr/?checksum=e91cb6379d432b86", "url": "https://translations.documentfoundation.org/api/units/107738778/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:31.316441Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/fr/?format=api", "source": [ "Options" ], "previous_source": "", "target": [ "Options" ], "id_hash": -2720686535624113612, "content_hash": -2720686535624113612, "location": "02010101.xhp", "context": "02010101.xhp\nhd_id3159267\nhelp.text", "note": "R8CbB", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 292, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/107519169/?format=api", "priority": 100, "id": 107738782, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/fr/?checksum=5a3e2e02baefc234", "url": "https://translations.documentfoundation.org/api/units/107738782/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:31.320297Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/fr/?format=api", "source": [ "Type" ], "previous_source": "", "target": [ "Type" ], "id_hash": -4053688658655726463, "content_hash": -4053688658655726463, "location": "02010101.xhp", "context": "02010101.xhp\nhd_id3147340\nhelp.text", "note": "MRJCp", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 293, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/107519198/?format=api", "priority": 100, "id": 107738784, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/fr/?checksum=47be67a46ecbb481", "url": "https://translations.documentfoundation.org/api/units/107738784/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:31.321640Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/fr/?format=api", "source": [ "<ahelp hid=\"dbaccess/ui/joindialog/type\">Specifies the join type of the selected join.</ahelp> Some databases support only a subset of the various possible types." ], "previous_source": "", "target": [ "<ahelp hid=\"dbaccess/ui/joindialog/type\">Indique le type de liaison du lien sélectionné.</ahelp> Certaines bases de données ne prennent en charge qu'un sous ensemble de types possibles." ], "id_hash": -7272426577638343159, "content_hash": -7272426577638343159, "location": "02010101.xhp", "context": "02010101.xhp\npar_id3152482\nhelp.text", "note": "rxAGo", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 294, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 20, "source_unit": "https://translations.documentfoundation.org/api/units/107519221/?format=api", "priority": 100, "id": 107738786, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/fr/?checksum=1b13268f00c1be09", "url": "https://translations.documentfoundation.org/api/units/107738786/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:31.323604Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/fr/?format=api", "source": [ "Inner Join" ], "previous_source": "", "target": [ "Jointure interne" ], "id_hash": -7586144127754050114, "content_hash": -7586144127754050114, "location": "02010101.xhp", "context": "02010101.xhp\nhd_id3155334\nhelp.text", "note": "ngfse", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 295, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/107519228/?format=api", "priority": 100, "id": 107738798, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/fr/?checksum=16b89a1be24de5be", "url": "https://translations.documentfoundation.org/api/units/107738798/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:31.350360Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/fr/?format=api", "source": [ "<ahelp hid=\"dbaccess/ui/joindialog/type\">In an inner join, the results table contains only those records for which the content of the linked fields is the same.</ahelp> In $[officename] SQL this type of link is created by a corresponding WHERE clause." ], "previous_source": "", "target": [ "<ahelp hid=\"dbaccess/ui/joindialog/type\">Dans une jointure interne, la table de résultat ne contient que les enregistrements dont les champs liés présentent un contenu identique.</ahelp> Dans $[officename] SQL, ce type de lien est créé par une clause WHERE correspondante." ], "id_hash": -6113919658300017234, "content_hash": -6113919658300017234, "location": "02010101.xhp", "context": "02010101.xhp\npar_id3155936\nhelp.text", "note": "356Dv", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 296, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 37, "source_unit": "https://translations.documentfoundation.org/api/units/107519239/?format=api", "priority": 100, "id": 107738800, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/fr/?checksum=2b26fe76b5bff5ae", "url": "https://translations.documentfoundation.org/api/units/107738800/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:31.352628Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/fr/?format=api", "source": [ "Left Join" ], "previous_source": "", "target": [ "Jointure gauche" ], "id_hash": -9146645766165797204, "content_hash": -9146645766165797204, "location": "02010101.xhp", "context": "02010101.xhp\nhd_id3156372\nhelp.text", "note": "XYKGT", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 297, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/107519253/?format=api", "priority": 100, "id": 107738802, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/fr/?checksum=01109622fd5b66ac", "url": "https://translations.documentfoundation.org/api/units/107738802/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:31.355358Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/fr/?format=api", "source": [ "<ahelp hid=\"dbaccess/ui/joindialog/type\">In a left join, the results table contains all records of the queried fields from the left table and only those records of the queried fields from the right table for which the content of the linked fields is the same.</ahelp> In $[officename] SQL this type of link corresponds to the LEFT OUTER JOIN command." ], "previous_source": "", "target": [ "<ahelp hid=\"dbaccess/ui/joindialog/type\">Dans une jointure gauche, la table de résultat contient tous les enregistrements des champs de la requête de la table gauche et uniquement les enregistrement des champs de requête de la table droite pour laquelle le contenu des champs liés est le même. </ahelp> Dans $[officename] SQL, ce type de lien correspond à la commande LEFT OUTER JOIN." ], "id_hash": 1610530649816152644, "content_hash": 1610530649816152644, "location": "02010101.xhp", "context": "02010101.xhp\npar_id3166450\nhelp.text", "note": "dRFux", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 298, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 56, "source_unit": "https://translations.documentfoundation.org/api/units/107519273/?format=api", "priority": 100, "id": 107738804, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/fr/?checksum=9659c117d22bba44", "url": "https://translations.documentfoundation.org/api/units/107738804/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:31.357098Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/fr/?format=api", "source": [ "Right Join" ], "previous_source": "", "target": [ "Jointure droite" ], "id_hash": 6056042749440435176, "content_hash": 6056042749440435176, "location": "02010101.xhp", "context": "02010101.xhp\nhd_id3155607\nhelp.text", "note": "DxGWD", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 299, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/107519288/?format=api", "priority": 100, "id": 107738806, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/fr/?checksum=d40b62cb58fa23e8", "url": "https://translations.documentfoundation.org/api/units/107738806/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:31.359014Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/fr/?format=api", "source": [ "<ahelp hid=\"dbaccess/ui/joindialog/type\">In a right join, the results table contains all records of the queried fields from the right table and only those records of the queried fields from the left table for which the content of the linked fields is the same.</ahelp> In $[officename] SQL this type of link corresponds to the RIGHT OUTER JOIN command." ], "previous_source": "", "target": [ "<ahelp hid=\"dbaccess/ui/joindialog/type\">Dans une jointure droite, la table de résultat contient tous les enregistrements des champs de la requête de la table droite et uniquement les enregistrement des champs de requête de la table gauche pour laquelle le contenu des champs liés est le même. </ahelp> Dans $[officename] SQL, ce type de lien correspond à la commande RIGHT OUTER JOIN." ], "id_hash": 2203328089698667858, "content_hash": 2203328089698667858, "location": "02010101.xhp", "context": "02010101.xhp\npar_id3150647\nhelp.text", "note": "9eD8R", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 300, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 56, "source_unit": "https://translations.documentfoundation.org/api/units/107519318/?format=api", "priority": 100, "id": 107738808, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/fr/?checksum=9e93cb394e210d52", "url": "https://translations.documentfoundation.org/api/units/107738808/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:31.360336Z" } ] }