Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/libo_help-24-2/textsdatabase/axm/units/?format=api&page=6
{ "count": 1739, "next": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/axm/units/?format=api&page=7", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/axm/units/?format=api&page=5", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/axm/?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/107518590/?format=api", "priority": 100, "id": 107576623, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/axm/?checksum=3f2535a9d80d6508", "url": "https://translations.documentfoundation.org/api/units/107576623/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:03.789508Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/axm/?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/107518594/?format=api", "priority": 100, "id": 107576627, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/axm/?checksum=f14bd7a10bd6cdf7", "url": "https://translations.documentfoundation.org/api/units/107576627/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:03.791061Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/axm/?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/107518605/?format=api", "priority": 100, "id": 107576630, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/axm/?checksum=e8ab361ad24e5ef5", "url": "https://translations.documentfoundation.org/api/units/107576630/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:03.793742Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/axm/?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/107518619/?format=api", "priority": 100, "id": 107576632, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/axm/?checksum=6c07db2f6eb86b62", "url": "https://translations.documentfoundation.org/api/units/107576632/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:03.795114Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/axm/?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/107518620/?format=api", "priority": 100, "id": 107576635, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/axm/?checksum=f80c95480647f882", "url": "https://translations.documentfoundation.org/api/units/107576635/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:03.796527Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/axm/?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/107518628/?format=api", "priority": 100, "id": 107576638, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/axm/?checksum=f0fbae51c760029d", "url": "https://translations.documentfoundation.org/api/units/107576638/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:03.797861Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/axm/?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/107518637/?format=api", "priority": 100, "id": 107576640, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/axm/?checksum=c484871ad9e28012", "url": "https://translations.documentfoundation.org/api/units/107576640/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:03.799173Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/axm/?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/107518651/?format=api", "priority": 100, "id": 107576642, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/axm/?checksum=6b6141823bb17437", "url": "https://translations.documentfoundation.org/api/units/107576642/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:03.800498Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/axm/?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/107518672/?format=api", "priority": 100, "id": 107576644, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/axm/?checksum=b8dcc2ab05d5d79c", "url": "https://translations.documentfoundation.org/api/units/107576644/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:03.801860Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/axm/?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/107518708/?format=api", "priority": 100, "id": 107576647, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/axm/?checksum=6e6e9c1d01afb80c", "url": "https://translations.documentfoundation.org/api/units/107576647/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:03.803260Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/axm/?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/107518713/?format=api", "priority": 100, "id": 107576649, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/axm/?checksum=70aa55b10400329d", "url": "https://translations.documentfoundation.org/api/units/107576649/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:03.804785Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/axm/?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/107518716/?format=api", "priority": 100, "id": 107576651, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/axm/?checksum=48d74ca9cf82657b", "url": "https://translations.documentfoundation.org/api/units/107576651/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:03.806178Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/axm/?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/107518722/?format=api", "priority": 100, "id": 107576653, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/axm/?checksum=510c532e099f7565", "url": "https://translations.documentfoundation.org/api/units/107576653/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:03.807413Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/axm/?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/107518728/?format=api", "priority": 100, "id": 107576656, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/axm/?checksum=d1caf16364dcea18", "url": "https://translations.documentfoundation.org/api/units/107576656/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:03.808972Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/axm/?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/107518735/?format=api", "priority": 100, "id": 107576658, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/axm/?checksum=db60cbc6c3a97af0", "url": "https://translations.documentfoundation.org/api/units/107576658/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:03.810445Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/axm/?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/107518752/?format=api", "priority": 100, "id": 107576661, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/axm/?checksum=e45527a32629c77b", "url": "https://translations.documentfoundation.org/api/units/107576661/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:03.811973Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/axm/?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/107518768/?format=api", "priority": 100, "id": 107576664, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/axm/?checksum=8640cb55143edbe7", "url": "https://translations.documentfoundation.org/api/units/107576664/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:03.823530Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/axm/?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/107518781/?format=api", "priority": 100, "id": 107576665, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/axm/?checksum=0f087ef2cd3405d3", "url": "https://translations.documentfoundation.org/api/units/107576665/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:03.825494Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/axm/?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/107518803/?format=api", "priority": 100, "id": 107576666, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/axm/?checksum=b90e9a747be3f72e", "url": "https://translations.documentfoundation.org/api/units/107576666/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:03.827109Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/axm/?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/107518814/?format=api", "priority": 100, "id": 107576669, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/axm/?checksum=1032d7351f837b9d", "url": "https://translations.documentfoundation.org/api/units/107576669/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:03.828695Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/axm/?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/107518824/?format=api", "priority": 100, "id": 107576672, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/axm/?checksum=9f137939443ff99b", "url": "https://translations.documentfoundation.org/api/units/107576672/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:03.830311Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/axm/?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/107518840/?format=api", "priority": 100, "id": 107576674, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/axm/?checksum=e622d0dc17a172b7", "url": "https://translations.documentfoundation.org/api/units/107576674/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:03.831830Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/axm/?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/107518861/?format=api", "priority": 100, "id": 107576677, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/axm/?checksum=9d40da7e1de2d565", "url": "https://translations.documentfoundation.org/api/units/107576677/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:03.837276Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/axm/?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/107518874/?format=api", "priority": 100, "id": 107576678, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/axm/?checksum=a2158a9cf1f1c2ad", "url": "https://translations.documentfoundation.org/api/units/107576678/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:03.839431Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/axm/?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/107518886/?format=api", "priority": 100, "id": 107576679, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/axm/?checksum=83ab6db864947e5d", "url": "https://translations.documentfoundation.org/api/units/107576679/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:03.841355Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/axm/?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/107518905/?format=api", "priority": 100, "id": 107576681, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/axm/?checksum=1651c3b512638dff", "url": "https://translations.documentfoundation.org/api/units/107576681/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:03.843471Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/axm/?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/107518948/?format=api", "priority": 100, "id": 107576683, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/axm/?checksum=e776a92d0c8d3d59", "url": "https://translations.documentfoundation.org/api/units/107576683/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:03.845501Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/axm/?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/107518962/?format=api", "priority": 100, "id": 107576686, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/axm/?checksum=ee5bc2a2964152df", "url": "https://translations.documentfoundation.org/api/units/107576686/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:03.847308Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/axm/?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/107518974/?format=api", "priority": 100, "id": 107576688, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/axm/?checksum=a4b6dcf329a9f0dd", "url": "https://translations.documentfoundation.org/api/units/107576688/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:03.848906Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/axm/?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/107518984/?format=api", "priority": 100, "id": 107576690, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/axm/?checksum=ee354695204d6021", "url": "https://translations.documentfoundation.org/api/units/107576690/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:03.850437Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/axm/?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/107518992/?format=api", "priority": 100, "id": 107576692, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/axm/?checksum=902fca834ddac001", "url": "https://translations.documentfoundation.org/api/units/107576692/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:03.851928Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/axm/?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/107518998/?format=api", "priority": 100, "id": 107576696, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/axm/?checksum=ce4cf17f8192519d", "url": "https://translations.documentfoundation.org/api/units/107576696/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:03.853295Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/axm/?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/107519000/?format=api", "priority": 100, "id": 107576697, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/axm/?checksum=71eeb3af9d062d58", "url": "https://translations.documentfoundation.org/api/units/107576697/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:03.854863Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/axm/?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/107519013/?format=api", "priority": 100, "id": 107576699, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/axm/?checksum=2350847d295db268", "url": "https://translations.documentfoundation.org/api/units/107576699/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:03.856186Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/axm/?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/107519029/?format=api", "priority": 100, "id": 107576700, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/axm/?checksum=9210035be5d33172", "url": "https://translations.documentfoundation.org/api/units/107576700/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:03.857456Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/axm/?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/107519046/?format=api", "priority": 100, "id": 107576701, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/axm/?checksum=a554c9728484b7f6", "url": "https://translations.documentfoundation.org/api/units/107576701/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:03.858734Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/axm/?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/107519062/?format=api", "priority": 100, "id": 107576704, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/axm/?checksum=09840769a28d869e", "url": "https://translations.documentfoundation.org/api/units/107576704/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:03.860093Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/axm/?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/107519089/?format=api", "priority": 100, "id": 107576707, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/axm/?checksum=7f7ea52a5c88cf04", "url": "https://translations.documentfoundation.org/api/units/107576707/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:03.861468Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/axm/?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/107519110/?format=api", "priority": 100, "id": 107576710, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/axm/?checksum=9282d570bc64b349", "url": "https://translations.documentfoundation.org/api/units/107576710/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:03.862680Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/axm/?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/107519134/?format=api", "priority": 100, "id": 107576750, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/axm/?checksum=67292492f3b3b9fc", "url": "https://translations.documentfoundation.org/api/units/107576750/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:03.918821Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/axm/?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/107519152/?format=api", "priority": 100, "id": 107576752, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/axm/?checksum=e91cb6379d432b86", "url": "https://translations.documentfoundation.org/api/units/107576752/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:03.921109Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/axm/?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/107519169/?format=api", "priority": 100, "id": 107576754, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/axm/?checksum=5a3e2e02baefc234", "url": "https://translations.documentfoundation.org/api/units/107576754/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:03.922901Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/axm/?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/107519198/?format=api", "priority": 100, "id": 107576756, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/axm/?checksum=47be67a46ecbb481", "url": "https://translations.documentfoundation.org/api/units/107576756/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:03.924639Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/axm/?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/107519221/?format=api", "priority": 100, "id": 107576757, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/axm/?checksum=1b13268f00c1be09", "url": "https://translations.documentfoundation.org/api/units/107576757/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:03.926341Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/axm/?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/107519228/?format=api", "priority": 100, "id": 107576759, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/axm/?checksum=16b89a1be24de5be", "url": "https://translations.documentfoundation.org/api/units/107576759/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:03.928036Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/axm/?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/107519239/?format=api", "priority": 100, "id": 107576763, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/axm/?checksum=2b26fe76b5bff5ae", "url": "https://translations.documentfoundation.org/api/units/107576763/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:03.929629Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/axm/?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/107519253/?format=api", "priority": 100, "id": 107576764, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/axm/?checksum=01109622fd5b66ac", "url": "https://translations.documentfoundation.org/api/units/107576764/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:03.931320Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/axm/?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/107519273/?format=api", "priority": 100, "id": 107576766, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/axm/?checksum=9659c117d22bba44", "url": "https://translations.documentfoundation.org/api/units/107576766/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:03.933104Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/axm/?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/107519288/?format=api", "priority": 100, "id": 107576767, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/axm/?checksum=d40b62cb58fa23e8", "url": "https://translations.documentfoundation.org/api/units/107576767/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:03.934808Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/axm/?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/107519318/?format=api", "priority": 100, "id": 107576769, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/axm/?checksum=9e93cb394e210d52", "url": "https://translations.documentfoundation.org/api/units/107576769/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:03.936371Z" } ] }