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/ht/units/?format=api&page=2
https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ht/units/?format=api&page=3", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ht/units/?format=api", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ht/?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": 107802978, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ht/?checksum=dea902a47485c2dd", "url": "https://translations.documentfoundation.org/api/units/107802978/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:02:40.209161Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ht/?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": 107802979, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ht/?checksum=11eba35f5321f710", "url": "https://translations.documentfoundation.org/api/units/107802979/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:02:40.210118Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ht/?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": 107802980, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ht/?checksum=72a44fa6a5026e13", "url": "https://translations.documentfoundation.org/api/units/107802980/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:02:40.211054Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ht/?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": 107802981, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ht/?checksum=1aa65ca0fb9818b4", "url": "https://translations.documentfoundation.org/api/units/107802981/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:02:40.211987Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ht/?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": 107802982, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ht/?checksum=1cd3637945f0950f", "url": "https://translations.documentfoundation.org/api/units/107802982/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:02:40.212898Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ht/?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": 107802983, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ht/?checksum=3ffe63140f439767", "url": "https://translations.documentfoundation.org/api/units/107802983/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:02:40.213821Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ht/?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": 107802984, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ht/?checksum=0445a48242375547", "url": "https://translations.documentfoundation.org/api/units/107802984/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:02:40.214746Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ht/?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": 107802985, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ht/?checksum=c1288dad2529377c", "url": "https://translations.documentfoundation.org/api/units/107802985/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:02:40.215734Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ht/?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": 107802986, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ht/?checksum=8f8798486d269085", "url": "https://translations.documentfoundation.org/api/units/107802986/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:02:40.216696Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ht/?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": 107802987, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ht/?checksum=97779b388756f796", "url": "https://translations.documentfoundation.org/api/units/107802987/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:02:40.217661Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ht/?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": 107802988, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ht/?checksum=97109c687a6cbcc5", "url": "https://translations.documentfoundation.org/api/units/107802988/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:02:40.218627Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ht/?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": 107802989, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ht/?checksum=68f9664066116f5e", "url": "https://translations.documentfoundation.org/api/units/107802989/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:02:40.219604Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ht/?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": 107802990, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ht/?checksum=dc47c813c5b39ae0", "url": "https://translations.documentfoundation.org/api/units/107802990/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:02:40.220629Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ht/?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": 107802991, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ht/?checksum=b8804936bbb6e76a", "url": "https://translations.documentfoundation.org/api/units/107802991/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:02:40.221637Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ht/?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": 107802992, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ht/?checksum=7ce09622aa850904", "url": "https://translations.documentfoundation.org/api/units/107802992/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:02:40.222608Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ht/?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": 107802993, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ht/?checksum=4b82a51e33e2ed25", "url": "https://translations.documentfoundation.org/api/units/107802993/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:02:40.223593Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ht/?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": 107802994, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ht/?checksum=5e023a2a0c2affac", "url": "https://translations.documentfoundation.org/api/units/107802994/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:02:40.224628Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ht/?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": 107802995, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ht/?checksum=7849316a0291e0c8", "url": "https://translations.documentfoundation.org/api/units/107802995/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:02:40.225604Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ht/?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": 107802996, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ht/?checksum=22270890ba3cf095", "url": "https://translations.documentfoundation.org/api/units/107802996/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:02:40.226646Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ht/?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": 107802997, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ht/?checksum=5886aeb7ed30b6a5", "url": "https://translations.documentfoundation.org/api/units/107802997/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:02:40.227670Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ht/?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": 107802998, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ht/?checksum=cf0f2a6362406892", "url": "https://translations.documentfoundation.org/api/units/107802998/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:02:40.228690Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ht/?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": 107802999, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ht/?checksum=9b6dd13be1999e6e", "url": "https://translations.documentfoundation.org/api/units/107802999/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:02:40.229827Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ht/?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": 107803000, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ht/?checksum=d1c1436eb826d119", "url": "https://translations.documentfoundation.org/api/units/107803000/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:02:40.231009Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ht/?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": 107803001, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ht/?checksum=5c2c16e4505d7fe4", "url": "https://translations.documentfoundation.org/api/units/107803001/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:02:40.232076Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ht/?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": 107803002, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ht/?checksum=d65863f2af599f88", "url": "https://translations.documentfoundation.org/api/units/107803002/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:02:40.233475Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ht/?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": 107803004, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ht/?checksum=3c00782e0b85aec3", "url": "https://translations.documentfoundation.org/api/units/107803004/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:02:40.234779Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ht/?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": 107803006, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ht/?checksum=6df5301aadc49aeb", "url": "https://translations.documentfoundation.org/api/units/107803006/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:02:40.236241Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ht/?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": 107803007, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ht/?checksum=631d20c605a20d23", "url": "https://translations.documentfoundation.org/api/units/107803007/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:02:40.237372Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ht/?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": 107803008, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ht/?checksum=68bd107572961497", "url": "https://translations.documentfoundation.org/api/units/107803008/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:02:40.238345Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ht/?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": 107803009, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ht/?checksum=a787366641c2ab24", "url": "https://translations.documentfoundation.org/api/units/107803009/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:02:40.239383Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ht/?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": 107803010, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ht/?checksum=70853ab037d30b7a", "url": "https://translations.documentfoundation.org/api/units/107803010/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:02:40.240566Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ht/?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": 107803012, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ht/?checksum=8d76aa7fa9b1a82a", "url": "https://translations.documentfoundation.org/api/units/107803012/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:02:40.241588Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ht/?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": 107803013, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ht/?checksum=e25b7d4e885bc602", "url": "https://translations.documentfoundation.org/api/units/107803013/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:02:40.242739Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ht/?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": 107803015, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ht/?checksum=f1c81b5956dcf2be", "url": "https://translations.documentfoundation.org/api/units/107803015/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:02:40.244109Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ht/?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": 107803016, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ht/?checksum=2ad0fabfdbbc21b0", "url": "https://translations.documentfoundation.org/api/units/107803016/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:02:40.245435Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ht/?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": 107803017, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ht/?checksum=57d745dd0c2dc6fe", "url": "https://translations.documentfoundation.org/api/units/107803017/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:02:40.246990Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ht/?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": 107803022, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ht/?checksum=d6e856e62a8ede53", "url": "https://translations.documentfoundation.org/api/units/107803022/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:02:40.248759Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ht/?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": 107803025, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ht/?checksum=e74352d1e5e89181", "url": "https://translations.documentfoundation.org/api/units/107803025/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:02:40.252120Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ht/?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": 107803028, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ht/?checksum=73b5da845ad0d65e", "url": "https://translations.documentfoundation.org/api/units/107803028/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:02:40.253615Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ht/?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": 107803031, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ht/?checksum=14d0fd4bb87eee4a", "url": "https://translations.documentfoundation.org/api/units/107803031/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:02:40.254967Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ht/?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": 107803034, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ht/?checksum=090896c1b159ca3a", "url": "https://translations.documentfoundation.org/api/units/107803034/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:02:40.256544Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ht/?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": 107803037, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ht/?checksum=f626d6d3b51bfaa6", "url": "https://translations.documentfoundation.org/api/units/107803037/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:02:40.258201Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ht/?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": 107803041, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ht/?checksum=2717695c7b093d7d", "url": "https://translations.documentfoundation.org/api/units/107803041/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:02:40.259956Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ht/?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": 107803042, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ht/?checksum=3ac5a4e5af5a11f3", "url": "https://translations.documentfoundation.org/api/units/107803042/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:02:40.261504Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ht/?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": 107803045, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ht/?checksum=cd7ac4b5ac8bc255", "url": "https://translations.documentfoundation.org/api/units/107803045/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:02:40.262999Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ht/?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": 107803047, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ht/?checksum=8ec5a81095830681", "url": "https://translations.documentfoundation.org/api/units/107803047/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:02:40.264224Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ht/?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": 107803049, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ht/?checksum=014585a5921ebdc4", "url": "https://translations.documentfoundation.org/api/units/107803049/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:02:40.265879Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ht/?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": 107803052, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ht/?checksum=4d0c58c2f962df32", "url": "https://translations.documentfoundation.org/api/units/107803052/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:02:40.267558Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ht/?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": 107803056, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ht/?checksum=e289bafaf2b0c7f7", "url": "https://translations.documentfoundation.org/api/units/107803056/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:02:40.269022Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/ht/?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": 107803060, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/ht/?checksum=b030e593968e4323", "url": "https://translations.documentfoundation.org/api/units/107803060/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:02:40.270370Z" } ] }{ "count": 1739, "next": "