Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/libo_help-24-2/textsdatabase/gug/units/?format=api&page=2
https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/gug/units/?format=api&page=3", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/gug/units/?format=api", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/gug/?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/107515114/?format=api", "priority": 100, "id": 107765431, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/gug/?checksum=dea902a47485c2dd", "url": "https://translations.documentfoundation.org/api/units/107765431/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:57.291520Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/gug/?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/107515124/?format=api", "priority": 100, "id": 107765435, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/gug/?checksum=11eba35f5321f710", "url": "https://translations.documentfoundation.org/api/units/107765435/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:57.293838Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/gug/?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/107515139/?format=api", "priority": 100, "id": 107765437, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/gug/?checksum=72a44fa6a5026e13", "url": "https://translations.documentfoundation.org/api/units/107765437/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:57.295924Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/gug/?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/107515162/?format=api", "priority": 100, "id": 107765440, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/gug/?checksum=1aa65ca0fb9818b4", "url": "https://translations.documentfoundation.org/api/units/107765440/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:57.297926Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/gug/?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/107515173/?format=api", "priority": 100, "id": 107765448, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/gug/?checksum=1cd3637945f0950f", "url": "https://translations.documentfoundation.org/api/units/107765448/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:57.305963Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/gug/?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/107515181/?format=api", "priority": 100, "id": 107765454, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/gug/?checksum=3ffe63140f439767", "url": "https://translations.documentfoundation.org/api/units/107765454/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:57.312528Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/gug/?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/107515188/?format=api", "priority": 100, "id": 107765459, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/gug/?checksum=0445a48242375547", "url": "https://translations.documentfoundation.org/api/units/107765459/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:57.317186Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/gug/?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/107515200/?format=api", "priority": 100, "id": 107765462, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/gug/?checksum=c1288dad2529377c", "url": "https://translations.documentfoundation.org/api/units/107765462/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:57.320928Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/gug/?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/107515224/?format=api", "priority": 100, "id": 107765465, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/gug/?checksum=8f8798486d269085", "url": "https://translations.documentfoundation.org/api/units/107765465/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:57.325028Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/gug/?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/107515236/?format=api", "priority": 100, "id": 107765474, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/gug/?checksum=97779b388756f796", "url": "https://translations.documentfoundation.org/api/units/107765474/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:57.332836Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/gug/?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/107515249/?format=api", "priority": 100, "id": 107765481, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/gug/?checksum=97109c687a6cbcc5", "url": "https://translations.documentfoundation.org/api/units/107765481/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:57.337435Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/gug/?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/107515263/?format=api", "priority": 100, "id": 107765487, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/gug/?checksum=68f9664066116f5e", "url": "https://translations.documentfoundation.org/api/units/107765487/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:57.345845Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/gug/?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/107515274/?format=api", "priority": 100, "id": 107765492, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/gug/?checksum=dc47c813c5b39ae0", "url": "https://translations.documentfoundation.org/api/units/107765492/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:57.350445Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/gug/?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/107515289/?format=api", "priority": 100, "id": 107765498, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/gug/?checksum=b8804936bbb6e76a", "url": "https://translations.documentfoundation.org/api/units/107765498/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:57.355479Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/gug/?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/107515305/?format=api", "priority": 100, "id": 107765505, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/gug/?checksum=7ce09622aa850904", "url": "https://translations.documentfoundation.org/api/units/107765505/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:57.360627Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/gug/?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/107515311/?format=api", "priority": 100, "id": 107765510, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/gug/?checksum=4b82a51e33e2ed25", "url": "https://translations.documentfoundation.org/api/units/107765510/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:57.363252Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/gug/?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/107515333/?format=api", "priority": 100, "id": 107765513, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/gug/?checksum=5e023a2a0c2affac", "url": "https://translations.documentfoundation.org/api/units/107765513/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:57.365632Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/gug/?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/107515351/?format=api", "priority": 100, "id": 107765519, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/gug/?checksum=7849316a0291e0c8", "url": "https://translations.documentfoundation.org/api/units/107765519/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:57.367614Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/gug/?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/107515361/?format=api", "priority": 100, "id": 107765522, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/gug/?checksum=22270890ba3cf095", "url": "https://translations.documentfoundation.org/api/units/107765522/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:57.369465Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/gug/?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/107515384/?format=api", "priority": 100, "id": 107765527, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/gug/?checksum=5886aeb7ed30b6a5", "url": "https://translations.documentfoundation.org/api/units/107765527/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:57.371229Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/gug/?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/107515411/?format=api", "priority": 100, "id": 107765531, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/gug/?checksum=cf0f2a6362406892", "url": "https://translations.documentfoundation.org/api/units/107765531/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:57.372869Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/gug/?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/107515439/?format=api", "priority": 100, "id": 107765536, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/gug/?checksum=9b6dd13be1999e6e", "url": "https://translations.documentfoundation.org/api/units/107765536/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:57.374810Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/gug/?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/107515463/?format=api", "priority": 100, "id": 107765541, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/gug/?checksum=d1c1436eb826d119", "url": "https://translations.documentfoundation.org/api/units/107765541/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:57.377235Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/gug/?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/107515482/?format=api", "priority": 100, "id": 107765544, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/gug/?checksum=5c2c16e4505d7fe4", "url": "https://translations.documentfoundation.org/api/units/107765544/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:57.379271Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/gug/?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/107515500/?format=api", "priority": 100, "id": 107765548, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/gug/?checksum=d65863f2af599f88", "url": "https://translations.documentfoundation.org/api/units/107765548/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:57.381071Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/gug/?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/107515519/?format=api", "priority": 100, "id": 107765551, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/gug/?checksum=3c00782e0b85aec3", "url": "https://translations.documentfoundation.org/api/units/107765551/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:57.382473Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/gug/?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/107515529/?format=api", "priority": 100, "id": 107765553, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/gug/?checksum=6df5301aadc49aeb", "url": "https://translations.documentfoundation.org/api/units/107765553/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:57.384033Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/gug/?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/107515547/?format=api", "priority": 100, "id": 107765556, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/gug/?checksum=631d20c605a20d23", "url": "https://translations.documentfoundation.org/api/units/107765556/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:57.385562Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/gug/?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/107515574/?format=api", "priority": 100, "id": 107765559, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/gug/?checksum=68bd107572961497", "url": "https://translations.documentfoundation.org/api/units/107765559/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:57.386993Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/gug/?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/107515601/?format=api", "priority": 100, "id": 107765562, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/gug/?checksum=a787366641c2ab24", "url": "https://translations.documentfoundation.org/api/units/107765562/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:57.388355Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/gug/?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/107515619/?format=api", "priority": 100, "id": 107765564, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/gug/?checksum=70853ab037d30b7a", "url": "https://translations.documentfoundation.org/api/units/107765564/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:57.389522Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/gug/?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/107515631/?format=api", "priority": 100, "id": 107765565, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/gug/?checksum=8d76aa7fa9b1a82a", "url": "https://translations.documentfoundation.org/api/units/107765565/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:57.390591Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/gug/?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/107515648/?format=api", "priority": 100, "id": 107765571, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/gug/?checksum=e25b7d4e885bc602", "url": "https://translations.documentfoundation.org/api/units/107765571/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:57.393556Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/gug/?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/107515657/?format=api", "priority": 100, "id": 107765581, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/gug/?checksum=f1c81b5956dcf2be", "url": "https://translations.documentfoundation.org/api/units/107765581/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:57.406660Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/gug/?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/107515668/?format=api", "priority": 100, "id": 107765585, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/gug/?checksum=2ad0fabfdbbc21b0", "url": "https://translations.documentfoundation.org/api/units/107765585/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:57.408781Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/gug/?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/107515677/?format=api", "priority": 100, "id": 107765589, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/gug/?checksum=57d745dd0c2dc6fe", "url": "https://translations.documentfoundation.org/api/units/107765589/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:57.410627Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/gug/?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/107515687/?format=api", "priority": 100, "id": 107765609, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/gug/?checksum=d6e856e62a8ede53", "url": "https://translations.documentfoundation.org/api/units/107765609/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:57.422563Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/gug/?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/107515695/?format=api", "priority": 100, "id": 107765613, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/gug/?checksum=e74352d1e5e89181", "url": "https://translations.documentfoundation.org/api/units/107765613/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:57.425014Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/gug/?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/107515713/?format=api", "priority": 100, "id": 107765617, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/gug/?checksum=73b5da845ad0d65e", "url": "https://translations.documentfoundation.org/api/units/107765617/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:57.427578Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/gug/?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/107515727/?format=api", "priority": 100, "id": 107765622, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/gug/?checksum=14d0fd4bb87eee4a", "url": "https://translations.documentfoundation.org/api/units/107765622/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:57.429600Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/gug/?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/107515737/?format=api", "priority": 100, "id": 107765625, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/gug/?checksum=090896c1b159ca3a", "url": "https://translations.documentfoundation.org/api/units/107765625/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:57.431482Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/gug/?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/107515749/?format=api", "priority": 100, "id": 107765629, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/gug/?checksum=f626d6d3b51bfaa6", "url": "https://translations.documentfoundation.org/api/units/107765629/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:57.433640Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/gug/?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/107515768/?format=api", "priority": 100, "id": 107765633, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/gug/?checksum=2717695c7b093d7d", "url": "https://translations.documentfoundation.org/api/units/107765633/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:57.435684Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/gug/?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/107515777/?format=api", "priority": 100, "id": 107765637, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/gug/?checksum=3ac5a4e5af5a11f3", "url": "https://translations.documentfoundation.org/api/units/107765637/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:57.437793Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/gug/?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/107515784/?format=api", "priority": 100, "id": 107765642, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/gug/?checksum=cd7ac4b5ac8bc255", "url": "https://translations.documentfoundation.org/api/units/107765642/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:57.439850Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/gug/?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/107515801/?format=api", "priority": 100, "id": 107765646, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/gug/?checksum=8ec5a81095830681", "url": "https://translations.documentfoundation.org/api/units/107765646/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:57.441844Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/gug/?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/107515812/?format=api", "priority": 100, "id": 107765650, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/gug/?checksum=014585a5921ebdc4", "url": "https://translations.documentfoundation.org/api/units/107765650/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:57.443617Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/gug/?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/107515820/?format=api", "priority": 100, "id": 107765653, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/gug/?checksum=4d0c58c2f962df32", "url": "https://translations.documentfoundation.org/api/units/107765653/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:57.445015Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/gug/?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/107515824/?format=api", "priority": 100, "id": 107765656, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/gug/?checksum=e289bafaf2b0c7f7", "url": "https://translations.documentfoundation.org/api/units/107765656/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:57.446409Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/gug/?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/107515826/?format=api", "priority": 100, "id": 107765660, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/gug/?checksum=b030e593968e4323", "url": "https://translations.documentfoundation.org/api/units/107765660/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:01:57.447845Z" } ] }{ "count": 1739, "next": "