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_VALENCIA/units/?format=api&page=2
{ "count": 1739, "next": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca_VALENCIA/units/?format=api&page=3", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca_VALENCIA/units/?format=api", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca_VALENCIA/?format=api", "source": [ "If you want to test a query, double-click the query name in the database document. The query result is displayed in a table similar to the Data Source View. Note: the table displayed is only temporary." ], "previous_source": "", "target": [ "Si voleu provar el funcionament d'una consulta, feu doble clic al nom d'aquesta consulta en el document de base de dades. El resultat de la consulta es mostrarà en una taula semblant a la Vista de fonts de dades. Nota: la taula que es mostrarà serà temporal." ], "id_hash": 6820986015982142173, "content_hash": 6820986015982142173, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3147559\nhelp.text", "note": "hYsxY", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 51, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 36, "source_unit": "https://translations.documentfoundation.org/api/units/107515114/?format=api", "priority": 100, "id": 107610890, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca_VALENCIA/?checksum=dea902a47485c2dd", "url": "https://translations.documentfoundation.org/api/units/107610890/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:45.939302Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca_VALENCIA/?format=api", "source": [ "Keys in Query Design View" ], "previous_source": "", "target": [ "Tecles per a la vista del disseny de la consulta" ], "id_hash": -7932066688871041264, "content_hash": -7932066688871041264, "location": "02010100.xhp", "context": "02010100.xhp\nhd_id8226264\nhelp.text", "note": "B4HEH", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 52, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/107515124/?format=api", "priority": 100, "id": 107610899, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca_VALENCIA/?checksum=11eba35f5321f710", "url": "https://translations.documentfoundation.org/api/units/107610899/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:45.946073Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca_VALENCIA/?format=api", "source": [ "Key" ], "previous_source": "", "target": [ "Tecla" ], "id_hash": -962556843198878189, "content_hash": -962556843198878189, "location": "02010100.xhp", "context": "02010100.xhp\npar_id2341074\nhelp.text", "note": "Cvd4o", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 53, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/107515139/?format=api", "priority": 100, "id": 107610913, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca_VALENCIA/?checksum=72a44fa6a5026e13", "url": "https://translations.documentfoundation.org/api/units/107610913/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:45.952943Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca_VALENCIA/?format=api", "source": [ "Function" ], "previous_source": "", "target": [ "Funció" ], "id_hash": -7303047899249108812, "content_hash": -7303047899249108812, "location": "02010100.xhp", "context": "02010100.xhp\npar_id4384289\nhelp.text", "note": "mCy9S", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 54, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/107515162/?format=api", "priority": 100, "id": 107610916, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca_VALENCIA/?checksum=1aa65ca0fb9818b4", "url": "https://translations.documentfoundation.org/api/units/107610916/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:45.954687Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca_VALENCIA/?format=api", "source": [ "F4" ], "previous_source": "", "target": [ "F4" ], "id_hash": -7146258811191257841, "content_hash": -7146258811191257841, "location": "02010100.xhp", "context": "02010100.xhp\npar_id5839106\nhelp.text", "note": "yybiC", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 55, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/107515173/?format=api", "priority": 100, "id": 107610921, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca_VALENCIA/?checksum=1cd3637945f0950f", "url": "https://translations.documentfoundation.org/api/units/107610921/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:45.967979Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca_VALENCIA/?format=api", "source": [ "Preview" ], "previous_source": "", "target": [ "Previsualitza" ], "id_hash": -4612140030574225561, "content_hash": -4612140030574225561, "location": "02010100.xhp", "context": "02010100.xhp\npar_id8554338\nhelp.text", "note": "FMTZD", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 56, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/107515181/?format=api", "priority": 100, "id": 107610924, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca_VALENCIA/?checksum=3ffe63140f439767", "url": "https://translations.documentfoundation.org/api/units/107610924/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:45.969968Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca_VALENCIA/?format=api", "source": [ "F5" ], "previous_source": "", "target": [ "F5" ], "id_hash": -8915539007946402489, "content_hash": -8915539007946402489, "location": "02010100.xhp", "context": "02010100.xhp\npar_id1254921\nhelp.text", "note": "YQhGF", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 57, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/107515188/?format=api", "priority": 100, "id": 107610927, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca_VALENCIA/?checksum=0445a48242375547", "url": "https://translations.documentfoundation.org/api/units/107610927/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:45.974603Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca_VALENCIA/?format=api", "source": [ "Run Query" ], "previous_source": "", "target": [ "Executa la consulta" ], "id_hash": 4695158386326058876, "content_hash": 4695158386326058876, "location": "02010100.xhp", "context": "02010100.xhp\npar_id7636646\nhelp.text", "note": "C9yhE", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 58, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/107515200/?format=api", "priority": 100, "id": 107610928, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca_VALENCIA/?checksum=c1288dad2529377c", "url": "https://translations.documentfoundation.org/api/units/107610928/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:45.976443Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca_VALENCIA/?format=api", "source": [ "F7" ], "previous_source": "", "target": [ "F7" ], "id_hash": 1119030469261168773, "content_hash": 1119030469261168773, "location": "02010100.xhp", "context": "02010100.xhp\npar_id8579363\nhelp.text", "note": "jdEeJ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 59, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/107515224/?format=api", "priority": 100, "id": 107610930, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca_VALENCIA/?checksum=8f8798486d269085", "url": "https://translations.documentfoundation.org/api/units/107610930/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:45.978032Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca_VALENCIA/?format=api", "source": [ "Add Table or Query" ], "previous_source": "", "target": [ "Afig la taula o consulta" ], "id_hash": 1690990852192008086, "content_hash": 1690990852192008086, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3227942\nhelp.text", "note": "6Y6Uw", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 60, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/107515236/?format=api", "priority": 100, "id": 107610932, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca_VALENCIA/?checksum=97779b388756f796", "url": "https://translations.documentfoundation.org/api/units/107610932/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:45.979298Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca_VALENCIA/?format=api", "source": [ "Browse" ], "previous_source": "", "target": [ "Navega" ], "id_hash": 1662000235044191429, "content_hash": 1662000235044191429, "location": "02010100.xhp", "context": "02010100.xhp\nhd_id3154939\nhelp.text", "note": "WN7wR", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 61, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/107515249/?format=api", "priority": 100, "id": 107610935, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca_VALENCIA/?checksum=97109c687a6cbcc5", "url": "https://translations.documentfoundation.org/api/units/107610935/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:45.981035Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca_VALENCIA/?format=api", "source": [ "When you open the query design for the first time, you see a dialog in which you must first select the table or query that will be the basis for your new query." ], "previous_source": "", "target": [ "En obrir el disseny de consultes per primera vegada, veureu un diàleg al qual haureu de seleccionar la taula o la consulta que s'utilitzarà per a la consulta nova." ], "id_hash": -1659182560932958370, "content_hash": -1659182560932958370, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3148799\nhelp.text", "note": "5y4VZ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 62, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 33, "source_unit": "https://translations.documentfoundation.org/api/units/107515263/?format=api", "priority": 100, "id": 107610937, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca_VALENCIA/?checksum=68f9664066116f5e", "url": "https://translations.documentfoundation.org/api/units/107610937/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:45.982725Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca_VALENCIA/?format=api", "source": [ "<ahelp hid=\"HID_CTL_QRYDGNTAB\">Double-click fields to add them to the query. Drag-and-drop to define relations.</ahelp>" ], "previous_source": "", "target": [ "<ahelp hid=\"HID_CTL_QRYDGNTAB\">Feu doble clic als camps que vulgueu per a afegir-los a la consulta. Arrossegueu i deixeu anar per a definir relacions.</ahelp>" ], "id_hash": 6649503362082642656, "content_hash": 6649503362082642656, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3144762\nhelp.text", "note": "FBQA9", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 63, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/107515274/?format=api", "priority": 100, "id": 107610941, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca_VALENCIA/?checksum=dc47c813c5b39ae0", "url": "https://translations.documentfoundation.org/api/units/107610941/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:45.986258Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca_VALENCIA/?format=api", "source": [ "While designing a query, you cannot modify the selected tables." ], "previous_source": "", "target": [ "Quan estigueu dissenyant una consulta no podreu modificar les taules seleccionades." ], "id_hash": 4071334562569316202, "content_hash": 4071334562569316202, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3157894\nhelp.text", "note": "eG8FD", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 64, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/107515289/?format=api", "priority": 100, "id": 107610944, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca_VALENCIA/?checksum=b8804936bbb6e76a", "url": "https://translations.documentfoundation.org/api/units/107610944/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:45.988812Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca_VALENCIA/?format=api", "source": [ "Remove tables" ], "previous_source": "", "target": [ "Suprimeix les taules" ], "id_hash": -225014905734625020, "content_hash": -225014905734625020, "location": "02010100.xhp", "context": "02010100.xhp\nhd_id3149562\nhelp.text", "note": "NLywF", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 65, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/107515305/?format=api", "priority": 100, "id": 107610947, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca_VALENCIA/?checksum=7ce09622aa850904", "url": "https://translations.documentfoundation.org/api/units/107610947/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:45.991964Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca_VALENCIA/?format=api", "source": [ "To remove the table from Design View, click the upper border of the table window and display the context menu. You can use the <emph>Delete</emph> command to remove the table from the Design View. Another option is to press the Delete key." ], "previous_source": "", "target": [ "Per a suprimir una taula de la Vista de disseny, feu clic a la vora superior de la finestra de la taula i obriu el menú contextual, on podreu triar l'ordre <emph>Suprimeix</emph>. De manera alternativa, podeu prémer la tecla Supr." ], "id_hash": -3782279187899683547, "content_hash": -3782279187899683547, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3150685\nhelp.text", "note": "TbQzA", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 66, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 42, "source_unit": "https://translations.documentfoundation.org/api/units/107515311/?format=api", "priority": 100, "id": 107610949, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca_VALENCIA/?checksum=4b82a51e33e2ed25", "url": "https://translations.documentfoundation.org/api/units/107610949/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:45.994022Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca_VALENCIA/?format=api", "source": [ "Move table and modify table size" ], "previous_source": "", "target": [ "Mou la taula i modifica'n la mida" ], "id_hash": -2449331295068946516, "content_hash": -2449331295068946516, "location": "02010100.xhp", "context": "02010100.xhp\nhd_id3150012\nhelp.text", "note": "VLTKB", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 67, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/107515333/?format=api", "priority": 100, "id": 107610954, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca_VALENCIA/?checksum=5e023a2a0c2affac", "url": "https://translations.documentfoundation.org/api/units/107610954/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:45.998947Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca_VALENCIA/?format=api", "source": [ "You can resize and arrange the tables according to your preferences. To move tables, drag the upper border to the desired position. Enlarge or reduce the size in which the table is displayed by positioning the mouse cursor on a border or on a corner and dragging the table until it is the desired size." ], "previous_source": "", "target": [ "Podeu redimensionar i organitzar les taules segons les vostres preferències. Per a moure una taula, arrossegueu-ne la vora superior fins a la posició que vulgueu. Podeu augmentar o reduir la mida d'una taula col·locant la busca del ratolí en una vora o una cantonada de la taula i arrossegant-lo fins aconseguir la mida desitjada." ], "id_hash": -555858747624136504, "content_hash": -555858747624136504, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3146922\nhelp.text", "note": "amBsQ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 68, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 55, "source_unit": "https://translations.documentfoundation.org/api/units/107515351/?format=api", "priority": 100, "id": 107610956, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca_VALENCIA/?checksum=7849316a0291e0c8", "url": "https://translations.documentfoundation.org/api/units/107610956/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:46.001132Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca_VALENCIA/?format=api", "source": [ "Table Relations" ], "previous_source": "", "target": [ "Relacions entre taules" ], "id_hash": -6762426897780641643, "content_hash": -6762426897780641643, "location": "02010100.xhp", "context": "02010100.xhp\nhd_id3145365\nhelp.text", "note": "UoCRG", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 69, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/107515361/?format=api", "priority": 100, "id": 107610963, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca_VALENCIA/?checksum=22270890ba3cf095", "url": "https://translations.documentfoundation.org/api/units/107610963/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:46.016058Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca_VALENCIA/?format=api", "source": [ "If there are data relations between a field name in one table and a field name in another table, you can use these relations for your query." ], "previous_source": "", "target": [ "En cas que hi haja dades relacionades entre el nom de camp d'una taula i el nom de camp d'una altra taula, podreu utilitzar aquestes relacions per a la vostra consulta." ], "id_hash": -2844394009656248667, "content_hash": -2844394009656248667, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3154145\nhelp.text", "note": "BFCxB", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 70, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 27, "source_unit": "https://translations.documentfoundation.org/api/units/107515384/?format=api", "priority": 100, "id": 107610965, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca_VALENCIA/?checksum=5886aeb7ed30b6a5", "url": "https://translations.documentfoundation.org/api/units/107610965/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:46.017608Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca_VALENCIA/?format=api", "source": [ "If, for example, you have a spreadsheet for articles identified by an article number, and a spreadsheet for customers in which you record all articles that a customer orders using the corresponding article numbers, then there is a relationship between the two \"article number\" data fields. If you now want to create a query that returns all articles that a customer has ordered, you must retrieve data from two spreadsheets. To do this, you must inform $[officename] about the relationship which exists between the data in the two spreadsheets." ], "previous_source": "", "target": [ "Així, si per exemple disposeu, d'una banda, d'un full de càlcul per a articles identificats amb un número d'article i, de l'altra, d'un altre full de càlcul per a clients en el qual registreu tots els articles que aquests clients sol·liciten mitjançant els números d'article corresponents, hi haurà una relació entre els dos camps de dades «número d'article». D'aquesta manera, si voleu crear una consulta que torne tots els articles sol·licitats per un client, haureu de recuperar les dades corresponents dels dos fulls de dades. Per a fer-ho, haureu d'informar el $[officename] sobre la relació que existeix entre les dades dels dos fulls de càlcul." ], "id_hash": 5696818659985483922, "content_hash": 5696818659985483922, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3152577\nhelp.text", "note": "jcLbE", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 71, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 89, "source_unit": "https://translations.documentfoundation.org/api/units/107515411/?format=api", "priority": 100, "id": 107610971, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca_VALENCIA/?checksum=cf0f2a6362406892", "url": "https://translations.documentfoundation.org/api/units/107610971/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:46.023028Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca_VALENCIA/?format=api", "source": [ "To do this, click a field name in a table (for example, the field name \"Item-Number\" from the Customer table), hold down the mouse button and then drag the field name to the field name of the other table (\"Item-Number\" from the Item table). When you release the mouse button, a line connecting the two fields between the two table windows appears. The corresponding condition that the content of the two field names must be identical is entered in the resulting SQL query." ], "previous_source": "", "target": [ "Per a indicar aquesta relació, feu clic al nom d'un camp d'una taula (per exemple, al nom del camp «Número-article» de la taula Clients), manteniu premut el botó del ratolí i arrossegueu el nom del camp fins a l'altra taula (fins a «Número-article» de la taula Articles). Quan deixeu anar el botó del ratolí, apareixerà una línia que connectarà els dos camps de les dues finestres. La condició corresponent, segons la qual els dos noms de camp hauran de ser idèntics, s'introduirà a la consulta SQL resultant." ], "id_hash": 1976465866603732590, "content_hash": 1976465866603732590, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3155302\nhelp.text", "note": "FspJi", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 72, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 83, "source_unit": "https://translations.documentfoundation.org/api/units/107515439/?format=api", "priority": 100, "id": 107610978, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca_VALENCIA/?checksum=9b6dd13be1999e6e", "url": "https://translations.documentfoundation.org/api/units/107610978/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:46.029422Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca_VALENCIA/?format=api", "source": [ "The creation of a query that is based on several related sheets is only possible if you use $[officename] as the interface for a relational database." ], "previous_source": "", "target": [ "Només podeu crear una consulta basada en diversos fulls relacionats si utilitzeu el $[officename] com a interfície per a una base de dades relacional." ], "id_hash": 5891063930392334617, "content_hash": 5891063930392334617, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3153876\nhelp.text", "note": "FmAaU", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 73, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 26, "source_unit": "https://translations.documentfoundation.org/api/units/107515463/?format=api", "priority": 100, "id": 107610987, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca_VALENCIA/?checksum=d1c1436eb826d119", "url": "https://translations.documentfoundation.org/api/units/107610987/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:46.034898Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca_VALENCIA/?format=api", "source": [ "You cannot access tables from different databases in a query. Queries involving multiple tables can only be created within one database." ], "previous_source": "", "target": [ "No podeu accedir a taules de bases de dades diferents en una consulta. Només podeu crear consultes en què intervinguin diverses taules en una sola base de dades." ], "id_hash": -2581663316533477404, "content_hash": -2581663316533477404, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3145646\nhelp.text", "note": "N2f8q", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 74, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 21, "source_unit": "https://translations.documentfoundation.org/api/units/107515482/?format=api", "priority": 100, "id": 107610990, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca_VALENCIA/?checksum=5c2c16e4505d7fe4", "url": "https://translations.documentfoundation.org/api/units/107610990/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:46.036803Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca_VALENCIA/?format=api", "source": [ "Specifying the relation type" ], "previous_source": "", "target": [ "Especificació del tipus de relació" ], "id_hash": 6221832779187462024, "content_hash": 6221832779187462024, "location": "02010100.xhp", "context": "02010100.xhp\nhd_id3153279\nhelp.text", "note": "nLSiq", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 75, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/107515500/?format=api", "priority": 100, "id": 107610995, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca_VALENCIA/?checksum=d65863f2af599f88", "url": "https://translations.documentfoundation.org/api/units/107610995/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:46.039344Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca_VALENCIA/?format=api", "source": [ "If you double-click on the line connecting two linked fields or call the menu command <emph>Insert - New Relation</emph>, you can specify the type of relation in the <link href=\"text/sdatabase/02010101.xhp\"><emph>Relations</emph></link> dialog." ], "previous_source": "", "target": [ "Si feu un doble clic a la línia que connecta dos camps relacionats o executeu la comanda de menú <emph>Inserir - Nova Relació</emph>, podeu especificar el tipus de relació al diàleg <link href=\"text/sdatabase/02010101.xhp\"><emph>Relacions</emph></link>." ], "id_hash": -4899784255421960509, "content_hash": -4899784255421960509, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3154791\nhelp.text", "note": "Js8Ga", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 76, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 31, "source_unit": "https://translations.documentfoundation.org/api/units/107515519/?format=api", "priority": 100, "id": 107611008, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca_VALENCIA/?checksum=3c00782e0b85aec3", "url": "https://translations.documentfoundation.org/api/units/107611008/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:46.043673Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca_VALENCIA/?format=api", "source": [ "<ahelp hid=\"HID_QUERY_EDIT_JOINCONNECTION\" visibility=\"hidden\">Edit Join Properties.</ahelp> Alternatively, press Tab until the line is selected, then press Shift+F10 to display the context menu and there choose the command <emph>Edit</emph>. Some databases support only a subset of the possible join types." ], "previous_source": "", "target": [ "<ahelp hid=\"HID_QUERY_EDIT_JOINCONNECTION\" visibility=\"hidden\">Edita les propietats de la unió.</ahelp> També podeu prémer la tecla Tab fins que la línia estiga seleccionada, i a continuació Maj+F10 per a mostrar el menú contextual i triar-hi l'ordre <emph>Edita</emph>. Hi ha bases de dades que només admeten un subconjunt de tots els tipus d'unió possibles." ], "id_hash": -1300080026283894037, "content_hash": -1300080026283894037, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3150094\nhelp.text", "note": "rAkmw", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 77, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 38, "source_unit": "https://translations.documentfoundation.org/api/units/107515529/?format=api", "priority": 100, "id": 107611011, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca_VALENCIA/?checksum=6df5301aadc49aeb", "url": "https://translations.documentfoundation.org/api/units/107611011/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:46.056166Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca_VALENCIA/?format=api", "source": [ "Deleting relations" ], "previous_source": "", "target": [ "Supressió de relacions" ], "id_hash": -2081471417905181405, "content_hash": -2081471417905181405, "location": "02010100.xhp", "context": "02010100.xhp\nhd_id3155851\nhelp.text", "note": "n3PMB", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 78, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/107515547/?format=api", "priority": 100, "id": 107611017, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca_VALENCIA/?checksum=631d20c605a20d23", "url": "https://translations.documentfoundation.org/api/units/107611017/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:46.065393Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca_VALENCIA/?format=api", "source": [ "To delete a relation between two tables, click the connection line and then press the Delete key." ], "previous_source": "", "target": [ "Per a suprimir la relació entre dues taules, feu clic a la línia de connexió i premeu la tecla Supr." ], "id_hash": -1676165389692300137, "content_hash": -1676165389692300137, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3156178\nhelp.text", "note": "jCb4H", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 79, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 17, "source_unit": "https://translations.documentfoundation.org/api/units/107515574/?format=api", "priority": 100, "id": 107611022, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca_VALENCIA/?checksum=68bd107572961497", "url": "https://translations.documentfoundation.org/api/units/107611022/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:46.068026Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca_VALENCIA/?format=api", "source": [ "Alternatively, delete the respective entries in <emph>Fields involved </emph>in the <emph>Relations</emph> dialog. Or press Tab until the connecting vector is displayed highlighted, then press Shift+F10 to open the context menu and select <emph>Delete </emph>command." ], "previous_source": "", "target": [ "També podeu suprimir les entrades respectives a <emph>Camps implicats</emph> del diàleg <emph>Relacions</emph>, o bé podeu prémer la tecla Tab fins que el vector de connexió quede realçat i, a continuació, Maj+F10 per a obrir el menú contextual i seleccionar-hi l'ordre <emph>Suprimeix</emph>." ], "id_hash": 2848305102152968996, "content_hash": 2848305102152968996, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3150715\nhelp.text", "note": "3UCig", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 80, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 34, "source_unit": "https://translations.documentfoundation.org/api/units/107515601/?format=api", "priority": 100, "id": 107611026, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca_VALENCIA/?checksum=a787366641c2ab24", "url": "https://translations.documentfoundation.org/api/units/107611026/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:46.070646Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca_VALENCIA/?format=api", "source": [ "Defining the query" ], "previous_source": "", "target": [ "Definició de la consulta" ], "id_hash": -1115420804179096710, "content_hash": -1115420804179096710, "location": "02010100.xhp", "context": "02010100.xhp\nhd_id3151208\nhelp.text", "note": "pBybB", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 81, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/107515619/?format=api", "priority": 100, "id": 107611032, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca_VALENCIA/?checksum=70853ab037d30b7a", "url": "https://translations.documentfoundation.org/api/units/107611032/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:46.075221Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca_VALENCIA/?format=api", "source": [ "<ahelp hid=\"HID_CTL_QRYDGNCRIT\">Select conditions to define the query.</ahelp> Each column of the design table accepts a data field for the query. The conditions in one row are linked with a Boolean AND." ], "previous_source": "", "target": [ "<ahelp hid=\"HID_CTL_QRYDGNCRIT\">Seleccioneu les condicions per a definir la consulta.</ahelp> Cada columna de la taula de disseny accepta un camp de dades per a la consulta. Les condicions d'una fila s'enllacen amb el booleà AND." ], "id_hash": 970150235029481514, "content_hash": 970150235029481514, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3158416\nhelp.text", "note": "yGfhU", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 82, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 31, "source_unit": "https://translations.documentfoundation.org/api/units/107515631/?format=api", "priority": 100, "id": 107611055, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca_VALENCIA/?checksum=8d76aa7fa9b1a82a", "url": "https://translations.documentfoundation.org/api/units/107611055/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:46.096094Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca_VALENCIA/?format=api", "source": [ "Specifying field names" ], "previous_source": "", "target": [ "Especificació del nom dels camps" ], "id_hash": 7087396214846244354, "content_hash": 7087396214846244354, "location": "02010100.xhp", "context": "02010100.xhp\nhd_id3154161\nhelp.text", "note": "UB5nG", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 83, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/107515648/?format=api", "priority": 100, "id": 107611059, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca_VALENCIA/?checksum=e25b7d4e885bc602", "url": "https://translations.documentfoundation.org/api/units/107611059/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:46.098434Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca_VALENCIA/?format=api", "source": [ "First, select all field names from the tables that you want to add to the query. You can do this either by drag-and-drop or by double-clicking a field name in the table window. With the drag-and-drop method, use the mouse to drag a field name from the table window into the lower area of the query design window. As you do this, you can decide which column in the query design window will receive the selected field. A field name can also be selected by double-clicking. It will then be added to the next free column in the query design window." ], "previous_source": "", "target": [ "En primer lloc, seleccioneu tots els noms dels camps de les taules que vulgueu afegir a la consulta. Per a fer-ho, podeu arrossegar i deixar anar o bé fer doble clic a un nom de camp a la finestra de la taula. Si opteu pel primer mètode, utilitzeu el ratolí per a arrossegar un nom de camp des de la finestra de la taula fins a l'àrea inferior de la finestra de disseny de la consulta. D'aquesta manera, podreu decidir a quina columna voleu afegir el camp. Podeu seleccionar un nom de camp fent-hi doble clic. En aquest cas, s'afegirà a la columna lliure següent en la finestra de disseny de la consulta." ], "id_hash": 8198833192151347902, "content_hash": 8198833192151347902, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3146791\nhelp.text", "note": "jyKMG", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 84, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 101, "source_unit": "https://translations.documentfoundation.org/api/units/107515657/?format=api", "priority": 100, "id": 107611061, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca_VALENCIA/?checksum=f1c81b5956dcf2be", "url": "https://translations.documentfoundation.org/api/units/107611061/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:46.100178Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca_VALENCIA/?format=api", "source": [ "Deleting field names" ], "previous_source": "", "target": [ "Supressió de noms de camp" ], "id_hash": -6138130590173748816, "content_hash": -6138130590173748816, "location": "02010100.xhp", "context": "02010100.xhp\nhd_id3150750\nhelp.text", "note": "66Dcr", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 85, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/107515668/?format=api", "priority": 100, "id": 107611068, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca_VALENCIA/?checksum=2ad0fabfdbbc21b0", "url": "https://translations.documentfoundation.org/api/units/107611068/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:46.106753Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca_VALENCIA/?format=api", "source": [ "To remove a field name from the query, click the column header of the field and choose the <emph>Delete</emph> command on the context menu for the column." ], "previous_source": "", "target": [ "Per a suprimir un nom de camp de la consulta, feu clic a la capçalera de columna del camp i trieu l'ordre <emph>Suprimeix</emph> en el menú contextual que es mostrarà per a la columna." ], "id_hash": -2893767419867838722, "content_hash": -2893767419867838722, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3154479\nhelp.text", "note": "AbhrW", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 86, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 27, "source_unit": "https://translations.documentfoundation.org/api/units/107515677/?format=api", "priority": 100, "id": 107611070, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca_VALENCIA/?checksum=57d745dd0c2dc6fe", "url": "https://translations.documentfoundation.org/api/units/107611070/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:46.108337Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca_VALENCIA/?format=api", "source": [ "Saving the query" ], "previous_source": "", "target": [ "Desament de la consulta" ], "id_hash": 6262350828415147603, "content_hash": 6262350828415147603, "location": "02010100.xhp", "context": "02010100.xhp\nhd_id3155764\nhelp.text", "note": "V92gB", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 87, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/107515687/?format=api", "priority": 100, "id": 107611073, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca_VALENCIA/?checksum=d6e856e62a8ede53", "url": "https://translations.documentfoundation.org/api/units/107611073/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:46.110109Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca_VALENCIA/?format=api", "source": [ "Use the <emph>Save</emph> icon on the Standard toolbar to save the query. You will see a dialog that asks you to enter a name for the query. If the database supports schemas, you can also enter a schema name." ], "previous_source": "", "target": [ "Utilitzeu la icona <emph>Guarda</emph> de la barra Estàndard per a guardar la consulta. Visualitzareu un diàleg que vos sol·licitarà un nom per a la consulta. Si la base de dades admet esquemes, també en podreu indicar un." ], "id_hash": 7440882070805057921, "content_hash": 7440882070805057921, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3148481\nhelp.text", "note": "2kWoA", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 88, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 39, "source_unit": "https://translations.documentfoundation.org/api/units/107515695/?format=api", "priority": 100, "id": 107611075, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca_VALENCIA/?checksum=e74352d1e5e89181", "url": "https://translations.documentfoundation.org/api/units/107611075/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:46.111629Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca_VALENCIA/?format=api", "source": [ "Schema" ], "previous_source": "", "target": [ "Esquema" ], "id_hash": -885561489714260386, "content_hash": -885561489714260386, "location": "02010100.xhp", "context": "02010100.xhp\nhd_id3154362\nhelp.text", "note": "M9UQL", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 89, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/107515713/?format=api", "priority": 100, "id": 107611080, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca_VALENCIA/?checksum=73b5da845ad0d65e", "url": "https://translations.documentfoundation.org/api/units/107611080/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:46.116024Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca_VALENCIA/?format=api", "source": [ "<ahelp hid=\"dbaccess/ui/savedialog/schema\">Enter the name of the schema that is assigned to the query or table view.</ahelp>" ], "previous_source": "", "target": [ "<ahelp hid=\"dbaccess/ui/savedialog/schema\">Introduïu el nom de l'esquema assignat a la consulta o a la vista de taula.</ahelp>" ], "id_hash": -7723394859280699830, "content_hash": -7723394859280699830, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3154754\nhelp.text", "note": "4Jwm3", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 90, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/107515727/?format=api", "priority": 100, "id": 107611083, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca_VALENCIA/?checksum=14d0fd4bb87eee4a", "url": "https://translations.documentfoundation.org/api/units/107611083/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:46.118008Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca_VALENCIA/?format=api", "source": [ "Query name or table view name" ], "previous_source": "", "target": [ "Nom de la consulta o de la visualització de la taula" ], "id_hash": -8572436132051432902, "content_hash": -8572436132051432902, "location": "02010100.xhp", "context": "02010100.xhp\nhd_id3156717\nhelp.text", "note": "6Q72c", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 91, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/107515737/?format=api", "priority": 100, "id": 107611086, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca_VALENCIA/?checksum=090896c1b159ca3a", "url": "https://translations.documentfoundation.org/api/units/107611086/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:46.120313Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca_VALENCIA/?format=api", "source": [ "<ahelp hid=\"dbaccess/ui/savedialog/title\">Enter the name of the query or table view.</ahelp>" ], "previous_source": "", "target": [ "<ahelp hid=\"dbaccess/ui/savedialog/title\">Introduïu el nom de la consulta o de la vista de taula.</ahelp>" ], "id_hash": 8513728350355454630, "content_hash": 8513728350355454630, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3154253\nhelp.text", "note": "Cw73K", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 92, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/107515749/?format=api", "priority": 100, "id": 107611219, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca_VALENCIA/?checksum=f626d6d3b51bfaa6", "url": "https://translations.documentfoundation.org/api/units/107611219/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:46.571065Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca_VALENCIA/?format=api", "source": [ "Filtering data" ], "previous_source": "", "target": [ "Filtratge de les dades" ], "id_hash": -6406536098989130371, "content_hash": -6406536098989130371, "location": "02010100.xhp", "context": "02010100.xhp\nhd_id3163805\nhelp.text", "note": "qgbNu", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 93, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/107515768/?format=api", "priority": 100, "id": 107611224, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca_VALENCIA/?checksum=2717695c7b093d7d", "url": "https://translations.documentfoundation.org/api/units/107611224/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:46.576037Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca_VALENCIA/?format=api", "source": [ "To filter data for the query, set the desired criteria in the lower area of the query design window. The following options are available:" ], "previous_source": "", "target": [ "Per a filtrar les dades de la consulta, definiu els criteris desitjats a la zona inferior de la finestra de disseny de la consulta. Hi ha disponibles les següents opcions:" ], "id_hash": -4988399705846574605, "content_hash": -4988399705846574605, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3154964\nhelp.text", "note": "Q9pG5", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 94, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 24, "source_unit": "https://translations.documentfoundation.org/api/units/107515777/?format=api", "priority": 100, "id": 107611229, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca_VALENCIA/?checksum=3ac5a4e5af5a11f3", "url": "https://translations.documentfoundation.org/api/units/107611229/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:46.578902Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca_VALENCIA/?format=api", "source": [ "Field" ], "previous_source": "", "target": [ "Camp" ], "id_hash": 5582990972642116181, "content_hash": 5582990972642116181, "location": "02010100.xhp", "context": "02010100.xhp\nhd_id3146916\nhelp.text", "note": "xxoMA", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 95, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/107515784/?format=api", "priority": 100, "id": 107611235, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca_VALENCIA/?checksum=cd7ac4b5ac8bc255", "url": "https://translations.documentfoundation.org/api/units/107611235/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:46.583006Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca_VALENCIA/?format=api", "source": [ "<ahelp hid=\"HID_QRYDGN_ROW_FIELD\">Enter the name of the data field that is referred to in the Query. All settings made in the filter option rows refer to this field.</ahelp> If you activate a cell here with a mouse click you'll see an arrow button, which enables you to select a field. The \"Table name.*\" option selects all data fields with the effect that the specified criteria will be applied to all table fields." ], "previous_source": "", "target": [ "<ahelp hid=\"HID_QRYDGN_ROW_FIELD\">Introduïu el nom del camp de dades al qual es fa referència a la consulta. Tots els ajustos realitzats a l'opció de filtre de files fan referència a aquest camp. </ahelp> Si activeu una cel·l'amb un clic del ratolí, veureu un botó fletxa que vos permetrà seleccionar un camp. L'opció \"Nom de la taula. *\" selecciona tots els camps de dades amb resultat que els criteris especificats s'aplicaran a tots els camps de la taula." ], "id_hash": 1064441676124325505, "content_hash": 1064441676124325505, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3156372\nhelp.text", "note": "4KDzZ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 96, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 71, "source_unit": "https://translations.documentfoundation.org/api/units/107515801/?format=api", "priority": 100, "id": 107611240, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca_VALENCIA/?checksum=8ec5a81095830681", "url": "https://translations.documentfoundation.org/api/units/107611240/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:46.585215Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca_VALENCIA/?format=api", "source": [ "Alias" ], "previous_source": "", "target": [ "Àlies" ], "id_hash": -9131745723256226364, "content_hash": -9131745723256226364, "location": "02010100.xhp", "context": "02010100.xhp\nhd_id3145150\nhelp.text", "note": "Z3pwF", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 97, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/107515812/?format=api", "priority": 100, "id": 107611245, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca_VALENCIA/?checksum=014585a5921ebdc4", "url": "https://translations.documentfoundation.org/api/units/107611245/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:46.589306Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca_VALENCIA/?format=api", "source": [ "<ahelp hid=\"HID_QRYDGN_ROW_ALIAS\">Specifies an alias. This alias will be listed in the query instead of the field name. This makes it possible to use user-defined column labels.</ahelp> For example, if the data field is named PtNo and, instead of that name, you would like to have PartNum appear in the query, enter PartNum as the alias." ], "previous_source": "", "target": [ "<ahelp hid=\"HID_QRYDGN_ROW_ALIAS\">Especifica un àlies. Aquest àlies es mostrarà a la consulta en lloc del nom del camp. Això permet utilitzar etiquetes de columna definides per l'usuari.</ahelp> Per exemple, si el camp de dades es diu PtNo i, en lloc d'aquest nom, voleu que PartNum aparega a la consulta, introduïu PartNum com a àlies." ], "id_hash": -3671462001782890702, "content_hash": -3671462001782890702, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3146315\nhelp.text", "note": "EDa3A", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 98, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 55, "source_unit": "https://translations.documentfoundation.org/api/units/107515820/?format=api", "priority": 100, "id": 107611247, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca_VALENCIA/?checksum=4d0c58c2f962df32", "url": "https://translations.documentfoundation.org/api/units/107611247/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:46.591365Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca_VALENCIA/?format=api", "source": [ "In a SQL statement, aliases are defined as follows:" ], "previous_source": "", "target": [ "En una declaració SQL, els àlies es defineixen segons:" ], "id_hash": 7100411874502559735, "content_hash": 7100411874502559735, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3155959\nhelp.text", "note": "vvWbt", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 99, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/107515824/?format=api", "priority": 100, "id": 107611252, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca_VALENCIA/?checksum=e289bafaf2b0c7f7", "url": "https://translations.documentfoundation.org/api/units/107611252/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:46.593896Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca_VALENCIA/?format=api", "source": [ "SELECT column AS alias FROM table." ], "previous_source": "", "target": [ "SELECT columna AS àlies FROM taula" ], "id_hash": 3472527734751511331, "content_hash": 3472527734751511331, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3149922\nhelp.text", "note": "CGsBz", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 100, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/107515826/?format=api", "priority": 100, "id": 107611255, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca_VALENCIA/?checksum=b030e593968e4323", "url": "https://translations.documentfoundation.org/api/units/107611255/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:46.595871Z" } ] }