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&page=2
{ "count": 1739, "next": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/units/?format=api&page=3", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/units/?format=api", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?format=api", "source": [ "If you want to test a query, double-click the query name in the database document. The query result is displayed in a table similar to the Data Source View. Note: the table displayed is only temporary." ], "previous_source": "", "target": [ "If you want to test a query, double-click the query name in the database document. The query result is displayed in a table similar to the Data Source View. Note: the table displayed is only temporary." ], "id_hash": 6820986015982142173, "content_hash": 6820986015982142173, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3147559\nhelp.text", "note": "hYsxY", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 51, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 36, "source_unit": "https://translations.documentfoundation.org/api/units/95823752/?format=api", "priority": 100, "id": 95823752, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=dea902a47485c2dd", "url": "https://translations.documentfoundation.org/api/units/95823752/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:06.221492Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?format=api", "source": [ "Keys in Query Design View" ], "previous_source": "", "target": [ "Keys in Query Design View" ], "id_hash": -7932066688871041264, "content_hash": -7932066688871041264, "location": "02010100.xhp", "context": "02010100.xhp\nhd_id8226264\nhelp.text", "note": "B4HEH", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 52, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/95823777/?format=api", "priority": 100, "id": 95823777, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=11eba35f5321f710", "url": "https://translations.documentfoundation.org/api/units/95823777/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:06.301860Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?format=api", "source": [ "Key" ], "previous_source": "", "target": [ "Key" ], "id_hash": -962556843198878189, "content_hash": -962556843198878189, "location": "02010100.xhp", "context": "02010100.xhp\npar_id2341074\nhelp.text", "note": "Cvd4o", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 53, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/95823831/?format=api", "priority": 100, "id": 95823831, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=72a44fa6a5026e13", "url": "https://translations.documentfoundation.org/api/units/95823831/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:06.489032Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?format=api", "source": [ "Function" ], "previous_source": "", "target": [ "Function" ], "id_hash": -7303047899249108812, "content_hash": -7303047899249108812, "location": "02010100.xhp", "context": "02010100.xhp\npar_id4384289\nhelp.text", "note": "mCy9S", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 54, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/95823862/?format=api", "priority": 100, "id": 95823862, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=1aa65ca0fb9818b4", "url": "https://translations.documentfoundation.org/api/units/95823862/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:06.500538Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?format=api", "source": [ "F4" ], "previous_source": "", "target": [ "F4" ], "id_hash": -7146258811191257841, "content_hash": -7146258811191257841, "location": "02010100.xhp", "context": "02010100.xhp\npar_id5839106\nhelp.text", "note": "yybiC", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 55, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/95823875/?format=api", "priority": 100, "id": 95823875, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=1cd3637945f0950f", "url": "https://translations.documentfoundation.org/api/units/95823875/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:06.509549Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?format=api", "source": [ "Preview" ], "previous_source": "", "target": [ "Preview" ], "id_hash": -4612140030574225561, "content_hash": -4612140030574225561, "location": "02010100.xhp", "context": "02010100.xhp\npar_id8554338\nhelp.text", "note": "FMTZD", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 56, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/95823876/?format=api", "priority": 100, "id": 95823876, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=3ffe63140f439767", "url": "https://translations.documentfoundation.org/api/units/95823876/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:06.519780Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?format=api", "source": [ "F5" ], "previous_source": "", "target": [ "F5" ], "id_hash": -8915539007946402489, "content_hash": -8915539007946402489, "location": "02010100.xhp", "context": "02010100.xhp\npar_id1254921\nhelp.text", "note": "YQhGF", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 57, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/95823877/?format=api", "priority": 100, "id": 95823877, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=0445a48242375547", "url": "https://translations.documentfoundation.org/api/units/95823877/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:06.530451Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?format=api", "source": [ "Run Query" ], "previous_source": "", "target": [ "Run Query" ], "id_hash": 4695158386326058876, "content_hash": 4695158386326058876, "location": "02010100.xhp", "context": "02010100.xhp\npar_id7636646\nhelp.text", "note": "C9yhE", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 58, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/95823885/?format=api", "priority": 100, "id": 95823885, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=c1288dad2529377c", "url": "https://translations.documentfoundation.org/api/units/95823885/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:06.542458Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?format=api", "source": [ "F7" ], "previous_source": "", "target": [ "F7" ], "id_hash": 1119030469261168773, "content_hash": 1119030469261168773, "location": "02010100.xhp", "context": "02010100.xhp\npar_id8579363\nhelp.text", "note": "jdEeJ", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 59, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/95823926/?format=api", "priority": 100, "id": 95823926, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=8f8798486d269085", "url": "https://translations.documentfoundation.org/api/units/95823926/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:06.619870Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?format=api", "source": [ "Add Table or Query" ], "previous_source": "", "target": [ "Add Table or Query" ], "id_hash": 1690990852192008086, "content_hash": 1690990852192008086, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3227942\nhelp.text", "note": "6Y6Uw", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 60, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/95823950/?format=api", "priority": 100, "id": 95823950, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=97779b388756f796", "url": "https://translations.documentfoundation.org/api/units/95823950/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:06.636511Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?format=api", "source": [ "Browse" ], "previous_source": "", "target": [ "Browse" ], "id_hash": 1662000235044191429, "content_hash": 1662000235044191429, "location": "02010100.xhp", "context": "02010100.xhp\nhd_id3154939\nhelp.text", "note": "WN7wR", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 61, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/95824009/?format=api", "priority": 100, "id": 95824009, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=97109c687a6cbcc5", "url": "https://translations.documentfoundation.org/api/units/95824009/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:06.667554Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?format=api", "source": [ "When you open the query design for the first time, you see a dialog in which you must first select the table or query that will be the basis for your new query." ], "previous_source": "", "target": [ "When you open the query design for the first time, you see a dialog in which you must first select the table or query that will be the basis for your new query." ], "id_hash": -1659182560932958370, "content_hash": -1659182560932958370, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3148799\nhelp.text", "note": "5y4VZ", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 62, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 33, "source_unit": "https://translations.documentfoundation.org/api/units/95824037/?format=api", "priority": 100, "id": 95824037, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=68f9664066116f5e", "url": "https://translations.documentfoundation.org/api/units/95824037/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:06.678925Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?format=api", "source": [ "<ahelp hid=\"HID_CTL_QRYDGNTAB\">Double-click fields to add them to the query. Drag-and-drop to define relations.</ahelp>" ], "previous_source": "", "target": [ "<ahelp hid=\"HID_CTL_QRYDGNTAB\">Double-click fields to add them to the query. Drag-and-drop to define relations.</ahelp>" ], "id_hash": 6649503362082642656, "content_hash": 6649503362082642656, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3144762\nhelp.text", "note": "FBQA9", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 63, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/95824084/?format=api", "priority": 100, "id": 95824084, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=dc47c813c5b39ae0", "url": "https://translations.documentfoundation.org/api/units/95824084/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:06.703260Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?format=api", "source": [ "While designing a query, you cannot modify the selected tables." ], "previous_source": "", "target": [ "While designing a query, you cannot modify the selected tables." ], "id_hash": 4071334562569316202, "content_hash": 4071334562569316202, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3157894\nhelp.text", "note": "eG8FD", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 64, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/95824142/?format=api", "priority": 100, "id": 95824142, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=b8804936bbb6e76a", "url": "https://translations.documentfoundation.org/api/units/95824142/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:06.725590Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?format=api", "source": [ "Remove tables" ], "previous_source": "", "target": [ "Remove tables" ], "id_hash": -225014905734625020, "content_hash": -225014905734625020, "location": "02010100.xhp", "context": "02010100.xhp\nhd_id3149562\nhelp.text", "note": "NLywF", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 65, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/95824167/?format=api", "priority": 100, "id": 95824167, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=7ce09622aa850904", "url": "https://translations.documentfoundation.org/api/units/95824167/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:06.735983Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?format=api", "source": [ "To remove the table from Design View, click the upper border of the table window and display the context menu. You can use the <emph>Delete</emph> command to remove the table from the Design View. Another option is to press the Delete key." ], "previous_source": "", "target": [ "To remove the table from Design View, click the upper border of the table window and display the context menu. You can use the <emph>Delete</emph> command to remove the table from the Design View. Another option is to press the Delete key." ], "id_hash": -3782279187899683547, "content_hash": -3782279187899683547, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3150685\nhelp.text", "note": "TbQzA", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 66, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 42, "source_unit": "https://translations.documentfoundation.org/api/units/95824184/?format=api", "priority": 100, "id": 95824184, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=4b82a51e33e2ed25", "url": "https://translations.documentfoundation.org/api/units/95824184/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:06.747501Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?format=api", "source": [ "Move table and modify table size" ], "previous_source": "", "target": [ "Move table and modify table size" ], "id_hash": -2449331295068946516, "content_hash": -2449331295068946516, "location": "02010100.xhp", "context": "02010100.xhp\nhd_id3150012\nhelp.text", "note": "VLTKB", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 67, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/95824204/?format=api", "priority": 100, "id": 95824204, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=5e023a2a0c2affac", "url": "https://translations.documentfoundation.org/api/units/95824204/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:06.758559Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?format=api", "source": [ "You can resize and arrange the tables according to your preferences. To move tables, drag the upper border to the desired position. Enlarge or reduce the size in which the table is displayed by positioning the mouse cursor on a border or on a corner and dragging the table until it is the desired size." ], "previous_source": "", "target": [ "You can resize and arrange the tables according to your preferences. To move tables, drag the upper border to the desired position. Enlarge or reduce the size in which the table is displayed by positioning the mouse cursor on a border or on a corner and dragging the table until it is the desired size." ], "id_hash": -555858747624136504, "content_hash": -555858747624136504, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3146922\nhelp.text", "note": "amBsQ", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 68, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 55, "source_unit": "https://translations.documentfoundation.org/api/units/95824268/?format=api", "priority": 100, "id": 95824268, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=7849316a0291e0c8", "url": "https://translations.documentfoundation.org/api/units/95824268/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:06.792316Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?format=api", "source": [ "Table Relations" ], "previous_source": "", "target": [ "Table Relations" ], "id_hash": -6762426897780641643, "content_hash": -6762426897780641643, "location": "02010100.xhp", "context": "02010100.xhp\nhd_id3145365\nhelp.text", "note": "UoCRG", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 69, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/95824324/?format=api", "priority": 100, "id": 95824324, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=22270890ba3cf095", "url": "https://translations.documentfoundation.org/api/units/95824324/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:06.819374Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?format=api", "source": [ "If there are data relations between a field name in one table and a field name in another table, you can use these relations for your query." ], "previous_source": "", "target": [ "If there are data relations between a field name in one table and a field name in another table, you can use these relations for your query." ], "id_hash": -2844394009656248667, "content_hash": -2844394009656248667, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3154145\nhelp.text", "note": "BFCxB", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 70, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 27, "source_unit": "https://translations.documentfoundation.org/api/units/95824359/?format=api", "priority": 100, "id": 95824359, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=5886aeb7ed30b6a5", "url": "https://translations.documentfoundation.org/api/units/95824359/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:06.832134Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?format=api", "source": [ "If, for example, you have a spreadsheet for articles identified by an article number, and a spreadsheet for customers in which you record all articles that a customer orders using the corresponding article numbers, then there is a relationship between the two \"article number\" data fields. If you now want to create a query that returns all articles that a customer has ordered, you must retrieve data from two spreadsheets. To do this, you must inform $[officename] about the relationship which exists between the data in the two spreadsheets." ], "previous_source": "", "target": [ "If, for example, you have a spreadsheet for articles identified by an article number, and a spreadsheet for customers in which you record all articles that a customer orders using the corresponding article numbers, then there is a relationship between the two \"article number\" data fields. If you now want to create a query that returns all articles that a customer has ordered, you must retrieve data from two spreadsheets. To do this, you must inform $[officename] about the relationship which exists between the data in the two spreadsheets." ], "id_hash": 5696818659985483922, "content_hash": 5696818659985483922, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3152577\nhelp.text", "note": "jcLbE", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 71, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 89, "source_unit": "https://translations.documentfoundation.org/api/units/95824394/?format=api", "priority": 100, "id": 95824394, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=cf0f2a6362406892", "url": "https://translations.documentfoundation.org/api/units/95824394/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:06.843876Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?format=api", "source": [ "To do this, click a field name in a table (for example, the field name \"Item-Number\" from the Customer table), hold down the mouse button and then drag the field name to the field name of the other table (\"Item-Number\" from the Item table). When you release the mouse button, a line connecting the two fields between the two table windows appears. The corresponding condition that the content of the two field names must be identical is entered in the resulting SQL query." ], "previous_source": "", "target": [ "To do this, click a field name in a table (for example, the field name \"Item-Number\" from the Customer table), hold down the mouse button and then drag the field name to the field name of the other table (\"Item-Number\" from the Item table). When you release the mouse button, a line connecting the two fields between the two table windows appears. The corresponding condition that the content of the two field names must be identical is entered in the resulting SQL query." ], "id_hash": 1976465866603732590, "content_hash": 1976465866603732590, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3155302\nhelp.text", "note": "FspJi", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 72, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 83, "source_unit": "https://translations.documentfoundation.org/api/units/95824430/?format=api", "priority": 100, "id": 95824430, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=9b6dd13be1999e6e", "url": "https://translations.documentfoundation.org/api/units/95824430/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:06.854177Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?format=api", "source": [ "The creation of a query that is based on several related sheets is only possible if you use $[officename] as the interface for a relational database." ], "previous_source": "", "target": [ "The creation of a query that is based on several related sheets is only possible if you use $[officename] as the interface for a relational database." ], "id_hash": 5891063930392334617, "content_hash": 5891063930392334617, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3153876\nhelp.text", "note": "FmAaU", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 73, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 26, "source_unit": "https://translations.documentfoundation.org/api/units/95824466/?format=api", "priority": 100, "id": 95824466, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=d1c1436eb826d119", "url": "https://translations.documentfoundation.org/api/units/95824466/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:06.864954Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?format=api", "source": [ "You cannot access tables from different databases in a query. Queries involving multiple tables can only be created within one database." ], "previous_source": "", "target": [ "You cannot access tables from different databases in a query. Queries involving multiple tables can only be created within one database." ], "id_hash": -2581663316533477404, "content_hash": -2581663316533477404, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3145646\nhelp.text", "note": "N2f8q", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 74, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 21, "source_unit": "https://translations.documentfoundation.org/api/units/95824488/?format=api", "priority": 100, "id": 95824488, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=5c2c16e4505d7fe4", "url": "https://translations.documentfoundation.org/api/units/95824488/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:06.874445Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?format=api", "source": [ "Specifying the relation type" ], "previous_source": "", "target": [ "Specifying the relation type" ], "id_hash": 6221832779187462024, "content_hash": 6221832779187462024, "location": "02010100.xhp", "context": "02010100.xhp\nhd_id3153279\nhelp.text", "note": "nLSiq", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 75, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/95824560/?format=api", "priority": 100, "id": 95824560, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=d65863f2af599f88", "url": "https://translations.documentfoundation.org/api/units/95824560/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:07.163547Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?format=api", "source": [ "If you double-click on the line connecting two linked fields or call the menu command <emph>Insert - New Relation</emph>, you can specify the type of relation in the <link href=\"text/sdatabase/02010101.xhp\"><emph>Relations</emph></link> dialog." ], "previous_source": "", "target": [ "If you double-click on the line connecting two linked fields or call the menu command <emph>Insert - New Relation</emph>, you can specify the type of relation in the <link href=\"text/sdatabase/02010101.xhp\"><emph>Relations</emph></link> dialog." ], "id_hash": -4899784255421960509, "content_hash": -4899784255421960509, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3154791\nhelp.text", "note": "Js8Ga", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 76, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 31, "source_unit": "https://translations.documentfoundation.org/api/units/95824621/?format=api", "priority": 100, "id": 95824621, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=3c00782e0b85aec3", "url": "https://translations.documentfoundation.org/api/units/95824621/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:07.198343Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?format=api", "source": [ "<ahelp hid=\"HID_QUERY_EDIT_JOINCONNECTION\" visibility=\"hidden\">Edit Join Properties.</ahelp> Alternatively, press Tab until the line is selected, then press Shift+F10 to display the context menu and there choose the command <emph>Edit</emph>. Some databases support only a subset of the possible join types." ], "previous_source": "", "target": [ "<ahelp hid=\"HID_QUERY_EDIT_JOINCONNECTION\" visibility=\"hidden\">Edit Join Properties.</ahelp> Alternatively, press Tab until the line is selected, then press Shift+F10 to display the context menu and there choose the command <emph>Edit</emph>. Some databases support only a subset of the possible join types." ], "id_hash": -1300080026283894037, "content_hash": -1300080026283894037, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3150094\nhelp.text", "note": "rAkmw", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 77, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 38, "source_unit": "https://translations.documentfoundation.org/api/units/95824677/?format=api", "priority": 100, "id": 95824677, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=6df5301aadc49aeb", "url": "https://translations.documentfoundation.org/api/units/95824677/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:07.214641Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?format=api", "source": [ "Deleting relations" ], "previous_source": "", "target": [ "Deleting relations" ], "id_hash": -2081471417905181405, "content_hash": -2081471417905181405, "location": "02010100.xhp", "context": "02010100.xhp\nhd_id3155851\nhelp.text", "note": "n3PMB", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 78, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/95824703/?format=api", "priority": 100, "id": 95824703, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=631d20c605a20d23", "url": "https://translations.documentfoundation.org/api/units/95824703/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:07.228660Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?format=api", "source": [ "To delete a relation between two tables, click the connection line and then press the Delete key." ], "previous_source": "", "target": [ "To delete a relation between two tables, click the connection line and then press the Delete key." ], "id_hash": -1676165389692300137, "content_hash": -1676165389692300137, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3156178\nhelp.text", "note": "jCb4H", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 79, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 17, "source_unit": "https://translations.documentfoundation.org/api/units/95824739/?format=api", "priority": 100, "id": 95824739, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=68bd107572961497", "url": "https://translations.documentfoundation.org/api/units/95824739/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:07.255592Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?format=api", "source": [ "Alternatively, delete the respective entries in <emph>Fields involved </emph>in the <emph>Relations</emph> dialog. Or press Tab until the connecting vector is displayed highlighted, then press Shift+F10 to open the context menu and select <emph>Delete </emph>command." ], "previous_source": "", "target": [ "Alternatively, delete the respective entries in <emph>Fields involved </emph>in the <emph>Relations</emph> dialog. Or press Tab until the connecting vector is displayed highlighted, then press Shift+F10 to open the context menu and select <emph>Delete </emph>command." ], "id_hash": 2848305102152968996, "content_hash": 2848305102152968996, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3150715\nhelp.text", "note": "3UCig", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 80, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 34, "source_unit": "https://translations.documentfoundation.org/api/units/95824758/?format=api", "priority": 100, "id": 95824758, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=a787366641c2ab24", "url": "https://translations.documentfoundation.org/api/units/95824758/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:07.267977Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?format=api", "source": [ "Defining the query" ], "previous_source": "", "target": [ "Defining the query" ], "id_hash": -1115420804179096710, "content_hash": -1115420804179096710, "location": "02010100.xhp", "context": "02010100.xhp\nhd_id3151208\nhelp.text", "note": "pBybB", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 81, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/95824783/?format=api", "priority": 100, "id": 95824783, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=70853ab037d30b7a", "url": "https://translations.documentfoundation.org/api/units/95824783/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:07.284956Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?format=api", "source": [ "<ahelp hid=\"HID_CTL_QRYDGNCRIT\">Select conditions to define the query.</ahelp> Each column of the design table accepts a data field for the query. The conditions in one row are linked with a Boolean AND." ], "previous_source": "", "target": [ "<ahelp hid=\"HID_CTL_QRYDGNCRIT\">Select conditions to define the query.</ahelp> Each column of the design table accepts a data field for the query. The conditions in one row are linked with a Boolean AND." ], "id_hash": 970150235029481514, "content_hash": 970150235029481514, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3158416\nhelp.text", "note": "yGfhU", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 82, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 31, "source_unit": "https://translations.documentfoundation.org/api/units/95824820/?format=api", "priority": 100, "id": 95824820, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=8d76aa7fa9b1a82a", "url": "https://translations.documentfoundation.org/api/units/95824820/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:07.344239Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?format=api", "source": [ "Specifying field names" ], "previous_source": "", "target": [ "Specifying field names" ], "id_hash": 7087396214846244354, "content_hash": 7087396214846244354, "location": "02010100.xhp", "context": "02010100.xhp\nhd_id3154161\nhelp.text", "note": "UB5nG", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 83, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/95824849/?format=api", "priority": 100, "id": 95824849, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=e25b7d4e885bc602", "url": "https://translations.documentfoundation.org/api/units/95824849/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:07.355954Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?format=api", "source": [ "First, select all field names from the tables that you want to add to the query. You can do this either by drag-and-drop or by double-clicking a field name in the table window. With the drag-and-drop method, use the mouse to drag a field name from the table window into the lower area of the query design window. As you do this, you can decide which column in the query design window will receive the selected field. A field name can also be selected by double-clicking. It will then be added to the next free column in the query design window." ], "previous_source": "", "target": [ "First, select all field names from the tables that you want to add to the query. You can do this either by drag-and-drop or by double-clicking a field name in the table window. With the drag-and-drop method, use the mouse to drag a field name from the table window into the lower area of the query design window. As you do this, you can decide which column in the query design window will receive the selected field. A field name can also be selected by double-clicking. It will then be added to the next free column in the query design window." ], "id_hash": 8198833192151347902, "content_hash": 8198833192151347902, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3146791\nhelp.text", "note": "jyKMG", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 84, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 101, "source_unit": "https://translations.documentfoundation.org/api/units/95824881/?format=api", "priority": 100, "id": 95824881, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=f1c81b5956dcf2be", "url": "https://translations.documentfoundation.org/api/units/95824881/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:07.366647Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?format=api", "source": [ "Deleting field names" ], "previous_source": "", "target": [ "Deleting field names" ], "id_hash": -6138130590173748816, "content_hash": -6138130590173748816, "location": "02010100.xhp", "context": "02010100.xhp\nhd_id3150750\nhelp.text", "note": "66Dcr", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 85, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/95824893/?format=api", "priority": 100, "id": 95824893, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=2ad0fabfdbbc21b0", "url": "https://translations.documentfoundation.org/api/units/95824893/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:07.376370Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?format=api", "source": [ "To remove a field name from the query, click the column header of the field and choose the <emph>Delete</emph> command on the context menu for the column." ], "previous_source": "", "target": [ "To remove a field name from the query, click the column header of the field and choose the <emph>Delete</emph> command on the context menu for the column." ], "id_hash": -2893767419867838722, "content_hash": -2893767419867838722, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3154479\nhelp.text", "note": "AbhrW", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 86, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 27, "source_unit": "https://translations.documentfoundation.org/api/units/95824937/?format=api", "priority": 100, "id": 95824937, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=57d745dd0c2dc6fe", "url": "https://translations.documentfoundation.org/api/units/95824937/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:07.635697Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?format=api", "source": [ "Saving the query" ], "previous_source": "", "target": [ "Saving the query" ], "id_hash": 6262350828415147603, "content_hash": 6262350828415147603, "location": "02010100.xhp", "context": "02010100.xhp\nhd_id3155764\nhelp.text", "note": "V92gB", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 87, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/95824984/?format=api", "priority": 100, "id": 95824984, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=d6e856e62a8ede53", "url": "https://translations.documentfoundation.org/api/units/95824984/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:07.674141Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?format=api", "source": [ "Use the <emph>Save</emph> icon on the Standard toolbar to save the query. You will see a dialog that asks you to enter a name for the query. If the database supports schemas, you can also enter a schema name." ], "previous_source": "", "target": [ "Use the <emph>Save</emph> icon on the Standard toolbar to save the query. You will see a dialog that asks you to enter a name for the query. If the database supports schemas, you can also enter a schema name." ], "id_hash": 7440882070805057921, "content_hash": 7440882070805057921, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3148481\nhelp.text", "note": "2kWoA", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 88, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 39, "source_unit": "https://translations.documentfoundation.org/api/units/95825030/?format=api", "priority": 100, "id": 95825030, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=e74352d1e5e89181", "url": "https://translations.documentfoundation.org/api/units/95825030/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:07.759946Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?format=api", "source": [ "Schema" ], "previous_source": "", "target": [ "Schema" ], "id_hash": -885561489714260386, "content_hash": -885561489714260386, "location": "02010100.xhp", "context": "02010100.xhp\nhd_id3154362\nhelp.text", "note": "M9UQL", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 89, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/95825038/?format=api", "priority": 100, "id": 95825038, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=73b5da845ad0d65e", "url": "https://translations.documentfoundation.org/api/units/95825038/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:07.770764Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?format=api", "source": [ "<ahelp hid=\"dbaccess/ui/savedialog/schema\">Enter the name of the schema that is assigned to the query or table view.</ahelp>" ], "previous_source": "", "target": [ "<ahelp hid=\"dbaccess/ui/savedialog/schema\">Enter the name of the schema that is assigned to the query or table view.</ahelp>" ], "id_hash": -7723394859280699830, "content_hash": -7723394859280699830, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3154754\nhelp.text", "note": "4Jwm3", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 90, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/95825082/?format=api", "priority": 100, "id": 95825082, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=14d0fd4bb87eee4a", "url": "https://translations.documentfoundation.org/api/units/95825082/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:07.820341Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?format=api", "source": [ "Query name or table view name" ], "previous_source": "", "target": [ "Query name or table view name" ], "id_hash": -8572436132051432902, "content_hash": -8572436132051432902, "location": "02010100.xhp", "context": "02010100.xhp\nhd_id3156717\nhelp.text", "note": "6Q72c", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 91, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/95825106/?format=api", "priority": 100, "id": 95825106, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=090896c1b159ca3a", "url": "https://translations.documentfoundation.org/api/units/95825106/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:07.841448Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?format=api", "source": [ "<ahelp hid=\"dbaccess/ui/savedialog/title\">Enter the name of the query or table view.</ahelp>" ], "previous_source": "", "target": [ "<ahelp hid=\"dbaccess/ui/savedialog/title\">Enter the name of the query or table view.</ahelp>" ], "id_hash": 8513728350355454630, "content_hash": 8513728350355454630, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3154253\nhelp.text", "note": "Cw73K", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 92, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/95825107/?format=api", "priority": 100, "id": 95825107, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=f626d6d3b51bfaa6", "url": "https://translations.documentfoundation.org/api/units/95825107/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:07.849653Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?format=api", "source": [ "Filtering data" ], "previous_source": "", "target": [ "Filtering data" ], "id_hash": -6406536098989130371, "content_hash": -6406536098989130371, "location": "02010100.xhp", "context": "02010100.xhp\nhd_id3163805\nhelp.text", "note": "qgbNu", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 93, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/95825145/?format=api", "priority": 100, "id": 95825145, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=2717695c7b093d7d", "url": "https://translations.documentfoundation.org/api/units/95825145/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:07.872159Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?format=api", "source": [ "To filter data for the query, set the desired criteria in the lower area of the query design window. The following options are available:" ], "previous_source": "", "target": [ "To filter data for the query, set the desired criteria in the lower area of the query design window. The following options are available:" ], "id_hash": -4988399705846574605, "content_hash": -4988399705846574605, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3154964\nhelp.text", "note": "Q9pG5", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 94, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 24, "source_unit": "https://translations.documentfoundation.org/api/units/95825161/?format=api", "priority": 100, "id": 95825161, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=3ac5a4e5af5a11f3", "url": "https://translations.documentfoundation.org/api/units/95825161/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:07.880813Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?format=api", "source": [ "Field" ], "previous_source": "", "target": [ "Field" ], "id_hash": 5582990972642116181, "content_hash": 5582990972642116181, "location": "02010100.xhp", "context": "02010100.xhp\nhd_id3146916\nhelp.text", "note": "xxoMA", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 95, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/95825208/?format=api", "priority": 100, "id": 95825208, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=cd7ac4b5ac8bc255", "url": "https://translations.documentfoundation.org/api/units/95825208/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:07.945917Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?format=api", "source": [ "<ahelp hid=\"HID_QRYDGN_ROW_FIELD\">Enter the name of the data field that is referred to in the Query. All settings made in the filter option rows refer to this field.</ahelp> If you activate a cell here with a mouse click you'll see an arrow button, which enables you to select a field. The \"Table name.*\" option selects all data fields with the effect that the specified criteria will be applied to all table fields." ], "previous_source": "", "target": [ "<ahelp hid=\"HID_QRYDGN_ROW_FIELD\">Enter the name of the data field that is referred to in the Query. All settings made in the filter option rows refer to this field.</ahelp> If you activate a cell here with a mouse click you'll see an arrow button, which enables you to select a field. The \"Table name.*\" option selects all data fields with the effect that the specified criteria will be applied to all table fields." ], "id_hash": 1064441676124325505, "content_hash": 1064441676124325505, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3156372\nhelp.text", "note": "4KDzZ", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 96, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 71, "source_unit": "https://translations.documentfoundation.org/api/units/95825261/?format=api", "priority": 100, "id": 95825261, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=8ec5a81095830681", "url": "https://translations.documentfoundation.org/api/units/95825261/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:07.970361Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?format=api", "source": [ "Alias" ], "previous_source": "", "target": [ "Alias" ], "id_hash": -9131745723256226364, "content_hash": -9131745723256226364, "location": "02010100.xhp", "context": "02010100.xhp\nhd_id3145150\nhelp.text", "note": "Z3pwF", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 97, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/95825311/?format=api", "priority": 100, "id": 95825311, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=014585a5921ebdc4", "url": "https://translations.documentfoundation.org/api/units/95825311/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:07.990489Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?format=api", "source": [ "<ahelp hid=\"HID_QRYDGN_ROW_ALIAS\">Specifies an alias. This alias will be listed in the query instead of the field name. This makes it possible to use user-defined column labels.</ahelp> For example, if the data field is named PtNo and, instead of that name, you would like to have PartNum appear in the query, enter PartNum as the alias." ], "previous_source": "", "target": [ "<ahelp hid=\"HID_QRYDGN_ROW_ALIAS\">Specifies an alias. This alias will be listed in the query instead of the field name. This makes it possible to use user-defined column labels.</ahelp> For example, if the data field is named PtNo and, instead of that name, you would like to have PartNum appear in the query, enter PartNum as the alias." ], "id_hash": -3671462001782890702, "content_hash": -3671462001782890702, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3146315\nhelp.text", "note": "EDa3A", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 98, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 55, "source_unit": "https://translations.documentfoundation.org/api/units/95825390/?format=api", "priority": 100, "id": 95825390, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=4d0c58c2f962df32", "url": "https://translations.documentfoundation.org/api/units/95825390/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:08.013843Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?format=api", "source": [ "In a SQL statement, aliases are defined as follows:" ], "previous_source": "", "target": [ "In a SQL statement, aliases are defined as follows:" ], "id_hash": 7100411874502559735, "content_hash": 7100411874502559735, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3155959\nhelp.text", "note": "vvWbt", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 99, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/95825421/?format=api", "priority": 100, "id": 95825421, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=e289bafaf2b0c7f7", "url": "https://translations.documentfoundation.org/api/units/95825421/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:08.024890Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?format=api", "source": [ "SELECT column AS alias FROM table." ], "previous_source": "", "target": [ "SELECT column AS alias FROM table." ], "id_hash": 3472527734751511331, "content_hash": 3472527734751511331, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3149922\nhelp.text", "note": "CGsBz", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 100, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/95825487/?format=api", "priority": 100, "id": 95825487, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=b030e593968e4323", "url": "https://translations.documentfoundation.org/api/units/95825487/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:08.057729Z" } ] }