Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/libo_help-7-6/textsdatabase/es/units/?format=api&page=6
{ "count": 1739, "next": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/es/units/?format=api&page=7", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/es/units/?format=api&page=5", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/es/?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": [ "Todas las expresiones de fecha (literales de fecha) deben acotarse con comillas rectas simples. (Consulte el manual de referencia de la base de datos y el conector concretos que utiliza para obtener más detalles al respecto.)" ], "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/95832235/?format=api", "priority": 100, "id": 96166334, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/es/?checksum=3f2535a9d80d6508", "url": "https://translations.documentfoundation.org/api/units/96166334/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:37:20.757721Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/es/?format=api", "source": [ "Querying Yes/No fields" ], "previous_source": "", "target": [ "Efectuar consultas en campos sí/no" ], "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/95832309/?format=api", "priority": 100, "id": 96166338, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/es/?checksum=f14bd7a10bd6cdf7", "url": "https://translations.documentfoundation.org/api/units/96166338/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:37:20.759984Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/es/?format=api", "source": [ "To query Yes/No fields, use the following syntax for dBASE tables:" ], "previous_source": "", "target": [ "Para efectuar consultas en campos sí/no, utilice esta sintaxis para archivos dBASE:" ], "id_hash": 7542181489787428597, "content_hash": 7542181489787428597, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3149523\nhelp.text", "note": "xWzix", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 253, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/95832346/?format=api", "priority": 100, "id": 96166341, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/es/?checksum=e8ab361ad24e5ef5", "url": "https://translations.documentfoundation.org/api/units/96166341/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:37:20.761829Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/es/?format=api", "source": [ "Status" ], "previous_source": "", "target": [ "Estado" ], "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/95832421/?format=api", "priority": 100, "id": 96166346, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/es/?checksum=6c07db2f6eb86b62", "url": "https://translations.documentfoundation.org/api/units/96166346/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:37:20.763641Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/es/?format=api", "source": [ "Query criterion" ], "previous_source": "", "target": [ "Criterio de consulta" ], "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/95832452/?format=api", "priority": 100, "id": 96166350, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/es/?checksum=f80c95480647f882", "url": "https://translations.documentfoundation.org/api/units/96166350/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:37:20.765460Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/es/?format=api", "source": [ "Example" ], "previous_source": "", "target": [ "Ejemplo" ], "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/95832475/?format=api", "priority": 100, "id": 96166353, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/es/?checksum=f0fbae51c760029d", "url": "https://translations.documentfoundation.org/api/units/96166353/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:37:20.767158Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/es/?format=api", "source": [ "Yes" ], "previous_source": "", "target": [ "Sí" ], "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/95832529/?format=api", "priority": 100, "id": 96166356, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/es/?checksum=c484871ad9e28012", "url": "https://translations.documentfoundation.org/api/units/96166356/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:37:20.769438Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/es/?format=api", "source": [ "for dBASE tables: not equal to any given value" ], "previous_source": "", "target": [ "para tablas dBASE: no es igual a ningún valor dado" ], "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/95832559/?format=api", "priority": 100, "id": 96166359, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/es/?checksum=6b6141823bb17437", "url": "https://translations.documentfoundation.org/api/units/96166359/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:37:20.771112Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/es/?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 devuelve todos los registros donde el campo Sí/No tiene el estado «Sí» o «Activado» (seleccionado en negro)," ], "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/95832593/?format=api", "priority": 100, "id": 96166362, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/es/?checksum=b8dcc2ab05d5d79c", "url": "https://translations.documentfoundation.org/api/units/96166362/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:37:20.772831Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/es/?format=api", "source": [ "No" ], "previous_source": "", "target": [ "No" ], "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/95832632/?format=api", "priority": 100, "id": 96166365, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/es/?checksum=6e6e9c1d01afb80c", "url": "https://translations.documentfoundation.org/api/units/96166365/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:37:20.774549Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/es/?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/95832676/?format=api", "priority": 100, "id": 96166368, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/es/?checksum=70aa55b10400329d", "url": "https://translations.documentfoundation.org/api/units/96166368/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:37:20.776049Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/es/?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 devuelve todos los registros en los que el campo Sí/No tiene el estado «No» o «Desactivado» (ninguna selección)." ], "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/95832721/?format=api", "priority": 100, "id": 96166371, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/es/?checksum=48d74ca9cf82657b", "url": "https://translations.documentfoundation.org/api/units/96166371/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:37:20.777959Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/es/?format=api", "source": [ "Null" ], "previous_source": "", "target": [ "Nulo" ], "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/95832780/?format=api", "priority": 100, "id": 96166377, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/es/?checksum=510c532e099f7565", "url": "https://translations.documentfoundation.org/api/units/96166377/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:37:20.781737Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/es/?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/95832822/?format=api", "priority": 100, "id": 96166380, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/es/?checksum=d1caf16364dcea18", "url": "https://translations.documentfoundation.org/api/units/96166380/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:37:20.784064Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/es/?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 muestra todos los registros de datos en los que el campo Sí/No no contiene ni el criterio Sí ni el criterio No (selección en gris)." ], "id_hash": 6584486709762292464, "content_hash": 6584486709762292464, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3159385\nhelp.text", "note": "dyXYc", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 265, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 21, "source_unit": "https://translations.documentfoundation.org/api/units/95832852/?format=api", "priority": 100, "id": 96166383, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/es/?checksum=db60cbc6c3a97af0", "url": "https://translations.documentfoundation.org/api/units/96166383/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:37:20.785952Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/es/?format=api", "source": [ "The syntax depends on the database system used. You should also note that Yes/No fields can be defined differently (only 2 states instead of 3)." ], "previous_source": "", "target": [ "La sintaxis depende del sistema de base de datos utilizado. También debe tener en cuenta que los campos Sí/No se pueden definir de manera diferente (solo 2 estados en lugar de 3)." ], "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/95832907/?format=api", "priority": 100, "id": 96166386, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/es/?checksum=e45527a32629c77b", "url": "https://translations.documentfoundation.org/api/units/96166386/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:37:20.787727Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/es/?format=api", "source": [ "Parameter queries" ], "previous_source": "", "target": [ "Consultas con parámetros" ], "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/95832932/?format=api", "priority": 100, "id": 96166389, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/es/?checksum=8640cb55143edbe7", "url": "https://translations.documentfoundation.org/api/units/96166389/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:37:20.789565Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/es/?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": [ "Las consultas con parámetros permiten al usuario introducir valores en el momento de la ejecución. Estos valores se usan junto con los demás criterios para seleccionar los registros que se mostrarán. Cada uno de esos valores tiene un nombre de parámetro asociado que se usa para mostrarlo al usuario en el momento de ejecutar la consulta." ], "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/95832959/?format=api", "priority": 100, "id": 96166391, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/es/?checksum=0f087ef2cd3405d3", "url": "https://translations.documentfoundation.org/api/units/96166391/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:37:20.791224Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/es/?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": [ "Los nombres de los parámetros van precedidos de dos puntos, tanto en la vista de diseño como en la vista SQL. Se pueden usar en cualquier sitio donde quiera que aparezca el valor. Si el mismo valor debe aparecer más de una vez, se usa el mismo nombre de parámetro." ], "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/95832984/?format=api", "priority": 100, "id": 96166395, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/es/?checksum=b90e9a747be3f72e", "url": "https://translations.documentfoundation.org/api/units/96166395/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:37:20.793097Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/es/?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": [ "En el caso más simple, en el que el usuario introduce un valor para una relación de igualdad, el nombre del parámetro, precedido por dos puntos, simplemente se introduce en la fila Criterio. En el <link href=\"text/sdatabase/02010100.xhp#sqlmode\">modo SQL</link>, esto debe escribirse como <item type=\"input\">WHERE \"Campo\" = :Nombre_del_parámetro</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/95833004/?format=api", "priority": 100, "id": 96166397, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/es/?checksum=1032d7351f837b9d", "url": "https://translations.documentfoundation.org/api/units/96166397/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:37:20.794900Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/es/?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": [ "Los nombres de los parámetros no pueden contener ninguno de estos caracteres: <item type=\"input\"><espacio>`!\"$%^*()+={}[]@'~#<>?/,</item>. Estos nombres no pueden ser iguales a los nombres de los campos o las palabras reservadas de SQL, pero pueden ser iguales a los alias." ], "id_hash": 2239266726598408603, "content_hash": 2239266726598408603, "location": "02010100.xhp", "context": "02010100.xhp\npar_id191120151905584287\nhelp.text", "note": "DZCXm", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 271, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 31, "source_unit": "https://translations.documentfoundation.org/api/units/95833020/?format=api", "priority": 100, "id": 96166400, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/es/?checksum=9f137939443ff99b", "url": "https://translations.documentfoundation.org/api/units/96166400/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:37:20.797246Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/es/?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": [ "Una construcción útil para seleccionar registros basados en partes del contenido de un campo de texto es agregar una columna oculta con <item type=\"input\">\"COMO '%' || :Parte_del_campo || '%'\"</item> como el criterio. Esto seleccionará registros con una coincidencia exacta. Si se desea una prueba que no distinga entre mayúsculas y minúsculas, una solución es usar <item type=\"input\">LOWER (Nombre_Campo)</item> como campo y <item type=\"input\">COMO LOWER ( '%' || :Parte_del_campo || '%' )</item> como criterio. Tenga en cuenta que los espacios en el criterio son importantes; si se omiten, el analizador de SQL interpreta el criterio completo como una cadena que debe coincidir. En <link href=\"text/sdatabase/02010100.xhp#sqlmode\">modo SQL</link> esto debe escribirse como <item type=\"input\">LOWER ( \"Nombre_Campo\" ) COMO LOWER ( '%' || :Parte_del_campo || '%' )</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/95833042/?format=api", "priority": 100, "id": 96166404, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/es/?checksum=e622d0dc17a172b7", "url": "https://translations.documentfoundation.org/api/units/96166404/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:37:20.799522Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/es/?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": [ "Las consultas con parámetros se pueden utilizar como origen para los datos de los <link href=\"text/shared/02/01170203.xhp\">subformularios</link>, para permitir que el usuario restrinja los registros mostrados." ], "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/95833068/?format=api", "priority": 100, "id": 96166407, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/es/?checksum=9d40da7e1de2d565", "url": "https://translations.documentfoundation.org/api/units/96166407/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:37:20.802383Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/es/?format=api", "source": [ "Parameter Input" ], "previous_source": "", "target": [ "Entrada de parámetros" ], "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/95833093/?format=api", "priority": 100, "id": 96166411, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/es/?checksum=a2158a9cf1f1c2ad", "url": "https://translations.documentfoundation.org/api/units/96166411/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:37:20.804141Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/es/?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\">El cuadro de diálogo <emph>Entrada de parámetros</emph> solicita al usuario que ingrese los valores de los parámetros. Introduzca un valor para cada parámetro de consulta y confirme pulsando en <emph>Aceptar</emph> u oprimiendo <emph>Intro</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/95833119/?format=api", "priority": 100, "id": 96166414, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/es/?checksum=83ab6db864947e5d", "url": "https://translations.documentfoundation.org/api/units/96166414/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:37:20.805354Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/es/?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": [ "Los valores proporcionados por el usuario pueden estar compuestos de cualesquier caracteres admisibles en SQL para el criterio relevante; esto puede depender del sistema de bases de datos subyacente." ], "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/95833207/?format=api", "priority": 100, "id": 96166417, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/es/?checksum=1651c3b512638dff", "url": "https://translations.documentfoundation.org/api/units/96166417/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:37:20.806958Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/es/?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": [ "Es posible utilizar los caracteres comodín «%» (cadena arbitraria) y «_» (carácter único arbitrario) de SQL como parte del valor para recuperar registros con criterios más complejos." ], "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/95833263/?format=api", "priority": 100, "id": 96166419, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/es/?checksum=e776a92d0c8d3d59", "url": "https://translations.documentfoundation.org/api/units/96166419/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:37:20.808412Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/es/?format=api", "source": [ "SQL Mode" ], "previous_source": "", "target": [ "Modo 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/95833316/?format=api", "priority": 100, "id": 96166421, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/es/?checksum=ee5bc2a2964152df", "url": "https://translations.documentfoundation.org/api/units/96166421/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:37:20.810871Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/es/?format=api", "source": [ "SQL stands for \"Structured Query Language\" and describes instructions for updating and administering relational databases." ], "previous_source": "", "target": [ "SQL es la sigla inglesa de «Structured Query Language» (‘lenguaje de consultas estructuradas’) y describe las instrucciones que se efectuarán para actualizar y gestionar bases de datos relacionales." ], "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/95833357/?format=api", "priority": 100, "id": 96166423, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/es/?checksum=a4b6dcf329a9f0dd", "url": "https://translations.documentfoundation.org/api/units/96166423/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:37:20.812291Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/es/?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": [ "Con $[officename] no necesita ningún conocimiento de SQL para la mayoría de las consultas, ya que no tiene que ingresar el código SQL. Si crea una consulta en el modo de diseño de consultas, $[officename] convierte automáticamente sus instrucciones a la sintaxis SQL correspondiente. Si, con la ayuda del botón <emph>Activar/desactivar la vista Diseño</emph>, cambia a la vista SQL, puede ver las instrucciones en código SQL para una consulta que ya se ha creado." ], "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/95833430/?format=api", "priority": 100, "id": 96166424, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/es/?checksum=ee354695204d6021", "url": "https://translations.documentfoundation.org/api/units/96166424/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:37:20.814100Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/es/?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": [ "Puede formular su consulta directamente en código SQL. Tenga en cuenta, sin embargo, que la sintaxis exacta depende del sistema de base de datos que utilice." ], "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/95833473/?format=api", "priority": 100, "id": 96166427, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/es/?checksum=902fca834ddac001", "url": "https://translations.documentfoundation.org/api/units/96166427/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:37:20.816465Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/es/?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": [ "Si introduce código SQL manualmente, puede crear consultas específicas de SQL que no serían posible mediante la interfaz gráfica en <emph>modo de diseño</emph>. Estas consultas deben ejecutarse en el modo nativo 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/95833505/?format=api", "priority": 100, "id": 96166428, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/es/?checksum=ce4cf17f8192519d", "url": "https://translations.documentfoundation.org/api/units/96166428/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:37:20.818291Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/es/?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": [ "Al pulsar el icono <link href=\"text/shared/02/14030000.xhp\"><emph>Ejecutar orden SQL directamente</emph></link> en el modo SQL, puede formular una consulta que no será procesada por $[officename], sino que se enviará directamente al motor de la base de datos." ], "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/95833552/?format=api", "priority": 100, "id": 96166430, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/es/?checksum=71eeb3af9d062d58", "url": "https://translations.documentfoundation.org/api/units/96166430/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:37:20.820200Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/es/?format=api", "source": [ "Join Properties" ], "previous_source": "", "target": [ "Propiedades de unión" ], "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/95833604/?format=api", "priority": 100, "id": 96166432, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/es/?checksum=2350847d295db268", "url": "https://translations.documentfoundation.org/api/units/96166432/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:37:20.822394Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/es/?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>enlaces;bases de datos relacionales (Base)</bookmark_value> <bookmark_value>uniones internas (Base)</bookmark_value> <bookmark_value>uniones en bases de datos (Base)</bookmark_value> <bookmark_value>uniones izquierdas (Base)</bookmark_value> <bookmark_value>uniones derechas (Base)</bookmark_value> <bookmark_value>uniones completas (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/95833631/?format=api", "priority": 100, "id": 96166434, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/es/?checksum=9210035be5d33172", "url": "https://translations.documentfoundation.org/api/units/96166434/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:37:20.823918Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/es/?format=api", "source": [ "Join Properties" ], "previous_source": "", "target": [ "Propiedades de unión" ], "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/95833656/?format=api", "priority": 100, "id": 96166436, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/es/?checksum=a554c9728484b7f6", "url": "https://translations.documentfoundation.org/api/units/96166436/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:37:20.826069Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/es/?format=api", "source": [ "If you double-click a connection between two linked fields in the query design, or if you choose <emph>Insert - New Relation</emph>, the <emph>Join Properties</emph> dialog appears. These properties will be used in all queries created in the future." ], "previous_source": "", "target": [ "Si pulsa dos veces en una conexión entre dos campos enlazados en el diseño de consulta o si selecciona <emph>Insertar ▸ Relación nueva</emph>, aparece el diálogo <emph>Propiedades de unión</emph>. Estas propiedades se utilizarán en todas las consultas que se creen en el futuro." ], "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/95833679/?format=api", "priority": 100, "id": 96166438, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/es/?checksum=09840769a28d869e", "url": "https://translations.documentfoundation.org/api/units/96166438/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:37:20.827706Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/es/?format=api", "source": [ "Tables involved" ], "previous_source": "", "target": [ "Tablas involucradas" ], "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/95833715/?format=api", "priority": 100, "id": 96166440, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/es/?checksum=7f7ea52a5c88cf04", "url": "https://translations.documentfoundation.org/api/units/96166440/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:37:20.829815Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/es/?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\">Especifica dos tablas diferentes que desea unir.</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/95833786/?format=api", "priority": 100, "id": 96166441, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/es/?checksum=9282d570bc64b349", "url": "https://translations.documentfoundation.org/api/units/96166441/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:37:20.835317Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/es/?format=api", "source": [ "Fields involved" ], "previous_source": "", "target": [ "Campos involucrados" ], "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/95833829/?format=api", "priority": 100, "id": 96166448, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/es/?checksum=67292492f3b3b9fc", "url": "https://translations.documentfoundation.org/api/units/96166448/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:37:20.843930Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/es/?format=api", "source": [ "<ahelp hid=\".\">Specifies two data fields that will be joined by a relation.</ahelp>" ], "previous_source": "", "target": [ "<ahelp hid=\".\">Especifica dos campos de datos que se unirán mediante una relación.</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/95833875/?format=api", "priority": 100, "id": 96166452, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/es/?checksum=e91cb6379d432b86", "url": "https://translations.documentfoundation.org/api/units/96166452/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:37:20.848461Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/es/?format=api", "source": [ "Options" ], "previous_source": "", "target": [ "Opciones" ], "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/95833910/?format=api", "priority": 100, "id": 96166455, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/es/?checksum=5a3e2e02baefc234", "url": "https://translations.documentfoundation.org/api/units/96166455/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:37:20.850938Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/es/?format=api", "source": [ "Type" ], "previous_source": "", "target": [ "Tipo" ], "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/95833944/?format=api", "priority": 100, "id": 96166458, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/es/?checksum=47be67a46ecbb481", "url": "https://translations.documentfoundation.org/api/units/96166458/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:37:20.854013Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/es/?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\">Especifica el tipo de la unión seleccionada.</ahelp> Ciertas bases de datos solamente admiten algunos de los distintos tipos posibles." ], "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/95833971/?format=api", "priority": 100, "id": 96166460, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/es/?checksum=1b13268f00c1be09", "url": "https://translations.documentfoundation.org/api/units/96166460/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:37:20.855931Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/es/?format=api", "source": [ "Inner Join" ], "previous_source": "", "target": [ "Unión interna" ], "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/95834014/?format=api", "priority": 100, "id": 96166463, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/es/?checksum=16b89a1be24de5be", "url": "https://translations.documentfoundation.org/api/units/96166463/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:37:20.858156Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/es/?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\">En una unión interior, la tabla de resultados contiene solo aquellos registros para los cuales el contenido de los campos vinculados es el mismo.</ahelp> Con el SQL del motor predeterminado de bases de datos de $[officename], este tipo de unión se crea con una cláusula 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/95834031/?format=api", "priority": 100, "id": 96166464, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/es/?checksum=2b26fe76b5bff5ae", "url": "https://translations.documentfoundation.org/api/units/96166464/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:37:20.859840Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/es/?format=api", "source": [ "Left Join" ], "previous_source": "", "target": [ "Left Join" ], "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": true, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/95834052/?format=api", "priority": 100, "id": 96166467, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/es/?checksum=01109622fd5b66ac", "url": "https://translations.documentfoundation.org/api/units/96166467/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:37:20.862540Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/es/?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\">En una operación LEFT JOIN, la tabla de resultados contiene todos los registros de los campos consultados de la tabla izquierda y solo aquellos registros de los campos consultados de la tabla derecha para los cuales los contenidos de los campos vinculados son los mismos.</ahelp> En el SQL del motor predeterminado de bases de datos de $[officename], este tipo de vínculo corresponde a la cláusula 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/95834075/?format=api", "priority": 100, "id": 96166469, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/es/?checksum=9659c117d22bba44", "url": "https://translations.documentfoundation.org/api/units/96166469/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:37:20.865064Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/es/?format=api", "source": [ "Right Join" ], "previous_source": "", "target": [ "Right Join" ], "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/95834092/?format=api", "priority": 100, "id": 96166470, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/es/?checksum=d40b62cb58fa23e8", "url": "https://translations.documentfoundation.org/api/units/96166470/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:37:20.916769Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/es/?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\">En una operación RIGHT JOIN, la tabla de resultados contiene todos los registros de los campos consultados de la tabla derecha y solo aquellos registros de los campos consultados de la tabla izquierda cuyo contenidos de los campos vinculados son los mismos.</ahelp> En el SQL del motor predeterminado de bases de datos de $[officename], este tipo de vínculo corresponde a la cláusula 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/95834104/?format=api", "priority": 100, "id": 96166472, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/es/?checksum=9e93cb394e210d52", "url": "https://translations.documentfoundation.org/api/units/96166472/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:37:20.918846Z" } ] }