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/csb/units/?format=api&page=6
{ "count": 1739, "next": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/units/?format=api&page=7", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/units/?format=api&page=5", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": 96043759, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=3f2535a9d80d6508", "url": "https://translations.documentfoundation.org/api/units/96043759/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:30.468836Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": 96043776, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=f14bd7a10bd6cdf7", "url": "https://translations.documentfoundation.org/api/units/96043776/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:30.474482Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": 96043791, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=e8ab361ad24e5ef5", "url": "https://translations.documentfoundation.org/api/units/96043791/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:30.480185Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": 96043796, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=6c07db2f6eb86b62", "url": "https://translations.documentfoundation.org/api/units/96043796/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:30.481784Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": 96043799, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=f80c95480647f882", "url": "https://translations.documentfoundation.org/api/units/96043799/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:30.483264Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": 96043804, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=f0fbae51c760029d", "url": "https://translations.documentfoundation.org/api/units/96043804/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:30.484861Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": 96043808, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=c484871ad9e28012", "url": "https://translations.documentfoundation.org/api/units/96043808/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:30.486507Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": 96043812, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=6b6141823bb17437", "url": "https://translations.documentfoundation.org/api/units/96043812/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:30.487990Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": 96043816, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=b8dcc2ab05d5d79c", "url": "https://translations.documentfoundation.org/api/units/96043816/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:30.489646Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": 96043821, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=6e6e9c1d01afb80c", "url": "https://translations.documentfoundation.org/api/units/96043821/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:30.491117Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": 96043826, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=70aa55b10400329d", "url": "https://translations.documentfoundation.org/api/units/96043826/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:30.492620Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": 96043832, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=48d74ca9cf82657b", "url": "https://translations.documentfoundation.org/api/units/96043832/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:30.494218Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": 96043836, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=510c532e099f7565", "url": "https://translations.documentfoundation.org/api/units/96043836/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:30.496389Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": 96043842, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=d1caf16364dcea18", "url": "https://translations.documentfoundation.org/api/units/96043842/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:30.498403Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": 96043846, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=db60cbc6c3a97af0", "url": "https://translations.documentfoundation.org/api/units/96043846/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:30.499879Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": 96043955, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=e45527a32629c77b", "url": "https://translations.documentfoundation.org/api/units/96043955/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:30.747788Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": 96043957, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=8640cb55143edbe7", "url": "https://translations.documentfoundation.org/api/units/96043957/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:30.750343Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": 96043961, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=0f087ef2cd3405d3", "url": "https://translations.documentfoundation.org/api/units/96043961/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:30.751836Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": 96043963, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=b90e9a747be3f72e", "url": "https://translations.documentfoundation.org/api/units/96043963/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:30.753425Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": 96043966, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=1032d7351f837b9d", "url": "https://translations.documentfoundation.org/api/units/96043966/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:30.754994Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": 96043971, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=9f137939443ff99b", "url": "https://translations.documentfoundation.org/api/units/96043971/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:30.757682Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": 96043974, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=e622d0dc17a172b7", "url": "https://translations.documentfoundation.org/api/units/96043974/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:30.759397Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": 96043977, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=9d40da7e1de2d565", "url": "https://translations.documentfoundation.org/api/units/96043977/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:30.760876Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": 96043991, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=a2158a9cf1f1c2ad", "url": "https://translations.documentfoundation.org/api/units/96043991/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:30.801755Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": 96043998, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=83ab6db864947e5d", "url": "https://translations.documentfoundation.org/api/units/96043998/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:30.803424Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": 96044002, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=1651c3b512638dff", "url": "https://translations.documentfoundation.org/api/units/96044002/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:30.808531Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": 96044004, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=e776a92d0c8d3d59", "url": "https://translations.documentfoundation.org/api/units/96044004/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:30.810078Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": 96044006, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=ee5bc2a2964152df", "url": "https://translations.documentfoundation.org/api/units/96044006/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:30.811507Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": 96044009, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=a4b6dcf329a9f0dd", "url": "https://translations.documentfoundation.org/api/units/96044009/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:30.812980Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": 96044012, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=ee354695204d6021", "url": "https://translations.documentfoundation.org/api/units/96044012/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:30.814388Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": 96044015, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=902fca834ddac001", "url": "https://translations.documentfoundation.org/api/units/96044015/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:30.816067Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": 96044019, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=ce4cf17f8192519d", "url": "https://translations.documentfoundation.org/api/units/96044019/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:30.817583Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": 96044022, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=71eeb3af9d062d58", "url": "https://translations.documentfoundation.org/api/units/96044022/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:30.818967Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": 96044025, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=2350847d295db268", "url": "https://translations.documentfoundation.org/api/units/96044025/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:30.820417Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": 96044029, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=9210035be5d33172", "url": "https://translations.documentfoundation.org/api/units/96044029/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:30.821942Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": 96044032, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=a554c9728484b7f6", "url": "https://translations.documentfoundation.org/api/units/96044032/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:30.823584Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": 96044034, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=09840769a28d869e", "url": "https://translations.documentfoundation.org/api/units/96044034/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:30.825019Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": 96044036, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=7f7ea52a5c88cf04", "url": "https://translations.documentfoundation.org/api/units/96044036/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:30.826629Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": 96044039, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=9282d570bc64b349", "url": "https://translations.documentfoundation.org/api/units/96044039/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:30.828493Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": 96044041, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=67292492f3b3b9fc", "url": "https://translations.documentfoundation.org/api/units/96044041/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:30.830044Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": 96044043, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=e91cb6379d432b86", "url": "https://translations.documentfoundation.org/api/units/96044043/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:30.831414Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": 96044045, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=5a3e2e02baefc234", "url": "https://translations.documentfoundation.org/api/units/96044045/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:30.833347Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": 96044047, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=47be67a46ecbb481", "url": "https://translations.documentfoundation.org/api/units/96044047/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:30.835404Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": 96044054, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=1b13268f00c1be09", "url": "https://translations.documentfoundation.org/api/units/96044054/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:30.840317Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": 96044061, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=16b89a1be24de5be", "url": "https://translations.documentfoundation.org/api/units/96044061/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:30.844664Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": 96044065, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=2b26fe76b5bff5ae", "url": "https://translations.documentfoundation.org/api/units/96044065/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:30.847949Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": 96044068, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=01109622fd5b66ac", "url": "https://translations.documentfoundation.org/api/units/96044068/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:30.849792Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": 96044071, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=9659c117d22bba44", "url": "https://translations.documentfoundation.org/api/units/96044071/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:30.851260Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": 96044075, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=d40b62cb58fa23e8", "url": "https://translations.documentfoundation.org/api/units/96044075/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:30.852789Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": 96044082, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=9e93cb394e210d52", "url": "https://translations.documentfoundation.org/api/units/96044082/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:30.860709Z" } ] }