Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/libo_help-7-6/textsdatabase/csb/units/?format=api&page=2
{ "count": 1739, "next": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/units/?format=api&page=3", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/units/?format=api", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": [ "" ], "id_hash": 6820986015982142173, "content_hash": 6820986015982142173, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3147559\nhelp.text", "note": "hYsxY", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 96042472, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=dea902a47485c2dd", "url": "https://translations.documentfoundation.org/api/units/96042472/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:29.351605Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?format=api", "source": [ "Keys in Query Design View" ], "previous_source": "", "target": [ "" ], "id_hash": -7932066688871041264, "content_hash": -7932066688871041264, "location": "02010100.xhp", "context": "02010100.xhp\nhd_id8226264\nhelp.text", "note": "B4HEH", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 96042476, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=11eba35f5321f710", "url": "https://translations.documentfoundation.org/api/units/96042476/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:29.352976Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?format=api", "source": [ "Key" ], "previous_source": "", "target": [ "" ], "id_hash": -962556843198878189, "content_hash": -962556843198878189, "location": "02010100.xhp", "context": "02010100.xhp\npar_id2341074\nhelp.text", "note": "Cvd4o", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 96042484, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=72a44fa6a5026e13", "url": "https://translations.documentfoundation.org/api/units/96042484/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:29.354375Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?format=api", "source": [ "Function" ], "previous_source": "", "target": [ "" ], "id_hash": -7303047899249108812, "content_hash": -7303047899249108812, "location": "02010100.xhp", "context": "02010100.xhp\npar_id4384289\nhelp.text", "note": "mCy9S", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 96042488, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=1aa65ca0fb9818b4", "url": "https://translations.documentfoundation.org/api/units/96042488/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:29.355698Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?format=api", "source": [ "F4" ], "previous_source": "", "target": [ "" ], "id_hash": -7146258811191257841, "content_hash": -7146258811191257841, "location": "02010100.xhp", "context": "02010100.xhp\npar_id5839106\nhelp.text", "note": "yybiC", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 96042494, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=1cd3637945f0950f", "url": "https://translations.documentfoundation.org/api/units/96042494/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:29.357081Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?format=api", "source": [ "Preview" ], "previous_source": "", "target": [ "" ], "id_hash": -4612140030574225561, "content_hash": -4612140030574225561, "location": "02010100.xhp", "context": "02010100.xhp\npar_id8554338\nhelp.text", "note": "FMTZD", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 96042501, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=3ffe63140f439767", "url": "https://translations.documentfoundation.org/api/units/96042501/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:29.358662Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?format=api", "source": [ "F5" ], "previous_source": "", "target": [ "" ], "id_hash": -8915539007946402489, "content_hash": -8915539007946402489, "location": "02010100.xhp", "context": "02010100.xhp\npar_id1254921\nhelp.text", "note": "YQhGF", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 96042518, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=0445a48242375547", "url": "https://translations.documentfoundation.org/api/units/96042518/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:29.367327Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?format=api", "source": [ "Run Query" ], "previous_source": "", "target": [ "" ], "id_hash": 4695158386326058876, "content_hash": 4695158386326058876, "location": "02010100.xhp", "context": "02010100.xhp\npar_id7636646\nhelp.text", "note": "C9yhE", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 96042523, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=c1288dad2529377c", "url": "https://translations.documentfoundation.org/api/units/96042523/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:29.369038Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?format=api", "source": [ "F7" ], "previous_source": "", "target": [ "" ], "id_hash": 1119030469261168773, "content_hash": 1119030469261168773, "location": "02010100.xhp", "context": "02010100.xhp\npar_id8579363\nhelp.text", "note": "jdEeJ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 96042527, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=8f8798486d269085", "url": "https://translations.documentfoundation.org/api/units/96042527/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:29.370769Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?format=api", "source": [ "Add Table or Query" ], "previous_source": "", "target": [ "" ], "id_hash": 1690990852192008086, "content_hash": 1690990852192008086, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3227942\nhelp.text", "note": "6Y6Uw", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 96042530, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=97779b388756f796", "url": "https://translations.documentfoundation.org/api/units/96042530/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:29.372981Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?format=api", "source": [ "Browse" ], "previous_source": "", "target": [ "" ], "id_hash": 1662000235044191429, "content_hash": 1662000235044191429, "location": "02010100.xhp", "context": "02010100.xhp\nhd_id3154939\nhelp.text", "note": "WN7wR", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 96042533, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=97109c687a6cbcc5", "url": "https://translations.documentfoundation.org/api/units/96042533/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:29.375013Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": [ "" ], "id_hash": -1659182560932958370, "content_hash": -1659182560932958370, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3148799\nhelp.text", "note": "5y4VZ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 96042536, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=68f9664066116f5e", "url": "https://translations.documentfoundation.org/api/units/96042536/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:29.376627Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": [ "" ], "id_hash": 6649503362082642656, "content_hash": 6649503362082642656, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3144762\nhelp.text", "note": "FBQA9", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 96042542, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=dc47c813c5b39ae0", "url": "https://translations.documentfoundation.org/api/units/96042542/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:29.378297Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?format=api", "source": [ "While designing a query, you cannot modify the selected tables." ], "previous_source": "", "target": [ "" ], "id_hash": 4071334562569316202, "content_hash": 4071334562569316202, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3157894\nhelp.text", "note": "eG8FD", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 96042548, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=b8804936bbb6e76a", "url": "https://translations.documentfoundation.org/api/units/96042548/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:29.379889Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?format=api", "source": [ "Remove tables" ], "previous_source": "", "target": [ "" ], "id_hash": -225014905734625020, "content_hash": -225014905734625020, "location": "02010100.xhp", "context": "02010100.xhp\nhd_id3149562\nhelp.text", "note": "NLywF", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 96042555, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=7ce09622aa850904", "url": "https://translations.documentfoundation.org/api/units/96042555/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:29.381430Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": [ "" ], "id_hash": -3782279187899683547, "content_hash": -3782279187899683547, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3150685\nhelp.text", "note": "TbQzA", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 96042558, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=4b82a51e33e2ed25", "url": "https://translations.documentfoundation.org/api/units/96042558/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:29.382952Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?format=api", "source": [ "Move table and modify table size" ], "previous_source": "", "target": [ "" ], "id_hash": -2449331295068946516, "content_hash": -2449331295068946516, "location": "02010100.xhp", "context": "02010100.xhp\nhd_id3150012\nhelp.text", "note": "VLTKB", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 96042564, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=5e023a2a0c2affac", "url": "https://translations.documentfoundation.org/api/units/96042564/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:29.384884Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": [ "" ], "id_hash": -555858747624136504, "content_hash": -555858747624136504, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3146922\nhelp.text", "note": "amBsQ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 96042569, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=7849316a0291e0c8", "url": "https://translations.documentfoundation.org/api/units/96042569/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:29.387149Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?format=api", "source": [ "Table Relations" ], "previous_source": "", "target": [ "" ], "id_hash": -6762426897780641643, "content_hash": -6762426897780641643, "location": "02010100.xhp", "context": "02010100.xhp\nhd_id3145365\nhelp.text", "note": "UoCRG", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 96042572, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=22270890ba3cf095", "url": "https://translations.documentfoundation.org/api/units/96042572/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:29.388860Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": [ "" ], "id_hash": -2844394009656248667, "content_hash": -2844394009656248667, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3154145\nhelp.text", "note": "BFCxB", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 96042576, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=5886aeb7ed30b6a5", "url": "https://translations.documentfoundation.org/api/units/96042576/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:29.390425Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": [ "" ], "id_hash": 5696818659985483922, "content_hash": 5696818659985483922, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3152577\nhelp.text", "note": "jcLbE", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 96042584, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=cf0f2a6362406892", "url": "https://translations.documentfoundation.org/api/units/96042584/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:29.392684Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": [ "" ], "id_hash": 1976465866603732590, "content_hash": 1976465866603732590, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3155302\nhelp.text", "note": "FspJi", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 96042588, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=9b6dd13be1999e6e", "url": "https://translations.documentfoundation.org/api/units/96042588/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:29.395567Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": [ "" ], "id_hash": 5891063930392334617, "content_hash": 5891063930392334617, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3153876\nhelp.text", "note": "FmAaU", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 96042592, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=d1c1436eb826d119", "url": "https://translations.documentfoundation.org/api/units/96042592/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:29.397281Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": [ "" ], "id_hash": -2581663316533477404, "content_hash": -2581663316533477404, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3145646\nhelp.text", "note": "N2f8q", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 96042597, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=5c2c16e4505d7fe4", "url": "https://translations.documentfoundation.org/api/units/96042597/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:29.398842Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?format=api", "source": [ "Specifying the relation type" ], "previous_source": "", "target": [ "" ], "id_hash": 6221832779187462024, "content_hash": 6221832779187462024, "location": "02010100.xhp", "context": "02010100.xhp\nhd_id3153279\nhelp.text", "note": "nLSiq", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 96042601, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=d65863f2af599f88", "url": "https://translations.documentfoundation.org/api/units/96042601/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:29.400783Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": [ "" ], "id_hash": -4899784255421960509, "content_hash": -4899784255421960509, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3154791\nhelp.text", "note": "Js8Ga", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 96042611, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=3c00782e0b85aec3", "url": "https://translations.documentfoundation.org/api/units/96042611/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:29.417239Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": [ "" ], "id_hash": -1300080026283894037, "content_hash": -1300080026283894037, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3150094\nhelp.text", "note": "rAkmw", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 96042620, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=6df5301aadc49aeb", "url": "https://translations.documentfoundation.org/api/units/96042620/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:29.422984Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?format=api", "source": [ "Deleting relations" ], "previous_source": "", "target": [ "" ], "id_hash": -2081471417905181405, "content_hash": -2081471417905181405, "location": "02010100.xhp", "context": "02010100.xhp\nhd_id3155851\nhelp.text", "note": "n3PMB", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 96042626, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=631d20c605a20d23", "url": "https://translations.documentfoundation.org/api/units/96042626/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:29.425167Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?format=api", "source": [ "To delete a relation between two tables, click the connection line and then press the Delete key." ], "previous_source": "", "target": [ "" ], "id_hash": -1676165389692300137, "content_hash": -1676165389692300137, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3156178\nhelp.text", "note": "jCb4H", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 96042632, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=68bd107572961497", "url": "https://translations.documentfoundation.org/api/units/96042632/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:29.426862Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": [ "" ], "id_hash": 2848305102152968996, "content_hash": 2848305102152968996, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3150715\nhelp.text", "note": "3UCig", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 96042639, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=a787366641c2ab24", "url": "https://translations.documentfoundation.org/api/units/96042639/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:29.428940Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?format=api", "source": [ "Defining the query" ], "previous_source": "", "target": [ "" ], "id_hash": -1115420804179096710, "content_hash": -1115420804179096710, "location": "02010100.xhp", "context": "02010100.xhp\nhd_id3151208\nhelp.text", "note": "pBybB", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 96042640, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=70853ab037d30b7a", "url": "https://translations.documentfoundation.org/api/units/96042640/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:29.941336Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": [ "" ], "id_hash": 970150235029481514, "content_hash": 970150235029481514, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3158416\nhelp.text", "note": "yGfhU", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 96042643, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=8d76aa7fa9b1a82a", "url": "https://translations.documentfoundation.org/api/units/96042643/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:29.944418Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?format=api", "source": [ "Specifying field names" ], "previous_source": "", "target": [ "" ], "id_hash": 7087396214846244354, "content_hash": 7087396214846244354, "location": "02010100.xhp", "context": "02010100.xhp\nhd_id3154161\nhelp.text", "note": "UB5nG", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 96042648, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=e25b7d4e885bc602", "url": "https://translations.documentfoundation.org/api/units/96042648/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:29.948377Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": [ "" ], "id_hash": 8198833192151347902, "content_hash": 8198833192151347902, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3146791\nhelp.text", "note": "jyKMG", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 96042654, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=f1c81b5956dcf2be", "url": "https://translations.documentfoundation.org/api/units/96042654/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:29.952271Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?format=api", "source": [ "Deleting field names" ], "previous_source": "", "target": [ "" ], "id_hash": -6138130590173748816, "content_hash": -6138130590173748816, "location": "02010100.xhp", "context": "02010100.xhp\nhd_id3150750\nhelp.text", "note": "66Dcr", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 96042667, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=2ad0fabfdbbc21b0", "url": "https://translations.documentfoundation.org/api/units/96042667/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:29.954193Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": [ "" ], "id_hash": -2893767419867838722, "content_hash": -2893767419867838722, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3154479\nhelp.text", "note": "AbhrW", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 96042674, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=57d745dd0c2dc6fe", "url": "https://translations.documentfoundation.org/api/units/96042674/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:29.962475Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?format=api", "source": [ "Saving the query" ], "previous_source": "", "target": [ "" ], "id_hash": 6262350828415147603, "content_hash": 6262350828415147603, "location": "02010100.xhp", "context": "02010100.xhp\nhd_id3155764\nhelp.text", "note": "V92gB", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 96042678, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=d6e856e62a8ede53", "url": "https://translations.documentfoundation.org/api/units/96042678/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:29.964455Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": [ "" ], "id_hash": 7440882070805057921, "content_hash": 7440882070805057921, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3148481\nhelp.text", "note": "2kWoA", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 96042701, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=e74352d1e5e89181", "url": "https://translations.documentfoundation.org/api/units/96042701/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:29.974327Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?format=api", "source": [ "Schema" ], "previous_source": "", "target": [ "" ], "id_hash": -885561489714260386, "content_hash": -885561489714260386, "location": "02010100.xhp", "context": "02010100.xhp\nhd_id3154362\nhelp.text", "note": "M9UQL", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 96042711, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=73b5da845ad0d65e", "url": "https://translations.documentfoundation.org/api/units/96042711/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:29.979163Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": [ "" ], "id_hash": -7723394859280699830, "content_hash": -7723394859280699830, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3154754\nhelp.text", "note": "4Jwm3", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 96042736, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=14d0fd4bb87eee4a", "url": "https://translations.documentfoundation.org/api/units/96042736/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:29.993116Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?format=api", "source": [ "Query name or table view name" ], "previous_source": "", "target": [ "" ], "id_hash": -8572436132051432902, "content_hash": -8572436132051432902, "location": "02010100.xhp", "context": "02010100.xhp\nhd_id3156717\nhelp.text", "note": "6Q72c", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 96042739, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=090896c1b159ca3a", "url": "https://translations.documentfoundation.org/api/units/96042739/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:29.994896Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?format=api", "source": [ "<ahelp hid=\"dbaccess/ui/savedialog/title\">Enter the name of the query or table view.</ahelp>" ], "previous_source": "", "target": [ "" ], "id_hash": 8513728350355454630, "content_hash": 8513728350355454630, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3154253\nhelp.text", "note": "Cw73K", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 96042753, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=f626d6d3b51bfaa6", "url": "https://translations.documentfoundation.org/api/units/96042753/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:30.001092Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?format=api", "source": [ "Filtering data" ], "previous_source": "", "target": [ "" ], "id_hash": -6406536098989130371, "content_hash": -6406536098989130371, "location": "02010100.xhp", "context": "02010100.xhp\nhd_id3163805\nhelp.text", "note": "qgbNu", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 96042766, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=2717695c7b093d7d", "url": "https://translations.documentfoundation.org/api/units/96042766/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:30.005190Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": [ "" ], "id_hash": -4988399705846574605, "content_hash": -4988399705846574605, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3154964\nhelp.text", "note": "Q9pG5", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 96042779, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=3ac5a4e5af5a11f3", "url": "https://translations.documentfoundation.org/api/units/96042779/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:30.010848Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?format=api", "source": [ "Field" ], "previous_source": "", "target": [ "" ], "id_hash": 5582990972642116181, "content_hash": 5582990972642116181, "location": "02010100.xhp", "context": "02010100.xhp\nhd_id3146916\nhelp.text", "note": "xxoMA", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 96042794, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=cd7ac4b5ac8bc255", "url": "https://translations.documentfoundation.org/api/units/96042794/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:30.015518Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": [ "" ], "id_hash": 1064441676124325505, "content_hash": 1064441676124325505, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3156372\nhelp.text", "note": "4KDzZ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 96042807, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=8ec5a81095830681", "url": "https://translations.documentfoundation.org/api/units/96042807/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:30.019889Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?format=api", "source": [ "Alias" ], "previous_source": "", "target": [ "" ], "id_hash": -9131745723256226364, "content_hash": -9131745723256226364, "location": "02010100.xhp", "context": "02010100.xhp\nhd_id3145150\nhelp.text", "note": "Z3pwF", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 96042815, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=014585a5921ebdc4", "url": "https://translations.documentfoundation.org/api/units/96042815/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:30.025239Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?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": [ "" ], "id_hash": -3671462001782890702, "content_hash": -3671462001782890702, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3146315\nhelp.text", "note": "EDa3A", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 96042822, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=4d0c58c2f962df32", "url": "https://translations.documentfoundation.org/api/units/96042822/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:30.029503Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?format=api", "source": [ "In a SQL statement, aliases are defined as follows:" ], "previous_source": "", "target": [ "" ], "id_hash": 7100411874502559735, "content_hash": 7100411874502559735, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3155959\nhelp.text", "note": "vvWbt", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 96042831, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=e289bafaf2b0c7f7", "url": "https://translations.documentfoundation.org/api/units/96042831/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:30.033572Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/csb/?format=api", "source": [ "SELECT column AS alias FROM table." ], "previous_source": "", "target": [ "" ], "id_hash": 3472527734751511331, "content_hash": 3472527734751511331, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3149922\nhelp.text", "note": "CGsBz", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 96042840, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/csb/?checksum=b030e593968e4323", "url": "https://translations.documentfoundation.org/api/units/96042840/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:35:30.037874Z" } ] }