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=6
{ "count": 1739, "next": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca_VALENCIA/units/?format=api&page=7", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca_VALENCIA/units/?format=api&page=5", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca_VALENCIA/?format=api", "source": [ "All date expressions (date literals) must be enclosed with single quotation marks. (Consult the reference for the particular database and connector you are using for more details.)" ], "previous_source": "", "target": [ "Totes les expressions data (tliterals data) s'han de tancar amb cometes simples. (Consulteu la referència de la base de dades i el connector que esteu utilitzant per a més detalls)." ], "id_hash": -4673270034736519928, "content_hash": -4673270034736519928, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3150510\nhelp.text", "note": "CZdA4", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 251, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 27, "source_unit": "https://translations.documentfoundation.org/api/units/107518590/?format=api", "priority": 100, "id": 107613962, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca_VALENCIA/?checksum=3f2535a9d80d6508", "url": "https://translations.documentfoundation.org/api/units/107613962/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:50.336281Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca_VALENCIA/?format=api", "source": [ "Querying Yes/No fields" ], "previous_source": "", "target": [ "Consulta de camps Si/No" ], "id_hash": 8163855836227489271, "content_hash": 8163855836227489271, "location": "02010100.xhp", "context": "02010100.xhp\nhd_id3150427\nhelp.text", "note": "HXdKT", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 252, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/107518594/?format=api", "priority": 100, "id": 107613963, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca_VALENCIA/?checksum=f14bd7a10bd6cdf7", "url": "https://translations.documentfoundation.org/api/units/107613963/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:50.338573Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca_VALENCIA/?format=api", "source": [ "To query Yes/No fields, use the following syntax for dBASE tables:" ], "previous_source": "", "target": [ "Per a efectuar consultes en camps sí/no, utilitzeu la sintaxi següent en taules dBASE:" ], "id_hash": 7542181489787428597, "content_hash": 7542181489787428597, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3149523\nhelp.text", "note": "xWzix", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 253, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/107518605/?format=api", "priority": 100, "id": 107613964, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca_VALENCIA/?checksum=e8ab361ad24e5ef5", "url": "https://translations.documentfoundation.org/api/units/107613964/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:50.340509Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca_VALENCIA/?format=api", "source": [ "Status" ], "previous_source": "", "target": [ "Estat" ], "id_hash": -1438940559154058398, "content_hash": -1438940559154058398, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3153180\nhelp.text", "note": "A4Uh7", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 254, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/107518619/?format=api", "priority": 100, "id": 107613965, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca_VALENCIA/?checksum=6c07db2f6eb86b62", "url": "https://translations.documentfoundation.org/api/units/107613965/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:50.342440Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca_VALENCIA/?format=api", "source": [ "Query criterion" ], "previous_source": "", "target": [ "Criteri de consulta" ], "id_hash": 8650453120847444098, "content_hash": 8650453120847444098, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3147481\nhelp.text", "note": "FnXiE", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 255, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/107518620/?format=api", "priority": 100, "id": 107613966, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca_VALENCIA/?checksum=f80c95480647f882", "url": "https://translations.documentfoundation.org/api/units/107613966/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:50.344971Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca_VALENCIA/?format=api", "source": [ "Example" ], "previous_source": "", "target": [ "Exemple" ], "id_hash": 8141292417662845597, "content_hash": 8141292417662845597, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3155187\nhelp.text", "note": "e6DJr", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 256, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/107518628/?format=api", "priority": 100, "id": 107613967, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca_VALENCIA/?checksum=f0fbae51c760029d", "url": "https://translations.documentfoundation.org/api/units/107613967/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:50.346861Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca_VALENCIA/?format=api", "source": [ "Yes" ], "previous_source": "", "target": [ "Sí" ], "id_hash": 4937219640899305490, "content_hash": 4937219640899305490, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3156092\nhelp.text", "note": "Guy7d", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 257, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/107518637/?format=api", "priority": 100, "id": 107613968, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca_VALENCIA/?checksum=c484871ad9e28012", "url": "https://translations.documentfoundation.org/api/units/107613968/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:50.348828Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca_VALENCIA/?format=api", "source": [ "for dBASE tables: not equal to any given value" ], "previous_source": "", "target": [ "per a taules dBASE: no és igual a cap valor donat" ], "id_hash": -1485834374452513737, "content_hash": -1485834374452513737, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3152414\nhelp.text", "note": "p9WTn", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 258, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/107518651/?format=api", "priority": 100, "id": 107613969, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca_VALENCIA/?checksum=6b6141823bb17437", "url": "https://translations.documentfoundation.org/api/units/107613969/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:50.350445Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca_VALENCIA/?format=api", "source": [ "=1 returns all records where the Yes/No field has the status \"Yes\" or \"On\" (selected in black)," ], "previous_source": "", "target": [ "=1 retorna tots els registres on el camp Sí/No té l'estat \"Sí\" o \"Activat\" (seleccionat en negre)" ], "id_hash": 4097363800793405340, "content_hash": 4097363800793405340, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3151265\nhelp.text", "note": "RFrvz", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 259, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 17, "source_unit": "https://translations.documentfoundation.org/api/units/107518672/?format=api", "priority": 100, "id": 107613970, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca_VALENCIA/?checksum=b8dcc2ab05d5d79c", "url": "https://translations.documentfoundation.org/api/units/107613970/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:50.352674Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca_VALENCIA/?format=api", "source": [ "No" ], "previous_source": "", "target": [ "No" ], "id_hash": -1265902796848252916, "content_hash": -1265902796848252916, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3152450\nhelp.text", "note": "3P4ZB", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 260, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/107518708/?format=api", "priority": 100, "id": 107613971, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca_VALENCIA/?checksum=6e6e9c1d01afb80c", "url": "https://translations.documentfoundation.org/api/units/107613971/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:50.354527Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca_VALENCIA/?format=api", "source": [ "." ], "previous_source": "", "target": [ "." ], "id_hash": -1104976539801341283, "content_hash": -1104976539801341283, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3150997\nhelp.text", "note": "BzBAa", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 261, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/107518713/?format=api", "priority": 100, "id": 107613972, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca_VALENCIA/?checksum=70aa55b10400329d", "url": "https://translations.documentfoundation.org/api/units/107613972/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:50.356090Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca_VALENCIA/?format=api", "source": [ "=0 returns all records for which the Yes/No field has the status \"No\" or \"Off\" (no selection)." ], "previous_source": "", "target": [ "=0 retorna tots els registres per als quals el camp Sí/No té l'estat \"No\" o \"Desactivat\" (sense selecció)." ], "id_hash": -3974623853916560005, "content_hash": -3974623853916560005, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3155331\nhelp.text", "note": "TFsQG", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 262, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 17, "source_unit": "https://translations.documentfoundation.org/api/units/107518716/?format=api", "priority": 100, "id": 107613973, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca_VALENCIA/?checksum=48d74ca9cf82657b", "url": "https://translations.documentfoundation.org/api/units/107613973/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:50.357239Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca_VALENCIA/?format=api", "source": [ "Null" ], "previous_source": "", "target": [ "Null" ], "id_hash": -3383237762867038875, "content_hash": -3383237762867038875, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3154179\nhelp.text", "note": "9KXzK", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 263, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/107518722/?format=api", "priority": 100, "id": 107613974, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca_VALENCIA/?checksum=510c532e099f7565", "url": "https://translations.documentfoundation.org/api/units/107613974/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:50.358423Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca_VALENCIA/?format=api", "source": [ "IS NULL" ], "previous_source": "", "target": [ "IS NULL" ], "id_hash": 5893788471563971096, "content_hash": 5893788471563971096, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3147035\nhelp.text", "note": "CwGZv", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 264, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/107518728/?format=api", "priority": 100, "id": 107613975, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca_VALENCIA/?checksum=d1caf16364dcea18", "url": "https://translations.documentfoundation.org/api/units/107613975/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:50.359532Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca_VALENCIA/?format=api", "source": [ "IS NULL returns all records for which the Yes/No field has neither of the states Yes or No (selected in gray)." ], "previous_source": "", "target": [ "IS NULL retorna tots els registres per als quals el camp Sí/No no té cap dels estats Sí o No (seleccionat en gris)." ], "id_hash": 6584486709762292464, "content_hash": 6584486709762292464, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3159385\nhelp.text", "note": "dyXYc", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 265, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 21, "source_unit": "https://translations.documentfoundation.org/api/units/107518735/?format=api", "priority": 100, "id": 107613976, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca_VALENCIA/?checksum=db60cbc6c3a97af0", "url": "https://translations.documentfoundation.org/api/units/107613976/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:50.360652Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca_VALENCIA/?format=api", "source": [ "The syntax depends on the database system used. You should also note that Yes/No fields can be defined differently (only 2 states instead of 3)." ], "previous_source": "", "target": [ "La sintaxi depèn del sistema de base de dades utilitzat. També heu de tindre en compte que els camps Sí/No es poden definir de manera diferent (només 2 estats en lloc de 3)." ], "id_hash": 7229728358486624123, "content_hash": 7229728358486624123, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3157888\nhelp.text", "note": "YWk5J", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 266, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 25, "source_unit": "https://translations.documentfoundation.org/api/units/107518752/?format=api", "priority": 100, "id": 107613977, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca_VALENCIA/?checksum=e45527a32629c77b", "url": "https://translations.documentfoundation.org/api/units/107613977/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:50.362338Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca_VALENCIA/?format=api", "source": [ "Parameter queries" ], "previous_source": "", "target": [ "Consulta de paràmetres" ], "id_hash": 450583529009372135, "content_hash": 450583529009372135, "location": "02010100.xhp", "context": "02010100.xhp\nhd_id3145772\nhelp.text", "note": "mmVa8", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 267, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/107518768/?format=api", "priority": 100, "id": 107613978, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca_VALENCIA/?checksum=8640cb55143edbe7", "url": "https://translations.documentfoundation.org/api/units/107613978/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:50.364787Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca_VALENCIA/?format=api", "source": [ "Parameter queries allow the user to input values at run-time. These values are used within the criteria for selecting the records to be displayed. Each such value has a parameter name associated with it, which is used to prompt the user when the query is run." ], "previous_source": "", "target": [ "La consulta de paràmetres permet a l'usuari introduir valors en temps d'execució. Aquests valors s'utilitzen en els criteris per seleccionar els registres que es mostran. Cada valor té un nom de paràmetre associat, que s'utilitza per preguntar a l'usuari quan s'executa la consulta." ], "id_hash": -8140116745182247469, "content_hash": -8140116745182247469, "location": "02010100.xhp", "context": "02010100.xhp\npar_id191120151905346795\nhelp.text", "note": "ND7xd", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 268, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 46, "source_unit": "https://translations.documentfoundation.org/api/units/107518781/?format=api", "priority": 100, "id": 107613979, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca_VALENCIA/?checksum=0f087ef2cd3405d3", "url": "https://translations.documentfoundation.org/api/units/107613979/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:50.366567Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca_VALENCIA/?format=api", "source": [ "Parameter names are preceded by a colon in both the Design and SQL views of a query. This can be used wherever a value can appear. If the same value is to appear more than once in the query, the same parameter name is used." ], "previous_source": "", "target": [ "Els noms dels paràmetres estan precedits per dos punts en les vistes de disseny i SQL d'una consulta. Això es pot utilitzar on puga aparèixer un valor. Si el mateix valor apareix més d'una vegada a la consulta, s'utilitza el mateix nom de paràmetre." ], "id_hash": 4111393334921262894, "content_hash": 4111393334921262894, "location": "02010100.xhp", "context": "02010100.xhp\npar_id191120151905439551\nhelp.text", "note": "Be7XG", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 269, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 45, "source_unit": "https://translations.documentfoundation.org/api/units/107518803/?format=api", "priority": 100, "id": 107613980, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca_VALENCIA/?checksum=b90e9a747be3f72e", "url": "https://translations.documentfoundation.org/api/units/107613980/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:50.369034Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca_VALENCIA/?format=api", "source": [ "In the simplest case, where the user enters a value which is matched for equality, the parameter name with its preceding colon is simply entered in the Criterion row. In <link href=\"text/sdatabase/02010100.xhp#sqlmode\">SQL mode</link> this should be typed as <item type=\"input\">WHERE \"Field\" = :Parameter_name</item>" ], "previous_source": "", "target": [ "" ], "id_hash": -8056140160250446947, "content_hash": -8056140160250446947, "location": "02010100.xhp", "context": "02010100.xhp\npar_id191120151905518123\nhelp.text", "note": "f2NMg", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 270, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 43, "source_unit": "https://translations.documentfoundation.org/api/units/107518814/?format=api", "priority": 100, "id": 107613981, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca_VALENCIA/?checksum=1032d7351f837b9d", "url": "https://translations.documentfoundation.org/api/units/107613981/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:50.373520Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca_VALENCIA/?format=api", "source": [ "Parameter names may not contain any of the characters <item type=\"input\"><space>`!\"$%^*()+={}[]@'~#<>?/,</item>. They may not be the same as field names or SQL reserved words. They may be the same as aliases." ], "previous_source": "", "target": [ "Els noms dels paràmetres no poden contindre cap dels caràcters <item type=\"input\"><space>`!\"$%^*()+={}[]@'~#<>?/,</item>. No poden ser els mateixos que els noms de camps o paraules reservades SQL. Poden ser els mateixos que els àlies." ], "id_hash": 2239266726598408603, "content_hash": 2239266726598408603, "location": "02010100.xhp", "context": "02010100.xhp\npar_id191120151905584287\nhelp.text", "note": "DZCXm", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 271, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 31, "source_unit": "https://translations.documentfoundation.org/api/units/107518824/?format=api", "priority": 100, "id": 107613982, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca_VALENCIA/?checksum=9f137939443ff99b", "url": "https://translations.documentfoundation.org/api/units/107613982/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:50.378166Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca_VALENCIA/?format=api", "source": [ "A useful construction for selecting records based on parts of a text field's content is to add a hidden column with <item type=\"input\">\"LIKE '%' || :Part_of_field || '%'\"</item> as the criterion. This will select records with an exact match. If a case-insensitive test is wanted, one solution is to use <item type=\"input\">LOWER (Field_Name)</item> as the field and <item type=\"input\">LIKE LOWER ( '%' || :Part_of_field || '%' )</item> as the criterion. Note that the spaces in the criterion are important; if they are left out the SQL parser interprets the entire criterion as a string to be matched. In <link href=\"text/sdatabase/02010100.xhp#sqlmode\">SQL mode</link> this should be typed as <item type=\"input\">LOWER ( \"Field_Name\" ) LIKE LOWER ( '%' || :Part_of_field || '%' )</item>." ], "previous_source": "", "target": [ "" ], "id_hash": 7359674384784650935, "content_hash": 7359674384784650935, "location": "02010100.xhp", "context": "02010100.xhp\npar_id191120151931441881\nhelp.text", "note": "WBEtt", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 272, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 120, "source_unit": "https://translations.documentfoundation.org/api/units/107518840/?format=api", "priority": 100, "id": 107613983, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca_VALENCIA/?checksum=e622d0dc17a172b7", "url": "https://translations.documentfoundation.org/api/units/107613983/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:50.381188Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca_VALENCIA/?format=api", "source": [ "Parameter queries may be used as the data source for <link href=\"text/shared/02/01170203.xhp\">subforms</link>, to allow the user to restrict the displayed records." ], "previous_source": "", "target": [ "Les consultes de paràmetres es poden utilitzar com a font de dades per als <link href=\"text/shared/02/01170203.xhp\">subformularis</link> per permetre a l'usuari restringir els registres mostrats." ], "id_hash": 2107924860811531621, "content_hash": 2107924860811531621, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3150585\nhelp.text", "note": "EAESi", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 273, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 21, "source_unit": "https://translations.documentfoundation.org/api/units/107518861/?format=api", "priority": 100, "id": 107613984, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca_VALENCIA/?checksum=9d40da7e1de2d565", "url": "https://translations.documentfoundation.org/api/units/107613984/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:50.383302Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca_VALENCIA/?format=api", "source": [ "Parameter Input" ], "previous_source": "", "target": [ "Entrada del paràmetre" ], "id_hash": 2456021578479157933, "content_hash": 2456021578479157933, "location": "02010100.xhp", "context": "02010100.xhp\nhd_id3151035\nhelp.text", "note": "DRj78", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 274, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/107518874/?format=api", "priority": 100, "id": 107613985, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca_VALENCIA/?checksum=a2158a9cf1f1c2ad", "url": "https://translations.documentfoundation.org/api/units/107613985/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:50.386217Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca_VALENCIA/?format=api", "source": [ "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\">The <emph>Parameter Input</emph> dialog asks the user to enter the parameter values. Enter a value for each query parameter and confirm by clicking <emph>OK</emph> or typing <emph>Enter</emph>.</ahelp>" ], "previous_source": "", "target": [ "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\">El diàleg <emph>entrada del paràmetre</emph> demana a l'usuari que introduïsca els valors del paràmetre. Introduïu un valor per a cada paràmetre de consulta i confirmeu-los clicant <emph>OK</emph> o escrivint <emph>Entrar</emph>.</ahelp>" ], "id_hash": 264425641860169309, "content_hash": 264425641860169309, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3153596\nhelp.text", "note": "BisCF", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 275, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 28, "source_unit": "https://translations.documentfoundation.org/api/units/107518886/?format=api", "priority": 100, "id": 107613986, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca_VALENCIA/?checksum=83ab6db864947e5d", "url": "https://translations.documentfoundation.org/api/units/107613986/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:50.388176Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca_VALENCIA/?format=api", "source": [ "The values entered by the user may consist of any characters which are allowable for the SQL for the relevant criterion; this may depend on the underlying database system." ], "previous_source": "", "target": [ "Els valors introduïts per l'usuari poden consistir en qualsevol caràcter permés a l'SQL per al criteri pertinent; això pot dependre del sistema de base de dades subjacent." ], "id_hash": -7615090312441786881, "content_hash": -7615090312441786881, "location": "02010100.xhp", "context": "02010100.xhp\npar_id191120151924165870\nhelp.text", "note": "eGETM", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 276, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 29, "source_unit": "https://translations.documentfoundation.org/api/units/107518905/?format=api", "priority": 100, "id": 107613987, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca_VALENCIA/?checksum=1651c3b512638dff", "url": "https://translations.documentfoundation.org/api/units/107613987/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:50.393126Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca_VALENCIA/?format=api", "source": [ "The user can use the SQL wild-card characters \"%\" (arbitrary string) or \"_\" (arbitrary single character) as part of the value to retrieve records with more complex criteria." ], "previous_source": "", "target": [ "L'usuari pot utilitzar els caràcters de comodí SQL \"%\" (cadena arbitrària) o \"_\" (caràcter únic arbitrari) com a part del valor per recuperar registres amb criteris més complexos." ], "id_hash": 7455332244107640153, "content_hash": 7455332244107640153, "location": "02010100.xhp", "context": "02010100.xhp\npar_id191120151939594217\nhelp.text", "note": "seFhG", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 277, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 28, "source_unit": "https://translations.documentfoundation.org/api/units/107518948/?format=api", "priority": 100, "id": 107613988, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca_VALENCIA/?checksum=e776a92d0c8d3d59", "url": "https://translations.documentfoundation.org/api/units/107613988/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:50.396951Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca_VALENCIA/?format=api", "source": [ "SQL Mode" ], "previous_source": "", "target": [ "Mode SQL" ], "id_hash": 7952163570614096607, "content_hash": 7952163570614096607, "location": "02010100.xhp", "context": "02010100.xhp\nhd_id3145181\nhelp.text", "note": "wRe6v", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 278, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/107518962/?format=api", "priority": 100, "id": 107613989, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca_VALENCIA/?checksum=ee5bc2a2964152df", "url": "https://translations.documentfoundation.org/api/units/107613989/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:50.400594Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca_VALENCIA/?format=api", "source": [ "SQL stands for \"Structured Query Language\" and describes instructions for updating and administering relational databases." ], "previous_source": "", "target": [ "SQL significa \"Llenguatge de consulta estructurat\" i descriu instruccions per actualitzar i administrar bases de dades relacionals." ], "id_hash": 2645544768060911837, "content_hash": 2645544768060911837, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3147013\nhelp.text", "note": "5avVu", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 279, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://translations.documentfoundation.org/api/units/107518974/?format=api", "priority": 100, "id": 107613990, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca_VALENCIA/?checksum=a4b6dcf329a9f0dd", "url": "https://translations.documentfoundation.org/api/units/107613990/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:50.405155Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca_VALENCIA/?format=api", "source": [ "In $[officename] you do not need any knowledge of SQL for most queries, since you do not have to enter the SQL code. If you create a query in the query designer, $[officename] automatically converts your instructions into the corresponding SQL syntax. If, with the help of the <emph>Switch Design View On/Off </emph>button, you change to the SQL view, you can see the SQL commands for a query that has already been created." ], "previous_source": "", "target": [ "Al $[officename] no necessitare cap coneixement d'SQL per a la majoria de consultes, ja que no heu d'introduir el codi SQL. Si creeu una consulta al dissenyador de consultes el $[officename] converteix automàticament les vostres instruccions en la sintaxi SQL corresponent. Si, amb l'ajuda del botó <emph>Canvia la vista de disseny Actiu/Desactiu </emph>, canvieu a la vista SQL, podeu veure les ordres SQL per a la consulta ja creada." ], "id_hash": 7941331124243750945, "content_hash": 7941331124243750945, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3152570\nhelp.text", "note": "wDAAY", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 280, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 73, "source_unit": "https://translations.documentfoundation.org/api/units/107518984/?format=api", "priority": 100, "id": 107613991, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca_VALENCIA/?checksum=ee354695204d6021", "url": "https://translations.documentfoundation.org/api/units/107613991/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:50.406733Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca_VALENCIA/?format=api", "source": [ "You can formulate your query directly in SQL code. Note, however, that the special syntax is dependent upon the database system that you use." ], "previous_source": "", "target": [ "Podeu formular la vostra consulta directament en codi SQL. Tingueu en compte, però, que la sintaxi especial depèn del sistema de base de dades que utilitzeu." ], "id_hash": 1166373493807955969, "content_hash": 1166373493807955969, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3152412\nhelp.text", "note": "hBQFv", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 281, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 24, "source_unit": "https://translations.documentfoundation.org/api/units/107518992/?format=api", "priority": 100, "id": 107613993, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca_VALENCIA/?checksum=902fca834ddac001", "url": "https://translations.documentfoundation.org/api/units/107613993/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:50.409820Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca_VALENCIA/?format=api", "source": [ "If you enter the SQL code manually, you can create SQL-specific queries that are not supported by the graphical interface in the <emph>Query designer</emph>. These queries must be executed in native SQL mode." ], "previous_source": "", "target": [ "Si introduïu el codi SQL manualment, podeu crear consultes específiques SQL que no siguen compatibles amb la interfície gràfica al <emph>Dissenyador de consultes</emph>. Aquestes consultes s'han d'executar en mode SQL natiu." ], "id_hash": 5642149963125379485, "content_hash": 5642149963125379485, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3146842\nhelp.text", "note": "kkuBG", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 282, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 33, "source_unit": "https://translations.documentfoundation.org/api/units/107518998/?format=api", "priority": 100, "id": 107613996, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca_VALENCIA/?checksum=ce4cf17f8192519d", "url": "https://translations.documentfoundation.org/api/units/107613996/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:50.412413Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca_VALENCIA/?format=api", "source": [ "By clicking the <link href=\"text/shared/02/14030000.xhp\"><emph>Run SQL command directly</emph></link> icon in the SQL view, you can formulate a query that is not processed by $[officename] and sent directly to the database engine." ], "previous_source": "", "target": [ "En fer clic a la icona <link href=\"text/shared/02/14030000.xhp\"><emph> Executa l'ordre SQL directament </emph></link> a la vista SQL, podeu formular una consulta que no és processada pel $[officename] i que s'envia directament al motor de base de dades." ], "id_hash": -1013675299276706472, "content_hash": -1013675299276706472, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3149632\nhelp.text", "note": "LgvXF", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 283, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 31, "source_unit": "https://translations.documentfoundation.org/api/units/107519000/?format=api", "priority": 100, "id": 107614000, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca_VALENCIA/?checksum=71eeb3af9d062d58", "url": "https://translations.documentfoundation.org/api/units/107614000/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:50.415558Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca_VALENCIA/?format=api", "source": [ "Join Properties" ], "previous_source": "", "target": [ "Propietats de la unió" ], "id_hash": -6678692574290660760, "content_hash": -6678692574290660760, "location": "02010101.xhp", "context": "02010101.xhp\ntit\nhelp.text", "note": "fKBDD", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 284, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/107519013/?format=api", "priority": 100, "id": 107614003, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca_VALENCIA/?checksum=2350847d295db268", "url": "https://translations.documentfoundation.org/api/units/107614003/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:50.417653Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca_VALENCIA/?format=api", "source": [ "<bookmark_value>links;relational databases (Base)</bookmark_value> <bookmark_value>inner joins (Base)</bookmark_value> <bookmark_value>joins in databases (Base)</bookmark_value> <bookmark_value>left joins (Base)</bookmark_value> <bookmark_value>right joins (Base)</bookmark_value> <bookmark_value>full joins (Base)</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>Enllaços;base de dades relacional (Base)</bookmark_value> <bookmark_value>inner joins (Base)</bookmark_value> <bookmark_value>joins in databases (Base)</bookmark_value> <bookmark_value>left joins (Base)</bookmark_value> <bookmark_value>right joins (Base)</bookmark_value> <bookmark_value>full joins (Base)</bookmark_value>" ], "id_hash": 1301543985542803826, "content_hash": 1301543985542803826, "location": "02010101.xhp", "context": "02010101.xhp\nbm_id3154015\nhelp.text", "note": "TTCNB", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 285, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/107519029/?format=api", "priority": 100, "id": 107614010, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca_VALENCIA/?checksum=9210035be5d33172", "url": "https://translations.documentfoundation.org/api/units/107614010/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:50.423929Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca_VALENCIA/?format=api", "source": [ "Join Properties" ], "previous_source": "", "target": [ "Propietats de la unió" ], "id_hash": 2689996371133773814, "content_hash": 2689996371133773814, "location": "02010101.xhp", "context": "02010101.xhp\nhd_id3154015\nhelp.text", "note": "DG7RD", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 286, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/107519046/?format=api", "priority": 100, "id": 107614013, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca_VALENCIA/?checksum=a554c9728484b7f6", "url": "https://translations.documentfoundation.org/api/units/107614013/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:50.427398Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca_VALENCIA/?format=api", "source": [ "If you double-click a connection between two linked fields in the query design, or if you choose <emph>Insert - New Relation</emph>, the <emph>Join Properties</emph> dialog appears. These properties will be used in all queries created in the future." ], "previous_source": "", "target": [ "Si feu doble clic en una connexió entre dos camps enllaçats en el disseny de consulta o, si trieu <emph>Insereix ▸ Nova relació</emph> , apareixerà el diàleg <emph>Propietats de la unió</emph>. Aquestes propietats s'utilitzaran en totes les consultes que es creen en el futur." ], "id_hash": -8537690843307473250, "content_hash": -8537690843307473250, "location": "02010101.xhp", "context": "02010101.xhp\npar_id3151205\nhelp.text", "note": "MzpBt", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 287, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 38, "source_unit": "https://translations.documentfoundation.org/api/units/107519062/?format=api", "priority": 100, "id": 107614014, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca_VALENCIA/?checksum=09840769a28d869e", "url": "https://translations.documentfoundation.org/api/units/107614014/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:50.431479Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca_VALENCIA/?format=api", "source": [ "Tables involved" ], "previous_source": "", "target": [ "Taules implicades" ], "id_hash": -36410145612706044, "content_hash": -36410145612706044, "location": "02010101.xhp", "context": "02010101.xhp\nhd_id3155066\nhelp.text", "note": "oszEF", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 288, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/107519089/?format=api", "priority": 100, "id": 107614016, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca_VALENCIA/?checksum=7f7ea52a5c88cf04", "url": "https://translations.documentfoundation.org/api/units/107614016/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:50.437145Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca_VALENCIA/?format=api", "source": [ "<ahelp hid=\"dbaccess/ui/joindialog/table2\">Specifies two different tables that you want to join.</ahelp>" ], "previous_source": "", "target": [ "<ahelp hid=\"dbaccess/ui/joindialog/table2\">Identifica dues taules diferents que voleu unir.</ahelp>" ], "id_hash": 1333863119828857673, "content_hash": 1333863119828857673, "location": "02010101.xhp", "context": "02010101.xhp\npar_id3153924\nhelp.text", "note": "2AkcB", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 289, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/107519110/?format=api", "priority": 100, "id": 107614018, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca_VALENCIA/?checksum=9282d570bc64b349", "url": "https://translations.documentfoundation.org/api/units/107614018/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:50.439718Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca_VALENCIA/?format=api", "source": [ "Fields involved" ], "previous_source": "", "target": [ "Camps implicats" ], "id_hash": -1789859163330594308, "content_hash": -1789859163330594308, "location": "02010101.xhp", "context": "02010101.xhp\nhd_id3155766\nhelp.text", "note": "X6wkD", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 290, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/107519134/?format=api", "priority": 100, "id": 107614020, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca_VALENCIA/?checksum=67292492f3b3b9fc", "url": "https://translations.documentfoundation.org/api/units/107614020/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:50.441677Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca_VALENCIA/?format=api", "source": [ "<ahelp hid=\".\">Specifies two data fields that will be joined by a relation.</ahelp>" ], "previous_source": "", "target": [ "<ahelp hid=\".\">Especifica dos camps de dades que s'uniran en una relació.</ahelp>" ], "id_hash": 7574129023308213126, "content_hash": 7574129023308213126, "location": "02010101.xhp", "context": "02010101.xhp\npar_id3148994\nhelp.text", "note": "8bYEZ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 291, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/107519152/?format=api", "priority": 100, "id": 107614023, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca_VALENCIA/?checksum=e91cb6379d432b86", "url": "https://translations.documentfoundation.org/api/units/107614023/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:50.443694Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca_VALENCIA/?format=api", "source": [ "Options" ], "previous_source": "", "target": [ "Opcions" ], "id_hash": -2720686535624113612, "content_hash": -2720686535624113612, "location": "02010101.xhp", "context": "02010101.xhp\nhd_id3159267\nhelp.text", "note": "R8CbB", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 292, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/107519169/?format=api", "priority": 100, "id": 107614025, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca_VALENCIA/?checksum=5a3e2e02baefc234", "url": "https://translations.documentfoundation.org/api/units/107614025/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:50.445611Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca_VALENCIA/?format=api", "source": [ "Type" ], "previous_source": "", "target": [ "Tipus" ], "id_hash": -4053688658655726463, "content_hash": -4053688658655726463, "location": "02010101.xhp", "context": "02010101.xhp\nhd_id3147340\nhelp.text", "note": "MRJCp", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 293, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/107519198/?format=api", "priority": 100, "id": 107614027, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca_VALENCIA/?checksum=47be67a46ecbb481", "url": "https://translations.documentfoundation.org/api/units/107614027/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:50.447249Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca_VALENCIA/?format=api", "source": [ "<ahelp hid=\"dbaccess/ui/joindialog/type\">Specifies the join type of the selected join.</ahelp> Some databases support only a subset of the various possible types." ], "previous_source": "", "target": [ "<ahelp hid=\"dbaccess/ui/joindialog/type\">Identifica el tipus d'unió de la unió seleccionada.</ahelp> Algunes bases de dades només admeten un subconjunt dels diversos tipus possibles." ], "id_hash": -7272426577638343159, "content_hash": -7272426577638343159, "location": "02010101.xhp", "context": "02010101.xhp\npar_id3152482\nhelp.text", "note": "rxAGo", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 294, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 20, "source_unit": "https://translations.documentfoundation.org/api/units/107519221/?format=api", "priority": 100, "id": 107614029, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca_VALENCIA/?checksum=1b13268f00c1be09", "url": "https://translations.documentfoundation.org/api/units/107614029/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:50.448711Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca_VALENCIA/?format=api", "source": [ "Inner Join" ], "previous_source": "", "target": [ "Inner Join" ], "id_hash": -7586144127754050114, "content_hash": -7586144127754050114, "location": "02010101.xhp", "context": "02010101.xhp\nhd_id3155334\nhelp.text", "note": "ngfse", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 295, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/107519228/?format=api", "priority": 100, "id": 107614032, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca_VALENCIA/?checksum=16b89a1be24de5be", "url": "https://translations.documentfoundation.org/api/units/107614032/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:50.450749Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca_VALENCIA/?format=api", "source": [ "<ahelp hid=\"dbaccess/ui/joindialog/type\">In an inner join, the results table contains only those records for which the content of the linked fields is the same.</ahelp> In $[officename] SQL this type of link is created by a corresponding WHERE clause." ], "previous_source": "", "target": [ "<ahelp hid=\"dbaccess/ui/joindialog/type\">En una unió interna, la taula de resultats només conté els registres per als quals el contingut dels camps enllaçats és el mateix.</ahelp> Al SQL $[officename] aquest tipus d'enllaç es crea amb una clàusula WHERE corresponent." ], "id_hash": -6113919658300017234, "content_hash": -6113919658300017234, "location": "02010101.xhp", "context": "02010101.xhp\npar_id3155936\nhelp.text", "note": "356Dv", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 296, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 37, "source_unit": "https://translations.documentfoundation.org/api/units/107519239/?format=api", "priority": 100, "id": 107614034, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca_VALENCIA/?checksum=2b26fe76b5bff5ae", "url": "https://translations.documentfoundation.org/api/units/107614034/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:50.453596Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca_VALENCIA/?format=api", "source": [ "Left Join" ], "previous_source": "", "target": [ "Unió a l'esquerra" ], "id_hash": -9146645766165797204, "content_hash": -9146645766165797204, "location": "02010101.xhp", "context": "02010101.xhp\nhd_id3156372\nhelp.text", "note": "XYKGT", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 297, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/107519253/?format=api", "priority": 100, "id": 107614036, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca_VALENCIA/?checksum=01109622fd5b66ac", "url": "https://translations.documentfoundation.org/api/units/107614036/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:50.456546Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca_VALENCIA/?format=api", "source": [ "<ahelp hid=\"dbaccess/ui/joindialog/type\">In a left join, the results table contains all records of the queried fields from the left table and only those records of the queried fields from the right table for which the content of the linked fields is the same.</ahelp> In $[officename] SQL this type of link corresponds to the LEFT OUTER JOIN command." ], "previous_source": "", "target": [ "<ahelp hid=\"dbaccess/ui/joindialog/type\">En una unió a l'esquerra, la taula de resultats conté tots els registres dels camps que s'han seleccionat a la taula de l'esquerra i, només els registres amb els camps que han estat seleccionats de la taula de la dreta per als quals el contingut dels camps enllaçats és el mateix.</ahelp> Al SQL $[officename] aquest tipus d'enllaç correspon a l'ordre LEFT OUTER JOIN." ], "id_hash": 1610530649816152644, "content_hash": 1610530649816152644, "location": "02010101.xhp", "context": "02010101.xhp\npar_id3166450\nhelp.text", "note": "dRFux", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 298, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 56, "source_unit": "https://translations.documentfoundation.org/api/units/107519273/?format=api", "priority": 100, "id": 107614038, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca_VALENCIA/?checksum=9659c117d22bba44", "url": "https://translations.documentfoundation.org/api/units/107614038/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:50.459120Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca_VALENCIA/?format=api", "source": [ "Right Join" ], "previous_source": "", "target": [ "Unió a la dreta" ], "id_hash": 6056042749440435176, "content_hash": 6056042749440435176, "location": "02010101.xhp", "context": "02010101.xhp\nhd_id3155607\nhelp.text", "note": "DxGWD", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 299, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/107519288/?format=api", "priority": 100, "id": 107614041, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca_VALENCIA/?checksum=d40b62cb58fa23e8", "url": "https://translations.documentfoundation.org/api/units/107614041/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:50.462263Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ca_VALENCIA/?format=api", "source": [ "<ahelp hid=\"dbaccess/ui/joindialog/type\">In a right join, the results table contains all records of the queried fields from the right table and only those records of the queried fields from the left table for which the content of the linked fields is the same.</ahelp> In $[officename] SQL this type of link corresponds to the RIGHT OUTER JOIN command." ], "previous_source": "", "target": [ "<ahelp hid=\"dbaccess/ui/joindialog/type\">En una unió a la dreta la taula de resultats conté tots els registres dels camps seleccionats de la taula de la dreta i només els registres dels camps seleccionats de la taula de l'esquerra per a la qual el contingut dels camps enllaçats és el mateix.</ahelp> Al SQL $[officename] aquest tipus d'enllaç correspon a l'ordre RIGHT OUTER JOIN." ], "id_hash": 2203328089698667858, "content_hash": 2203328089698667858, "location": "02010101.xhp", "context": "02010101.xhp\npar_id3150647\nhelp.text", "note": "9eD8R", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 300, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 56, "source_unit": "https://translations.documentfoundation.org/api/units/107519318/?format=api", "priority": 100, "id": 107614042, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ca_VALENCIA/?checksum=9e93cb394e210d52", "url": "https://translations.documentfoundation.org/api/units/107614042/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T16:58:50.474377Z" } ] }