Changes
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/changes/?format=api&page=31
{ "count": 1810, "next": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/es/changes/?format=api&page=32", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/es/changes/?format=api&page=30", "results": [ { "unit": "https://translations.documentfoundation.org/api/units/96166489/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:37:33.259182Z", "action": 59, "target": "<link href=\"text/shared/02/01170000.xhp\">Controles de formulario</link>", "id": 33545789, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33545789/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96166488/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:37:33.259155Z", "action": 59, "target": "<link href=\"text/shared/autopi/01090000.xhp\">Asistente para formularios</link>", "id": 33545788, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33545788/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96166486/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:37:33.259130Z", "action": 59, "target": "Es posible utilizar formularios para introducir o editar contenidos en bases de datos existentes de manera fácil.", "id": 33545787, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33545787/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96166484/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:37:33.259105Z", "action": 59, "target": "<bookmark_value>formularios; información general (Base)</bookmark_value>", "id": 33545786, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33545786/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96166483/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:37:33.259079Z", "action": 59, "target": "<link href=\"text/sdatabase/04000000.xhp\">Formularios</link>", "id": 33545785, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33545785/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96166481/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:37:33.259053Z", "action": 59, "target": "Formularios", "id": 33545784, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33545784/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96166479/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:37:33.259027Z", "action": 59, "target": "<ahelp hid=\".\">En una operación NATURAL JOIN, la palabra clave <literal>NATURAL</literal> se inserta en la instrucción SQL que define la relación. La relación une todas las columnas que tienen el mismo nombre de columna en ambas tablas. La tabla unida resultante contiene solo una columna para cada par de columnas con el mismo nombre.</ahelp>", "id": 33545783, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33545783/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96166477/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:37:33.259002Z", "action": 59, "target": "Natural", "id": 33545782, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33545782/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96166475/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:37:33.258976Z", "action": 59, "target": "<ahelp hid=\"dbaccess/ui/joindialog/type\">En una operación FULL JOIN, la tabla de resultados contiene todos los registros de los campos consultados de las tablas izquierda y derecha.</ahelp> En el SQL del motor predeterminado de bases de datos de $[officename], este tipo de enlace corresponde a la cláusula FULL OUTER JOIN.", "id": 33545781, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33545781/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96166474/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:37:33.258950Z", "action": 59, "target": "Full Join", "id": 33545780, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33545780/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96166472/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:37:33.258923Z", "action": 59, "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": 33545779, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33545779/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96166470/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:37:33.258898Z", "action": 59, "target": "Right Join", "id": 33545778, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33545778/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96166469/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:37:33.258872Z", "action": 59, "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": 33545777, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33545777/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96166467/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:37:33.258846Z", "action": 59, "target": "Left Join", "id": 33545776, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33545776/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96166464/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:37:33.258820Z", "action": 59, "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": 33545775, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33545775/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96166463/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:37:33.258794Z", "action": 59, "target": "Unión interna", "id": 33545774, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33545774/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96166460/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:37:33.258768Z", "action": 59, "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": 33545773, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33545773/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96166458/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:37:33.258741Z", "action": 59, "target": "Tipo", "id": 33545772, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33545772/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96166455/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:37:33.258715Z", "action": 59, "target": "Opciones", "id": 33545771, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33545771/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96166452/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:37:33.258689Z", "action": 59, "target": "<ahelp hid=\".\">Especifica dos campos de datos que se unirán mediante una relación.</ahelp>", "id": 33545770, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33545770/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96166448/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:37:33.258663Z", "action": 59, "target": "Campos involucrados", "id": 33545769, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33545769/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96166441/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:37:33.258636Z", "action": 59, "target": "<ahelp hid=\"dbaccess/ui/joindialog/table2\">Especifica dos tablas diferentes que desea unir.</ahelp>", "id": 33545768, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33545768/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96166440/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:37:33.258610Z", "action": 59, "target": "Tablas involucradas", "id": 33545767, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33545767/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96166438/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:37:33.258584Z", "action": 59, "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": 33545766, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33545766/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96166436/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:37:33.258559Z", "action": 59, "target": "Propiedades de unión", "id": 33545765, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33545765/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96166434/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:37:33.258532Z", "action": 59, "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": 33545764, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33545764/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96166432/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:37:33.258507Z", "action": 59, "target": "Propiedades de unión", "id": 33545763, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33545763/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96166430/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:37:33.258480Z", "action": 59, "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": 33545762, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33545762/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96166428/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:37:33.258454Z", "action": 59, "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": 33545761, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33545761/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96166427/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:37:33.258429Z", "action": 59, "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": 33545760, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33545760/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96166424/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:37:33.258402Z", "action": 59, "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": 33545759, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33545759/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96166423/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:37:33.258376Z", "action": 59, "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": 33545757, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33545757/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96166421/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:37:33.258350Z", "action": 59, "target": "Modo SQL", "id": 33545756, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33545756/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96166419/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:37:33.258323Z", "action": 59, "target": "El usuario puede utilizar los caracteres comodín de SQL \"%\" (cadena arbitraria) o \"_\" (carácter único arbitrario) como parte del valor que se usa para recuperar registros con criterios más complejos.", "id": 33545755, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33545755/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96166417/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:37:33.258296Z", "action": 59, "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": 33545754, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33545754/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96166414/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:37:33.258270Z", "action": 59, "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": 33545753, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33545753/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96166411/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:37:33.258245Z", "action": 59, "target": "Entrada de parámetros", "id": 33545752, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33545752/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96166407/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:37:33.258218Z", "action": 59, "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": 33545751, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33545751/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96166404/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:37:33.258191Z", "action": 59, "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": 33545750, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33545750/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96166400/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:37:33.258164Z", "action": 59, "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": 33545749, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33545749/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96166397/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:37:33.258138Z", "action": 59, "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": 33545748, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33545748/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96166395/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:37:33.258111Z", "action": 59, "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": 33545747, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33545747/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96166391/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:37:33.258085Z", "action": 59, "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": 33545746, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33545746/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96166389/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:37:33.258059Z", "action": 59, "target": "Consultas con parámetros", "id": 33545745, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33545745/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96166386/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:37:33.258033Z", "action": 59, "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": 33545744, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33545744/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96166383/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:37:33.258007Z", "action": 59, "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": 33545743, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33545743/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96166380/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:37:33.257981Z", "action": 59, "target": "IS NULL", "id": 33545742, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33545742/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96166377/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:37:33.257956Z", "action": 59, "target": "Nulo", "id": 33545741, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33545741/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96166371/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:37:33.257930Z", "action": 59, "target": "=0 devuelve todos los registros en los que el campo Sí/No tiene el estado «No» o «Desactivado» (ninguna selección).", "id": 33545740, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33545740/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96166368/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/es/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:37:33.257904Z", "action": 59, "target": ".", "id": 33545739, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33545739/?format=api" } ] }