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/cs/units/?format=api&page=6
{ "count": 1739, "next": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/cs/units/?format=api&page=7", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/cs/units/?format=api&page=5", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/cs/?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": [ "Všechny výrazy (literály) data musí být uzavřeny v jednoduchých uvozovkách. (Podrobnosti naleznete v dokumentaci k databázi a konektoru, které používáte.)" ], "id_hash": -4673270034736519928, "content_hash": -4673270034736519928, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3150510\nhelp.text", "note": "CZdA4", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 251, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 27, "source_unit": "https://translations.documentfoundation.org/api/units/107518590/?format=api", "priority": 100, "id": 107630959, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/cs/?checksum=3f2535a9d80d6508", "url": "https://translations.documentfoundation.org/api/units/107630959/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:59:18.807370Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/cs/?format=api", "source": [ "Querying Yes/No fields" ], "previous_source": "", "target": [ "Dotazy na pole s hodnotami Yes/No (Ano/Ne)" ], "id_hash": 8163855836227489271, "content_hash": 8163855836227489271, "location": "02010100.xhp", "context": "02010100.xhp\nhd_id3150427\nhelp.text", "note": "HXdKT", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 252, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/107518594/?format=api", "priority": 100, "id": 107630961, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/cs/?checksum=f14bd7a10bd6cdf7", "url": "https://translations.documentfoundation.org/api/units/107630961/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:59:18.809939Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/cs/?format=api", "source": [ "To query Yes/No fields, use the following syntax for dBASE tables:" ], "previous_source": "", "target": [ "Chcete-li filtrovat pole typu Ano/Ne, použijte pro tabulky dBASE následující syntaxi:" ], "id_hash": 7542181489787428597, "content_hash": 7542181489787428597, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3149523\nhelp.text", "note": "xWzix", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 253, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/107518605/?format=api", "priority": 100, "id": 107630963, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/cs/?checksum=e8ab361ad24e5ef5", "url": "https://translations.documentfoundation.org/api/units/107630963/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:59:18.812414Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/cs/?format=api", "source": [ "Status" ], "previous_source": "", "target": [ "Stav" ], "id_hash": -1438940559154058398, "content_hash": -1438940559154058398, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3153180\nhelp.text", "note": "A4Uh7", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 254, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/107518619/?format=api", "priority": 100, "id": 107630965, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/cs/?checksum=6c07db2f6eb86b62", "url": "https://translations.documentfoundation.org/api/units/107630965/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:59:18.815141Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/cs/?format=api", "source": [ "Query criterion" ], "previous_source": "", "target": [ "Kritérium dotazu" ], "id_hash": 8650453120847444098, "content_hash": 8650453120847444098, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3147481\nhelp.text", "note": "FnXiE", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 255, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/107518620/?format=api", "priority": 100, "id": 107630966, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/cs/?checksum=f80c95480647f882", "url": "https://translations.documentfoundation.org/api/units/107630966/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:59:18.817655Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/cs/?format=api", "source": [ "Example" ], "previous_source": "", "target": [ "Příklad" ], "id_hash": 8141292417662845597, "content_hash": 8141292417662845597, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3155187\nhelp.text", "note": "e6DJr", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 256, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/107518628/?format=api", "priority": 100, "id": 107630967, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/cs/?checksum=f0fbae51c760029d", "url": "https://translations.documentfoundation.org/api/units/107630967/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:59:18.820122Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/cs/?format=api", "source": [ "Yes" ], "previous_source": "", "target": [ "ano" ], "id_hash": 4937219640899305490, "content_hash": 4937219640899305490, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3156092\nhelp.text", "note": "Guy7d", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 257, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/107518637/?format=api", "priority": 100, "id": 107630968, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/cs/?checksum=c484871ad9e28012", "url": "https://translations.documentfoundation.org/api/units/107630968/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:59:18.822082Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/cs/?format=api", "source": [ "for dBASE tables: not equal to any given value" ], "previous_source": "", "target": [ "pro tabulky ve formátu dBASE: není rovno žádné zadané hodnotě" ], "id_hash": -1485834374452513737, "content_hash": -1485834374452513737, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3152414\nhelp.text", "note": "p9WTn", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 258, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/107518651/?format=api", "priority": 100, "id": 107630969, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/cs/?checksum=6b6141823bb17437", "url": "https://translations.documentfoundation.org/api/units/107630969/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:59:18.824083Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/cs/?format=api", "source": [ "=1 returns all records where the Yes/No field has the status \"Yes\" or \"On\" (selected in black)," ], "previous_source": "", "target": [ "=1 vrátí všechny záznamy, kde má pole Ano/Ne stav Ano nebo Zapnuto (zobrazeno černě)," ], "id_hash": 4097363800793405340, "content_hash": 4097363800793405340, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3151265\nhelp.text", "note": "RFrvz", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 259, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 17, "source_unit": "https://translations.documentfoundation.org/api/units/107518672/?format=api", "priority": 100, "id": 107630970, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/cs/?checksum=b8dcc2ab05d5d79c", "url": "https://translations.documentfoundation.org/api/units/107630970/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:59:18.830302Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/cs/?format=api", "source": [ "No" ], "previous_source": "", "target": [ "ne" ], "id_hash": -1265902796848252916, "content_hash": -1265902796848252916, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3152450\nhelp.text", "note": "3P4ZB", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 260, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/107518708/?format=api", "priority": 100, "id": 107630971, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/cs/?checksum=6e6e9c1d01afb80c", "url": "https://translations.documentfoundation.org/api/units/107630971/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:59:18.835508Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/cs/?format=api", "source": [ "." ], "previous_source": "", "target": [ "." ], "id_hash": -1104976539801341283, "content_hash": -1104976539801341283, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3150997\nhelp.text", "note": "BzBAa", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 261, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/107518713/?format=api", "priority": 100, "id": 107630972, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/cs/?checksum=70aa55b10400329d", "url": "https://translations.documentfoundation.org/api/units/107630972/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:59:18.837248Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/cs/?format=api", "source": [ "=0 returns all records for which the Yes/No field has the status \"No\" or \"Off\" (no selection)." ], "previous_source": "", "target": [ "=0 vrátí všechny záznamy, kde má pole Ano/Ne stav Ne nebo Vypnuto (neoznačeno)." ], "id_hash": -3974623853916560005, "content_hash": -3974623853916560005, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3155331\nhelp.text", "note": "TFsQG", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 262, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 17, "source_unit": "https://translations.documentfoundation.org/api/units/107518716/?format=api", "priority": 100, "id": 107630973, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/cs/?checksum=48d74ca9cf82657b", "url": "https://translations.documentfoundation.org/api/units/107630973/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:59:18.839354Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/cs/?format=api", "source": [ "Null" ], "previous_source": "", "target": [ "Null" ], "id_hash": -3383237762867038875, "content_hash": -3383237762867038875, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3154179\nhelp.text", "note": "9KXzK", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 263, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/107518722/?format=api", "priority": 100, "id": 107630974, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/cs/?checksum=510c532e099f7565", "url": "https://translations.documentfoundation.org/api/units/107630974/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:59:18.842085Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/cs/?format=api", "source": [ "IS NULL" ], "previous_source": "", "target": [ "IS NULL" ], "id_hash": 5893788471563971096, "content_hash": 5893788471563971096, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3147035\nhelp.text", "note": "CwGZv", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 264, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/107518728/?format=api", "priority": 100, "id": 107630975, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/cs/?checksum=d1caf16364dcea18", "url": "https://translations.documentfoundation.org/api/units/107630975/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:59:18.845550Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/cs/?format=api", "source": [ "IS NULL returns all records for which the Yes/No field has neither of the states Yes or No (selected in gray)." ], "previous_source": "", "target": [ "IS NULL vrátí všechny záznamy, kde pole Ano/Ne není ve stavu ani Ano ani Ne (označeno šedě)." ], "id_hash": 6584486709762292464, "content_hash": 6584486709762292464, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3159385\nhelp.text", "note": "dyXYc", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 265, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 21, "source_unit": "https://translations.documentfoundation.org/api/units/107518735/?format=api", "priority": 100, "id": 107630976, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/cs/?checksum=db60cbc6c3a97af0", "url": "https://translations.documentfoundation.org/api/units/107630976/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:59:18.849321Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/cs/?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": [ "Tato syntaxe závisí na použitém databázovém systému. Poznámka: pole Ano/Ne se mohou chovat různě (mohou nabývat dvou stavů místo tří)." ], "id_hash": 7229728358486624123, "content_hash": 7229728358486624123, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3157888\nhelp.text", "note": "YWk5J", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 266, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 25, "source_unit": "https://translations.documentfoundation.org/api/units/107518752/?format=api", "priority": 100, "id": 107630977, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/cs/?checksum=e45527a32629c77b", "url": "https://translations.documentfoundation.org/api/units/107630977/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:59:18.853841Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/cs/?format=api", "source": [ "Parameter queries" ], "previous_source": "", "target": [ "Parametrické dotazy" ], "id_hash": 450583529009372135, "content_hash": 450583529009372135, "location": "02010100.xhp", "context": "02010100.xhp\nhd_id3145772\nhelp.text", "note": "mmVa8", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 267, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/107518768/?format=api", "priority": 100, "id": 107630978, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/cs/?checksum=8640cb55143edbe7", "url": "https://translations.documentfoundation.org/api/units/107630978/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:59:18.856816Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/cs/?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": [ "Parametrické dotazy umožňují uživateli při vykonávání zadat vstupní hodnoty. Tyto hodnoty jsou použity v rámci kritérií pro výběr záznamů, které se mají zobrazit. Každé hodnotě odpovídá název parametru, který se zobrazí s výzvou pro zadání hodnoty při spuštění dotazu." ], "id_hash": -8140116745182247469, "content_hash": -8140116745182247469, "location": "02010100.xhp", "context": "02010100.xhp\npar_id191120151905346795\nhelp.text", "note": "ND7xd", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 268, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 46, "source_unit": "https://translations.documentfoundation.org/api/units/107518781/?format=api", "priority": 100, "id": 107630979, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/cs/?checksum=0f087ef2cd3405d3", "url": "https://translations.documentfoundation.org/api/units/107630979/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:59:18.858768Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/cs/?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": [ "Názvy parametrů jsou uvozeny dvojtečkou, a to v režimu návrhu i SQL. Tento zápis se použije, kdekoliv se má hodnota vyskytnout. Pokud se stejná hodnota objevuje v dotazu víckrát, použije se tentýž název parametru." ], "id_hash": 4111393334921262894, "content_hash": 4111393334921262894, "location": "02010100.xhp", "context": "02010100.xhp\npar_id191120151905439551\nhelp.text", "note": "Be7XG", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 269, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 45, "source_unit": "https://translations.documentfoundation.org/api/units/107518803/?format=api", "priority": 100, "id": 107630980, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/cs/?checksum=b90e9a747be3f72e", "url": "https://translations.documentfoundation.org/api/units/107630980/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:59:18.860808Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/cs/?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": [ "V nejjednodušším případě, kdy uživatel vkládá hodnotu, které se mají záznamy rovnat, je název parametru s uvozující dvojtečkou zadán do řádku Kritérium. V <link href=\"text/shared/explorer/database/02010100.xhp#sqlmode\">režimu SQL</link>to lze zapsat jako <item type=\"input\">WHERE \"Pole\" = :Nazev_parametru</item>" ], "id_hash": -8056140160250446947, "content_hash": -8056140160250446947, "location": "02010100.xhp", "context": "02010100.xhp\npar_id191120151905518123\nhelp.text", "note": "f2NMg", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 270, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 43, "source_unit": "https://translations.documentfoundation.org/api/units/107518814/?format=api", "priority": 100, "id": 107630981, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/cs/?checksum=1032d7351f837b9d", "url": "https://translations.documentfoundation.org/api/units/107630981/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:59:18.864024Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/cs/?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": [ "Názvy parametrů nesmí obsahovat některý ze znaků <item type=\"input\"><mezera>`!\"$%^*()+={}[]@'~#<>?/,</item>. Rovněž nemohou být stejné jako názvy polí nebo vyhrazená slova jazyka SQL. Mohou být stejné jako aliasy." ], "id_hash": 2239266726598408603, "content_hash": 2239266726598408603, "location": "02010100.xhp", "context": "02010100.xhp\npar_id191120151905584287\nhelp.text", "note": "DZCXm", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 271, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 31, "source_unit": "https://translations.documentfoundation.org/api/units/107518824/?format=api", "priority": 100, "id": 107630982, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/cs/?checksum=9f137939443ff99b", "url": "https://translations.documentfoundation.org/api/units/107630982/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:59:18.866652Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/cs/?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": [ "Při výběru záznamů podle části obsahu textového pole bývá užitečné přidat skrytý sloupec s kritériem <item type=\"input\">\"LIKE '%' || :Cast_pole || '%'\"</item>. Tím vyberete záznamy s přesnou shodou. Požadujete-li, aby při testování nezáleželo na velikosti písmen, řešením může být použití pole <item type=\"input\">LOWER (Nazev_pole)</item> a kritéria <item type=\"input\">LIKE LOWER ( '%' || :Cast_pole || '%' )</item>. Důležité jsou mezery v kritériu: jsou-li vynechány, syntaktický analyzátor SQL celé kritérium interpretuje jako řetězec, s nímž se má obsah shodovat. V <link href=\"text/sdatabase/02010100.xhp#sqlmode\">režimu SQL</link> lze toto zapsat jako <item type=\"input\">LOWER ( \"Nazev_pole\" ) LIKE LOWER ( '%' || :Cast_pole || '%' )</item>." ], "id_hash": 7359674384784650935, "content_hash": 7359674384784650935, "location": "02010100.xhp", "context": "02010100.xhp\npar_id191120151931441881\nhelp.text", "note": "WBEtt", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 272, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 120, "source_unit": "https://translations.documentfoundation.org/api/units/107518840/?format=api", "priority": 100, "id": 107630983, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/cs/?checksum=e622d0dc17a172b7", "url": "https://translations.documentfoundation.org/api/units/107630983/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:59:18.869372Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/cs/?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": [ "Parametrické dotazy lze použít jako zdroj dat pro <link href=\"text/shared/02/01170203.xhp\">podformuláře</link>, u nichž může uživatel omezit zobrazené záznamy." ], "id_hash": 2107924860811531621, "content_hash": 2107924860811531621, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3150585\nhelp.text", "note": "EAESi", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 273, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 21, "source_unit": "https://translations.documentfoundation.org/api/units/107518861/?format=api", "priority": 100, "id": 107630984, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/cs/?checksum=9d40da7e1de2d565", "url": "https://translations.documentfoundation.org/api/units/107630984/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:59:18.873683Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/cs/?format=api", "source": [ "Parameter Input" ], "previous_source": "", "target": [ "Vstup parametru" ], "id_hash": 2456021578479157933, "content_hash": 2456021578479157933, "location": "02010100.xhp", "context": "02010100.xhp\nhd_id3151035\nhelp.text", "note": "DRj78", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 274, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/107518874/?format=api", "priority": 100, "id": 107630985, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/cs/?checksum=a2158a9cf1f1c2ad", "url": "https://translations.documentfoundation.org/api/units/107630985/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:59:18.876134Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/cs/?format=api", "source": [ "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\">The <emph>Parameter Input</emph> dialog asks the user to enter the parameter values. Enter a value for each query parameter and confirm by clicking <emph>OK</emph> or typing <emph>Enter</emph>.</ahelp>" ], "previous_source": "", "target": [ "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\">V dialogovém okně <emph>Vstup parametru</emph> je uživatel požádán o zadání hodnot parametrů. Zadejte hodnotu pro každý parametr dotazu a potvrďte klepnutím na <emph>OK</emph> nebo stisknutím klávesy <emph>Enter</emph>.</ahelp>" ], "id_hash": 264425641860169309, "content_hash": 264425641860169309, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3153596\nhelp.text", "note": "BisCF", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 275, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 28, "source_unit": "https://translations.documentfoundation.org/api/units/107518886/?format=api", "priority": 100, "id": 107630986, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/cs/?checksum=83ab6db864947e5d", "url": "https://translations.documentfoundation.org/api/units/107630986/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:59:18.879505Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/cs/?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": [ "Hodnoty zadané uživatelem mohou obsahovat jakékoliv znaky, které jsou povolené pro SQL příslušného kritéria; to může záviset na použitém databázovém systému." ], "id_hash": -7615090312441786881, "content_hash": -7615090312441786881, "location": "02010100.xhp", "context": "02010100.xhp\npar_id191120151924165870\nhelp.text", "note": "eGETM", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 276, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 29, "source_unit": "https://translations.documentfoundation.org/api/units/107518905/?format=api", "priority": 100, "id": 107630987, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/cs/?checksum=1651c3b512638dff", "url": "https://translations.documentfoundation.org/api/units/107630987/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:59:18.882938Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/cs/?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": [ "Je-li potřeba získat záznamy pomocí komplexnějších kritérií, je možné jako součást hodnoty použít zástupné znaky SQL \"%\" (libovolný řetězec) nebo \"_\" (libovolný jediný znak)." ], "id_hash": 7455332244107640153, "content_hash": 7455332244107640153, "location": "02010100.xhp", "context": "02010100.xhp\npar_id191120151939594217\nhelp.text", "note": "seFhG", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 277, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 28, "source_unit": "https://translations.documentfoundation.org/api/units/107518948/?format=api", "priority": 100, "id": 107630988, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/cs/?checksum=e776a92d0c8d3d59", "url": "https://translations.documentfoundation.org/api/units/107630988/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:59:18.886526Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/cs/?format=api", "source": [ "SQL Mode" ], "previous_source": "", "target": [ "Režim SQL" ], "id_hash": 7952163570614096607, "content_hash": 7952163570614096607, "location": "02010100.xhp", "context": "02010100.xhp\nhd_id3145181\nhelp.text", "note": "wRe6v", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 278, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/107518962/?format=api", "priority": 100, "id": 107630989, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/cs/?checksum=ee5bc2a2964152df", "url": "https://translations.documentfoundation.org/api/units/107630989/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:59:18.889762Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/cs/?format=api", "source": [ "SQL stands for \"Structured Query Language\" and describes instructions for updating and administering relational databases." ], "previous_source": "", "target": [ "SQL neboli „Structured Query Language“ je jazyk, který popisuje příkazy sloužící k aktualizaci a správě relačních databází." ], "id_hash": 2645544768060911837, "content_hash": 2645544768060911837, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3147013\nhelp.text", "note": "5avVu", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 279, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://translations.documentfoundation.org/api/units/107518974/?format=api", "priority": 100, "id": 107630990, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/cs/?checksum=a4b6dcf329a9f0dd", "url": "https://translations.documentfoundation.org/api/units/107630990/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:59:18.893892Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/cs/?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": [ "V $[officename] nemusíte pro většinu dotazů SQL znát, jelikož není nutné zadávat příkazy SQL přímo. Když vytvoříte dotaz v režimu návrhu, $[officename] automaticky převede zadané instrukce na odpovídající syntaxi SQL. Pokud se tlačítkem <emph>Režim návrhu zap/vyp</emph> přepnete do režimu SQL, zobrazí se příkazy SQL pro vytvořený dotaz." ], "id_hash": 7941331124243750945, "content_hash": 7941331124243750945, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3152570\nhelp.text", "note": "wDAAY", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 280, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 73, "source_unit": "https://translations.documentfoundation.org/api/units/107518984/?format=api", "priority": 100, "id": 107630991, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/cs/?checksum=ee354695204d6021", "url": "https://translations.documentfoundation.org/api/units/107630991/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:59:18.897273Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/cs/?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": [ "Dotaz je však možné také zadat přímo v SQL. Speciální syntaxe ovšem závisí na použitém databázovém systému." ], "id_hash": 1166373493807955969, "content_hash": 1166373493807955969, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3152412\nhelp.text", "note": "hBQFv", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 281, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 24, "source_unit": "https://translations.documentfoundation.org/api/units/107518992/?format=api", "priority": 100, "id": 107630992, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/cs/?checksum=902fca834ddac001", "url": "https://translations.documentfoundation.org/api/units/107630992/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:59:18.900356Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/cs/?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": [ "Pokud zadáváte SQL dotaz přímo, je možné použít specifické možnosti SQL, které nelze zadat v grafickém rozhraní v <emph>Návrhu dotazu</emph>. Tyto dotazy je nutno spouštět v nativním režimu SQL." ], "id_hash": 5642149963125379485, "content_hash": 5642149963125379485, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3146842\nhelp.text", "note": "kkuBG", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 282, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 33, "source_unit": "https://translations.documentfoundation.org/api/units/107518998/?format=api", "priority": 100, "id": 107630993, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/cs/?checksum=ce4cf17f8192519d", "url": "https://translations.documentfoundation.org/api/units/107630993/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:59:18.902957Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/cs/?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": [ "Po klepnutí na ikonu <link href=\"text/shared/02/14030000.xhp\"><emph>Spustit SQL příkaz přímo</emph></link> v režimu SQL je možné zadat dotaz, který nezpracovává LibreOffice, ale posílá se přímo databázovému enginu." ], "id_hash": -1013675299276706472, "content_hash": -1013675299276706472, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3149632\nhelp.text", "note": "LgvXF", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 283, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 31, "source_unit": "https://translations.documentfoundation.org/api/units/107519000/?format=api", "priority": 100, "id": 107630994, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/cs/?checksum=71eeb3af9d062d58", "url": "https://translations.documentfoundation.org/api/units/107630994/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:59:18.905203Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/cs/?format=api", "source": [ "Join Properties" ], "previous_source": "", "target": [ "Vlastnosti spojení (join)" ], "id_hash": -6678692574290660760, "content_hash": -6678692574290660760, "location": "02010101.xhp", "context": "02010101.xhp\ntit\nhelp.text", "note": "fKBDD", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 284, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/107519013/?format=api", "priority": 100, "id": 107630995, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/cs/?checksum=2350847d295db268", "url": "https://translations.documentfoundation.org/api/units/107630995/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:59:18.907507Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/cs/?format=api", "source": [ "<bookmark_value>links;relational databases (Base)</bookmark_value> <bookmark_value>inner joins (Base)</bookmark_value> <bookmark_value>joins in databases (Base)</bookmark_value> <bookmark_value>left joins (Base)</bookmark_value> <bookmark_value>right joins (Base)</bookmark_value> <bookmark_value>full joins (Base)</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>odkazy;relační databáze (Base)</bookmark_value><bookmark_value>vnitřní spojení (Base)</bookmark_value><bookmark_value>spojení v databázích (Base)</bookmark_value><bookmark_value>spojení zleva (Base)</bookmark_value><bookmark_value>spojení zprava (Base)</bookmark_value><bookmark_value>úplné spojení (Base)</bookmark_value>" ], "id_hash": 1301543985542803826, "content_hash": 1301543985542803826, "location": "02010101.xhp", "context": "02010101.xhp\nbm_id3154015\nhelp.text", "note": "TTCNB", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 285, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/107519029/?format=api", "priority": 100, "id": 107630996, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/cs/?checksum=9210035be5d33172", "url": "https://translations.documentfoundation.org/api/units/107630996/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:59:18.908913Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/cs/?format=api", "source": [ "Join Properties" ], "previous_source": "", "target": [ "Vlastnosti spojení (join)" ], "id_hash": 2689996371133773814, "content_hash": 2689996371133773814, "location": "02010101.xhp", "context": "02010101.xhp\nhd_id3154015\nhelp.text", "note": "DG7RD", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 286, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/107519046/?format=api", "priority": 100, "id": 107630997, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/cs/?checksum=a554c9728484b7f6", "url": "https://translations.documentfoundation.org/api/units/107630997/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:59:18.911289Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/cs/?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": [ "Pokud v návrhu dotazu poklepete na spojnici mezi dvěma poli nebo zvolíte <emph>Vložit - Nová relace</emph>, zobrazí se dialogové okno <emph>Vlastnosti spojení</emph>. Možnosti, které nastavíte, se použijí pro všechny nově vytvořené dotazy." ], "id_hash": -8537690843307473250, "content_hash": -8537690843307473250, "location": "02010101.xhp", "context": "02010101.xhp\npar_id3151205\nhelp.text", "note": "MzpBt", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 287, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 38, "source_unit": "https://translations.documentfoundation.org/api/units/107519062/?format=api", "priority": 100, "id": 107630998, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/cs/?checksum=09840769a28d869e", "url": "https://translations.documentfoundation.org/api/units/107630998/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:59:18.912953Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/cs/?format=api", "source": [ "Tables involved" ], "previous_source": "", "target": [ "Použité tabulky" ], "id_hash": -36410145612706044, "content_hash": -36410145612706044, "location": "02010101.xhp", "context": "02010101.xhp\nhd_id3155066\nhelp.text", "note": "oszEF", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 288, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/107519089/?format=api", "priority": 100, "id": 107630999, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/cs/?checksum=7f7ea52a5c88cf04", "url": "https://translations.documentfoundation.org/api/units/107630999/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:59:18.915763Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/cs/?format=api", "source": [ "<ahelp hid=\"dbaccess/ui/joindialog/table2\">Specifies two different tables that you want to join.</ahelp>" ], "previous_source": "", "target": [ "<ahelp hid=\"dbaccess/ui/joindialog/table2\">Určuje dvě různé tabulky, které si přejete propojit.</ahelp>" ], "id_hash": 1333863119828857673, "content_hash": 1333863119828857673, "location": "02010101.xhp", "context": "02010101.xhp\npar_id3153924\nhelp.text", "note": "2AkcB", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 289, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/107519110/?format=api", "priority": 100, "id": 107631000, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/cs/?checksum=9282d570bc64b349", "url": "https://translations.documentfoundation.org/api/units/107631000/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:59:18.917904Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/cs/?format=api", "source": [ "Fields involved" ], "previous_source": "", "target": [ "Použitá pole" ], "id_hash": -1789859163330594308, "content_hash": -1789859163330594308, "location": "02010101.xhp", "context": "02010101.xhp\nhd_id3155766\nhelp.text", "note": "X6wkD", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 290, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/107519134/?format=api", "priority": 100, "id": 107631001, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/cs/?checksum=67292492f3b3b9fc", "url": "https://translations.documentfoundation.org/api/units/107631001/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:59:18.920661Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/cs/?format=api", "source": [ "<ahelp hid=\".\">Specifies two data fields that will be joined by a relation.</ahelp>" ], "previous_source": "", "target": [ "<ahelp hid=\".\">Určuje dvě pole, která budou spojena relací.</ahelp>" ], "id_hash": 7574129023308213126, "content_hash": 7574129023308213126, "location": "02010101.xhp", "context": "02010101.xhp\npar_id3148994\nhelp.text", "note": "8bYEZ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 291, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/107519152/?format=api", "priority": 100, "id": 107631002, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/cs/?checksum=e91cb6379d432b86", "url": "https://translations.documentfoundation.org/api/units/107631002/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:59:18.922792Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/cs/?format=api", "source": [ "Options" ], "previous_source": "", "target": [ "Možnosti" ], "id_hash": -2720686535624113612, "content_hash": -2720686535624113612, "location": "02010101.xhp", "context": "02010101.xhp\nhd_id3159267\nhelp.text", "note": "R8CbB", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 292, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/107519169/?format=api", "priority": 100, "id": 107631003, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/cs/?checksum=5a3e2e02baefc234", "url": "https://translations.documentfoundation.org/api/units/107631003/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:59:18.924953Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/cs/?format=api", "source": [ "Type" ], "previous_source": "", "target": [ "Typ" ], "id_hash": -4053688658655726463, "content_hash": -4053688658655726463, "location": "02010101.xhp", "context": "02010101.xhp\nhd_id3147340\nhelp.text", "note": "MRJCp", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 293, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/107519198/?format=api", "priority": 100, "id": 107631004, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/cs/?checksum=47be67a46ecbb481", "url": "https://translations.documentfoundation.org/api/units/107631004/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:59:18.927061Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/cs/?format=api", "source": [ "<ahelp hid=\"dbaccess/ui/joindialog/type\">Specifies the join type of the selected join.</ahelp> Some databases support only a subset of the various possible types." ], "previous_source": "", "target": [ "<ahelp hid=\"dbaccess/ui/joindialog/type\">Určuje typ vybraného spojení.</ahelp> Některé databáze podporují jen část možných typů." ], "id_hash": -7272426577638343159, "content_hash": -7272426577638343159, "location": "02010101.xhp", "context": "02010101.xhp\npar_id3152482\nhelp.text", "note": "rxAGo", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 294, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 20, "source_unit": "https://translations.documentfoundation.org/api/units/107519221/?format=api", "priority": 100, "id": 107631005, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/cs/?checksum=1b13268f00c1be09", "url": "https://translations.documentfoundation.org/api/units/107631005/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:59:18.929084Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/cs/?format=api", "source": [ "Inner Join" ], "previous_source": "", "target": [ "Vnitřní spoj" ], "id_hash": -7586144127754050114, "content_hash": -7586144127754050114, "location": "02010101.xhp", "context": "02010101.xhp\nhd_id3155334\nhelp.text", "note": "ngfse", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 295, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/107519228/?format=api", "priority": 100, "id": 107631006, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/cs/?checksum=16b89a1be24de5be", "url": "https://translations.documentfoundation.org/api/units/107631006/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:59:18.932687Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/cs/?format=api", "source": [ "<ahelp hid=\"dbaccess/ui/joindialog/type\">In an inner join, the results table contains only those records for which the content of the linked fields is the same.</ahelp> In $[officename] SQL this type of link is created by a corresponding WHERE clause." ], "previous_source": "", "target": [ "<ahelp hid=\"dbaccess/ui/joindialog/type\">Při vnitřním spoji obsahuje výsledná tabulka pouze ty záznamy, ve kterých je obsah propojených polí stejný.</ahelp> V $[officename] SQL se tento typ spojení vytvoří odpovídající klauzulí WHERE." ], "id_hash": -6113919658300017234, "content_hash": -6113919658300017234, "location": "02010101.xhp", "context": "02010101.xhp\npar_id3155936\nhelp.text", "note": "356Dv", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 296, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 37, "source_unit": "https://translations.documentfoundation.org/api/units/107519239/?format=api", "priority": 100, "id": 107631007, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/cs/?checksum=2b26fe76b5bff5ae", "url": "https://translations.documentfoundation.org/api/units/107631007/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:59:18.934575Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/cs/?format=api", "source": [ "Left Join" ], "previous_source": "", "target": [ "Levý spoj" ], "id_hash": -9146645766165797204, "content_hash": -9146645766165797204, "location": "02010101.xhp", "context": "02010101.xhp\nhd_id3156372\nhelp.text", "note": "XYKGT", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 297, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/107519253/?format=api", "priority": 100, "id": 107631008, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/cs/?checksum=01109622fd5b66ac", "url": "https://translations.documentfoundation.org/api/units/107631008/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:59:18.936311Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/cs/?format=api", "source": [ "<ahelp hid=\"dbaccess/ui/joindialog/type\">In a left join, the results table contains all records of the queried fields from the left table and only those records of the queried fields from the right table for which the content of the linked fields is the same.</ahelp> In $[officename] SQL this type of link corresponds to the LEFT OUTER JOIN command." ], "previous_source": "", "target": [ "<ahelp hid=\"dbaccess/ui/joindialog/type\">Při levém spoji obsahuje výsledná tabulka všechny záznamy levé tabulky a pouze ty záznamy pravé tabulky, pro které je obsah propojených polí stejný.</ahelp> V $[officename] SQL tento typ spoje odpovídá příkazu LEFT OUTER JOIN." ], "id_hash": 1610530649816152644, "content_hash": 1610530649816152644, "location": "02010101.xhp", "context": "02010101.xhp\npar_id3166450\nhelp.text", "note": "dRFux", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 298, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 56, "source_unit": "https://translations.documentfoundation.org/api/units/107519273/?format=api", "priority": 100, "id": 107631009, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/cs/?checksum=9659c117d22bba44", "url": "https://translations.documentfoundation.org/api/units/107631009/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:59:18.937645Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/cs/?format=api", "source": [ "Right Join" ], "previous_source": "", "target": [ "Pravý spoj" ], "id_hash": 6056042749440435176, "content_hash": 6056042749440435176, "location": "02010101.xhp", "context": "02010101.xhp\nhd_id3155607\nhelp.text", "note": "DxGWD", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 299, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/107519288/?format=api", "priority": 100, "id": 107631010, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/cs/?checksum=d40b62cb58fa23e8", "url": "https://translations.documentfoundation.org/api/units/107631010/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:59:18.939389Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/cs/?format=api", "source": [ "<ahelp hid=\"dbaccess/ui/joindialog/type\">In a right join, the results table contains all records of the queried fields from the right table and only those records of the queried fields from the left table for which the content of the linked fields is the same.</ahelp> In $[officename] SQL this type of link corresponds to the RIGHT OUTER JOIN command." ], "previous_source": "", "target": [ "<ahelp hid=\"dbaccess/ui/joindialog/type\">Při pravém spoji obsahuje výsledná tabulka všechny záznamy pravé tabulky a pouze ty záznamy levé tabulky, pro které je obsah propojených polí stejný.</ahelp> V $[officename] SQL tento typ spoje odpovídá příkazu RIGHT OUTER JOIN." ], "id_hash": 2203328089698667858, "content_hash": 2203328089698667858, "location": "02010101.xhp", "context": "02010101.xhp\npar_id3150647\nhelp.text", "note": "9eD8R", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 300, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 56, "source_unit": "https://translations.documentfoundation.org/api/units/107519318/?format=api", "priority": 100, "id": 107631011, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/cs/?checksum=9e93cb394e210d52", "url": "https://translations.documentfoundation.org/api/units/107631011/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:59:18.948010Z" } ] }