Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/libo_help-7-6/textsdatabase/it/units/?format=api&page=6
{ "count": 1739, "next": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/it/units/?format=api&page=7", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/it/units/?format=api&page=5", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/it/?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": [ "Tutte le espressioni di data (letterali di data) devono essere racchiuse tra virgolette singole (per ulteriori informazioni, consultate la documentazione relativa allo specifico database e al connettore che state utilizzando)." ], "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/95832235/?format=api", "priority": 100, "id": 96387209, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/it/?checksum=3f2535a9d80d6508", "url": "https://translations.documentfoundation.org/api/units/96387209/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:41:03.985985Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/it/?format=api", "source": [ "Querying Yes/No fields" ], "previous_source": "", "target": [ "Ricercare campi Sì/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/95832309/?format=api", "priority": 100, "id": 96387215, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/it/?checksum=f14bd7a10bd6cdf7", "url": "https://translations.documentfoundation.org/api/units/96387215/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:41:03.988134Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/it/?format=api", "source": [ "To query Yes/No fields, use the following syntax for dBASE tables:" ], "previous_source": "", "target": [ "Per eseguire ricerche nei campi Sì/No nelle tabelle dBase, utilizzate la seguente sintassi:" ], "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/95832346/?format=api", "priority": 100, "id": 96387219, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/it/?checksum=e8ab361ad24e5ef5", "url": "https://translations.documentfoundation.org/api/units/96387219/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:41:03.989804Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/it/?format=api", "source": [ "Status" ], "previous_source": "", "target": [ "Stato" ], "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/95832421/?format=api", "priority": 100, "id": 96387224, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/it/?checksum=6c07db2f6eb86b62", "url": "https://translations.documentfoundation.org/api/units/96387224/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:41:03.991629Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/it/?format=api", "source": [ "Query criterion" ], "previous_source": "", "target": [ "Criterio di ricerca" ], "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/95832452/?format=api", "priority": 100, "id": 96387229, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/it/?checksum=f80c95480647f882", "url": "https://translations.documentfoundation.org/api/units/96387229/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:41:03.993326Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/it/?format=api", "source": [ "Example" ], "previous_source": "", "target": [ "Esempio" ], "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/95832475/?format=api", "priority": 100, "id": 96387234, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/it/?checksum=f0fbae51c760029d", "url": "https://translations.documentfoundation.org/api/units/96387234/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:41:03.995513Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/it/?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/95832529/?format=api", "priority": 100, "id": 96387239, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/it/?checksum=c484871ad9e28012", "url": "https://translations.documentfoundation.org/api/units/96387239/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:41:03.999353Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/it/?format=api", "source": [ "for dBASE tables: not equal to any given value" ], "previous_source": "", "target": [ "per le tabelle dBASE: non uguale a qualsiasi valore dato" ], "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/95832559/?format=api", "priority": 100, "id": 96387245, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/it/?checksum=6b6141823bb17437", "url": "https://translations.documentfoundation.org/api/units/96387245/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:41:04.001767Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/it/?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 restituisce tutti i record di dati nei quali il campo Sì/No ha la condizione \"Sì\" o \"on\" (contrassegno nero)." ], "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/95832593/?format=api", "priority": 100, "id": 96387250, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/it/?checksum=b8dcc2ab05d5d79c", "url": "https://translations.documentfoundation.org/api/units/96387250/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:41:04.004054Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/it/?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/95832632/?format=api", "priority": 100, "id": 96387258, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/it/?checksum=6e6e9c1d01afb80c", "url": "https://translations.documentfoundation.org/api/units/96387258/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:41:04.007564Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/it/?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/95832676/?format=api", "priority": 100, "id": 96387272, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/it/?checksum=70aa55b10400329d", "url": "https://translations.documentfoundation.org/api/units/96387272/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:41:04.079717Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/it/?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 restituisce tutti i campi di dati nei quali il campo Sì/No ha la condizione \"No\" o \"off\" (nessun contrassegno)." ], "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/95832721/?format=api", "priority": 100, "id": 96387297, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/it/?checksum=48d74ca9cf82657b", "url": "https://translations.documentfoundation.org/api/units/96387297/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:41:04.093892Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/it/?format=api", "source": [ "Null" ], "previous_source": "", "target": [ "Vuoto" ], "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/95832780/?format=api", "priority": 100, "id": 96387302, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/it/?checksum=510c532e099f7565", "url": "https://translations.documentfoundation.org/api/units/96387302/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:41:04.095971Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/it/?format=api", "source": [ "IS NULL" ], "previous_source": "", "target": [ "È ZERO" ], "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/95832822/?format=api", "priority": 100, "id": 96387308, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/it/?checksum=d1caf16364dcea18", "url": "https://translations.documentfoundation.org/api/units/96387308/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:41:04.097803Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/it/?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": [ "È ZERO restituisce tutti i record di dati nei quali il campo Sì/No non ha nessuna delle due condizioni Sì o No (contrassegno grigio)." ], "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/95832852/?format=api", "priority": 100, "id": 96387312, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/it/?checksum=db60cbc6c3a97af0", "url": "https://translations.documentfoundation.org/api/units/96387312/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:41:04.099573Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/it/?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 sintassi dipende dal sistema di database utilizzato. Tenete presente inoltre che i campi Sì/No possono essere definiti in modo differente (solo con 2 stati invece di 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/95832907/?format=api", "priority": 100, "id": 96387318, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/it/?checksum=e45527a32629c77b", "url": "https://translations.documentfoundation.org/api/units/96387318/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:41:04.101494Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/it/?format=api", "source": [ "Parameter queries" ], "previous_source": "", "target": [ "Ricerche di parametri" ], "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/95832932/?format=api", "priority": 100, "id": 96387324, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/it/?checksum=8640cb55143edbe7", "url": "https://translations.documentfoundation.org/api/units/96387324/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:41:04.103453Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/it/?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": [ "Le ricerche di parametro consentono all'utente di immettere valori al tempo di esecuzione (runtime). Questo valori sono utilizzati all'interno dei criteri per selezionare i record da visualizzare. Ciascun valore dato è associato a un nome di parametro, il quale viene utilizzato per avvisare l'utente quando è avviata la ricerca." ], "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/95832959/?format=api", "priority": 100, "id": 96387329, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/it/?checksum=0f087ef2cd3405d3", "url": "https://translations.documentfoundation.org/api/units/96387329/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:41:04.105185Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/it/?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": [ "I nomi di parametro sono preceduti dai due punti sia nella vista struttura, sia nella vista SQL di una ricerca. Questo è applicabile ovunque possa apparire un valore. Se lo stesso valore deve apparire più di una volta nella ricerca, viene utilizzato lo stesso nome di parametro." ], "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/95832984/?format=api", "priority": 100, "id": 96387332, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/it/?checksum=b90e9a747be3f72e", "url": "https://translations.documentfoundation.org/api/units/96387332/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:41:04.107030Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/it/?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": [ "Nel caso più semplice, laddove l'utente inserisca un valore che viene individuato per uguaglianza, il nome di parametro, assieme ai due punti che lo precedono, va semplicemente inserito nella riga Criterio. In <link href=\"text/sdatabase/02010100.xhp#sqlmode\">modo SQL</link> questo deve essere digitato come <item type=\"input\">WHERE \"Campo\" = :Nome_parametro</item>" ], "id_hash": -8056140160250446947, "content_hash": -8056140160250446947, "location": "02010100.xhp", "context": "02010100.xhp\npar_id191120151905518123\nhelp.text", "note": "f2NMg", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "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/95833004/?format=api", "priority": 100, "id": 96387337, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/it/?checksum=1032d7351f837b9d", "url": "https://translations.documentfoundation.org/api/units/96387337/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:41:04.108780Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/it/?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": [ "I nomi di parametro non possono contenere i caratteri <item type=\"input\"><space>`!\"$%^*()+={}[]@'~#<>?/,</item>. Non possono essere uguali ai nomi di campo o alle parole riservate SQL. Possono essere uguali agli alias." ], "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/95833020/?format=api", "priority": 100, "id": 96387344, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/it/?checksum=9f137939443ff99b", "url": "https://translations.documentfoundation.org/api/units/96387344/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:41:04.111133Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/it/?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": [ "Un costrutto utile per la selezione dei record basata su parti del contenuto di un campo di testo è aggiungere una colonna nascosta con <item type=\"input\">\"LIKE '%' || :Parte_del_campo || '%'\"</item> come criterio. Il costrutto selezionerà i record con corrispondenza esatta. Se si richiede un test che non consideri le maiuscole/minuscole, una soluzione è usare <item type=\"input\">LOWER (Nome_Campo)</item> come campo e <item type=\"input\">LIKE LOWER ( '%' || :Parte_del_campo || '%' )</item> come criterio. Da notare che gli spazi nel criterio sono importanti; se vengono esclusi, l'analizzatore SQL considera l'intero criterio come una stringa da individuare. In <link href=\"text/sdatabase/02010100.xhp#sqlmode\">modo SQL</link> ciò deve essere digitato come <item type=\"input\">LOWER ( \"Nome_Campo\" ) LIKE LOWER ( '%' || :Parte_del_campo || '%' )</item>." ], "id_hash": 7359674384784650935, "content_hash": 7359674384784650935, "location": "02010100.xhp", "context": "02010100.xhp\npar_id191120151931441881\nhelp.text", "note": "WBEtt", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "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/95833042/?format=api", "priority": 100, "id": 96387349, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/it/?checksum=e622d0dc17a172b7", "url": "https://translations.documentfoundation.org/api/units/96387349/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:41:04.113698Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/it/?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": [ "Le ricerche di parametro possono essere utilizzate come sorgente dati per i <link href=\"text/shared/02/01170203.xhp\">formulari secondari</link>, al fine di consentire all'utente di ridurre i record visualizzati." ], "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/95833068/?format=api", "priority": 100, "id": 96387356, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/it/?checksum=9d40da7e1de2d565", "url": "https://translations.documentfoundation.org/api/units/96387356/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:41:04.116821Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/it/?format=api", "source": [ "Parameter Input" ], "previous_source": "", "target": [ "Specifica parametro" ], "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/95833093/?format=api", "priority": 100, "id": 96387361, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/it/?checksum=a2158a9cf1f1c2ad", "url": "https://translations.documentfoundation.org/api/units/96387361/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:41:04.119069Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/it/?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\">La finestra di dialogo <emph>Specifica parametro</emph> chiede all'utente di inserire i valori del parametro. Inserire un valore per ciascun parametro di ricerca e confermare facendo clic su <emph>OK</emph> o premendo <emph>Invio</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/95833119/?format=api", "priority": 100, "id": 96387365, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/it/?checksum=83ab6db864947e5d", "url": "https://translations.documentfoundation.org/api/units/96387365/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:41:04.120866Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/it/?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": [ "I valori inseriti dall'utente possono comprendere qualsiasi carattere consentito da SQL per il criterio attinente; ciò può dipendere dal sistema di database su cui si lavora." ], "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/95833207/?format=api", "priority": 100, "id": 96387373, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/it/?checksum=1651c3b512638dff", "url": "https://translations.documentfoundation.org/api/units/96387373/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:41:04.167558Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/it/?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'utente può utilizzare i caratteri jolly SQL \"%\" (stringa arbitraria) o \"_\" (singolo carattere arbitrario) come parte del valore, al fine di recuperare record in base a criteri più complessi." ], "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/95833263/?format=api", "priority": 100, "id": 96387379, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/it/?checksum=e776a92d0c8d3d59", "url": "https://translations.documentfoundation.org/api/units/96387379/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:41:04.173738Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/it/?format=api", "source": [ "SQL Mode" ], "previous_source": "", "target": [ "Modo 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/95833316/?format=api", "priority": 100, "id": 96387384, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/it/?checksum=ee5bc2a2964152df", "url": "https://translations.documentfoundation.org/api/units/96387384/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:41:04.175536Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/it/?format=api", "source": [ "SQL stands for \"Structured Query Language\" and describes instructions for updating and administering relational databases." ], "previous_source": "", "target": [ "SQL è l'abbreviazione di \"Structured Query Language\" e descrive le istruzioni per cercare, aggiornare e gestire database relazionali." ], "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/95833357/?format=api", "priority": 100, "id": 96387388, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/it/?checksum=a4b6dcf329a9f0dd", "url": "https://translations.documentfoundation.org/api/units/96387388/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:41:04.177049Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/it/?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": [ "In $[officename], per la maggior parte delle ricerche non è necessario che conosciate il linguaggio SQL, poiché non dovete inserire il codice SQL. Se create una ricerca con la struttura ricerca, $[officename] converte automaticamente le vostre istruzioni nella sintassi SQL corrispondente. Attivando la vista SQL con il pulsante <emph>Vista struttura sì/no</emph>, potete vedere i comandi SQL per le ricerche già create." ], "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/95833430/?format=api", "priority": 100, "id": 96387393, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/it/?checksum=ee354695204d6021", "url": "https://translations.documentfoundation.org/api/units/96387393/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:41:04.178644Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/it/?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": [ "Potete formulare la ricerca direttamente in codice SQL. In questo caso è opportuno ricordare che la sintassi speciale dipende dal sistema di database in uso." ], "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/95833473/?format=api", "priority": 100, "id": 96387400, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/it/?checksum=902fca834ddac001", "url": "https://translations.documentfoundation.org/api/units/96387400/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:41:04.180911Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/it/?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": [ "Se inserite manualmente il codice SQL, potete creare ricerche SQL specifiche che non devono essere supportate dall'interfaccia grafica nella <emph>Struttura ricerca</emph>. Queste ricerche devono essere eseguite in modo SQL nativo." ], "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/95833505/?format=api", "priority": 100, "id": 96387404, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/it/?checksum=ce4cf17f8192519d", "url": "https://translations.documentfoundation.org/api/units/96387404/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:41:04.182684Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/it/?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": [ "Con un clic sull'icona <link href=\"text/shared/02/14030000.xhp\"><emph>Esegui direttamente il comando SQL</emph></link> nella vista SQL, potete formulare una ricerca che sia inviata direttamente al motore di database, evitando che venga elaborata da $[officename]." ], "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/95833552/?format=api", "priority": 100, "id": 96387411, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/it/?checksum=71eeb3af9d062d58", "url": "https://translations.documentfoundation.org/api/units/96387411/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:41:04.184750Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/it/?format=api", "source": [ "Join Properties" ], "previous_source": "", "target": [ "Proprietà delle relazioni" ], "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/95833604/?format=api", "priority": 100, "id": 96387417, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/it/?checksum=2350847d295db268", "url": "https://translations.documentfoundation.org/api/units/96387417/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:41:04.186827Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/it/?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>Collegamento; database relazionali (Base)</bookmark_value><bookmark_value>Relazione interna (Base)</bookmark_value><bookmark_value>Relazione nei database (Base)</bookmark_value><bookmark_value>Relazione sinistra (Base)</bookmark_value><bookmark_value>Relazione destra (Base)</bookmark_value><bookmark_value>Relazione completa (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/95833631/?format=api", "priority": 100, "id": 96387424, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/it/?checksum=9210035be5d33172", "url": "https://translations.documentfoundation.org/api/units/96387424/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:41:04.188578Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/it/?format=api", "source": [ "Join Properties" ], "previous_source": "", "target": [ "Proprietà delle relazioni" ], "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/95833656/?format=api", "priority": 100, "id": 96387432, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/it/?checksum=a554c9728484b7f6", "url": "https://translations.documentfoundation.org/api/units/96387432/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:41:04.190704Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/it/?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": [ "Facendo doppio clic sulla connessione tra due campi collegati nella struttura ricerca, o scegliendo <emph>Inserisci - Nuova relazione</emph>, si apre la finestra di dialogo <emph>Proprietà delle relazioni</emph>. Queste proprietà verranno utilizzate in tutte le ricerche create successivamente." ], "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/95833679/?format=api", "priority": 100, "id": 96387438, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/it/?checksum=09840769a28d869e", "url": "https://translations.documentfoundation.org/api/units/96387438/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:41:04.192372Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/it/?format=api", "source": [ "Tables involved" ], "previous_source": "", "target": [ "Tabelle considerate" ], "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/95833715/?format=api", "priority": 100, "id": 96387442, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/it/?checksum=7f7ea52a5c88cf04", "url": "https://translations.documentfoundation.org/api/units/96387442/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:41:04.400948Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/it/?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\">Permette di specificare due diverse tabelle da collegare.</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/95833786/?format=api", "priority": 100, "id": 96387449, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/it/?checksum=9282d570bc64b349", "url": "https://translations.documentfoundation.org/api/units/96387449/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:41:04.406916Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/it/?format=api", "source": [ "Fields involved" ], "previous_source": "", "target": [ "Campi considerati" ], "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/95833829/?format=api", "priority": 100, "id": 96387453, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/it/?checksum=67292492f3b3b9fc", "url": "https://translations.documentfoundation.org/api/units/96387453/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:41:04.409274Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/it/?format=api", "source": [ "<ahelp hid=\".\">Specifies two data fields that will be joined by a relation.</ahelp>" ], "previous_source": "", "target": [ "<ahelp hid=\".\">Permette di specificare due campi di dati che saranno collegati mediante una relazione.</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/95833875/?format=api", "priority": 100, "id": 96387473, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/it/?checksum=e91cb6379d432b86", "url": "https://translations.documentfoundation.org/api/units/96387473/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:41:04.417936Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/it/?format=api", "source": [ "Options" ], "previous_source": "", "target": [ "Opzioni" ], "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/95833910/?format=api", "priority": 100, "id": 96387478, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/it/?checksum=5a3e2e02baefc234", "url": "https://translations.documentfoundation.org/api/units/96387478/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:41:04.420082Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/it/?format=api", "source": [ "Type" ], "previous_source": "", "target": [ "Tipo" ], "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/95833944/?format=api", "priority": 100, "id": 96387491, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/it/?checksum=47be67a46ecbb481", "url": "https://translations.documentfoundation.org/api/units/96387491/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:41:04.425989Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/it/?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\">Specifica di che tipo è la relazione selezionata.</ahelp> Alcuni database supportano solo un sottoinsieme di vari tipi possibili." ], "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/95833971/?format=api", "priority": 100, "id": 96387494, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/it/?checksum=1b13268f00c1be09", "url": "https://translations.documentfoundation.org/api/units/96387494/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:41:04.427648Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/it/?format=api", "source": [ "Inner Join" ], "previous_source": "", "target": [ "Relazione interna" ], "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": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/95834014/?format=api", "priority": 100, "id": 96387496, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/it/?checksum=16b89a1be24de5be", "url": "https://translations.documentfoundation.org/api/units/96387496/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:41:04.430626Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/it/?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\">In una relazione interna, la tabella dei risultati contiene solo quei record i cui campi collegati presentano lo stesso contenuto.</ahelp> In SQL di $[officename], questo tipo di relazione viene creato mediante una corrispondente clausola WHERE." ], "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/95834031/?format=api", "priority": 100, "id": 96387498, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/it/?checksum=2b26fe76b5bff5ae", "url": "https://translations.documentfoundation.org/api/units/96387498/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:41:04.432601Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/it/?format=api", "source": [ "Left Join" ], "previous_source": "", "target": [ "Relazione sinistra" ], "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/95834052/?format=api", "priority": 100, "id": 96387501, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/it/?checksum=01109622fd5b66ac", "url": "https://translations.documentfoundation.org/api/units/96387501/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:41:04.434869Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/it/?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\">In una relazione sinistra, la tabella dei risultati contiene tutti i record dei campi ricercati dalla tabella a sinistra e solo quei record dei campi ricercati dalla tabella a destra i cui campi collegati presentano lo stesso contenuto.</ahelp> In SQL di $[officename], questo tipo di relazione corrisponde al comando 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/95834075/?format=api", "priority": 100, "id": 96387513, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/it/?checksum=9659c117d22bba44", "url": "https://translations.documentfoundation.org/api/units/96387513/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:41:04.445992Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/it/?format=api", "source": [ "Right Join" ], "previous_source": "", "target": [ "Relazione destra" ], "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/95834092/?format=api", "priority": 100, "id": 96387517, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/it/?checksum=d40b62cb58fa23e8", "url": "https://translations.documentfoundation.org/api/units/96387517/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:41:04.448395Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/it/?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\">In una relazione destra, la tabella dei risultati contiene tutti i record dei campi ricercati dalla tabella a destra e solo quei record dei campi ricercati dalla tabella a sinistra i cui campi collegati presentano lo stesso contenuto.</ahelp> In SQL di $[officename], questo tipo di relazione corrisponde al comando 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/95834104/?format=api", "priority": 100, "id": 96387524, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/it/?checksum=9e93cb394e210d52", "url": "https://translations.documentfoundation.org/api/units/96387524/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:41:04.472017Z" } ] }