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/hyw/units/?format=api
{ "count": 1739, "next": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/hyw/units/?format=api&page=2", "previous": null, "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/hyw/?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": 96342263, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/hyw/?checksum=fcb9360a9f636de9", "url": "https://translations.documentfoundation.org/api/units/96342263/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:40:24.388060Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/hyw/?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": 96342273, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/hyw/?checksum=af9261c6732fd36a", "url": "https://translations.documentfoundation.org/api/units/96342273/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:40:24.391749Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/hyw/?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": 96342286, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/hyw/?checksum=3cd90160d8bc55b0", "url": "https://translations.documentfoundation.org/api/units/96342286/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:40:24.395688Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/hyw/?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": 96342296, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/hyw/?checksum=f4d7eef0cd53765d", "url": "https://translations.documentfoundation.org/api/units/96342296/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:40:24.399628Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/hyw/?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": 96342308, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/hyw/?checksum=9911e723644caad7", "url": "https://translations.documentfoundation.org/api/units/96342308/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:40:24.403555Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/hyw/?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": 96342320, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/hyw/?checksum=0deb652bc286cb5f", "url": "https://translations.documentfoundation.org/api/units/96342320/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:40:24.407461Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/hyw/?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": 96342330, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/hyw/?checksum=b297844f97daf183", "url": "https://translations.documentfoundation.org/api/units/96342330/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:40:24.411196Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/hyw/?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": 96342345, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/hyw/?checksum=b567c0ed3e4c0312", "url": "https://translations.documentfoundation.org/api/units/96342345/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:40:24.415750Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/hyw/?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": 96342357, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/hyw/?checksum=e56636d7d6748ac5", "url": "https://translations.documentfoundation.org/api/units/96342357/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:40:24.419908Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/hyw/?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": 96342368, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/hyw/?checksum=a020d1fd2a15e98b", "url": "https://translations.documentfoundation.org/api/units/96342368/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:40:24.423544Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/hyw/?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": 96342374, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/hyw/?checksum=4126469a166fbcb5", "url": "https://translations.documentfoundation.org/api/units/96342374/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:40:24.425250Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/hyw/?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": 96342378, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/hyw/?checksum=dd3ba288c5852b36", "url": "https://translations.documentfoundation.org/api/units/96342378/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:40:24.427172Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/hyw/?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": 96342385, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/hyw/?checksum=ba93a3b1fdc3efb8", "url": "https://translations.documentfoundation.org/api/units/96342385/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:40:24.428914Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/hyw/?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": 96342390, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/hyw/?checksum=f7c73a9691ea6d89", "url": "https://translations.documentfoundation.org/api/units/96342390/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:40:24.430485Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/hyw/?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": 96342400, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/hyw/?checksum=34d9043a307d36ef", "url": "https://translations.documentfoundation.org/api/units/96342400/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:40:24.434953Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/hyw/?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": 96342418, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/hyw/?checksum=91944ace196b0182", "url": "https://translations.documentfoundation.org/api/units/96342418/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:40:24.444429Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/hyw/?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": 96342422, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/hyw/?checksum=ee13f392ea47e39b", "url": "https://translations.documentfoundation.org/api/units/96342422/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:40:24.446133Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/hyw/?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": 96342424, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/hyw/?checksum=b1177a74f7d9e332", "url": "https://translations.documentfoundation.org/api/units/96342424/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:40:24.447678Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/hyw/?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": 96342428, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/hyw/?checksum=1ac6c359dd3366d7", "url": "https://translations.documentfoundation.org/api/units/96342428/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:40:24.449216Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/hyw/?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": 96342431, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/hyw/?checksum=abf257b542435a1b", "url": "https://translations.documentfoundation.org/api/units/96342431/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:40:24.450651Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/hyw/?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": 96342435, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/hyw/?checksum=e3999352b859f6ce", "url": "https://translations.documentfoundation.org/api/units/96342435/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:40:24.452239Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/hyw/?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": 96342441, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/hyw/?checksum=709593088328aead", "url": "https://translations.documentfoundation.org/api/units/96342441/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:40:24.453817Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/hyw/?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": 96342445, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/hyw/?checksum=b24818dd85363e5d", "url": "https://translations.documentfoundation.org/api/units/96342445/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:40:24.455364Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/hyw/?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": 96342450, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/hyw/?checksum=462a5d4af417175a", "url": "https://translations.documentfoundation.org/api/units/96342450/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:40:24.457107Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/hyw/?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": 96342456, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/hyw/?checksum=8ffadc3ede902bfa", "url": "https://translations.documentfoundation.org/api/units/96342456/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:40:24.459004Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/hyw/?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": 96342470, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/hyw/?checksum=91932d096cf9a266", "url": "https://translations.documentfoundation.org/api/units/96342470/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:40:24.463332Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/hyw/?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": 96342483, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/hyw/?checksum=86dc11d6756be577", "url": "https://translations.documentfoundation.org/api/units/96342483/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:40:24.467946Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/hyw/?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": 96342490, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/hyw/?checksum=632ddc136cb51477", "url": "https://translations.documentfoundation.org/api/units/96342490/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:40:24.470133Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/hyw/?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": 96342496, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/hyw/?checksum=c7bda96962d6eafe", "url": "https://translations.documentfoundation.org/api/units/96342496/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:40:24.472006Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/hyw/?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": 96342509, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/hyw/?checksum=097c617a77e8ddf5", "url": "https://translations.documentfoundation.org/api/units/96342509/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:40:24.474315Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/hyw/?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": 96342555, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/hyw/?checksum=e07abd2718925537", "url": "https://translations.documentfoundation.org/api/units/96342555/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:40:24.493518Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/hyw/?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": 96342565, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/hyw/?checksum=14270425a9cee626", "url": "https://translations.documentfoundation.org/api/units/96342565/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:40:24.501660Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/hyw/?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": 96342579, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/hyw/?checksum=ba088e280cd63fe1", "url": "https://translations.documentfoundation.org/api/units/96342579/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:40:24.509047Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/hyw/?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": 96342587, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/hyw/?checksum=02308bea64b4454c", "url": "https://translations.documentfoundation.org/api/units/96342587/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:40:24.512172Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/hyw/?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": 96342598, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/hyw/?checksum=dd9dd155c2ce0979", "url": "https://translations.documentfoundation.org/api/units/96342598/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:40:24.517663Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/hyw/?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": 96342605, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/hyw/?checksum=2e3fc76c5ddb32f8", "url": "https://translations.documentfoundation.org/api/units/96342605/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:40:24.521620Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/hyw/?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": 96342614, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/hyw/?checksum=d9c5bc2f9ce95743", "url": "https://translations.documentfoundation.org/api/units/96342614/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:40:24.526307Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/hyw/?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": 96342618, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/hyw/?checksum=2eb937393ad43b49", "url": "https://translations.documentfoundation.org/api/units/96342618/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:40:24.528302Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/hyw/?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": 96342635, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/hyw/?checksum=00844a4f87370bbb", "url": "https://translations.documentfoundation.org/api/units/96342635/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:40:24.534146Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/hyw/?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": 96342641, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/hyw/?checksum=62e4d663818421d2", "url": "https://translations.documentfoundation.org/api/units/96342641/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:40:24.536165Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/hyw/?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": 96342646, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/hyw/?checksum=6aa559d25ae98aba", "url": "https://translations.documentfoundation.org/api/units/96342646/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:40:24.538079Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/hyw/?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": 96342654, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/hyw/?checksum=c91e4cc986471d06", "url": "https://translations.documentfoundation.org/api/units/96342654/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:40:24.540028Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/hyw/?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": 96342658, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/hyw/?checksum=366bc2b01af04284", "url": "https://translations.documentfoundation.org/api/units/96342658/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:40:24.541682Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/hyw/?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": 96342664, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/hyw/?checksum=50d5ce9d11783c9a", "url": "https://translations.documentfoundation.org/api/units/96342664/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:40:24.543256Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/hyw/?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": 96342667, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/hyw/?checksum=a27cee0dfeff3de4", "url": "https://translations.documentfoundation.org/api/units/96342667/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:40:24.544888Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/hyw/?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": 96342672, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/hyw/?checksum=b56b2e54fec2ce3c", "url": "https://translations.documentfoundation.org/api/units/96342672/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:40:24.546388Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/hyw/?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": 96342676, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/hyw/?checksum=d67ba8b6822c99ea", "url": "https://translations.documentfoundation.org/api/units/96342676/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:40:24.547851Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/hyw/?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": 96342680, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/hyw/?checksum=2b245b18ee436e30", "url": "https://translations.documentfoundation.org/api/units/96342680/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:40:24.549309Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/hyw/?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": 96342683, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/hyw/?checksum=d4297045f3120bcc", "url": "https://translations.documentfoundation.org/api/units/96342683/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:40:24.550737Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/hyw/?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": 96342686, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/hyw/?checksum=0cccefa354efc54b", "url": "https://translations.documentfoundation.org/api/units/96342686/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:40:24.552121Z" } ] }