Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/libo_help-24-2/textsdatabase/ca/units/?format=api&page=3
https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca/units/?format=api&page=4", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca/units/?format=api&page=2", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca/?format=api", "source": [ "For example:" ], "previous_source": "", "target": [ "Per exemple:" ], "id_hash": 8995234995823052801, "content_hash": 8995234995823052801, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3159335\nhelp.text", "note": "TWexq", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 101, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/107515828/?format=api", "priority": 100, "id": 107618821, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca/?checksum=fcd57e91e5320801", "url": "https://translations.documentfoundation.org/api/units/107618821/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:56.899380Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca/?format=api", "source": [ "Table" ], "previous_source": "", "target": [ "Taula" ], "id_hash": -5757111159800539212, "content_hash": -5757111159800539212, "location": "02010100.xhp", "context": "02010100.xhp\nhd_id3148485\nhelp.text", "note": "roTzi", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 102, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/107515831/?format=api", "priority": 100, "id": 107618822, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca/?checksum=301aa1e713a6d7b4", "url": "https://translations.documentfoundation.org/api/units/107618822/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:56.900732Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca/?format=api", "source": [ "<ahelp hid=\"HID_QRYDGN_ROW_TABLE\">The corresponding database table of the selected data field is listed here.</ahelp> If you activate this cell with a mouse click, an arrow will appear which enables you to select a different table for the current query." ], "previous_source": "", "target": [ "<ahelp hid=\"HID_QRYDGN_ROW_TABLE\">Mostra la taula de la base de dades corresponent al camp de dades seleccionat.</ahelp> Si activeu aquesta cel·la amb un clic del ratolí, apareixerà una fletxa que permet seleccionar una taula diferent per a la consulta actual." ], "id_hash": -8607992337364229760, "content_hash": -8607992337364229760, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3163665\nhelp.text", "note": "GM9Sp", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 103, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 38, "source_unit": "https://translations.documentfoundation.org/api/units/107515833/?format=api", "priority": 100, "id": 107618850, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca/?checksum=088a4493861ee180", "url": "https://translations.documentfoundation.org/api/units/107618850/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:56.978119Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca/?format=api", "source": [ "Sort" ], "previous_source": "", "target": [ "Ordena" ], "id_hash": -2339764603938987521, "content_hash": -2339764603938987521, "location": "02010100.xhp", "context": "02010100.xhp\nhd_id3154207\nhelp.text", "note": "JGcfa", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 104, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/107515836/?format=api", "priority": 100, "id": 107618853, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca/?checksum=5f877c7d442f21ff", "url": "https://translations.documentfoundation.org/api/units/107618853/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:57.000432Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca/?format=api", "source": [ "<ahelp hid=\"HID_QRYDGN_ROW_ORDER\">If you click on this cell, you can choose a sort option: ascending, descending and unsorted.</ahelp> Text fields will be sorted alphabetically and numerical fields numerically. For most databases, administrators can set the sorting options at the database level." ], "previous_source": "", "target": [ "<ahelp hid=\"HID_QRYDGN_ROW_ORDER\">Fent clic a aquesta cel·la, podreu triar una opció d’ordenació: ascendent, descendent i sense classificar.</ahelp> Els camps de text s’ordenaran alfabèticament i els numèrics numèricament. En la major part de les bases de dades els administradors poden definir les opcions d’ordenació." ], "id_hash": -1031038218170177832, "content_hash": -1031038218170177832, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3150979\nhelp.text", "note": "uXuDt", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 105, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 40, "source_unit": "https://translations.documentfoundation.org/api/units/107515838/?format=api", "priority": 100, "id": 107618857, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca/?checksum=71b10434081d66d8", "url": "https://translations.documentfoundation.org/api/units/107618857/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:57.006030Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca/?format=api", "source": [ "Visible" ], "previous_source": "", "target": [ "Visible" ], "id_hash": 6896535723236492576, "content_hash": 6896535723236492576, "location": "02010100.xhp", "context": "02010100.xhp\nhd_id3150384\nhelp.text", "note": "XsqW8", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 106, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/107515842/?format=api", "priority": 100, "id": 107618860, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca/?checksum=dfb56ab36c4d8520", "url": "https://translations.documentfoundation.org/api/units/107618860/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:57.009117Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca/?format=api", "source": [ "<ahelp hid=\"HID_QRYDGN_ROW_VISIBLE\">If you mark the <emph>Visible</emph> property for a data field, that field will be visibly displayed in the resulting query</ahelp>. If you are only using a data field to formulate a condition or make a calculation, you do not necessarily need to display it." ], "previous_source": "", "target": [ "<ahelp hid=\"HID_QRYDGN_ROW_VISIBLE\">Si marqueu la propietat com a <emph>Visible</emph> pel camp de dades, aquest camp es visualitzarà a la consulta resultant</ahelp>. Si només utilitzeu un camp per formular una condició o fer un càlcul, no necessàriament cal que es mostri." ], "id_hash": -5614781346581602478, "content_hash": -5614781346581602478, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3146133\nhelp.text", "note": "AAZfA", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 107, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 45, "source_unit": "https://translations.documentfoundation.org/api/units/107515854/?format=api", "priority": 100, "id": 107618862, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca/?checksum=32144a1d19839f52", "url": "https://translations.documentfoundation.org/api/units/107618862/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:57.010891Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca/?format=api", "source": [ "Criteria" ], "previous_source": "", "target": [ "Criteris" ], "id_hash": 469406007502932698, "content_hash": 469406007502932698, "location": "02010100.xhp", "context": "02010100.xhp\nhd_id3154714\nhelp.text", "note": "eQFRR", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 108, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/107515869/?format=api", "priority": 100, "id": 107618870, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca/?checksum=8683aa46dca58ada", "url": "https://translations.documentfoundation.org/api/units/107618870/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:57.017996Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca/?format=api", "source": [ "<ahelp hid=\"HID_QRYDGN_ROW_CRIT\">Specifies a first criteria by which the content of the data field is to be filtered.</ahelp>" ], "previous_source": "", "target": [ "<ahelp hid=\"HID_QRYDGN_ROW_CRIT\">Especifica un primer criteri amb què s'ha de filtrar el contingut del camp de dades.</ahelp>" ], "id_hash": 4919040097694507359, "content_hash": 4919040097694507359, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3145134\nhelp.text", "note": "fWRgB", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 109, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 17, "source_unit": "https://translations.documentfoundation.org/api/units/107515884/?format=api", "priority": 100, "id": 107618876, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca/?checksum=c443f0e81afbe15f", "url": "https://translations.documentfoundation.org/api/units/107618876/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:57.023238Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca/?format=api", "source": [ "or" ], "previous_source": "", "target": [ "o" ], "id_hash": -2192449250051491563, "content_hash": -2192449250051491563, "location": "02010100.xhp", "context": "02010100.xhp\nhd_id3152477\nhelp.text", "note": "qpADC", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 110, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/107515951/?format=api", "priority": 100, "id": 107618879, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca/?checksum=6192db05ee9bf915", "url": "https://translations.documentfoundation.org/api/units/107618879/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:57.025616Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca/?format=api", "source": [ "Here you can enter one additional filter criterion for each line. Multiple criteria in a single column will be interpreted as boolean OR." ], "previous_source": "", "target": [ "Podeu introduir un criteri de filtre addicional a cada fila. Diversos criteris en una sola columna s’interpretaran com a O booleà." ], "id_hash": -5948053012660454605, "content_hash": -5948053012660454605, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3154585\nhelp.text", "note": "KFVy8", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 111, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 23, "source_unit": "https://translations.documentfoundation.org/api/units/107515974/?format=api", "priority": 100, "id": 107618883, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca/?checksum=2d74454c932e7b33", "url": "https://translations.documentfoundation.org/api/units/107618883/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:57.027626Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca/?format=api", "source": [ "You can also use the context menu of the line headers in the lower area of the query design window to insert a filter based on a function:" ], "previous_source": "", "target": [ "També podeu utilitzar el menú contextual de les capçaleres de fila, a la zona inferior de la finestra de disseny de la consulta, per a inserir un filtre basat en una funció:" ], "id_hash": -4995871244841271865, "content_hash": -4995871244841271865, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3148800\nhelp.text", "note": "eXvp7", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 112, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 28, "source_unit": "https://translations.documentfoundation.org/api/units/107515995/?format=api", "priority": 100, "id": 107618886, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca/?checksum=3aab199273a5bdc7", "url": "https://translations.documentfoundation.org/api/units/107618886/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:57.030923Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca/?format=api", "source": [ "Functions" ], "previous_source": "", "target": [ "Funcions" ], "id_hash": -3778155876137593813, "content_hash": -3778155876137593813, "location": "02010100.xhp", "context": "02010100.xhp\nhd_id3148419\nhelp.text", "note": "5x8LE", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 113, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/107516016/?format=api", "priority": 100, "id": 107618890, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca/?checksum=4b914b3f88c3942b", "url": "https://translations.documentfoundation.org/api/units/107618890/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:57.037093Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca/?format=api", "source": [ "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\" visibility=\"hidden\">Select a function to run in the query.</ahelp> The functions which are available here depend on those provided by the database engine." ], "previous_source": "", "target": [ "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\" visibility=\"hidden\">Seleccioneu una funció per a executar a la consulta.</ahelp> Les funcions disponibles depenen de les proporcionades pel motor de base de dades." ], "id_hash": 1942541461262905934, "content_hash": 1942541461262905934, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3153233\nhelp.text", "note": "Cxhjn", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 114, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 24, "source_unit": "https://translations.documentfoundation.org/api/units/107516037/?format=api", "priority": 100, "id": 107618894, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca/?checksum=9af54b2ac00b324e", "url": "https://translations.documentfoundation.org/api/units/107618894/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:57.042127Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca/?format=api", "source": [ "If you are working with the embedded HSQL database, the list box in the <emph>Function</emph> row offers you the following options:" ], "previous_source": "", "target": [ "Si treballeu amb una base de dades HSQL incrustada, el quadre de llista de la fila <emph>Funció</emph> ofereix les següents opcions:" ], "id_hash": -4919950466613680551, "content_hash": -4919950466613680551, "location": "02010100.xhp", "context": "02010100.xhp\npar_id8760818\nhelp.text", "note": "qFuqw", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 115, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 21, "source_unit": "https://translations.documentfoundation.org/api/units/107516052/?format=api", "priority": 100, "id": 107618897, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca/?checksum=3bb8d31e1cf96659", "url": "https://translations.documentfoundation.org/api/units/107618897/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:57.045227Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca/?format=api", "source": [ "Option" ], "previous_source": "", "target": [ "Opció" ], "id_hash": -772347665347452252, "content_hash": -772347665347452252, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3150307\nhelp.text", "note": "9tdDn", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 116, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/107516083/?format=api", "priority": 100, "id": 107618900, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca/?checksum=754811e3f3dce2a4", "url": "https://translations.documentfoundation.org/api/units/107618900/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:57.047758Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca/?format=api", "source": [ "Effect" ], "previous_source": "", "target": [ "Efecte" ], "id_hash": -7801313243572344229, "content_hash": -7801313243572344229, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3152993\nhelp.text", "note": "kBvXF", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 117, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/107516106/?format=api", "priority": 100, "id": 107618901, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca/?checksum=13bc2af02751ea5b", "url": "https://translations.documentfoundation.org/api/units/107618901/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:57.049755Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca/?format=api", "source": [ "No function" ], "previous_source": "", "target": [ "Cap funció" ], "id_hash": -7324759229702383126, "content_hash": -7324759229702383126, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3155377\nhelp.text", "note": "zCunm", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 118, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/107516121/?format=api", "priority": 100, "id": 107618904, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca/?checksum=1a593a49f05359ea", "url": "https://translations.documentfoundation.org/api/units/107618904/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:57.051800Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca/?format=api", "source": [ "No function will be executed." ], "previous_source": "", "target": [ "No s'executarà cap funció." ], "id_hash": -619848378788163284, "content_hash": -619848378788163284, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3155533\nhelp.text", "note": "kZMTN", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 119, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/107516133/?format=api", "priority": 100, "id": 107618908, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca/?checksum=7765db2effbad12c", "url": "https://translations.documentfoundation.org/api/units/107618908/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:57.054018Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca/?format=api", "source": [ "Average" ], "previous_source": "", "target": [ "Mitjana" ], "id_hash": -3393985297947577142, "content_hash": -3393985297947577142, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3166420\nhelp.text", "note": "6dWZZ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 120, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/107516159/?format=api", "priority": 100, "id": 107618910, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca/?checksum=50e6245a86efb4ca", "url": "https://translations.documentfoundation.org/api/units/107618910/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:57.056226Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca/?format=api", "source": [ "Calculates the arithmetic mean of a field." ], "previous_source": "", "target": [ "Calcula la mitjana aritmètica d'un camp." ], "id_hash": 3066656777709062648, "content_hash": 3066656777709062648, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3154486\nhelp.text", "note": "NfRNs", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 121, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/107516172/?format=api", "priority": 100, "id": 107618911, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca/?checksum=aa8ef4176b6489f8", "url": "https://translations.documentfoundation.org/api/units/107618911/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:57.058670Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca/?format=api", "source": [ "Count" ], "previous_source": "", "target": [ "Comptatge" ], "id_hash": -5772603136064988624, "content_hash": -5772603136064988624, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3149979\nhelp.text", "note": "6z2Kj", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 122, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/107516190/?format=api", "priority": 100, "id": 107618912, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca/?checksum=2fe39808458a5a30", "url": "https://translations.documentfoundation.org/api/units/107618912/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:57.060931Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca/?format=api", "source": [ "Determines the number of records in the table. Empty fields can either be counted (a) or excluded (b)." ], "previous_source": "", "target": [ "Determina el nombre de registres d'una taula. Els camps buits es poden comptar (a) o excloure (b)." ], "id_hash": -6730459759722231728, "content_hash": -6730459759722231728, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3155810\nhelp.text", "note": "rvWA5", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 123, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/107516224/?format=api", "priority": 100, "id": 107618913, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca/?checksum=22989a820eb20850", "url": "https://translations.documentfoundation.org/api/units/107618913/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:57.063146Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca/?format=api", "source": [ "a) COUNT(*): Passing an asterisk as the argument counts all records in the table." ], "previous_source": "", "target": [ "a) COUNT(*): en passar un asterisc com a argument, es comptabilitzen tots els registres de la taula." ], "id_hash": -6577677318719850332, "content_hash": -6577677318719850332, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3151333\nhelp.text", "note": "UyAx2", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 124, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/107516242/?format=api", "priority": 100, "id": 107618914, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca/?checksum=24b76554228f38a4", "url": "https://translations.documentfoundation.org/api/units/107618914/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:57.065513Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca/?format=api", "source": [ "b) COUNT(column): Passing a field name as an argument counts only the records in which the specified field contains a value. Records in which the field has a Null value (i.e. contains no textual or numeric value) will not be counted." ], "previous_source": "", "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_hash": -3702508971976732456, "content_hash": -3702508971976732456, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3152889\nhelp.text", "note": "FNCC8", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 125, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 41, "source_unit": "https://translations.documentfoundation.org/api/units/107516293/?format=api", "priority": 100, "id": 107618915, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca/?checksum=4c9e0bb4eba150d8", "url": "https://translations.documentfoundation.org/api/units/107618915/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:57.067835Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca/?format=api", "source": [ "Maximum" ], "previous_source": "", "target": [ "Màxim" ], "id_hash": -3013235731327700788, "content_hash": -3013235731327700788, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3153067\nhelp.text", "note": "2ubvb", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 126, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/107516309/?format=api", "priority": 100, "id": 107618916, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca/?checksum=562ed61131b2b0cc", "url": "https://translations.documentfoundation.org/api/units/107618916/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:57.071986Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca/?format=api", "source": [ "Determines the highest value of a record for that field." ], "previous_source": "", "target": [ "Determina el registre amb el valor més gran per a aquest camp." ], "id_hash": -1271906049264834213, "content_hash": -1271906049264834213, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3159221\nhelp.text", "note": "ds4ey", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 127, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/107516343/?format=api", "priority": 100, "id": 107618918, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca/?checksum=6e59482fe1e6295b", "url": "https://translations.documentfoundation.org/api/units/107618918/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:57.074189Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca/?format=api", "source": [ "Minimum" ], "previous_source": "", "target": [ "Mínim" ], "id_hash": -3369143774484625893, "content_hash": -3369143774484625893, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3146866\nhelp.text", "note": "EhSWy", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 128, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/107516351/?format=api", "priority": 100, "id": 107618920, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca/?checksum=513e65966ca0061b", "url": "https://translations.documentfoundation.org/api/units/107618920/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:57.076589Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca/?format=api", "source": [ "Determines the lowest value of a record for that field." ], "previous_source": "", "target": [ "Determina el registre amb el valor menor per a aquest camp." ], "id_hash": 7910640238210885664, "content_hash": 7910640238210885664, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3157982\nhelp.text", "note": "VxmeB", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 129, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/107516366/?format=api", "priority": 100, "id": 107618921, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca/?checksum=edc83d626078a820", "url": "https://translations.documentfoundation.org/api/units/107618921/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:57.078540Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca/?format=api", "source": [ "Sum" ], "previous_source": "", "target": [ "Suma" ], "id_hash": -3951253331645022563, "content_hash": -3951253331645022563, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3154828\nhelp.text", "note": "CvkuF", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 130, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/107516372/?format=api", "priority": 100, "id": 107618923, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca/?checksum=492a54078db83e9d", "url": "https://translations.documentfoundation.org/api/units/107618923/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:57.080541Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca/?format=api", "source": [ "Calculates the sum of the values of records for the associated fields." ], "previous_source": "", "target": [ "Calcula la suma dels valors dels registres per als camps associats." ], "id_hash": -1293247112796432643, "content_hash": -1293247112796432643, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3154536\nhelp.text", "note": "82gAC", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 131, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/107516382/?format=api", "priority": 100, "id": 107618924, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca/?checksum=6e0d769a52f816fd", "url": "https://translations.documentfoundation.org/api/units/107618924/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:57.082283Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca/?format=api", "source": [ "Group" ], "previous_source": "", "target": [ "Agrupa" ], "id_hash": 5611092234196237787, "content_hash": 5611092234196237787, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3148820\nhelp.text", "note": "zCzVC", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 132, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/107516389/?format=api", "priority": 100, "id": 107618927, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca/?checksum=cdde9aa87d383ddb", "url": "https://translations.documentfoundation.org/api/units/107618927/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:57.084299Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca/?format=api", "source": [ "Groups query data according to the selected field name. Functions are executed according to the specified groups. In SQL, this option corresponds to the GROUP BY clause. If a criterion is added, this entry appears in the SQL HAVING sub-clause." ], "previous_source": "", "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_hash": -7409234191239514324, "content_hash": -7409234191239514324, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3149438\nhelp.text", "note": "tSPNG", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 133, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 40, "source_unit": "https://translations.documentfoundation.org/api/units/107516410/?format=api", "priority": 100, "id": 107618928, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca/?checksum=192d1cc2457d772c", "url": "https://translations.documentfoundation.org/api/units/107618928/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:57.086309Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca/?format=api", "source": [ "You can also enter function calls directly into the SQL statement. The syntax is:" ], "previous_source": "", "target": [ "També es poden introduir crides a funcions directament a la sentència SQL." ], "id_hash": -3806082811502480015, "content_hash": -3806082811502480015, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3156038\nhelp.text", "note": "qHfpD", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 134, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/107516415/?format=api", "priority": 100, "id": 107618935, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca/?checksum=4b2e13d932acb571", "url": "https://translations.documentfoundation.org/api/units/107618935/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:57.090462Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca/?format=api", "source": [ "SELECT FUNCTION(column) FROM table." ], "previous_source": "", "target": [ "SELECT FUNCTION(columna) FROM taula." ], "id_hash": -1305221081140801602, "content_hash": -1305221081140801602, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3156340\nhelp.text", "note": "Qg6Ue", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 135, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/107516420/?format=api", "priority": 100, "id": 107618938, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca/?checksum=6de2ec5791404fbe", "url": "https://translations.documentfoundation.org/api/units/107618938/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:57.093011Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca/?format=api", "source": [ "For example, the function call in SQL for calculating a sum is:" ], "previous_source": "", "target": [ "Per exemple, la crida en SQL a la funció que calcula la suma és:" ], "id_hash": -7092442938933433496, "content_hash": -7092442938933433496, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3155075\nhelp.text", "note": "qAAoF", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 136, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/107516436/?format=api", "priority": 100, "id": 107618939, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca/?checksum=1d9294b973252b68", "url": "https://translations.documentfoundation.org/api/units/107618939/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:57.094769Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca/?format=api", "source": [ "SELECT SUM(\"Price\") FROM \"Article\"." ], "previous_source": "", "target": [ "SELECT SUM(\"Preu\") FROM \"Article\"." ], "id_hash": 6764390312089837957, "content_hash": 6764390312089837957, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3154591\nhelp.text", "note": "VrHLf", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 137, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/107516457/?format=api", "priority": 100, "id": 107618942, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca/?checksum=dddff1264a356185", "url": "https://translations.documentfoundation.org/api/units/107618942/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:57.096524Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca/?format=api", "source": [ "Except for the <emph>Group</emph> function, the above functions are called Aggregate functions. These are functions that calculate data to create summaries from the results. Additional functions that are not listed in the list box might be also possible. These depend on the specific database engine in use and on the current functionality provided by the Base driver used to connect to that database engine." ], "previous_source": "", "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_hash": -5781971165104475833, "content_hash": -5781971165104475833, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3159205\nhelp.text", "note": "dABCo", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 138, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 64, "source_unit": "https://translations.documentfoundation.org/api/units/107516464/?format=api", "priority": 100, "id": 107618944, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca/?checksum=2fc24fdc0a657147", "url": "https://translations.documentfoundation.org/api/units/107618944/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:57.098332Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca/?format=api", "source": [ "To use other functions not listed in the list box, you must enter them manually under <emph>Field</emph>." ], "previous_source": "", "target": [ "Per a utilitzar aquestes funcions no enumerades, les heu d'introduir manualment a <emph>Camp</emph>." ], "id_hash": -2209269641612400515, "content_hash": -2209269641612400515, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3148651\nhelp.text", "note": "BVC6J", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 139, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 17, "source_unit": "https://translations.documentfoundation.org/api/units/107516486/?format=api", "priority": 100, "id": 107618947, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca/?checksum=615718f756a3687d", "url": "https://translations.documentfoundation.org/api/units/107618947/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:57.100917Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca/?format=api", "source": [ "You can also assign aliases to function calls. If you do not want to display the query string in the column header, enter a desired substitute name under <emph>Alias</emph>." ], "previous_source": "", "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_hash": 4139553630722688505, "content_hash": 4139553630722688505, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3155098\nhelp.text", "note": "WkboS", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 140, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 29, "source_unit": "https://translations.documentfoundation.org/api/units/107516500/?format=api", "priority": 100, "id": 107618949, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca/?checksum=b972a61847e785f9", "url": "https://translations.documentfoundation.org/api/units/107618949/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:57.103252Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca/?format=api", "source": [ "The corresponding function in an SQL statement is:" ], "previous_source": "", "target": [ "La funció corresponent a la declaració SQL és:" ], "id_hash": 9037870816902336553, "content_hash": 9037870816902336553, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3155539\nhelp.text", "note": "98GCC", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 141, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/107516540/?format=api", "priority": 100, "id": 107618951, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca/?checksum=fd6cf79f8f555029", "url": "https://translations.documentfoundation.org/api/units/107618951/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:57.105571Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca/?format=api", "source": [ "SELECT FUNCTION() AS alias FROM table" ], "previous_source": "", "target": [ "SELECT FUNCTION() AS àlies FROM taula" ], "id_hash": 3137508638940812960, "content_hash": 3137508638940812960, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3149425\nhelp.text", "note": "WACG9", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 142, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/107516555/?format=api", "priority": 100, "id": 107618952, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca/?checksum=ab8aab7bdfc956a0", "url": "https://translations.documentfoundation.org/api/units/107618952/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:57.107652Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca/?format=api", "source": [ "Example:" ], "previous_source": "", "target": [ "Exemple:" ], "id_hash": 3538033891106052086, "content_hash": 3538033891106052086, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3144431\nhelp.text", "note": "EjzuD", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 143, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/107516563/?format=api", "priority": 100, "id": 107618955, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca/?checksum=b1199f1422ab57f6", "url": "https://translations.documentfoundation.org/api/units/107618955/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:57.109551Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca/?format=api", "source": [ "SELECT COUNT(*) AS count FROM \"Item\"" ], "previous_source": "", "target": [ "SELECT COUNT(*) AS comptatge FROM \"article\"" ], "id_hash": -5763803079986489729, "content_hash": -5763803079986489729, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3154614\nhelp.text", "note": "G9URE", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 144, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/107516591/?format=api", "priority": 100, "id": 107618957, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca/?checksum=3002dba2fe1a567f", "url": "https://translations.documentfoundation.org/api/units/107618957/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:57.111644Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca/?format=api", "source": [ "If you run such a function, you cannot insert any additional columns for the query other than as an argument in a \"Group\" function." ], "previous_source": "", "target": [ "Si executeu aquesta funció, a la consulta no podreu inserir cap columna addicional que no sigui un argument de la funció «Agrupa»." ], "id_hash": 5156466470725607062, "content_hash": 5156466470725607062, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3154610\nhelp.text", "note": "xiNnR", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 145, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 24, "source_unit": "https://translations.documentfoundation.org/api/units/107516617/?format=api", "priority": 100, "id": 107618959, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca/?checksum=c78f72ef5bcfde96", "url": "https://translations.documentfoundation.org/api/units/107618959/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:57.113467Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca/?format=api", "source": [ "<emph>Examples</emph>" ], "previous_source": "", "target": [ "<emph>Exemples</emph>" ], "id_hash": 8201778419404166585, "content_hash": 8201778419404166585, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3154644\nhelp.text", "note": "EHACK", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 146, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/107516631/?format=api", "priority": 100, "id": 107618962, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca/?checksum=f1d292047f0cd5b9", "url": "https://translations.documentfoundation.org/api/units/107618962/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:57.118642Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca/?format=api", "source": [ "In the following example, a query is run through two tables: an \"Item\" table with the \"Item_No\" field and a \"Suppliers\" table with the \"Supplier_Name\" field. In addition, both tables have a common field name \"Supplier_No.\"" ], "previous_source": "", "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_hash": 5859342271891411772, "content_hash": 5859342271891411772, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3151120\nhelp.text", "note": "N5CBE", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 147, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 36, "source_unit": "https://translations.documentfoundation.org/api/units/107516674/?format=api", "priority": 100, "id": 107618964, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca/?checksum=d15090c08d84933c", "url": "https://translations.documentfoundation.org/api/units/107618964/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:57.121443Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca/?format=api", "source": [ "The following steps are required to create a query containing all suppliers who deliver more than three items." ], "previous_source": "", "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_hash": -4011807035459456714, "content_hash": -4011807035459456714, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3155144\nhelp.text", "note": "P5hJD", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 148, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/107516687/?format=api", "priority": 100, "id": 107618965, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca/?checksum=485332c1b806b136", "url": "https://translations.documentfoundation.org/api/units/107618965/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:57.123784Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca/?format=api", "source": [ "Insert the \"Item\" and \"Suppliers\" tables into the query design." ], "previous_source": "", "target": [ "Inseriu les taules «Article» i «Proveïdors» al disseny de la consulta." ], "id_hash": 1435240278817732818, "content_hash": 1435240278817732818, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3153240\nhelp.text", "note": "ZhRQD", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 149, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/107516695/?format=api", "priority": 100, "id": 107618970, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca/?checksum=93eaff6dea4378d2", "url": "https://translations.documentfoundation.org/api/units/107618970/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:57.128802Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca/?format=api", "source": [ "Link the \"Supplier_No\" fields of the two tables if there is not already a relation of this type." ], "previous_source": "", "target": [ "Enllaceu els camps «Num_proveïdor» de les dues taules si encara no hi ha cap relació d'aquest tipus." ], "id_hash": 2905548939711794635, "content_hash": 2905548939711794635, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3148807\nhelp.text", "note": "LMRUV", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 150, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/107516703/?format=api", "priority": 100, "id": 107618973, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca/?checksum=a852955dcd08cdcb", "url": "https://translations.documentfoundation.org/api/units/107618973/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:57.134295Z" } ] }{ "count": 1739, "next": "