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/en/units/?format=api
{ "count": 1739, "next": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/units/?format=api&page=2", "previous": null, "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?format=api", "source": [ "Queries" ], "previous_source": "", "target": [ "Queries" ], "id_hash": 8987273950646201833, "content_hash": 8987273950646201833, "location": "02000000.xhp", "context": "02000000.xhp\ntit\nhelp.text", "note": "ugSgG", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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": 95820924, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=fcb9360a9f636de9", "url": "https://translations.documentfoundation.org/api/units/95820924/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:03.687769Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?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": [ "<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>" ], "id_hash": 3427909771346301802, "content_hash": 3427909771346301802, "location": "02000000.xhp", "context": "02000000.xhp\nbm_id3150445\nhelp.text", "note": "nuBLG", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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": 95820965, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=af9261c6732fd36a", "url": "https://translations.documentfoundation.org/api/units/95820965/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:03.704599Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?format=api", "source": [ "<link href=\"text/sdatabase/02000000.xhp\">Queries</link>" ], "previous_source": "", "target": [ "<link href=\"text/sdatabase/02000000.xhp\">Queries</link>" ], "id_hash": -4838834809168177744, "content_hash": -4838834809168177744, "location": "02000000.xhp", "context": "02000000.xhp\nhd_id3150445\nhelp.text", "note": "BzrrZ", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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": 95821072, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=3cd90160d8bc55b0", "url": "https://translations.documentfoundation.org/api/units/95821072/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:03.823912Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?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": [ "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." ], "id_hash": 8419460746396792413, "content_hash": 8419460746396792413, "location": "02000000.xhp", "context": "02000000.xhp\npar_id3150499\nhelp.text", "note": "KaF9w", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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": 95821102, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=f4d7eef0cd53765d", "url": "https://translations.documentfoundation.org/api/units/95821102/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:03.841428Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?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": [ "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\"." ], "id_hash": 1806479064744897239, "content_hash": 1806479064744897239, "location": "02000000.xhp", "context": "02000000.xhp\npar_id3147399\nhelp.text", "note": "FG8C9", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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": 95821147, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=9911e723644caad7", "url": "https://translations.documentfoundation.org/api/units/95821147/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:03.869110Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?format=api", "source": [ "Printing Queries" ], "previous_source": "", "target": [ "Printing Queries" ], "id_hash": -8220365456213095585, "content_hash": -8220365456213095585, "location": "02000000.xhp", "context": "02000000.xhp\nhd_id3153750\nhelp.text", "note": "AuJW3", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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": 95821199, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=0deb652bc286cb5f", "url": "https://translations.documentfoundation.org/api/units/95821199/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:03.898207Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?format=api", "source": [ "To print a query or table:" ], "previous_source": "", "target": [ "To print a query or table:" ], "id_hash": 3645527900764696963, "content_hash": 3645527900764696963, "location": "02000000.xhp", "context": "02000000.xhp\npar_id3149183\nhelp.text", "note": "BVVMe", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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": 95821245, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=b297844f97daf183", "url": "https://translations.documentfoundation.org/api/units/95821245/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:03.920559Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?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": [ "Open a text document (or a spreadsheet document if you prefer the specific printing functions of this type of document)." ], "id_hash": 3848256531796329234, "content_hash": 3848256531796329234, "location": "02000000.xhp", "context": "02000000.xhp\npar_id3156426\nhelp.text", "note": "zDMbu", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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": 95821279, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=b567c0ed3e4c0312", "url": "https://translations.documentfoundation.org/api/units/95821279/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:03.930339Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?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": [ "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." ], "id_hash": 7306587746099038917, "content_hash": 7306587746099038917, "location": "02000000.xhp", "context": "02000000.xhp\npar_id3149827\nhelp.text", "note": "KFWTE", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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": 95821327, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=e56636d7d6748ac5", "url": "https://translations.documentfoundation.org/api/units/95821327/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:04.043852Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?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": [ "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." ], "id_hash": 2315081093731445131, "content_hash": 2315081093731445131, "location": "02000000.xhp", "context": "02000000.xhp\npar_id3149398\nhelp.text", "note": "KegMF", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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": 95821393, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=a020d1fd2a15e98b", "url": "https://translations.documentfoundation.org/api/units/95821393/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:04.079973Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?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": [ "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." ], "id_hash": -4528854747659125579, "content_hash": -4528854747659125579, "location": "02000000.xhp", "context": "02000000.xhp\npar_id3150443\nhelp.text", "note": "m5TnG", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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": 95821423, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=4126469a166fbcb5", "url": "https://translations.documentfoundation.org/api/units/95821423/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:04.092722Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?format=api", "source": [ "The query or table will be inserted into your document." ], "previous_source": "", "target": [ "The query or table will be inserted into your document." ], "id_hash": 6718141977466317622, "content_hash": 6718141977466317622, "location": "02000000.xhp", "context": "02000000.xhp\npar_id3153561\nhelp.text", "note": "AAQ4y", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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": 95821457, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=dd3ba288c5852b36", "url": "https://translations.documentfoundation.org/api/units/95821457/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:04.104520Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?format=api", "source": [ "Print the document by choosing <emph>File - Print</emph>." ], "previous_source": "", "target": [ "Print the document by choosing <emph>File - Print</emph>." ], "id_hash": 4220897260638302136, "content_hash": 4220897260638302136, "location": "02000000.xhp", "context": "02000000.xhp\npar_id3150503\nhelp.text", "note": "XDLzM", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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": 95821484, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=ba93a3b1fdc3efb8", "url": "https://translations.documentfoundation.org/api/units/95821484/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:04.168211Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?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": [ "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." ], "id_hash": 8630931629246410121, "content_hash": 8630931629246410121, "location": "02000000.xhp", "context": "02000000.xhp\npar_id3153146\nhelp.text", "note": "Kh9NG", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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": 95821508, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=f7c73a9691ea6d89", "url": "https://translations.documentfoundation.org/api/units/95821508/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:04.178888Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?format=api", "source": [ "<link href=\"text/shared/main0212.xhp\">Sorting and Filtering Data</link>" ], "previous_source": "", "target": [ "<link href=\"text/shared/main0212.xhp\">Sorting and Filtering Data</link>" ], "id_hash": -5415292428968184081, "content_hash": -5415292428968184081, "location": "02000000.xhp", "context": "02000000.xhp\nhd_id3148946\nhelp.text", "note": "2ygym", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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": 95821526, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=34d9043a307d36ef", "url": "https://translations.documentfoundation.org/api/units/95821526/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:04.190026Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?format=api", "source": [ "Allows you to sort and filter the data in a query table." ], "previous_source": "", "target": [ "Allows you to sort and filter the data in a query table." ], "id_hash": 1266719644248113538, "content_hash": 1266719644248113538, "location": "02000000.xhp", "context": "02000000.xhp\npar_id3149655\nhelp.text", "note": "ERCGr", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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": 95821545, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=91944ace196b0182", "url": "https://translations.documentfoundation.org/api/units/95821545/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:04.200338Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?format=api", "source": [ "<link href=\"text/sdatabase/02010100.xhp\">Query Design</link>" ], "previous_source": "", "target": [ "<link href=\"text/sdatabase/02010100.xhp\">Query Design</link>" ], "id_hash": 7931951181050930075, "content_hash": 7931951181050930075, "location": "02000000.xhp", "context": "02000000.xhp\nhd_id3153379\nhelp.text", "note": "xFrWT", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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": 95821570, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=ee13f392ea47e39b", "url": "https://translations.documentfoundation.org/api/units/95821570/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:04.210877Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?format=api", "source": [ "With the <emph>Query Design</emph>, you can create and edit a query or view." ], "previous_source": "", "target": [ "With the <emph>Query Design</emph>, you can create and edit a query or view." ], "id_hash": 3537430675115860786, "content_hash": 3537430675115860786, "location": "02000000.xhp", "context": "02000000.xhp\npar_id3151211\nhelp.text", "note": "3JCfK", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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": 95821593, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=b1177a74f7d9e332", "url": "https://translations.documentfoundation.org/api/units/95821593/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:04.221684Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?format=api", "source": [ "<link href=\"text/sdatabase/02010100.xhp\">Query Through Several Tables</link>" ], "previous_source": "", "target": [ "<link href=\"text/sdatabase/02010100.xhp\">Query Through Several Tables</link>" ], "id_hash": -7293927755749300521, "content_hash": -7293927755749300521, "location": "02000000.xhp", "context": "02000000.xhp\nhd_id3153968\nhelp.text", "note": "zXqLY", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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": 95821627, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=1ac6c359dd3366d7", "url": "https://translations.documentfoundation.org/api/units/95821627/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:04.241044Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?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": [ "The query result can contain data from several tables if these are linked to each other by suitable data fields." ], "id_hash": 3166689924007287323, "content_hash": 3166689924007287323, "location": "02000000.xhp", "context": "02000000.xhp\npar_id3151043\nhelp.text", "note": "ASeVi", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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": 95821668, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=abf257b542435a1b", "url": "https://translations.documentfoundation.org/api/units/95821668/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:04.265841Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?format=api", "source": [ "<link href=\"text/sdatabase/02010100.xhp\">Formulating Query Criteria</link>" ], "previous_source": "", "target": [ "<link href=\"text/sdatabase/02010100.xhp\">Formulating Query Criteria</link>" ], "id_hash": 7176929464681101006, "content_hash": 7176929464681101006, "location": "02000000.xhp", "context": "02000000.xhp\nhd_id3159149\nhelp.text", "note": "2SVKa", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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": 95821690, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=e3999352b859f6ce", "url": "https://translations.documentfoundation.org/api/units/95821690/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:04.280893Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?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": [ "You can find out which operators and commands can be used to formulate the filter conditions for a query." ], "id_hash": -1110820068307456339, "content_hash": -1110820068307456339, "location": "02000000.xhp", "context": "02000000.xhp\npar_id3154910\nhelp.text", "note": "JTXBF", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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": 95821751, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=709593088328aead", "url": "https://translations.documentfoundation.org/api/units/95821751/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:04.316832Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?format=api", "source": [ "<link href=\"text/sdatabase/02010100.xhp\">Executing Functions</link>" ], "previous_source": "", "target": [ "<link href=\"text/sdatabase/02010100.xhp\">Executing Functions</link>" ], "id_hash": 3623173239921327709, "content_hash": 3623173239921327709, "location": "02000000.xhp", "context": "02000000.xhp\nhd_id3156212\nhelp.text", "note": "nssDt", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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": 95821776, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=b24818dd85363e5d", "url": "https://translations.documentfoundation.org/api/units/95821776/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:04.330597Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?format=api", "source": [ "You can perform calculations with the data of a table and store the results as a query result." ], "previous_source": "", "target": [ "You can perform calculations with the data of a table and store the results as a query result." ], "id_hash": -4167415928673855654, "content_hash": -4167415928673855654, "location": "02000000.xhp", "context": "02000000.xhp\npar_id3144762\nhelp.text", "note": "FWCVa", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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": 95821789, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=462a5d4af417175a", "url": "https://translations.documentfoundation.org/api/units/95821789/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:04.352469Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?format=api", "source": [ "Missing Element" ], "previous_source": "", "target": [ "Missing Element" ], "id_hash": 1151474817326656506, "content_hash": 1151474817326656506, "location": "02000002.xhp", "context": "02000002.xhp\ntit\nhelp.text", "note": "BncmA", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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": 95821818, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=8ffadc3ede902bfa", "url": "https://translations.documentfoundation.org/api/units/95821818/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:04.392328Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?format=api", "source": [ "<bookmark_value>queries; missing elements (Base)</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>queries; missing elements (Base)</bookmark_value>" ], "id_hash": 1266405438727496294, "content_hash": 1266405438727496294, "location": "02000002.xhp", "context": "02000002.xhp\nbm_id3150445\nhelp.text", "note": "noWgR", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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": 95821824, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=91932d096cf9a266", "url": "https://translations.documentfoundation.org/api/units/95821824/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:04.405932Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?format=api", "source": [ "Missing Element" ], "previous_source": "", "target": [ "Missing Element" ], "id_hash": 494289671894590839, "content_hash": 494289671894590839, "location": "02000002.xhp", "context": "02000002.xhp\nhd_id3150445\nhelp.text", "note": "EoEQz", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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": 95821852, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=86dc11d6756be577", "url": "https://translations.documentfoundation.org/api/units/95821852/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:04.455531Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?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": [ "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." ], "id_hash": -2076761877161634697, "content_hash": -2076761877161634697, "location": "02000002.xhp", "context": "02000002.xhp\npar_id3150247\nhelp.text", "note": "X2NF9", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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": 95821902, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=632ddc136cb51477", "url": "https://translations.documentfoundation.org/api/units/95821902/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:04.488033Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?format=api", "source": [ "How to continue?" ], "previous_source": "", "target": [ "How to continue?" ], "id_hash": 5169474217386109694, "content_hash": 5169474217386109694, "location": "02000002.xhp", "context": "02000002.xhp\nhd_id3145072\nhelp.text", "note": "fBc3m", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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": 95821929, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=c7bda96962d6eafe", "url": "https://translations.documentfoundation.org/api/units/95821929/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:04.549699Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?format=api", "source": [ "There are three options available for answering this question:" ], "previous_source": "", "target": [ "There are three options available for answering this question:" ], "id_hash": -8539843614775648779, "content_hash": -8539843614775648779, "location": "02000002.xhp", "context": "02000002.xhp\npar_id3149177\nhelp.text", "note": "wV7Bh", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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": 95821964, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=097c617a77e8ddf5", "url": "https://translations.documentfoundation.org/api/units/95821964/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:04.561077Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?format=api", "source": [ "Do you really want to open the query in the graphic view?" ], "previous_source": "", "target": [ "Do you really want to open the query in the graphic view?" ], "id_hash": 6952076950413399351, "content_hash": 6952076950413399351, "location": "02000002.xhp", "context": "02000002.xhp\nhd_id3147576\nhelp.text", "note": "nwD7D", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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": 95821978, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=e07abd2718925537", "url": "https://translations.documentfoundation.org/api/units/95821978/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:04.569751Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?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": [ "<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." ], "id_hash": -7771238072195291610, "content_hash": -7771238072195291610, "location": "02000002.xhp", "context": "02000002.xhp\npar_id3166461\nhelp.text", "note": "qwqCZ", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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": 95822020, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=14270425a9cee626", "url": "https://translations.documentfoundation.org/api/units/95822020/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:04.646104Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?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": [ "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." ], "id_hash": 4181748556678709217, "content_hash": 4181748556678709217, "location": "02000002.xhp", "context": "02000002.xhp\npar_id3153031\nhelp.text", "note": "DX2vA", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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": 95822074, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=ba088e280cd63fe1", "url": "https://translations.documentfoundation.org/api/units/95822074/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:04.682928Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?format=api", "source": [ "Open the query in the SQL View" ], "previous_source": "", "target": [ "Open the query in the SQL View" ], "id_hash": -9065592211068664500, "content_hash": -9065592211068664500, "location": "02000002.xhp", "context": "02000002.xhp\nhd_id3149578\nhelp.text", "note": "477G3", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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": 95822134, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=02308bea64b4454c", "url": "https://translations.documentfoundation.org/api/units/95822134/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:04.708953Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?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": [ "<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)." ], "id_hash": 6745777983141579129, "content_hash": 6745777983141579129, "location": "02000002.xhp", "context": "02000002.xhp\npar_id3159157\nhelp.text", "note": "DL23B", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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": 95822170, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=dd9dd155c2ce0979", "url": "https://translations.documentfoundation.org/api/units/95822170/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:04.730920Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?format=api", "source": [ "Do not open the query" ], "previous_source": "", "target": [ "Do not open the query" ], "id_hash": -5890770519332277512, "content_hash": -5890770519332277512, "location": "02000002.xhp", "context": "02000002.xhp\nhd_id3150984\nhelp.text", "note": "2N4uG", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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": 95822192, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=2e3fc76c5ddb32f8", "url": "https://translations.documentfoundation.org/api/units/95822192/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:04.742755Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?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": [ "<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." ], "id_hash": 6468783352469608259, "content_hash": 6468783352469608259, "location": "02000002.xhp", "context": "02000002.xhp\npar_id3156329\nhelp.text", "note": "9hCbd", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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": 95822213, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=d9c5bc2f9ce95743", "url": "https://translations.documentfoundation.org/api/units/95822213/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:04.754939Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?format=api", "source": [ "Also ignore similar errors" ], "previous_source": "", "target": [ "Also ignore similar errors" ], "id_hash": -5856589121478968503, "content_hash": -5856589121478968503, "location": "02000002.xhp", "context": "02000002.xhp\nhd_id3148492\nhelp.text", "note": "4QDUr", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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": 95822242, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=2eb937393ad43b49", "url": "https://translations.documentfoundation.org/api/units/95822242/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:04.767263Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?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": [ "<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." ], "id_hash": -9186135634497565765, "content_hash": -9186135634497565765, "location": "02000002.xhp", "context": "02000002.xhp\npar_id3154285\nhelp.text", "note": "tv3MZ", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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": 95822262, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=00844a4f87370bbb", "url": "https://translations.documentfoundation.org/api/units/95822262/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:04.779757Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?format=api", "source": [ "Query Design" ], "previous_source": "", "target": [ "Query Design" ], "id_hash": -2097315803584781870, "content_hash": -2097315803584781870, "location": "02010100.xhp", "context": "02010100.xhp\ntit\nhelp.text", "note": "E3MVS", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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": 95822300, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=62e4d663818421d2", "url": "https://translations.documentfoundation.org/api/units/95822300/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:04.796535Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?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": [ "<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>" ], "id_hash": -1538724937673897286, "content_hash": -1538724937673897286, "location": "02010100.xhp", "context": "02010100.xhp\nbm_id3153323\nhelp.text", "note": "Ys2sC", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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": 95822375, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=6aa559d25ae98aba", "url": "https://translations.documentfoundation.org/api/units/95822375/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:04.821416Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?format=api", "source": [ "<link href=\"text/sdatabase/02010100.xhp\">Query Design</link>" ], "previous_source": "", "target": [ "<link href=\"text/sdatabase/02010100.xhp\">Query Design</link>" ], "id_hash": 5268733042495003910, "content_hash": 5268733042495003910, "location": "02010100.xhp", "context": "02010100.xhp\nhd_id3153394\nhelp.text", "note": "kJs5m", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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": 95823390, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=c91e4cc986471d06", "url": "https://translations.documentfoundation.org/api/units/95823390/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:06.075830Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?format=api", "source": [ "<ahelp hid=\".\">The <emph>Query Design View </emph>allows you to create and edit a database query.</ahelp>" ], "previous_source": "", "target": [ "<ahelp hid=\".\">The <emph>Query Design View </emph>allows you to create and edit a database query.</ahelp>" ], "id_hash": -5301930074676641148, "content_hash": -5301930074676641148, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3156411\nhelp.text", "note": "GU8Jd", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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": 95823440, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=366bc2b01af04284", "url": "https://translations.documentfoundation.org/api/units/95823440/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:06.091998Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?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": [ "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." ], "id_hash": -3398583169782891366, "content_hash": -3398583169782891366, "location": "02010100.xhp", "context": "02010100.xhp\npar_id7024140\nhelp.text", "note": "vGBE5", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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": 95823497, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=50d5ce9d11783c9a", "url": "https://translations.documentfoundation.org/api/units/95823497/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:06.104159Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?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": [ "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." ], "id_hash": 2485122838281797092, "content_hash": 2485122838281797092, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3159176\nhelp.text", "note": "WZcUE", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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": 95823531, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=a27cee0dfeff3de4", "url": "https://translations.documentfoundation.org/api/units/95823531/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:06.126947Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?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": [ "The Query Design window layout is stored with a created query, but cannot be stored with a created view." ], "id_hash": 3849221249104531004, "content_hash": 3849221249104531004, "location": "02010100.xhp", "context": "02010100.xhp\npar_id8307138\nhelp.text", "note": "JMyC7", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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": 95823559, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=b56b2e54fec2ce3c", "url": "https://translations.documentfoundation.org/api/units/95823559/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:06.141360Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?format=api", "source": [ "The Design View" ], "previous_source": "", "target": [ "The Design View" ], "id_hash": 6231760011218688490, "content_hash": 6231760011218688490, "location": "02010100.xhp", "context": "02010100.xhp\nhd_id3149233\nhelp.text", "note": "TEBj6", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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": 95823600, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=d67ba8b6822c99ea", "url": "https://translations.documentfoundation.org/api/units/95823600/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:06.163559Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?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": [ "To create a query, click the <emph>Queries</emph> icon in a database document, then click <emph>Create Query in Design View</emph>." ], "id_hash": -6114662231427551696, "content_hash": -6114662231427551696, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3145673\nhelp.text", "note": "zkTQc", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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": 95823626, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=2b245b18ee436e30", "url": "https://translations.documentfoundation.org/api/units/95823626/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:06.177785Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?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": [ "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." ], "id_hash": 6064501818964184012, "content_hash": 6064501818964184012, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3150255\nhelp.text", "note": "AtAHv", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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": 95823663, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=d4297045f3120bcc", "url": "https://translations.documentfoundation.org/api/units/95823663/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:06.190939Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?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": [ "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." ], "id_hash": -8300996528366959285, "content_hash": -8300996528366959285, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3152474\nhelp.text", "note": "74LSC", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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": 95823728, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=0cccefa354efc54b", "url": "https://translations.documentfoundation.org/api/units/95823728/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:06.209397Z" } ] }