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/eo/units/?format=api&page=2
https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/eo/units/?format=api&page=3", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/eo/units/?format=api", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/eo/?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": 107682450, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/eo/?checksum=dea902a47485c2dd", "url": "https://translations.documentfoundation.org/api/units/107682450/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:39.047138Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/eo/?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": 107682454, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/eo/?checksum=11eba35f5321f710", "url": "https://translations.documentfoundation.org/api/units/107682454/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:39.048831Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/eo/?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": 107682455, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/eo/?checksum=72a44fa6a5026e13", "url": "https://translations.documentfoundation.org/api/units/107682455/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:39.050105Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/eo/?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": 107682458, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/eo/?checksum=1aa65ca0fb9818b4", "url": "https://translations.documentfoundation.org/api/units/107682458/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:39.051365Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/eo/?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": 107682460, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/eo/?checksum=1cd3637945f0950f", "url": "https://translations.documentfoundation.org/api/units/107682460/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:39.052699Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/eo/?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": 107682464, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/eo/?checksum=3ffe63140f439767", "url": "https://translations.documentfoundation.org/api/units/107682464/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:39.054370Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/eo/?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": 107682470, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/eo/?checksum=0445a48242375547", "url": "https://translations.documentfoundation.org/api/units/107682470/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:39.056329Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/eo/?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": 107682471, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/eo/?checksum=c1288dad2529377c", "url": "https://translations.documentfoundation.org/api/units/107682471/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:39.058194Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/eo/?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": 107682475, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/eo/?checksum=8f8798486d269085", "url": "https://translations.documentfoundation.org/api/units/107682475/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:39.059904Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/eo/?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": 107682478, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/eo/?checksum=97779b388756f796", "url": "https://translations.documentfoundation.org/api/units/107682478/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:39.061128Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/eo/?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": 107682481, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/eo/?checksum=97109c687a6cbcc5", "url": "https://translations.documentfoundation.org/api/units/107682481/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:39.062185Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/eo/?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": 107682483, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/eo/?checksum=68f9664066116f5e", "url": "https://translations.documentfoundation.org/api/units/107682483/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:39.063172Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/eo/?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": 107682484, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/eo/?checksum=dc47c813c5b39ae0", "url": "https://translations.documentfoundation.org/api/units/107682484/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:39.064472Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/eo/?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": 107682487, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/eo/?checksum=b8804936bbb6e76a", "url": "https://translations.documentfoundation.org/api/units/107682487/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:39.065824Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/eo/?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": 107682490, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/eo/?checksum=7ce09622aa850904", "url": "https://translations.documentfoundation.org/api/units/107682490/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:39.067347Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/eo/?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": 107682495, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/eo/?checksum=4b82a51e33e2ed25", "url": "https://translations.documentfoundation.org/api/units/107682495/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:39.069091Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/eo/?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": 107682499, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/eo/?checksum=5e023a2a0c2affac", "url": "https://translations.documentfoundation.org/api/units/107682499/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:39.071244Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/eo/?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": 107682501, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/eo/?checksum=7849316a0291e0c8", "url": "https://translations.documentfoundation.org/api/units/107682501/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:39.073262Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/eo/?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": 107682507, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/eo/?checksum=22270890ba3cf095", "url": "https://translations.documentfoundation.org/api/units/107682507/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:39.075321Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/eo/?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": 107682511, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/eo/?checksum=5886aeb7ed30b6a5", "url": "https://translations.documentfoundation.org/api/units/107682511/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:39.077098Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/eo/?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": 107682515, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/eo/?checksum=cf0f2a6362406892", "url": "https://translations.documentfoundation.org/api/units/107682515/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:39.078645Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/eo/?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": 107682520, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/eo/?checksum=9b6dd13be1999e6e", "url": "https://translations.documentfoundation.org/api/units/107682520/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:39.080062Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/eo/?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": 107682521, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/eo/?checksum=d1c1436eb826d119", "url": "https://translations.documentfoundation.org/api/units/107682521/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:39.081334Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/eo/?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": 107682524, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/eo/?checksum=5c2c16e4505d7fe4", "url": "https://translations.documentfoundation.org/api/units/107682524/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:39.082581Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/eo/?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": 107682529, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/eo/?checksum=d65863f2af599f88", "url": "https://translations.documentfoundation.org/api/units/107682529/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:39.083892Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/eo/?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": 107682531, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/eo/?checksum=3c00782e0b85aec3", "url": "https://translations.documentfoundation.org/api/units/107682531/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:39.085234Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/eo/?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": 107682534, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/eo/?checksum=6df5301aadc49aeb", "url": "https://translations.documentfoundation.org/api/units/107682534/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:39.086662Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/eo/?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": 107682538, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/eo/?checksum=631d20c605a20d23", "url": "https://translations.documentfoundation.org/api/units/107682538/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:39.088142Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/eo/?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": 107682540, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/eo/?checksum=68bd107572961497", "url": "https://translations.documentfoundation.org/api/units/107682540/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:39.089236Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/eo/?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": 107682544, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/eo/?checksum=a787366641c2ab24", "url": "https://translations.documentfoundation.org/api/units/107682544/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:39.090260Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/eo/?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": 107682545, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/eo/?checksum=70853ab037d30b7a", "url": "https://translations.documentfoundation.org/api/units/107682545/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:39.091430Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/eo/?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": 107682548, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/eo/?checksum=8d76aa7fa9b1a82a", "url": "https://translations.documentfoundation.org/api/units/107682548/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:39.092824Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/eo/?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": 107682553, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/eo/?checksum=e25b7d4e885bc602", "url": "https://translations.documentfoundation.org/api/units/107682553/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:39.094328Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/eo/?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": 107682556, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/eo/?checksum=f1c81b5956dcf2be", "url": "https://translations.documentfoundation.org/api/units/107682556/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:39.095725Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/eo/?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": 107682560, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/eo/?checksum=2ad0fabfdbbc21b0", "url": "https://translations.documentfoundation.org/api/units/107682560/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:39.097066Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/eo/?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": 107682562, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/eo/?checksum=57d745dd0c2dc6fe", "url": "https://translations.documentfoundation.org/api/units/107682562/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:39.098024Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/eo/?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": 107682564, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/eo/?checksum=d6e856e62a8ede53", "url": "https://translations.documentfoundation.org/api/units/107682564/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:39.099266Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/eo/?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": 107682568, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/eo/?checksum=e74352d1e5e89181", "url": "https://translations.documentfoundation.org/api/units/107682568/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:39.100702Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/eo/?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": 107682570, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/eo/?checksum=73b5da845ad0d65e", "url": "https://translations.documentfoundation.org/api/units/107682570/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:39.102189Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/eo/?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": 107682574, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/eo/?checksum=14d0fd4bb87eee4a", "url": "https://translations.documentfoundation.org/api/units/107682574/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:39.202096Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/eo/?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": 107682577, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/eo/?checksum=090896c1b159ca3a", "url": "https://translations.documentfoundation.org/api/units/107682577/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:39.205300Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/eo/?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": 107682580, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/eo/?checksum=f626d6d3b51bfaa6", "url": "https://translations.documentfoundation.org/api/units/107682580/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:39.208309Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/eo/?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": 107682581, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/eo/?checksum=2717695c7b093d7d", "url": "https://translations.documentfoundation.org/api/units/107682581/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:39.210931Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/eo/?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": 107682584, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/eo/?checksum=3ac5a4e5af5a11f3", "url": "https://translations.documentfoundation.org/api/units/107682584/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:39.212926Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/eo/?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": 107682587, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/eo/?checksum=cd7ac4b5ac8bc255", "url": "https://translations.documentfoundation.org/api/units/107682587/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:39.215374Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/eo/?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": 107682590, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/eo/?checksum=8ec5a81095830681", "url": "https://translations.documentfoundation.org/api/units/107682590/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:39.217416Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/eo/?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": 107682591, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/eo/?checksum=014585a5921ebdc4", "url": "https://translations.documentfoundation.org/api/units/107682591/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:39.219359Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/eo/?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": 107682595, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/eo/?checksum=4d0c58c2f962df32", "url": "https://translations.documentfoundation.org/api/units/107682595/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:39.221201Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/eo/?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": 107682599, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/eo/?checksum=e289bafaf2b0c7f7", "url": "https://translations.documentfoundation.org/api/units/107682599/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:39.223468Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/eo/?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": 107682604, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/eo/?checksum=b030e593968e4323", "url": "https://translations.documentfoundation.org/api/units/107682604/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:39.225415Z" } ] }{ "count": 1739, "next": "