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/ht/units/?format=api
https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/ht/units/?format=api&page=2", "previous": null, "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/ht/?format=api", "source": [ "Queries" ], "previous_source": "", "target": [ "" ], "id_hash": 8987273950646201833, "content_hash": 8987273950646201833, "location": "02000000.xhp", "context": "02000000.xhp\ntit\nhelp.text", "note": "ugSgG", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/95820924/?format=api", "priority": 100, "id": 96298903, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/ht/?checksum=fcb9360a9f636de9", "url": "https://translations.documentfoundation.org/api/units/96298903/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:39:44.183962Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/ht/?format=api", "source": [ "<bookmark_value>queries;overview (Base)</bookmark_value><bookmark_value>tables in databases; printing queries (Base)</bookmark_value><bookmark_value>printing; queries (Base)</bookmark_value><bookmark_value>queries; printing (Base)</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": 3427909771346301802, "content_hash": 3427909771346301802, "location": "02000000.xhp", "context": "02000000.xhp\nbm_id3150445\nhelp.text", "note": "nuBLG", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/95820965/?format=api", "priority": 100, "id": 96298906, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/ht/?checksum=af9261c6732fd36a", "url": "https://translations.documentfoundation.org/api/units/96298906/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:39:44.185508Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/ht/?format=api", "source": [ "<link href=\"text/sdatabase/02000000.xhp\">Queries</link>" ], "previous_source": "", "target": [ "" ], "id_hash": -4838834809168177744, "content_hash": -4838834809168177744, "location": "02000000.xhp", "context": "02000000.xhp\nhd_id3150445\nhelp.text", "note": "BzrrZ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 3, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/95821072/?format=api", "priority": 100, "id": 96298911, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/ht/?checksum=3cd90160d8bc55b0", "url": "https://translations.documentfoundation.org/api/units/96298911/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:39:44.186877Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/ht/?format=api", "source": [ "A \"query\" is a special view of a table. A query can display chosen records or chosen fields within records; it can also sort those records. A query can apply to one table or to multiple tables, if they are linked by common data fields." ], "previous_source": "", "target": [ "" ], "id_hash": 8419460746396792413, "content_hash": 8419460746396792413, "location": "02000000.xhp", "context": "02000000.xhp\npar_id3150499\nhelp.text", "note": "KaF9w", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 4, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 45, "source_unit": "https://translations.documentfoundation.org/api/units/95821102/?format=api", "priority": 100, "id": 96298913, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/ht/?checksum=f4d7eef0cd53765d", "url": "https://translations.documentfoundation.org/api/units/96298913/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:39:44.188169Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/ht/?format=api", "source": [ "Use queries to find records from data tables based on certain criteria. All queries created for a database are listed under the <emph>Queries</emph> entry. Since this entry contains the database queries, it is also called the \"query container\"." ], "previous_source": "", "target": [ "" ], "id_hash": 1806479064744897239, "content_hash": 1806479064744897239, "location": "02000000.xhp", "context": "02000000.xhp\npar_id3147399\nhelp.text", "note": "FG8C9", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 5, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 38, "source_unit": "https://translations.documentfoundation.org/api/units/95821147/?format=api", "priority": 100, "id": 96298917, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/ht/?checksum=9911e723644caad7", "url": "https://translations.documentfoundation.org/api/units/96298917/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:39:44.189553Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/ht/?format=api", "source": [ "Printing Queries" ], "previous_source": "", "target": [ "" ], "id_hash": -8220365456213095585, "content_hash": -8220365456213095585, "location": "02000000.xhp", "context": "02000000.xhp\nhd_id3153750\nhelp.text", "note": "AuJW3", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/95821199/?format=api", "priority": 100, "id": 96298922, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/ht/?checksum=0deb652bc286cb5f", "url": "https://translations.documentfoundation.org/api/units/96298922/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:39:44.191061Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/ht/?format=api", "source": [ "To print a query or table:" ], "previous_source": "", "target": [ "" ], "id_hash": 3645527900764696963, "content_hash": 3645527900764696963, "location": "02000000.xhp", "context": "02000000.xhp\npar_id3149183\nhelp.text", "note": "BVVMe", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/95821245/?format=api", "priority": 100, "id": 96298926, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/ht/?checksum=b297844f97daf183", "url": "https://translations.documentfoundation.org/api/units/96298926/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:39:44.192454Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/ht/?format=api", "source": [ "Open a text document (or a spreadsheet document if you prefer the specific printing functions of this type of document)." ], "previous_source": "", "target": [ "" ], "id_hash": 3848256531796329234, "content_hash": 3848256531796329234, "location": "02000000.xhp", "context": "02000000.xhp\npar_id3156426\nhelp.text", "note": "zDMbu", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 8, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 20, "source_unit": "https://translations.documentfoundation.org/api/units/95821279/?format=api", "priority": 100, "id": 96298931, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/ht/?checksum=b567c0ed3e4c0312", "url": "https://translations.documentfoundation.org/api/units/96298931/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:39:44.193941Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/ht/?format=api", "source": [ "Open the database file and click the Table icon if you want to print a table, or click the Query icon if you want to print a query." ], "previous_source": "", "target": [ "" ], "id_hash": 7306587746099038917, "content_hash": 7306587746099038917, "location": "02000000.xhp", "context": "02000000.xhp\npar_id3149827\nhelp.text", "note": "KFWTE", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 9, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 28, "source_unit": "https://translations.documentfoundation.org/api/units/95821327/?format=api", "priority": 100, "id": 96298936, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/ht/?checksum=e56636d7d6748ac5", "url": "https://translations.documentfoundation.org/api/units/96298936/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:39:44.195439Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/ht/?format=api", "source": [ "Drag the name of the table or query into the open text document or spreadsheet. The dialog <link href=\"text/shared/02/12070000.xhp\">Insert Database Columns</link> opens." ], "previous_source": "", "target": [ "" ], "id_hash": 2315081093731445131, "content_hash": 2315081093731445131, "location": "02000000.xhp", "context": "02000000.xhp\npar_id3149398\nhelp.text", "note": "KegMF", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 10, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 22, "source_unit": "https://translations.documentfoundation.org/api/units/95821393/?format=api", "priority": 100, "id": 96298941, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/ht/?checksum=a020d1fd2a15e98b", "url": "https://translations.documentfoundation.org/api/units/96298941/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:39:44.197023Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/ht/?format=api", "source": [ "Decide which columns = data fields you want to include. You can also click the <emph>AutoFormat</emph> button and select a corresponding formatting type. Close the dialog." ], "previous_source": "", "target": [ "" ], "id_hash": -4528854747659125579, "content_hash": -4528854747659125579, "location": "02000000.xhp", "context": "02000000.xhp\npar_id3150443\nhelp.text", "note": "m5TnG", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 11, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 26, "source_unit": "https://translations.documentfoundation.org/api/units/95821423/?format=api", "priority": 100, "id": 96298947, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/ht/?checksum=4126469a166fbcb5", "url": "https://translations.documentfoundation.org/api/units/96298947/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:39:44.198595Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/ht/?format=api", "source": [ "The query or table will be inserted into your document." ], "previous_source": "", "target": [ "" ], "id_hash": 6718141977466317622, "content_hash": 6718141977466317622, "location": "02000000.xhp", "context": "02000000.xhp\npar_id3153561\nhelp.text", "note": "AAQ4y", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 12, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/95821457/?format=api", "priority": 100, "id": 96298953, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/ht/?checksum=dd3ba288c5852b36", "url": "https://translations.documentfoundation.org/api/units/96298953/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:39:44.200188Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/ht/?format=api", "source": [ "Print the document by choosing <emph>File - Print</emph>." ], "previous_source": "", "target": [ "" ], "id_hash": 4220897260638302136, "content_hash": 4220897260638302136, "location": "02000000.xhp", "context": "02000000.xhp\npar_id3150503\nhelp.text", "note": "XDLzM", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 13, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/95821484/?format=api", "priority": 100, "id": 96298958, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/ht/?checksum=ba93a3b1fdc3efb8", "url": "https://translations.documentfoundation.org/api/units/96298958/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:39:44.201694Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/ht/?format=api", "source": [ "You can also open the data source view (Ctrl+Shift+F4), select the entire database table in the data source view (click on the top left corner of the table), and then drag the selection to a text document or spreadsheet." ], "previous_source": "", "target": [ "" ], "id_hash": 8630931629246410121, "content_hash": 8630931629246410121, "location": "02000000.xhp", "context": "02000000.xhp\npar_id3153146\nhelp.text", "note": "Kh9NG", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 14, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 39, "source_unit": "https://translations.documentfoundation.org/api/units/95821508/?format=api", "priority": 100, "id": 96298959, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/ht/?checksum=f7c73a9691ea6d89", "url": "https://translations.documentfoundation.org/api/units/96298959/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:39:44.203434Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/ht/?format=api", "source": [ "<link href=\"text/shared/main0212.xhp\">Sorting and Filtering Data</link>" ], "previous_source": "", "target": [ "" ], "id_hash": -5415292428968184081, "content_hash": -5415292428968184081, "location": "02000000.xhp", "context": "02000000.xhp\nhd_id3148946\nhelp.text", "note": "2ygym", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 15, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/95821526/?format=api", "priority": 100, "id": 96298968, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/ht/?checksum=34d9043a307d36ef", "url": "https://translations.documentfoundation.org/api/units/96298968/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:39:44.205531Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/ht/?format=api", "source": [ "Allows you to sort and filter the data in a query table." ], "previous_source": "", "target": [ "" ], "id_hash": 1266719644248113538, "content_hash": 1266719644248113538, "location": "02000000.xhp", "context": "02000000.xhp\npar_id3149655\nhelp.text", "note": "ERCGr", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 16, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/95821545/?format=api", "priority": 100, "id": 96298970, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/ht/?checksum=91944ace196b0182", "url": "https://translations.documentfoundation.org/api/units/96298970/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:39:44.207366Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/ht/?format=api", "source": [ "<link href=\"text/sdatabase/02010100.xhp\">Query Design</link>" ], "previous_source": "", "target": [ "" ], "id_hash": 7931951181050930075, "content_hash": 7931951181050930075, "location": "02000000.xhp", "context": "02000000.xhp\nhd_id3153379\nhelp.text", "note": "xFrWT", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 17, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/95821570/?format=api", "priority": 100, "id": 96298974, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/ht/?checksum=ee13f392ea47e39b", "url": "https://translations.documentfoundation.org/api/units/96298974/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:39:44.208825Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/ht/?format=api", "source": [ "With the <emph>Query Design</emph>, you can create and edit a query or view." ], "previous_source": "", "target": [ "" ], "id_hash": 3537430675115860786, "content_hash": 3537430675115860786, "location": "02000000.xhp", "context": "02000000.xhp\npar_id3151211\nhelp.text", "note": "3JCfK", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 18, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/95821593/?format=api", "priority": 100, "id": 96298985, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/ht/?checksum=b1177a74f7d9e332", "url": "https://translations.documentfoundation.org/api/units/96298985/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:39:44.211977Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/ht/?format=api", "source": [ "<link href=\"text/sdatabase/02010100.xhp\">Query Through Several Tables</link>" ], "previous_source": "", "target": [ "" ], "id_hash": -7293927755749300521, "content_hash": -7293927755749300521, "location": "02000000.xhp", "context": "02000000.xhp\nhd_id3153968\nhelp.text", "note": "zXqLY", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 19, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/95821627/?format=api", "priority": 100, "id": 96298989, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/ht/?checksum=1ac6c359dd3366d7", "url": "https://translations.documentfoundation.org/api/units/96298989/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:39:44.213616Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/ht/?format=api", "source": [ "The query result can contain data from several tables if these are linked to each other by suitable data fields." ], "previous_source": "", "target": [ "" ], "id_hash": 3166689924007287323, "content_hash": 3166689924007287323, "location": "02000000.xhp", "context": "02000000.xhp\npar_id3151043\nhelp.text", "note": "ASeVi", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 20, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 20, "source_unit": "https://translations.documentfoundation.org/api/units/95821668/?format=api", "priority": 100, "id": 96298995, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/ht/?checksum=abf257b542435a1b", "url": "https://translations.documentfoundation.org/api/units/96298995/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:39:44.215965Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/ht/?format=api", "source": [ "<link href=\"text/sdatabase/02010100.xhp\">Formulating Query Criteria</link>" ], "previous_source": "", "target": [ "" ], "id_hash": 7176929464681101006, "content_hash": 7176929464681101006, "location": "02000000.xhp", "context": "02000000.xhp\nhd_id3159149\nhelp.text", "note": "2SVKa", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 21, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/95821690/?format=api", "priority": 100, "id": 96299007, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/ht/?checksum=e3999352b859f6ce", "url": "https://translations.documentfoundation.org/api/units/96299007/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:39:44.220010Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/ht/?format=api", "source": [ "You can find out which operators and commands can be used to formulate the filter conditions for a query." ], "previous_source": "", "target": [ "" ], "id_hash": -1110820068307456339, "content_hash": -1110820068307456339, "location": "02000000.xhp", "context": "02000000.xhp\npar_id3154910\nhelp.text", "note": "JTXBF", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 22, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/95821751/?format=api", "priority": 100, "id": 96299011, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/ht/?checksum=709593088328aead", "url": "https://translations.documentfoundation.org/api/units/96299011/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:39:44.222278Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/ht/?format=api", "source": [ "<link href=\"text/sdatabase/02010100.xhp\">Executing Functions</link>" ], "previous_source": "", "target": [ "" ], "id_hash": 3623173239921327709, "content_hash": 3623173239921327709, "location": "02000000.xhp", "context": "02000000.xhp\nhd_id3156212\nhelp.text", "note": "nssDt", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 23, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/95821776/?format=api", "priority": 100, "id": 96299017, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/ht/?checksum=b24818dd85363e5d", "url": "https://translations.documentfoundation.org/api/units/96299017/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:39:44.223954Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/ht/?format=api", "source": [ "You can perform calculations with the data of a table and store the results as a query result." ], "previous_source": "", "target": [ "" ], "id_hash": -4167415928673855654, "content_hash": -4167415928673855654, "location": "02000000.xhp", "context": "02000000.xhp\npar_id3144762\nhelp.text", "note": "FWCVa", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 24, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/95821789/?format=api", "priority": 100, "id": 96299021, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/ht/?checksum=462a5d4af417175a", "url": "https://translations.documentfoundation.org/api/units/96299021/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:39:44.225445Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/ht/?format=api", "source": [ "Missing Element" ], "previous_source": "", "target": [ "" ], "id_hash": 1151474817326656506, "content_hash": 1151474817326656506, "location": "02000002.xhp", "context": "02000002.xhp\ntit\nhelp.text", "note": "BncmA", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 25, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/95821818/?format=api", "priority": 100, "id": 96299026, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/ht/?checksum=8ffadc3ede902bfa", "url": "https://translations.documentfoundation.org/api/units/96299026/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:39:44.226805Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/ht/?format=api", "source": [ "<bookmark_value>queries; missing elements (Base)</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": 1266405438727496294, "content_hash": 1266405438727496294, "location": "02000002.xhp", "context": "02000002.xhp\nbm_id3150445\nhelp.text", "note": "noWgR", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 26, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/95821824/?format=api", "priority": 100, "id": 96299029, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/ht/?checksum=91932d096cf9a266", "url": "https://translations.documentfoundation.org/api/units/96299029/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:39:44.227773Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/ht/?format=api", "source": [ "Missing Element" ], "previous_source": "", "target": [ "" ], "id_hash": 494289671894590839, "content_hash": 494289671894590839, "location": "02000002.xhp", "context": "02000002.xhp\nhd_id3150445\nhelp.text", "note": "EoEQz", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 27, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/95821852/?format=api", "priority": 100, "id": 96299040, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/ht/?checksum=86dc11d6756be577", "url": "https://translations.documentfoundation.org/api/units/96299040/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:39:44.230266Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/ht/?format=api", "source": [ "If a query in which tables or fields no longer exist is opened, the<emph> Missing Element </emph>dialog appears. This dialog names the missing table or the field which cannot be interpreted and allows you to decide how to continue with the procedure." ], "previous_source": "", "target": [ "" ], "id_hash": -2076761877161634697, "content_hash": -2076761877161634697, "location": "02000002.xhp", "context": "02000002.xhp\npar_id3150247\nhelp.text", "note": "X2NF9", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 28, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 42, "source_unit": "https://translations.documentfoundation.org/api/units/95821902/?format=api", "priority": 100, "id": 96299044, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/ht/?checksum=632ddc136cb51477", "url": "https://translations.documentfoundation.org/api/units/96299044/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:39:44.235151Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/ht/?format=api", "source": [ "How to continue?" ], "previous_source": "", "target": [ "" ], "id_hash": 5169474217386109694, "content_hash": 5169474217386109694, "location": "02000002.xhp", "context": "02000002.xhp\nhd_id3145072\nhelp.text", "note": "fBc3m", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 29, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/95821929/?format=api", "priority": 100, "id": 96299049, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/ht/?checksum=c7bda96962d6eafe", "url": "https://translations.documentfoundation.org/api/units/96299049/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:39:44.236860Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/ht/?format=api", "source": [ "There are three options available for answering this question:" ], "previous_source": "", "target": [ "" ], "id_hash": -8539843614775648779, "content_hash": -8539843614775648779, "location": "02000002.xhp", "context": "02000002.xhp\npar_id3149177\nhelp.text", "note": "wV7Bh", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 30, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/95821964/?format=api", "priority": 100, "id": 96299051, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/ht/?checksum=097c617a77e8ddf5", "url": "https://translations.documentfoundation.org/api/units/96299051/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:39:44.238358Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/ht/?format=api", "source": [ "Do you really want to open the query in the graphic view?" ], "previous_source": "", "target": [ "" ], "id_hash": 6952076950413399351, "content_hash": 6952076950413399351, "location": "02000002.xhp", "context": "02000002.xhp\nhd_id3147576\nhelp.text", "note": "nwD7D", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 31, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/95821978/?format=api", "priority": 100, "id": 96299055, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/ht/?checksum=e07abd2718925537", "url": "https://translations.documentfoundation.org/api/units/96299055/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:39:44.239846Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/ht/?format=api", "source": [ "<ahelp hid=\".\">Allows you to open the query in the <link href=\"text/sdatabase/02010100.xhp\">Design View</link> in spite of missing elements.</ahelp> This option also allows you to specify if other errors need to be ignored." ], "previous_source": "", "target": [ "" ], "id_hash": -7771238072195291610, "content_hash": -7771238072195291610, "location": "02000002.xhp", "context": "02000002.xhp\npar_id3166461\nhelp.text", "note": "qwqCZ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 32, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 31, "source_unit": "https://translations.documentfoundation.org/api/units/95822020/?format=api", "priority": 100, "id": 96299060, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/ht/?checksum=14270425a9cee626", "url": "https://translations.documentfoundation.org/api/units/96299060/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:39:44.241303Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/ht/?format=api", "source": [ "The query is opened in the Design View (the graphical interface). Missing tables appear blank and invalid fields appear with their (invalid) names in the list of fields. This lets you work with exactly those fields that caused the error." ], "previous_source": "", "target": [ "" ], "id_hash": 4181748556678709217, "content_hash": 4181748556678709217, "location": "02000002.xhp", "context": "02000002.xhp\npar_id3153031\nhelp.text", "note": "DX2vA", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 33, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 40, "source_unit": "https://translations.documentfoundation.org/api/units/95822074/?format=api", "priority": 100, "id": 96299065, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/ht/?checksum=ba088e280cd63fe1", "url": "https://translations.documentfoundation.org/api/units/96299065/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:39:44.242873Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/ht/?format=api", "source": [ "Open the query in the SQL View" ], "previous_source": "", "target": [ "" ], "id_hash": -9065592211068664500, "content_hash": -9065592211068664500, "location": "02000002.xhp", "context": "02000002.xhp\nhd_id3149578\nhelp.text", "note": "477G3", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 34, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/95822134/?format=api", "priority": 100, "id": 96299071, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/ht/?checksum=02308bea64b4454c", "url": "https://translations.documentfoundation.org/api/units/96299071/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:39:44.245007Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/ht/?format=api", "source": [ "<ahelp hid=\".\">Allows you to open the query design in the <link href=\"text/sdatabase/02010100.xhp\">SQL Mode</link> and to interpret the query as a <link href=\"text/shared/02/14030000.xhp\">Native SQL</link>.</ahelp> You can only quit the native SQL mode when the $[officename] statement is completely interpreted (only possible if the used tables or fields in the query really exist)." ], "previous_source": "", "target": [ "" ], "id_hash": 6745777983141579129, "content_hash": 6745777983141579129, "location": "02000002.xhp", "context": "02000002.xhp\npar_id3159157\nhelp.text", "note": "DL23B", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 35, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 51, "source_unit": "https://translations.documentfoundation.org/api/units/95822170/?format=api", "priority": 100, "id": 96299077, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/ht/?checksum=dd9dd155c2ce0979", "url": "https://translations.documentfoundation.org/api/units/96299077/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:39:44.246603Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/ht/?format=api", "source": [ "Do not open the query" ], "previous_source": "", "target": [ "" ], "id_hash": -5890770519332277512, "content_hash": -5890770519332277512, "location": "02000002.xhp", "context": "02000002.xhp\nhd_id3150984\nhelp.text", "note": "2N4uG", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 36, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/95822192/?format=api", "priority": 100, "id": 96299083, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/ht/?checksum=2e3fc76c5ddb32f8", "url": "https://translations.documentfoundation.org/api/units/96299083/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:39:44.248860Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/ht/?format=api", "source": [ "<ahelp hid=\".\">Allows you to cancel the procedure and specify that the query should not be opened.</ahelp> This option corresponds to the function of the <emph>Cancel</emph> dialog button." ], "previous_source": "", "target": [ "" ], "id_hash": 6468783352469608259, "content_hash": 6468783352469608259, "location": "02000002.xhp", "context": "02000002.xhp\npar_id3156329\nhelp.text", "note": "9hCbd", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 37, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 27, "source_unit": "https://translations.documentfoundation.org/api/units/95822213/?format=api", "priority": 100, "id": 96299092, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/ht/?checksum=d9c5bc2f9ce95743", "url": "https://translations.documentfoundation.org/api/units/96299092/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:39:44.251289Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/ht/?format=api", "source": [ "Also ignore similar errors" ], "previous_source": "", "target": [ "" ], "id_hash": -5856589121478968503, "content_hash": -5856589121478968503, "location": "02000002.xhp", "context": "02000002.xhp\nhd_id3148492\nhelp.text", "note": "4QDUr", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 38, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/95822242/?format=api", "priority": 100, "id": 96299126, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/ht/?checksum=2eb937393ad43b49", "url": "https://translations.documentfoundation.org/api/units/96299126/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:39:44.268617Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/ht/?format=api", "source": [ "<ahelp hid=\".\">If you selected the first option, but you still want to open the query in the graphics view in spite of missing elements, you can specify whether other errors are ignored.</ahelp> Therefore, in the current opening process, no error message will be displayed if the query can not be correctly interpreted." ], "previous_source": "", "target": [ "" ], "id_hash": -9186135634497565765, "content_hash": -9186135634497565765, "location": "02000002.xhp", "context": "02000002.xhp\npar_id3154285\nhelp.text", "note": "tv3MZ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 39, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 52, "source_unit": "https://translations.documentfoundation.org/api/units/95822262/?format=api", "priority": 100, "id": 96299132, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/ht/?checksum=00844a4f87370bbb", "url": "https://translations.documentfoundation.org/api/units/96299132/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:39:44.270442Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/ht/?format=api", "source": [ "Query Design" ], "previous_source": "", "target": [ "" ], "id_hash": -2097315803584781870, "content_hash": -2097315803584781870, "location": "02010100.xhp", "context": "02010100.xhp\ntit\nhelp.text", "note": "E3MVS", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 40, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/95822300/?format=api", "priority": 100, "id": 96299136, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/ht/?checksum=62e4d663818421d2", "url": "https://translations.documentfoundation.org/api/units/96299136/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:39:44.272438Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/ht/?format=api", "source": [ "<bookmark_value>views; creating database views (Base)</bookmark_value> <bookmark_value>queries; creating in design view (Base)</bookmark_value> <bookmark_value>designing; queries (Base)</bookmark_value> <bookmark_value>design view; queries/views (Base)</bookmark_value> <bookmark_value>joining;tables (Base)</bookmark_value> <bookmark_value>tables in databases; joining for queries (Base)</bookmark_value> <bookmark_value>queries; joining tables (Base)</bookmark_value> <bookmark_value>tables in databases; relations (Base)</bookmark_value> <bookmark_value>relations; joining tables (Base)</bookmark_value> <bookmark_value>queries; deleting table links (Base)</bookmark_value> <bookmark_value>criteria of query design (Base)</bookmark_value> <bookmark_value>queries; formulating filter conditions (Base)</bookmark_value> <bookmark_value>filter conditions;in queries (Base)</bookmark_value> <bookmark_value>parameters; queries (Base)</bookmark_value> <bookmark_value>queries; parameter queries (Base)</bookmark_value> <bookmark_value>SQL; queries (Base)</bookmark_value> <bookmark_value>native SQL (Base)</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": -1538724937673897286, "content_hash": -1538724937673897286, "location": "02010100.xhp", "context": "02010100.xhp\nbm_id3153323\nhelp.text", "note": "Ys2sC", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 41, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 72, "source_unit": "https://translations.documentfoundation.org/api/units/95822375/?format=api", "priority": 100, "id": 96299141, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/ht/?checksum=6aa559d25ae98aba", "url": "https://translations.documentfoundation.org/api/units/96299141/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:39:44.273756Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/ht/?format=api", "source": [ "<link href=\"text/sdatabase/02010100.xhp\">Query Design</link>" ], "previous_source": "", "target": [ "" ], "id_hash": 5268733042495003910, "content_hash": 5268733042495003910, "location": "02010100.xhp", "context": "02010100.xhp\nhd_id3153394\nhelp.text", "note": "kJs5m", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 42, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/95823390/?format=api", "priority": 100, "id": 96299145, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/ht/?checksum=c91e4cc986471d06", "url": "https://translations.documentfoundation.org/api/units/96299145/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:39:44.275264Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/ht/?format=api", "source": [ "<ahelp hid=\".\">The <emph>Query Design View </emph>allows you to create and edit a database query.</ahelp>" ], "previous_source": "", "target": [ "" ], "id_hash": -5301930074676641148, "content_hash": -5301930074676641148, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3156411\nhelp.text", "note": "GU8Jd", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 43, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/95823440/?format=api", "priority": 100, "id": 96299151, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/ht/?checksum=366bc2b01af04284", "url": "https://translations.documentfoundation.org/api/units/96299151/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:39:44.276660Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/ht/?format=api", "source": [ "Most databases use queries to filter or to sort database tables to display records on your computer. Views offer the same functionality as queries, but on the server side. If your database is on a server that supports views, you can use views to filter the records on the server to speed up the display time." ], "previous_source": "", "target": [ "" ], "id_hash": -3398583169782891366, "content_hash": -3398583169782891366, "location": "02010100.xhp", "context": "02010100.xhp\npar_id7024140\nhelp.text", "note": "vGBE5", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 44, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 56, "source_unit": "https://translations.documentfoundation.org/api/units/95823497/?format=api", "priority": 100, "id": 96299156, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/ht/?checksum=50d5ce9d11783c9a", "url": "https://translations.documentfoundation.org/api/units/96299156/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:39:44.278261Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/ht/?format=api", "source": [ "Selecting the <emph>Create View</emph> command from the <emph>Tables</emph> tab page of a database document, you see the <emph>View Design</emph> window that resembles the <emph>Query Design</emph> window described here." ], "previous_source": "", "target": [ "" ], "id_hash": 2485122838281797092, "content_hash": 2485122838281797092, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3159176\nhelp.text", "note": "WZcUE", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 45, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 28, "source_unit": "https://translations.documentfoundation.org/api/units/95823531/?format=api", "priority": 100, "id": 96299160, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/ht/?checksum=a27cee0dfeff3de4", "url": "https://translations.documentfoundation.org/api/units/96299160/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:39:44.279673Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/ht/?format=api", "source": [ "The Query Design window layout is stored with a created query, but cannot be stored with a created view." ], "previous_source": "", "target": [ "" ], "id_hash": 3849221249104531004, "content_hash": 3849221249104531004, "location": "02010100.xhp", "context": "02010100.xhp\npar_id8307138\nhelp.text", "note": "JMyC7", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 46, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/95823559/?format=api", "priority": 100, "id": 96299166, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/ht/?checksum=b56b2e54fec2ce3c", "url": "https://translations.documentfoundation.org/api/units/96299166/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:39:44.281143Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/ht/?format=api", "source": [ "The Design View" ], "previous_source": "", "target": [ "" ], "id_hash": 6231760011218688490, "content_hash": 6231760011218688490, "location": "02010100.xhp", "context": "02010100.xhp\nhd_id3149233\nhelp.text", "note": "TEBj6", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 47, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/95823600/?format=api", "priority": 100, "id": 96299171, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/ht/?checksum=d67ba8b6822c99ea", "url": "https://translations.documentfoundation.org/api/units/96299171/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:39:44.282491Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/ht/?format=api", "source": [ "To create a query, click the <emph>Queries</emph> icon in a database document, then click <emph>Create Query in Design View</emph>." ], "previous_source": "", "target": [ "" ], "id_hash": -6114662231427551696, "content_hash": -6114662231427551696, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3145673\nhelp.text", "note": "zkTQc", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 48, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/95823626/?format=api", "priority": 100, "id": 96299175, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/ht/?checksum=2b245b18ee436e30", "url": "https://translations.documentfoundation.org/api/units/96299175/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:39:44.283857Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/ht/?format=api", "source": [ "The lower pane of the Design View is where you define the query. To define a query, specify the database field names to include and the criteria for displaying the fields. To rearrange the columns in the lower pane of the Design View, drag a column header to a new location, or select the column and press <switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+arrow key." ], "previous_source": "", "target": [ "" ], "id_hash": 6064501818964184012, "content_hash": 6064501818964184012, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3150255\nhelp.text", "note": "AtAHv", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 49, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 61, "source_unit": "https://translations.documentfoundation.org/api/units/95823663/?format=api", "priority": 100, "id": 96299180, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/ht/?checksum=d4297045f3120bcc", "url": "https://translations.documentfoundation.org/api/units/96299180/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:39:44.285408Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/ht/?format=api", "source": [ "In the top of the query Design View window, the <link href=\"text/shared/main0214.xhp\">icons</link> of the <emph>Query Design</emph> Bar and the <emph>Design</emph> bar are displayed." ], "previous_source": "", "target": [ "" ], "id_hash": -8300996528366959285, "content_hash": -8300996528366959285, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3152474\nhelp.text", "note": "74LSC", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 50, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 23, "source_unit": "https://translations.documentfoundation.org/api/units/95823728/?format=api", "priority": 100, "id": 96299186, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/ht/?checksum=0cccefa354efc54b", "url": "https://translations.documentfoundation.org/api/units/96299186/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:39:44.287018Z" } ] }{ "count": 1739, "next": "