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/ca/changes/?format=api&page=42
{ "count": 2221, "next": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/ca/changes/?format=api&page=43", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/ca/changes/?format=api&page=41", "results": [ { "unit": "https://translations.documentfoundation.org/api/units/95995432/?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/ca/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:34:54.569704Z", "action": 59, "target": "Per exemple, si el nom «Joan» apareix diverses vegades a la base de dades d'adreces, podeu triar l'ordre <emph> Valors distints </emph> per a especificar a la consulta que el nom «Joan» només apareixi una vegada.", "id": 33374807, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33374807/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/95995429/?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/ca/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:34:54.569653Z", "action": 59, "target": "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\"> Recupera només els valors diferents de la consulta. </ahelp> S'aplica als múltiples registres que poden contenir diverses repeticions de les dades pels camps seleccionats. Si està activa l'ordre <emph> Valors diferents </emph>, només s'hauria de veure un registre a la consulta (DISTINCT). En cas contrari, veureu tots els registres corresponents als criteris de consulta (ALL).", "id": 33374806, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33374806/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/95995428/?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/ca/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:34:54.569604Z", "action": 59, "target": "Valors diferents", "id": 33374805, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33374805/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/95995426/?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/ca/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:34:54.569556Z", "action": 59, "target": "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\">Mostra o amaga la fila segons l'àlies del nom.</ahelp>", "id": 33374804, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33374804/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/95995413/?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/ca/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:34:54.569507Z", "action": 59, "target": "Àlies del nom", "id": 33374803, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33374803/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/95995410/?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/ca/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:34:54.569457Z", "action": 59, "target": "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\">Mostra o amaga la fila segons el nom de la taula.</ahelp>", "id": 33374802, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33374802/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/95995407/?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/ca/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:34:54.569409Z", "action": 59, "target": "Nom de la taula", "id": 33374801, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33374801/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/95995404/?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/ca/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:34:54.569361Z", "action": 59, "target": "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\">Mostra o amaga una fila segons la selecció de funcions.</ahelp>", "id": 33374800, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33374800/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/95995401/?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/ca/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:34:54.569315Z", "action": 59, "target": "Funcions", "id": 33374799, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33374799/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/95995398/?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/ca/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:34:54.569268Z", "action": 59, "target": "Al menú contextual hi ha disponibles les següents ordres i símbols:", "id": 33374798, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33374798/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/95995395/?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/ca/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:34:54.569220Z", "action": 59, "target": "Executeu la consulta.", "id": 33374797, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33374797/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/95995392/?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/ca/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:34:54.569171Z", "action": 59, "target": "Seleccioneu Grup per al camp «Num_proveïdor».", "id": 33374796, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33374796/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/95995389/?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/ca/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:34:54.569125Z", "action": 59, "target": "També podeu introduir «Mitjana» a la línia en l'àlies del nom (sense cometes).", "id": 33374795, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33374795/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/95995385/?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/ca/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:34:54.569075Z", "action": 59, "target": "Activeu la fila <emph>Funció</emph> i seleccioneu la funció Mitjana del camp «Preu».", "id": 33374794, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33374794/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/95995382/?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/ca/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:34:54.569026Z", "action": 59, "target": "Feu doble clic als camps «Preu» i «Num_proveïdor».", "id": 33374793, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33374793/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/95995380/?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/ca/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:34:54.568977Z", "action": 59, "target": "Inseriu la taula «Article» al disseny de la consulta.", "id": 33374792, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33374792/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/95995376/?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/ca/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:34:54.568928Z", "action": 59, "target": "Si «preu» (preu individual d'un article) i «Num_proveïdor» (proveïdor de l'article) existeixen a la taula «Article», podreu obtenir el preu mitjà de l'article que proporciona un proveïdor amb la següent consulta:", "id": 33374791, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33374791/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/95995374/?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/ca/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:34:54.568879Z", "action": 59, "target": "Executeu la consulta.", "id": 33374790, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33374790/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/95995368/?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/ca/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:34:54.568832Z", "action": 59, "target": "Feu doble clic al camp «Nom_proveidor» a la taula «Proveïdors» i seleccioneu la funció Grup.", "id": 33374789, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33374789/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/95995367/?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/ca/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:34:54.568786Z", "action": 59, "target": "Introduïu >3 com a criteri i desactiveu el camp Visible.", "id": 33374788, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33374788/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/95995364/?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/ca/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:34:54.568735Z", "action": 59, "target": "Feu doble clic al camp «Num_article» de la taula «Article». Mostreu la fila <emph>Funció</emph> mitjançant el menú contextual i seleccioneu la funció Comptatge.", "id": 33374787, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33374787/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/95995361/?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/ca/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:34:54.568686Z", "action": 59, "target": "Enllaceu els camps «Num_proveïdor» de les dues taules si encara no hi ha cap relació d'aquest tipus.", "id": 33374786, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33374786/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/95995358/?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/ca/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:34:54.568635Z", "action": 59, "target": "Inseriu les taules «Article» i «Proveïdors» al disseny de la consulta.", "id": 33374785, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33374785/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/95995355/?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/ca/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:34:54.568587Z", "action": 59, "target": "Els passos següents són necessaris per a crear una consulta que contingui tots els proveïdors que lliuren més de tres articles.", "id": 33374784, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33374784/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/95995353/?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/ca/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:34:54.568538Z", "action": 59, "target": "A l'exemple següent, s'executa una consulta a través de dues taules: una taula «Article» amb el camp «Num_article» i una taula «Proveïdors» amb el camp «Nom_proveïdor». A més, les dues taules tenen un camp comú, «Num_proveïdor».", "id": 33374783, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33374783/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/95995348/?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/ca/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:34:54.568493Z", "action": 59, "target": "<emph>Exemples</emph>", "id": 33374782, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33374782/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/95995345/?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/ca/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:34:54.568449Z", "action": 59, "target": "Si executeu aquesta funció, a la consulta no podreu inserir cap columna addicional que no sigui un argument de la funció «Agrupa».", "id": 33374781, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33374781/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/95995341/?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/ca/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:34:54.568406Z", "action": 59, "target": "SELECT COUNT(*) AS comptatge FROM \"article\"", "id": 33374780, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33374780/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/95995337/?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/ca/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:34:54.568364Z", "action": 59, "target": "Exemple:", "id": 33374779, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33374779/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/95995336/?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/ca/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:34:54.568321Z", "action": 59, "target": "SELECT FUNCTION() AS àlies FROM taula", "id": 33374778, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33374778/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/95995332/?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/ca/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:34:54.568270Z", "action": 59, "target": "La funció corresponent a la declaració SQL és:", "id": 33374777, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33374777/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/95995330/?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/ca/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:34:54.568226Z", "action": 59, "target": "També és possible assignar àlies a les crides de les funcions. Si no voleu que es mostri la cadena de la consulta a la capçalera de la columna, introduïu un nom substitut a <emph>Àlies</emph>.", "id": 33374776, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33374776/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/95995326/?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/ca/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:34:54.568182Z", "action": 59, "target": "Per a utilitzar aquestes funcions no enumerades, les heu d'introduir manualment a <emph>Camp</emph>.", "id": 33374775, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33374775/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/95995323/?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/ca/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:34:54.568138Z", "action": 59, "target": "Excepte per la funció <emph>Group</emph>, les anteriors funcions s’anomenen funcions agregades. Són funcions que calculen les dades per crear resums a partir dels resultats. És possible que hi hagi funcions addicionals que no apareixen al quadre de llista. Aquestes depenen del motor de base de dades específic que s’utilitzi i, de la funcionalitat proporcionada pel controlador utilitzat per connectar-se a aquest motor.", "id": 33374774, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33374774/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/95995317/?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/ca/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:34:54.568108Z", "action": 59, "target": "SELECT SUM(\"Preu\") FROM \"Article\".", "id": 33374773, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33374773/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/95995311/?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/ca/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:34:54.568080Z", "action": 59, "target": "Per exemple, la crida en SQL a la funció que calcula la suma és:", "id": 33374772, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33374772/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/95995308/?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/ca/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:34:54.568053Z", "action": 59, "target": "SELECT FUNCTION(columna) FROM taula.", "id": 33374771, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33374771/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/95995305/?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/ca/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:34:54.568026Z", "action": 59, "target": "També es poden introduir crides a funcions directament a la sentència SQL.", "id": 33374770, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33374770/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/95995303/?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/ca/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:34:54.567998Z", "action": 59, "target": "Agrupa les dades d'acord amb el nom del camp seleccionat. Les funcions s’executen segons els grups especificats. A SQL, aquesta opció correspon a la clàusula GROUP BY. Si s’afegeix un criteri, aquesta entrada apareix a la subclàusula SQL HAVING.", "id": 33374769, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33374769/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/95995301/?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/ca/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:34:54.567970Z", "action": 59, "target": "Agrupa", "id": 33374768, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33374768/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/95995300/?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/ca/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:34:54.567939Z", "action": 59, "target": "Calcula la suma dels valors dels registres per als camps associats.", "id": 33374767, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33374767/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/95995298/?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/ca/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:34:54.567895Z", "action": 59, "target": "Suma", "id": 33374766, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33374766/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/95995297/?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/ca/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:34:54.567845Z", "action": 59, "target": "Determina el registre amb el valor menor per a aquest camp.", "id": 33374765, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33374765/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/95995295/?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/ca/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:34:54.567796Z", "action": 59, "target": "Mínim", "id": 33374764, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33374764/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/95995293/?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/ca/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:34:54.567741Z", "action": 59, "target": "Determina el registre amb el valor més gran per a aquest camp.", "id": 33374763, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33374763/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/95995290/?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/ca/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:34:54.567691Z", "action": 59, "target": "Màxim", "id": 33374762, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33374762/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/95995288/?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/ca/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:34:54.567640Z", "action": 59, "target": "b) COUNT(columna): passar el nom d'un camp com a argument només compta els registres en què el camp especificat conté un valor. Els registres en què el camp té un valor nul (és a dir, no conté cap valor textual o numèric) no es comptabilitzaran.", "id": 33374761, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33374761/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/95995287/?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/ca/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:34:54.567591Z", "action": 59, "target": "a) COUNT(*): en passar un asterisc com a argument, es comptabilitzen tots els registres de la taula.", "id": 33374760, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33374760/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/95995285/?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/ca/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:34:54.567541Z", "action": 59, "target": "Determina el nombre de registres d'una taula. Els camps buits es poden comptar (a) o excloure (b).", "id": 33374759, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33374759/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/95995282/?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/ca/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:34:54.567491Z", "action": 59, "target": "Comptatge", "id": 33374758, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33374758/?format=api" } ] }