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