Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/libo_help-7-6/textsdatabase/id/units/?format=api&page=6
{ "count": 1739, "next": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/id/units/?format=api&page=7", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/id/units/?format=api&page=5", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/id/?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": [ "" ], "id_hash": -4673270034736519928, "content_hash": -4673270034736519928, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3150510\nhelp.text", "note": "CZdA4", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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/95832235/?format=api", "priority": 100, "id": 96356082, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/id/?checksum=3f2535a9d80d6508", "url": "https://translations.documentfoundation.org/api/units/96356082/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:40:35.600353Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/id/?format=api", "source": [ "Querying Yes/No fields" ], "previous_source": "", "target": [ "" ], "id_hash": 8163855836227489271, "content_hash": 8163855836227489271, "location": "02010100.xhp", "context": "02010100.xhp\nhd_id3150427\nhelp.text", "note": "HXdKT", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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/95832309/?format=api", "priority": 100, "id": 96356085, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/id/?checksum=f14bd7a10bd6cdf7", "url": "https://translations.documentfoundation.org/api/units/96356085/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:40:35.601643Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/id/?format=api", "source": [ "To query Yes/No fields, use the following syntax for dBASE tables:" ], "previous_source": "", "target": [ "" ], "id_hash": 7542181489787428597, "content_hash": 7542181489787428597, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3149523\nhelp.text", "note": "xWzix", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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/95832346/?format=api", "priority": 100, "id": 96356087, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/id/?checksum=e8ab361ad24e5ef5", "url": "https://translations.documentfoundation.org/api/units/96356087/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:40:35.602792Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/id/?format=api", "source": [ "Status" ], "previous_source": "", "target": [ "" ], "id_hash": -1438940559154058398, "content_hash": -1438940559154058398, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3153180\nhelp.text", "note": "A4Uh7", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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/95832421/?format=api", "priority": 100, "id": 96356105, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/id/?checksum=6c07db2f6eb86b62", "url": "https://translations.documentfoundation.org/api/units/96356105/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:40:35.619622Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/id/?format=api", "source": [ "Query criterion" ], "previous_source": "", "target": [ "" ], "id_hash": 8650453120847444098, "content_hash": 8650453120847444098, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3147481\nhelp.text", "note": "FnXiE", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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/95832452/?format=api", "priority": 100, "id": 96356110, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/id/?checksum=f80c95480647f882", "url": "https://translations.documentfoundation.org/api/units/96356110/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:40:35.621683Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/id/?format=api", "source": [ "Example" ], "previous_source": "", "target": [ "" ], "id_hash": 8141292417662845597, "content_hash": 8141292417662845597, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3155187\nhelp.text", "note": "e6DJr", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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/95832475/?format=api", "priority": 100, "id": 96356114, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/id/?checksum=f0fbae51c760029d", "url": "https://translations.documentfoundation.org/api/units/96356114/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:40:35.622947Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/id/?format=api", "source": [ "Yes" ], "previous_source": "", "target": [ "" ], "id_hash": 4937219640899305490, "content_hash": 4937219640899305490, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3156092\nhelp.text", "note": "Guy7d", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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/95832529/?format=api", "priority": 100, "id": 96356117, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/id/?checksum=c484871ad9e28012", "url": "https://translations.documentfoundation.org/api/units/96356117/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:40:35.624074Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/id/?format=api", "source": [ "for dBASE tables: not equal to any given value" ], "previous_source": "", "target": [ "" ], "id_hash": -1485834374452513737, "content_hash": -1485834374452513737, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3152414\nhelp.text", "note": "p9WTn", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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/95832559/?format=api", "priority": 100, "id": 96356121, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/id/?checksum=6b6141823bb17437", "url": "https://translations.documentfoundation.org/api/units/96356121/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:40:35.625317Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/id/?format=api", "source": [ "=1 returns all records where the Yes/No field has the status \"Yes\" or \"On\" (selected in black)," ], "previous_source": "", "target": [ "" ], "id_hash": 4097363800793405340, "content_hash": 4097363800793405340, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3151265\nhelp.text", "note": "RFrvz", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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/95832593/?format=api", "priority": 100, "id": 96356126, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/id/?checksum=b8dcc2ab05d5d79c", "url": "https://translations.documentfoundation.org/api/units/96356126/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:40:35.626593Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/id/?format=api", "source": [ "No" ], "previous_source": "", "target": [ "" ], "id_hash": -1265902796848252916, "content_hash": -1265902796848252916, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3152450\nhelp.text", "note": "3P4ZB", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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/95832632/?format=api", "priority": 100, "id": 96356129, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/id/?checksum=6e6e9c1d01afb80c", "url": "https://translations.documentfoundation.org/api/units/96356129/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:40:35.627831Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/id/?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": 0, "fuzzy": false, "translated": false, "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/95832676/?format=api", "priority": 100, "id": 96356134, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/id/?checksum=70aa55b10400329d", "url": "https://translations.documentfoundation.org/api/units/96356134/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:40:35.629113Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/id/?format=api", "source": [ "=0 returns all records for which the Yes/No field has the status \"No\" or \"Off\" (no selection)." ], "previous_source": "", "target": [ "" ], "id_hash": -3974623853916560005, "content_hash": -3974623853916560005, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3155331\nhelp.text", "note": "TFsQG", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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/95832721/?format=api", "priority": 100, "id": 96356138, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/id/?checksum=48d74ca9cf82657b", "url": "https://translations.documentfoundation.org/api/units/96356138/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:40:35.630220Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/id/?format=api", "source": [ "Null" ], "previous_source": "", "target": [ "" ], "id_hash": -3383237762867038875, "content_hash": -3383237762867038875, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3154179\nhelp.text", "note": "9KXzK", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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/95832780/?format=api", "priority": 100, "id": 96356141, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/id/?checksum=510c532e099f7565", "url": "https://translations.documentfoundation.org/api/units/96356141/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:40:35.631209Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/id/?format=api", "source": [ "IS NULL" ], "previous_source": "", "target": [ "" ], "id_hash": 5893788471563971096, "content_hash": 5893788471563971096, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3147035\nhelp.text", "note": "CwGZv", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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/95832822/?format=api", "priority": 100, "id": 96356145, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/id/?checksum=d1caf16364dcea18", "url": "https://translations.documentfoundation.org/api/units/96356145/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:40:35.632359Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/id/?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": [ "" ], "id_hash": 6584486709762292464, "content_hash": 6584486709762292464, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3159385\nhelp.text", "note": "dyXYc", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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/95832852/?format=api", "priority": 100, "id": 96356148, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/id/?checksum=db60cbc6c3a97af0", "url": "https://translations.documentfoundation.org/api/units/96356148/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:40:35.633500Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/id/?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": [ "" ], "id_hash": 7229728358486624123, "content_hash": 7229728358486624123, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3157888\nhelp.text", "note": "YWk5J", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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/95832907/?format=api", "priority": 100, "id": 96356151, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/id/?checksum=e45527a32629c77b", "url": "https://translations.documentfoundation.org/api/units/96356151/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:40:35.634920Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/id/?format=api", "source": [ "Parameter queries" ], "previous_source": "", "target": [ "" ], "id_hash": 450583529009372135, "content_hash": 450583529009372135, "location": "02010100.xhp", "context": "02010100.xhp\nhd_id3145772\nhelp.text", "note": "mmVa8", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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/95832932/?format=api", "priority": 100, "id": 96356156, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/id/?checksum=8640cb55143edbe7", "url": "https://translations.documentfoundation.org/api/units/96356156/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:40:35.636340Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/id/?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": [ "" ], "id_hash": -8140116745182247469, "content_hash": -8140116745182247469, "location": "02010100.xhp", "context": "02010100.xhp\npar_id191120151905346795\nhelp.text", "note": "ND7xd", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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/95832959/?format=api", "priority": 100, "id": 96356161, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/id/?checksum=0f087ef2cd3405d3", "url": "https://translations.documentfoundation.org/api/units/96356161/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:40:35.637706Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/id/?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": [ "" ], "id_hash": 4111393334921262894, "content_hash": 4111393334921262894, "location": "02010100.xhp", "context": "02010100.xhp\npar_id191120151905439551\nhelp.text", "note": "Be7XG", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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/95832984/?format=api", "priority": 100, "id": 96356164, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/id/?checksum=b90e9a747be3f72e", "url": "https://translations.documentfoundation.org/api/units/96356164/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:40:35.638685Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/id/?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": [ "" ], "id_hash": -8056140160250446947, "content_hash": -8056140160250446947, "location": "02010100.xhp", "context": "02010100.xhp\npar_id191120151905518123\nhelp.text", "note": "f2NMg", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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/95833004/?format=api", "priority": 100, "id": 96356169, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/id/?checksum=1032d7351f837b9d", "url": "https://translations.documentfoundation.org/api/units/96356169/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:40:35.639837Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/id/?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": [ "" ], "id_hash": 2239266726598408603, "content_hash": 2239266726598408603, "location": "02010100.xhp", "context": "02010100.xhp\npar_id191120151905584287\nhelp.text", "note": "DZCXm", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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/95833020/?format=api", "priority": 100, "id": 96356173, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/id/?checksum=9f137939443ff99b", "url": "https://translations.documentfoundation.org/api/units/96356173/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:40:35.641187Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/id/?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": [ "" ], "id_hash": 7359674384784650935, "content_hash": 7359674384784650935, "location": "02010100.xhp", "context": "02010100.xhp\npar_id191120151931441881\nhelp.text", "note": "WBEtt", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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/95833042/?format=api", "priority": 100, "id": 96356176, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/id/?checksum=e622d0dc17a172b7", "url": "https://translations.documentfoundation.org/api/units/96356176/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:40:35.642414Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/id/?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": [ "" ], "id_hash": 2107924860811531621, "content_hash": 2107924860811531621, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3150585\nhelp.text", "note": "EAESi", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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/95833068/?format=api", "priority": 100, "id": 96356180, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/id/?checksum=9d40da7e1de2d565", "url": "https://translations.documentfoundation.org/api/units/96356180/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:40:35.643719Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/id/?format=api", "source": [ "Parameter Input" ], "previous_source": "", "target": [ "" ], "id_hash": 2456021578479157933, "content_hash": 2456021578479157933, "location": "02010100.xhp", "context": "02010100.xhp\nhd_id3151035\nhelp.text", "note": "DRj78", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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/95833093/?format=api", "priority": 100, "id": 96356182, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/id/?checksum=a2158a9cf1f1c2ad", "url": "https://translations.documentfoundation.org/api/units/96356182/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:40:35.644830Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/id/?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": [ "" ], "id_hash": 264425641860169309, "content_hash": 264425641860169309, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3153596\nhelp.text", "note": "BisCF", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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/95833119/?format=api", "priority": 100, "id": 96356187, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/id/?checksum=83ab6db864947e5d", "url": "https://translations.documentfoundation.org/api/units/96356187/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:40:35.645926Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/id/?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": [ "" ], "id_hash": -7615090312441786881, "content_hash": -7615090312441786881, "location": "02010100.xhp", "context": "02010100.xhp\npar_id191120151924165870\nhelp.text", "note": "eGETM", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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/95833207/?format=api", "priority": 100, "id": 96356190, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/id/?checksum=1651c3b512638dff", "url": "https://translations.documentfoundation.org/api/units/96356190/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:40:35.647060Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/id/?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": [ "" ], "id_hash": 7455332244107640153, "content_hash": 7455332244107640153, "location": "02010100.xhp", "context": "02010100.xhp\npar_id191120151939594217\nhelp.text", "note": "seFhG", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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/95833263/?format=api", "priority": 100, "id": 96356195, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/id/?checksum=e776a92d0c8d3d59", "url": "https://translations.documentfoundation.org/api/units/96356195/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:40:35.648204Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/id/?format=api", "source": [ "SQL Mode" ], "previous_source": "", "target": [ "" ], "id_hash": 7952163570614096607, "content_hash": 7952163570614096607, "location": "02010100.xhp", "context": "02010100.xhp\nhd_id3145181\nhelp.text", "note": "wRe6v", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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/95833316/?format=api", "priority": 100, "id": 96356200, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/id/?checksum=ee5bc2a2964152df", "url": "https://translations.documentfoundation.org/api/units/96356200/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:40:35.649451Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/id/?format=api", "source": [ "SQL stands for \"Structured Query Language\" and describes instructions for updating and administering relational databases." ], "previous_source": "", "target": [ "" ], "id_hash": 2645544768060911837, "content_hash": 2645544768060911837, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3147013\nhelp.text", "note": "5avVu", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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/95833357/?format=api", "priority": 100, "id": 96356204, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/id/?checksum=a4b6dcf329a9f0dd", "url": "https://translations.documentfoundation.org/api/units/96356204/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:40:35.650584Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/id/?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": [ "" ], "id_hash": 7941331124243750945, "content_hash": 7941331124243750945, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3152570\nhelp.text", "note": "wDAAY", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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/95833430/?format=api", "priority": 100, "id": 96356210, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/id/?checksum=ee354695204d6021", "url": "https://translations.documentfoundation.org/api/units/96356210/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:40:35.651734Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/id/?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": [ "" ], "id_hash": 1166373493807955969, "content_hash": 1166373493807955969, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3152412\nhelp.text", "note": "hBQFv", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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/95833473/?format=api", "priority": 100, "id": 96356213, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/id/?checksum=902fca834ddac001", "url": "https://translations.documentfoundation.org/api/units/96356213/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:40:35.652947Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/id/?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": [ "" ], "id_hash": 5642149963125379485, "content_hash": 5642149963125379485, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3146842\nhelp.text", "note": "kkuBG", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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/95833505/?format=api", "priority": 100, "id": 96356217, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/id/?checksum=ce4cf17f8192519d", "url": "https://translations.documentfoundation.org/api/units/96356217/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:40:35.653897Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/id/?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": [ "" ], "id_hash": -1013675299276706472, "content_hash": -1013675299276706472, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3149632\nhelp.text", "note": "LgvXF", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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/95833552/?format=api", "priority": 100, "id": 96356220, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/id/?checksum=71eeb3af9d062d58", "url": "https://translations.documentfoundation.org/api/units/96356220/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:40:35.654864Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/id/?format=api", "source": [ "Join Properties" ], "previous_source": "", "target": [ "" ], "id_hash": -6678692574290660760, "content_hash": -6678692574290660760, "location": "02010101.xhp", "context": "02010101.xhp\ntit\nhelp.text", "note": "fKBDD", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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/95833604/?format=api", "priority": 100, "id": 96356227, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/id/?checksum=2350847d295db268", "url": "https://translations.documentfoundation.org/api/units/96356227/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:40:35.656022Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/id/?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": [ "" ], "id_hash": 1301543985542803826, "content_hash": 1301543985542803826, "location": "02010101.xhp", "context": "02010101.xhp\nbm_id3154015\nhelp.text", "note": "TTCNB", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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/95833631/?format=api", "priority": 100, "id": 96356231, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/id/?checksum=9210035be5d33172", "url": "https://translations.documentfoundation.org/api/units/96356231/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:40:35.657170Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/id/?format=api", "source": [ "Join Properties" ], "previous_source": "", "target": [ "" ], "id_hash": 2689996371133773814, "content_hash": 2689996371133773814, "location": "02010101.xhp", "context": "02010101.xhp\nhd_id3154015\nhelp.text", "note": "DG7RD", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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/95833656/?format=api", "priority": 100, "id": 96356235, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/id/?checksum=a554c9728484b7f6", "url": "https://translations.documentfoundation.org/api/units/96356235/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:40:35.658332Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/id/?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": [ "" ], "id_hash": -8537690843307473250, "content_hash": -8537690843307473250, "location": "02010101.xhp", "context": "02010101.xhp\npar_id3151205\nhelp.text", "note": "MzpBt", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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/95833679/?format=api", "priority": 100, "id": 96356240, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/id/?checksum=09840769a28d869e", "url": "https://translations.documentfoundation.org/api/units/96356240/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:40:35.659310Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/id/?format=api", "source": [ "Tables involved" ], "previous_source": "", "target": [ "" ], "id_hash": -36410145612706044, "content_hash": -36410145612706044, "location": "02010101.xhp", "context": "02010101.xhp\nhd_id3155066\nhelp.text", "note": "oszEF", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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/95833715/?format=api", "priority": 100, "id": 96356243, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/id/?checksum=7f7ea52a5c88cf04", "url": "https://translations.documentfoundation.org/api/units/96356243/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:40:35.660212Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/id/?format=api", "source": [ "<ahelp hid=\"dbaccess/ui/joindialog/table2\">Specifies two different tables that you want to join.</ahelp>" ], "previous_source": "", "target": [ "" ], "id_hash": 1333863119828857673, "content_hash": 1333863119828857673, "location": "02010101.xhp", "context": "02010101.xhp\npar_id3153924\nhelp.text", "note": "2AkcB", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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/95833786/?format=api", "priority": 100, "id": 96356246, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/id/?checksum=9282d570bc64b349", "url": "https://translations.documentfoundation.org/api/units/96356246/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:40:35.661115Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/id/?format=api", "source": [ "Fields involved" ], "previous_source": "", "target": [ "" ], "id_hash": -1789859163330594308, "content_hash": -1789859163330594308, "location": "02010101.xhp", "context": "02010101.xhp\nhd_id3155766\nhelp.text", "note": "X6wkD", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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/95833829/?format=api", "priority": 100, "id": 96356250, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/id/?checksum=67292492f3b3b9fc", "url": "https://translations.documentfoundation.org/api/units/96356250/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:40:35.661964Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/id/?format=api", "source": [ "<ahelp hid=\".\">Specifies two data fields that will be joined by a relation.</ahelp>" ], "previous_source": "", "target": [ "" ], "id_hash": 7574129023308213126, "content_hash": 7574129023308213126, "location": "02010101.xhp", "context": "02010101.xhp\npar_id3148994\nhelp.text", "note": "8bYEZ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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/95833875/?format=api", "priority": 100, "id": 96356327, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/id/?checksum=e91cb6379d432b86", "url": "https://translations.documentfoundation.org/api/units/96356327/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:40:36.135922Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/id/?format=api", "source": [ "Options" ], "previous_source": "", "target": [ "" ], "id_hash": -2720686535624113612, "content_hash": -2720686535624113612, "location": "02010101.xhp", "context": "02010101.xhp\nhd_id3159267\nhelp.text", "note": "R8CbB", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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/95833910/?format=api", "priority": 100, "id": 96356331, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/id/?checksum=5a3e2e02baefc234", "url": "https://translations.documentfoundation.org/api/units/96356331/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:40:36.139220Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/id/?format=api", "source": [ "Type" ], "previous_source": "", "target": [ "" ], "id_hash": -4053688658655726463, "content_hash": -4053688658655726463, "location": "02010101.xhp", "context": "02010101.xhp\nhd_id3147340\nhelp.text", "note": "MRJCp", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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/95833944/?format=api", "priority": 100, "id": 96356338, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/id/?checksum=47be67a46ecbb481", "url": "https://translations.documentfoundation.org/api/units/96356338/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:40:36.143847Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/id/?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": [ "" ], "id_hash": -7272426577638343159, "content_hash": -7272426577638343159, "location": "02010101.xhp", "context": "02010101.xhp\npar_id3152482\nhelp.text", "note": "rxAGo", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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/95833971/?format=api", "priority": 100, "id": 96356344, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/id/?checksum=1b13268f00c1be09", "url": "https://translations.documentfoundation.org/api/units/96356344/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:40:36.150473Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/id/?format=api", "source": [ "Inner Join" ], "previous_source": "", "target": [ "" ], "id_hash": -7586144127754050114, "content_hash": -7586144127754050114, "location": "02010101.xhp", "context": "02010101.xhp\nhd_id3155334\nhelp.text", "note": "ngfse", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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/95834014/?format=api", "priority": 100, "id": 96356348, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/id/?checksum=16b89a1be24de5be", "url": "https://translations.documentfoundation.org/api/units/96356348/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:40:36.152307Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/id/?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": [ "" ], "id_hash": -6113919658300017234, "content_hash": -6113919658300017234, "location": "02010101.xhp", "context": "02010101.xhp\npar_id3155936\nhelp.text", "note": "356Dv", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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/95834031/?format=api", "priority": 100, "id": 96356350, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/id/?checksum=2b26fe76b5bff5ae", "url": "https://translations.documentfoundation.org/api/units/96356350/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:40:36.153744Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/id/?format=api", "source": [ "Left Join" ], "previous_source": "", "target": [ "" ], "id_hash": -9146645766165797204, "content_hash": -9146645766165797204, "location": "02010101.xhp", "context": "02010101.xhp\nhd_id3156372\nhelp.text", "note": "XYKGT", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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/95834052/?format=api", "priority": 100, "id": 96356352, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/id/?checksum=01109622fd5b66ac", "url": "https://translations.documentfoundation.org/api/units/96356352/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:40:36.154939Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/id/?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": [ "" ], "id_hash": 1610530649816152644, "content_hash": 1610530649816152644, "location": "02010101.xhp", "context": "02010101.xhp\npar_id3166450\nhelp.text", "note": "dRFux", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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/95834075/?format=api", "priority": 100, "id": 96356354, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/id/?checksum=9659c117d22bba44", "url": "https://translations.documentfoundation.org/api/units/96356354/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:40:36.155994Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/id/?format=api", "source": [ "Right Join" ], "previous_source": "", "target": [ "" ], "id_hash": 6056042749440435176, "content_hash": 6056042749440435176, "location": "02010101.xhp", "context": "02010101.xhp\nhd_id3155607\nhelp.text", "note": "DxGWD", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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/95834092/?format=api", "priority": 100, "id": 96356359, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/id/?checksum=d40b62cb58fa23e8", "url": "https://translations.documentfoundation.org/api/units/96356359/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:40:36.158079Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/id/?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": [ "" ], "id_hash": 2203328089698667858, "content_hash": 2203328089698667858, "location": "02010101.xhp", "context": "02010101.xhp\npar_id3150647\nhelp.text", "note": "9eD8R", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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/95834104/?format=api", "priority": 100, "id": 96356363, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/id/?checksum=9e93cb394e210d52", "url": "https://translations.documentfoundation.org/api/units/96356363/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:40:36.159582Z" } ] }