Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/libo_help-24-2/textsdatabase/en_AU/units/?format=api
{ "count": 1739, "next": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en_AU/units/?format=api&page=2", "previous": null, "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en_AU/?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/107514289/?format=api", "priority": 100, "id": 107662854, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/en_AU/?checksum=fcb9360a9f636de9", "url": "https://translations.documentfoundation.org/api/units/107662854/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:21.564863Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en_AU/?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/107514309/?format=api", "priority": 100, "id": 107662856, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/en_AU/?checksum=af9261c6732fd36a", "url": "https://translations.documentfoundation.org/api/units/107662856/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:21.566681Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en_AU/?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/107514318/?format=api", "priority": 100, "id": 107662863, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/en_AU/?checksum=3cd90160d8bc55b0", "url": "https://translations.documentfoundation.org/api/units/107662863/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:21.576416Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en_AU/?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/107514329/?format=api", "priority": 100, "id": 107662865, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/en_AU/?checksum=f4d7eef0cd53765d", "url": "https://translations.documentfoundation.org/api/units/107662865/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:21.578634Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en_AU/?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/107514339/?format=api", "priority": 100, "id": 107662869, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/en_AU/?checksum=9911e723644caad7", "url": "https://translations.documentfoundation.org/api/units/107662869/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:21.580971Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en_AU/?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/107514356/?format=api", "priority": 100, "id": 107662873, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/en_AU/?checksum=0deb652bc286cb5f", "url": "https://translations.documentfoundation.org/api/units/107662873/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:21.583498Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en_AU/?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/107514376/?format=api", "priority": 100, "id": 107662875, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/en_AU/?checksum=b297844f97daf183", "url": "https://translations.documentfoundation.org/api/units/107662875/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:21.585366Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en_AU/?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/107514385/?format=api", "priority": 100, "id": 107662879, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/en_AU/?checksum=b567c0ed3e4c0312", "url": "https://translations.documentfoundation.org/api/units/107662879/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:21.587043Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en_AU/?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/107514392/?format=api", "priority": 100, "id": 107662883, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/en_AU/?checksum=e56636d7d6748ac5", "url": "https://translations.documentfoundation.org/api/units/107662883/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:21.588781Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en_AU/?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/107514402/?format=api", "priority": 100, "id": 107662887, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/en_AU/?checksum=a020d1fd2a15e98b", "url": "https://translations.documentfoundation.org/api/units/107662887/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:21.590621Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en_AU/?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/107514419/?format=api", "priority": 100, "id": 107662890, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/en_AU/?checksum=4126469a166fbcb5", "url": "https://translations.documentfoundation.org/api/units/107662890/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:21.592461Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en_AU/?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/107514438/?format=api", "priority": 100, "id": 107662892, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/en_AU/?checksum=dd3ba288c5852b36", "url": "https://translations.documentfoundation.org/api/units/107662892/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:21.594512Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en_AU/?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/107514451/?format=api", "priority": 100, "id": 107662894, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/en_AU/?checksum=ba93a3b1fdc3efb8", "url": "https://translations.documentfoundation.org/api/units/107662894/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:21.596431Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en_AU/?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/107514464/?format=api", "priority": 100, "id": 107662896, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/en_AU/?checksum=f7c73a9691ea6d89", "url": "https://translations.documentfoundation.org/api/units/107662896/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:21.598528Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en_AU/?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/107514473/?format=api", "priority": 100, "id": 107662901, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/en_AU/?checksum=34d9043a307d36ef", "url": "https://translations.documentfoundation.org/api/units/107662901/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:21.608399Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en_AU/?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/107514486/?format=api", "priority": 100, "id": 107662903, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/en_AU/?checksum=91944ace196b0182", "url": "https://translations.documentfoundation.org/api/units/107662903/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:21.610284Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en_AU/?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/107514498/?format=api", "priority": 100, "id": 107662905, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/en_AU/?checksum=ee13f392ea47e39b", "url": "https://translations.documentfoundation.org/api/units/107662905/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:21.612880Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en_AU/?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/107514506/?format=api", "priority": 100, "id": 107662907, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/en_AU/?checksum=b1177a74f7d9e332", "url": "https://translations.documentfoundation.org/api/units/107662907/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:21.614698Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en_AU/?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/107514519/?format=api", "priority": 100, "id": 107662908, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/en_AU/?checksum=1ac6c359dd3366d7", "url": "https://translations.documentfoundation.org/api/units/107662908/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:21.616013Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en_AU/?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/107514526/?format=api", "priority": 100, "id": 107662910, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/en_AU/?checksum=abf257b542435a1b", "url": "https://translations.documentfoundation.org/api/units/107662910/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:21.617252Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en_AU/?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/107514536/?format=api", "priority": 100, "id": 107662912, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/en_AU/?checksum=e3999352b859f6ce", "url": "https://translations.documentfoundation.org/api/units/107662912/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:21.618746Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en_AU/?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/107514546/?format=api", "priority": 100, "id": 107662913, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/en_AU/?checksum=709593088328aead", "url": "https://translations.documentfoundation.org/api/units/107662913/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:21.620045Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en_AU/?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/107514552/?format=api", "priority": 100, "id": 107662915, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/en_AU/?checksum=b24818dd85363e5d", "url": "https://translations.documentfoundation.org/api/units/107662915/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:21.621115Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en_AU/?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/107514561/?format=api", "priority": 100, "id": 107662917, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/en_AU/?checksum=462a5d4af417175a", "url": "https://translations.documentfoundation.org/api/units/107662917/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:21.622414Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en_AU/?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/107514582/?format=api", "priority": 100, "id": 107662918, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/en_AU/?checksum=8ffadc3ede902bfa", "url": "https://translations.documentfoundation.org/api/units/107662918/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:21.623886Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en_AU/?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/107514595/?format=api", "priority": 100, "id": 107662920, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/en_AU/?checksum=91932d096cf9a266", "url": "https://translations.documentfoundation.org/api/units/107662920/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:21.625332Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en_AU/?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/107514609/?format=api", "priority": 100, "id": 107662922, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/en_AU/?checksum=86dc11d6756be577", "url": "https://translations.documentfoundation.org/api/units/107662922/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:21.627011Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en_AU/?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/107514617/?format=api", "priority": 100, "id": 107662924, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/en_AU/?checksum=632ddc136cb51477", "url": "https://translations.documentfoundation.org/api/units/107662924/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:21.628828Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en_AU/?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/107514635/?format=api", "priority": 100, "id": 107662926, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/en_AU/?checksum=c7bda96962d6eafe", "url": "https://translations.documentfoundation.org/api/units/107662926/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:21.630357Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en_AU/?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/107514658/?format=api", "priority": 100, "id": 107662927, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/en_AU/?checksum=097c617a77e8ddf5", "url": "https://translations.documentfoundation.org/api/units/107662927/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:21.631759Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en_AU/?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/107514670/?format=api", "priority": 100, "id": 107662929, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/en_AU/?checksum=e07abd2718925537", "url": "https://translations.documentfoundation.org/api/units/107662929/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:21.633136Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en_AU/?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/107514683/?format=api", "priority": 100, "id": 107662931, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/en_AU/?checksum=14270425a9cee626", "url": "https://translations.documentfoundation.org/api/units/107662931/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:21.634678Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en_AU/?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/107514698/?format=api", "priority": 100, "id": 107662933, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/en_AU/?checksum=ba088e280cd63fe1", "url": "https://translations.documentfoundation.org/api/units/107662933/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:21.636421Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en_AU/?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/107514709/?format=api", "priority": 100, "id": 107662935, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/en_AU/?checksum=02308bea64b4454c", "url": "https://translations.documentfoundation.org/api/units/107662935/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:21.638064Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en_AU/?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/107514729/?format=api", "priority": 100, "id": 107662937, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/en_AU/?checksum=dd9dd155c2ce0979", "url": "https://translations.documentfoundation.org/api/units/107662937/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:21.639499Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en_AU/?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/107514741/?format=api", "priority": 100, "id": 107662939, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/en_AU/?checksum=2e3fc76c5ddb32f8", "url": "https://translations.documentfoundation.org/api/units/107662939/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:21.641024Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en_AU/?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/107514758/?format=api", "priority": 100, "id": 107662940, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/en_AU/?checksum=d9c5bc2f9ce95743", "url": "https://translations.documentfoundation.org/api/units/107662940/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:21.642393Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en_AU/?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/107514779/?format=api", "priority": 100, "id": 107662942, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/en_AU/?checksum=2eb937393ad43b49", "url": "https://translations.documentfoundation.org/api/units/107662942/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:21.643768Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en_AU/?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/107514801/?format=api", "priority": 100, "id": 107662943, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/en_AU/?checksum=00844a4f87370bbb", "url": "https://translations.documentfoundation.org/api/units/107662943/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:21.645149Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en_AU/?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/107514826/?format=api", "priority": 100, "id": 107662945, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/en_AU/?checksum=62e4d663818421d2", "url": "https://translations.documentfoundation.org/api/units/107662945/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:21.646697Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en_AU/?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/107514888/?format=api", "priority": 100, "id": 107662947, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/en_AU/?checksum=6aa559d25ae98aba", "url": "https://translations.documentfoundation.org/api/units/107662947/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:21.650597Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en_AU/?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/107514902/?format=api", "priority": 100, "id": 107662949, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/en_AU/?checksum=c91e4cc986471d06", "url": "https://translations.documentfoundation.org/api/units/107662949/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:21.654090Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en_AU/?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/107514936/?format=api", "priority": 100, "id": 107662951, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/en_AU/?checksum=366bc2b01af04284", "url": "https://translations.documentfoundation.org/api/units/107662951/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:21.659297Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en_AU/?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/107514961/?format=api", "priority": 100, "id": 107662954, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/en_AU/?checksum=50d5ce9d11783c9a", "url": "https://translations.documentfoundation.org/api/units/107662954/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:21.665343Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en_AU/?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/107514976/?format=api", "priority": 100, "id": 107662956, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/en_AU/?checksum=a27cee0dfeff3de4", "url": "https://translations.documentfoundation.org/api/units/107662956/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:21.669633Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en_AU/?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/107514989/?format=api", "priority": 100, "id": 107662957, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/en_AU/?checksum=b56b2e54fec2ce3c", "url": "https://translations.documentfoundation.org/api/units/107662957/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:21.672164Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en_AU/?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/107515007/?format=api", "priority": 100, "id": 107662958, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/en_AU/?checksum=d67ba8b6822c99ea", "url": "https://translations.documentfoundation.org/api/units/107662958/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:21.675585Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en_AU/?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/107515028/?format=api", "priority": 100, "id": 107662959, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/en_AU/?checksum=2b245b18ee436e30", "url": "https://translations.documentfoundation.org/api/units/107662959/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:21.677640Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en_AU/?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/107515069/?format=api", "priority": 100, "id": 107662961, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/en_AU/?checksum=d4297045f3120bcc", "url": "https://translations.documentfoundation.org/api/units/107662961/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:21.679500Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en_AU/?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/107515085/?format=api", "priority": 100, "id": 107662963, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/en_AU/?checksum=0cccefa354efc54b", "url": "https://translations.documentfoundation.org/api/units/107662963/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:21.681868Z" } ] }