Changes
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/libo_help-24-2/textsdatabase/es/changes/?format=api&page=33
{ "count": 1773, "next": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/es/changes/?format=api&page=34", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/es/changes/?format=api&page=32", "results": [ { "unit": "https://translations.documentfoundation.org/api/units/107689968/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/es/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T17:00:56.068208Z", "action": 59, "target": "En SQL, esta orden se corresponde con el predicado DISTINCT.", "id": 45436377, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45436377/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107689957/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/es/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T17:00:56.068172Z", "action": 59, "target": "En el caso de una consulta que incluye varios campos, la combinación de valores de todos los campos debe ser inequívoca, de modo que el resultado pueda obtenerse a partir de un registro específico. Por ejemplo, supongamos que su agenda contiene «Lucía de Madrid» una vez y «Lucía de Barcelona» dos veces. La orden <emph>Valores unívocos</emph> hace que la consulta utilice los campos «apellido» y «ciudad» y devuelva como resultado «Lucía de Madrid» una vez y «Lucía de Barcelona» una vez.", "id": 45436376, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45436376/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107689932/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/es/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T17:00:56.068136Z", "action": 59, "target": "Por ejemplo, si el nombre «Lucía» aparece varias veces en la base de datos de direcciones, elija la opción <emph>Valores unívocos</emph> para especificar en la consulta que el nombre «Lucía» aparezca una sola vez.", "id": 45436375, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45436375/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107689912/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/es/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T17:00:56.068101Z", "action": 59, "target": "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\">Recupera solo valores distintos de la consulta.</ahelp> Esto se aplica a varios registros que pueden contener varias apariciones repetitivas de datos en los campos seleccionados. Si la orden <emph>Valores distintos</emph> está activo, solo debería ver un registro en la consulta (DISTINTO). De lo contrario, verá todos los registros correspondientes a los criterios de consulta (TODOS).", "id": 45436374, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45436374/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107689904/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/es/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T17:00:56.068066Z", "action": 59, "target": "Valores distintos", "id": 45436373, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45436373/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107689892/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/es/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T17:00:56.068030Z", "action": 59, "target": "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\">Muestra u oculta la fila del nombre de alias.</ahelp>", "id": 45436372, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45436372/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107689878/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/es/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T17:00:56.067994Z", "action": 59, "target": "Nombre de alias", "id": 45436371, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45436371/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107689874/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/es/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T17:00:56.067960Z", "action": 59, "target": "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\">Muestra u oculta la fila del nombre de la tabla.</ahelp>", "id": 45436370, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45436370/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107689867/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/es/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T17:00:56.067926Z", "action": 59, "target": "Nombre de tabla", "id": 45436369, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45436369/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107689855/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/es/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T17:00:56.067893Z", "action": 59, "target": "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\">Muestra u oculta una fila según la selección de funciones.</ahelp>", "id": 45436368, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45436368/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107689849/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/es/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T17:00:56.067858Z", "action": 59, "target": "Funciones", "id": 45436367, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45436367/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107689842/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/es/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T17:00:56.067824Z", "action": 59, "target": "Dispone de las órdenes de menú contextual y los símbolos siguientes:", "id": 45436366, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45436366/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107689838/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/es/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T17:00:56.067789Z", "action": 59, "target": "Ejecute la consulta.", "id": 45436365, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45436365/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107689821/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/es/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T17:00:56.067754Z", "action": 59, "target": "Elija grupo para el campo \"Num_proveedor\".", "id": 45436364, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45436364/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107689818/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/es/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T17:00:56.067719Z", "action": 59, "target": "También puede introducir «Promedio» en la fila del nombre de alias (sin las comillas).", "id": 45436363, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45436363/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107689803/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/es/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T17:00:56.067682Z", "action": 59, "target": "Active la fila <emph>Función</emph> y seleccione la función Promedio en el campo «Precio».", "id": 45436362, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45436362/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107689788/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/es/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T17:00:56.067647Z", "action": 59, "target": "Pulse dos veces en los campos «Precio» y «Num_proveedor».", "id": 45436361, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45436361/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107689782/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/es/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T17:00:56.067612Z", "action": 59, "target": "Inserte la tabla «Artículo» en el diseño de la consulta.", "id": 45436360, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45436360/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107689773/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/es/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T17:00:56.067576Z", "action": 59, "target": "Si en la tabla \"Artículo\" existen los campos \"precio\" (para el precio individual de un artículo) y \"Num_proveedor\" (para el proveedor del artículo), puede obtener el precio medio del artículo que proporciona un proveedor con el siguiente consulta:", "id": 45436359, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45436359/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107689756/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/es/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T17:00:56.067540Z", "action": 59, "target": "Ejecute la consulta.", "id": 45436358, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45436358/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107689727/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/es/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T17:00:56.067506Z", "action": 59, "target": "Haga doble pulsación en el campo «Nombre_proveedor» en la tabla «Proveedores» y seleccione la función Agrupar.", "id": 45436357, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45436357/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107689719/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/es/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T17:00:56.067471Z", "action": 59, "target": "Introduzca >3 como criterio y desactive el campo Visible.", "id": 45436356, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45436356/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107689716/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/es/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T17:00:56.067435Z", "action": 59, "target": "Haga doble pulsación en el campo «Num_articulo» de la tabla «Articulo». Muestre la línea <emph>Función</emph> utilizando el menú contextual y seleccione la función Contar.", "id": 45436355, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45436355/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107689712/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/es/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T17:00:56.067401Z", "action": 59, "target": "Enlace los campos «Num_proveedor» de las dos tablas si todavía no existiese una relación de este tipo.", "id": 45436354, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45436354/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107689708/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/es/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T17:00:56.067366Z", "action": 59, "target": "Inserte las tablas «Artículo» y «Proveedores» en el diseño de la consulta.", "id": 45436353, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45436353/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107689700/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/es/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T17:00:56.067333Z", "action": 59, "target": "Los pasos descritos a continuación son necesarios para crear una consulta que contenga todos los proveedores que entregan más de tres artículos.", "id": 45436352, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45436352/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107689690/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/es/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T17:00:56.067299Z", "action": 59, "target": "En el ejemplo siguiente, se ejecuta una consulta a través de dos tablas: una, «Artículos», con el campo «Num_articulo», y la otra, «Proveedores», con el campo «Nombre_proveedor». Ambas tablas cuentan además con un nombre de campo en común, «Num_proveedor».", "id": 45436351, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45436351/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107689685/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/es/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T17:00:56.067266Z", "action": 59, "target": "<emph>Ejemplos</emph>", "id": 45436350, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45436350/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107689676/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/es/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T17:00:56.067233Z", "action": 59, "target": "Si ejecuta esta función, no podrá insertar más columnas para la consulta que no sean argumentos de la función «Agrupar».", "id": 45436349, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45436349/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107689670/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/es/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T17:00:56.067201Z", "action": 59, "target": "SELECT COUNT(*) AS recuento FROM \"Articulo\"", "id": 45436348, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45436348/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107689664/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/es/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T17:00:56.067166Z", "action": 59, "target": "Ejemplo:", "id": 45436347, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45436347/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107689656/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/es/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T17:00:56.067133Z", "action": 59, "target": "SELECT FUNCTION() AS alias FROM tabla", "id": 45436346, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45436346/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107689645/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/es/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T17:00:56.067100Z", "action": 59, "target": "En una instrucción SQL, la llamada a función correspondiente es:", "id": 45436345, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45436345/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107689639/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/es/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T17:00:56.067066Z", "action": 59, "target": "También es posible asignar alias a las llamadas de las funciones. Si no quiere que se muestre la cadena de la consulta en la cabecera de la columna, introduzca un nombre sustituto en <emph>Alias</emph>.", "id": 45436344, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45436344/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107689635/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/es/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T17:00:56.067030Z", "action": 59, "target": "Para utilizar estas funciones no enumeradas, las debe introducir manualmente en <emph>Campo</emph>.", "id": 45436343, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45436343/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107689628/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/es/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T17:00:56.066994Z", "action": 59, "target": "Con la salvedad de la función <emph>Agrupar</emph>, las funciones anteriores se denominan funciones de totalización. Son funciones que calculan datos para crear resúmenes a partir de los resultados. También son posibles funciones adicionales que no se enumeran en el cuadro de lista. Estas dependen del motor de base de datos específico en uso y de la funcionalidad proporcionada por el controlador de Base utilizado para conectarse a ese motor de bases de datos.", "id": 45436342, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45436342/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107689606/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/es/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T17:00:56.066959Z", "action": 59, "target": "SELECT SUM(\"Precio\") FROM \"Articulo\".", "id": 45436341, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45436341/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107689603/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/es/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T17:00:56.066924Z", "action": 59, "target": "En SQL la función para sumar, por ejemplo, se presenta del modo siguiente:", "id": 45436340, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45436340/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107689595/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/es/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T17:00:56.066889Z", "action": 59, "target": "SELECT FUNCTION(columna) FROM tabla.", "id": 45436339, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45436339/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107689588/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/es/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T17:00:56.066854Z", "action": 59, "target": "También se pueden introducir llamadas a funciones directamente en una expresión SQL. La sintaxis es:", "id": 45436338, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45436338/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107689580/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/es/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T17:00:56.066818Z", "action": 59, "target": "Agrupa los datos de la consulta de acuerdo con el nombre del campo seleccionado. Las funciones se ejecutan en función de los grupos seleccionados. En SQL, esta opción se corresponde con la cláusula GROUP BY. Si se añade un criterio, esta entrada aparecerá en la subcláusula HAVING de SQL.", "id": 45436337, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45436337/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107689575/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/es/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T17:00:56.066782Z", "action": 59, "target": "Agrupar", "id": 45436336, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45436336/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107689572/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/es/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T17:00:56.066719Z", "action": 59, "target": "Calcula la suma de los valores de los registros para los campos asociados.", "id": 45436335, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45436335/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107689568/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/es/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T17:00:56.057962Z", "action": 59, "target": "Suma", "id": 45436334, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45436334/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107689564/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/es/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T17:00:56.057924Z", "action": 59, "target": "Determina el valor más bajo de un registro para este campo.", "id": 45436333, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45436333/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107689560/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/es/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T17:00:56.057618Z", "action": 59, "target": "Mínimo", "id": 45436332, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45436332/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107689555/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/es/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T17:00:56.057584Z", "action": 59, "target": "Determina el valor más alto de un registro para este campo.", "id": 45436331, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45436331/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107689551/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/es/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T17:00:56.057550Z", "action": 59, "target": "Máximo", "id": 45436330, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45436330/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107689544/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/es/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T17:00:56.057514Z", "action": 59, "target": "b) COUNT(columna): pasar un nombre de campo como argumento cuenta únicamente los registros en los cuales el campo especificado contiene un valor. Aquellos registros en los que el campo tenga un valor nulo (es decir, que no contiene ningún valor textual ni numérico) no se incluirán en el recuento.", "id": 45436329, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45436329/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107689539/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/es/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T17:00:56.057479Z", "action": 59, "target": "a) COUNT(*): si introduce un asterisco como argumento se cuentan todos los registros de datos de la tabla.", "id": 45436328, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45436328/?format=api" } ] }