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/csb/units/?format=api
https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/units/?format=api&page=2", "previous": null, "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": 96042186, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=fcb9360a9f636de9", "url": "https://translations.documentfoundation.org/api/units/96042186/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:29.246577Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": 96042192, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=af9261c6732fd36a", "url": "https://translations.documentfoundation.org/api/units/96042192/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:29.279348Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": 96042195, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=3cd90160d8bc55b0", "url": "https://translations.documentfoundation.org/api/units/96042195/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:29.280975Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": 96042199, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=f4d7eef0cd53765d", "url": "https://translations.documentfoundation.org/api/units/96042199/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:29.282343Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": 96042204, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=9911e723644caad7", "url": "https://translations.documentfoundation.org/api/units/96042204/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:29.283790Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": 96042208, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=0deb652bc286cb5f", "url": "https://translations.documentfoundation.org/api/units/96042208/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:29.285387Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": 96042213, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=b297844f97daf183", "url": "https://translations.documentfoundation.org/api/units/96042213/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:29.286835Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": 96042218, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=b567c0ed3e4c0312", "url": "https://translations.documentfoundation.org/api/units/96042218/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:29.288196Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": 96042224, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=e56636d7d6748ac5", "url": "https://translations.documentfoundation.org/api/units/96042224/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:29.289592Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": 96042229, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=a020d1fd2a15e98b", "url": "https://translations.documentfoundation.org/api/units/96042229/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:29.291001Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": 96042234, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=4126469a166fbcb5", "url": "https://translations.documentfoundation.org/api/units/96042234/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:29.292699Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": 96042240, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=dd3ba288c5852b36", "url": "https://translations.documentfoundation.org/api/units/96042240/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:29.294202Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": 96042247, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=ba93a3b1fdc3efb8", "url": "https://translations.documentfoundation.org/api/units/96042247/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:29.295683Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": 96042253, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=f7c73a9691ea6d89", "url": "https://translations.documentfoundation.org/api/units/96042253/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:29.297218Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": 96042260, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=34d9043a307d36ef", "url": "https://translations.documentfoundation.org/api/units/96042260/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:29.298859Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": 96042265, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=91944ace196b0182", "url": "https://translations.documentfoundation.org/api/units/96042265/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:29.300473Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": 96042272, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=ee13f392ea47e39b", "url": "https://translations.documentfoundation.org/api/units/96042272/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:29.302037Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": 96042276, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=b1177a74f7d9e332", "url": "https://translations.documentfoundation.org/api/units/96042276/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:29.303619Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": 96042282, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=1ac6c359dd3366d7", "url": "https://translations.documentfoundation.org/api/units/96042282/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:29.305165Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": 96042290, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=abf257b542435a1b", "url": "https://translations.documentfoundation.org/api/units/96042290/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:29.306718Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": 96042295, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=e3999352b859f6ce", "url": "https://translations.documentfoundation.org/api/units/96042295/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:29.308252Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": 96042301, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=709593088328aead", "url": "https://translations.documentfoundation.org/api/units/96042301/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:29.309780Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": 96042307, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=b24818dd85363e5d", "url": "https://translations.documentfoundation.org/api/units/96042307/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:29.311330Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": 96042312, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=462a5d4af417175a", "url": "https://translations.documentfoundation.org/api/units/96042312/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:29.312869Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": 96042317, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=8ffadc3ede902bfa", "url": "https://translations.documentfoundation.org/api/units/96042317/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:29.314403Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": 96042324, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=91932d096cf9a266", "url": "https://translations.documentfoundation.org/api/units/96042324/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:29.316068Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": 96042331, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=86dc11d6756be577", "url": "https://translations.documentfoundation.org/api/units/96042331/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:29.317607Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": 96042339, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=632ddc136cb51477", "url": "https://translations.documentfoundation.org/api/units/96042339/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:29.320121Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": 96042345, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=c7bda96962d6eafe", "url": "https://translations.documentfoundation.org/api/units/96042345/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:29.321800Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": 96042351, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=097c617a77e8ddf5", "url": "https://translations.documentfoundation.org/api/units/96042351/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:29.323220Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": 96042357, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=e07abd2718925537", "url": "https://translations.documentfoundation.org/api/units/96042357/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:29.324490Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": 96042365, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=14270425a9cee626", "url": "https://translations.documentfoundation.org/api/units/96042365/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:29.325852Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": 96042371, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=ba088e280cd63fe1", "url": "https://translations.documentfoundation.org/api/units/96042371/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:29.327341Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": 96042376, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=02308bea64b4454c", "url": "https://translations.documentfoundation.org/api/units/96042376/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:29.329390Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": 96042382, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=dd9dd155c2ce0979", "url": "https://translations.documentfoundation.org/api/units/96042382/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:29.330718Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": 96042389, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=2e3fc76c5ddb32f8", "url": "https://translations.documentfoundation.org/api/units/96042389/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:29.332202Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": 96042395, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=d9c5bc2f9ce95743", "url": "https://translations.documentfoundation.org/api/units/96042395/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:29.333383Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": 96042397, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=2eb937393ad43b49", "url": "https://translations.documentfoundation.org/api/units/96042397/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:29.334527Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": 96042404, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=00844a4f87370bbb", "url": "https://translations.documentfoundation.org/api/units/96042404/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:29.335689Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": 96042410, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=62e4d663818421d2", "url": "https://translations.documentfoundation.org/api/units/96042410/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:29.337243Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": 96042414, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=6aa559d25ae98aba", "url": "https://translations.documentfoundation.org/api/units/96042414/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:29.338333Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": 96042420, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=c91e4cc986471d06", "url": "https://translations.documentfoundation.org/api/units/96042420/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:29.339758Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": 96042426, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=366bc2b01af04284", "url": "https://translations.documentfoundation.org/api/units/96042426/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:29.340994Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": 96042430, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=50d5ce9d11783c9a", "url": "https://translations.documentfoundation.org/api/units/96042430/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:29.342224Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": 96042436, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=a27cee0dfeff3de4", "url": "https://translations.documentfoundation.org/api/units/96042436/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:29.343683Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": 96042442, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=b56b2e54fec2ce3c", "url": "https://translations.documentfoundation.org/api/units/96042442/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:29.345065Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": 96042449, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=d67ba8b6822c99ea", "url": "https://translations.documentfoundation.org/api/units/96042449/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:29.346397Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": 96042452, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=2b245b18ee436e30", "url": "https://translations.documentfoundation.org/api/units/96042452/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:29.347527Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": 96042458, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=d4297045f3120bcc", "url": "https://translations.documentfoundation.org/api/units/96042458/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:29.348679Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": 96042465, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=0cccefa354efc54b", "url": "https://translations.documentfoundation.org/api/units/96042465/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:29.350170Z" } ] }{ "count": 1739, "next": "