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/en_ZA/units/?format=api&page=3
https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en_ZA/units/?format=api&page=4", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en_ZA/units/?format=api&page=2", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en_ZA/?format=api", "source": [ "For example:" ], "previous_source": "", "target": [ "" ], "id_hash": 8995234995823052801, "content_hash": 8995234995823052801, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3159335\nhelp.text", "note": "TWexq", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 101, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/107515828/?format=api", "priority": 100, "id": 107675868, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/en_ZA/?checksum=fcd57e91e5320801", "url": "https://translations.documentfoundation.org/api/units/107675868/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:34.204128Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en_ZA/?format=api", "source": [ "Table" ], "previous_source": "", "target": [ "" ], "id_hash": -5757111159800539212, "content_hash": -5757111159800539212, "location": "02010100.xhp", "context": "02010100.xhp\nhd_id3148485\nhelp.text", "note": "roTzi", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 102, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/107515831/?format=api", "priority": 100, "id": 107675873, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/en_ZA/?checksum=301aa1e713a6d7b4", "url": "https://translations.documentfoundation.org/api/units/107675873/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:34.205831Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en_ZA/?format=api", "source": [ "<ahelp hid=\"HID_QRYDGN_ROW_TABLE\">The corresponding database table of the selected data field is listed here.</ahelp> If you activate this cell with a mouse click, an arrow will appear which enables you to select a different table for the current query." ], "previous_source": "", "target": [ "" ], "id_hash": -8607992337364229760, "content_hash": -8607992337364229760, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3163665\nhelp.text", "note": "GM9Sp", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 103, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 38, "source_unit": "https://translations.documentfoundation.org/api/units/107515833/?format=api", "priority": 100, "id": 107675877, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/en_ZA/?checksum=088a4493861ee180", "url": "https://translations.documentfoundation.org/api/units/107675877/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:34.207858Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en_ZA/?format=api", "source": [ "Sort" ], "previous_source": "", "target": [ "" ], "id_hash": -2339764603938987521, "content_hash": -2339764603938987521, "location": "02010100.xhp", "context": "02010100.xhp\nhd_id3154207\nhelp.text", "note": "JGcfa", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 104, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/107515836/?format=api", "priority": 100, "id": 107675880, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/en_ZA/?checksum=5f877c7d442f21ff", "url": "https://translations.documentfoundation.org/api/units/107675880/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:34.210649Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en_ZA/?format=api", "source": [ "<ahelp hid=\"HID_QRYDGN_ROW_ORDER\">If you click on this cell, you can choose a sort option: ascending, descending and unsorted.</ahelp> Text fields will be sorted alphabetically and numerical fields numerically. For most databases, administrators can set the sorting options at the database level." ], "previous_source": "", "target": [ "" ], "id_hash": -1031038218170177832, "content_hash": -1031038218170177832, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3150979\nhelp.text", "note": "uXuDt", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 105, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 40, "source_unit": "https://translations.documentfoundation.org/api/units/107515838/?format=api", "priority": 100, "id": 107675883, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/en_ZA/?checksum=71b10434081d66d8", "url": "https://translations.documentfoundation.org/api/units/107675883/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:34.214447Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en_ZA/?format=api", "source": [ "Visible" ], "previous_source": "", "target": [ "" ], "id_hash": 6896535723236492576, "content_hash": 6896535723236492576, "location": "02010100.xhp", "context": "02010100.xhp\nhd_id3150384\nhelp.text", "note": "XsqW8", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 106, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/107515842/?format=api", "priority": 100, "id": 107675885, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/en_ZA/?checksum=dfb56ab36c4d8520", "url": "https://translations.documentfoundation.org/api/units/107675885/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:34.217258Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en_ZA/?format=api", "source": [ "<ahelp hid=\"HID_QRYDGN_ROW_VISIBLE\">If you mark the <emph>Visible</emph> property for a data field, that field will be visibly displayed in the resulting query</ahelp>. If you are only using a data field to formulate a condition or make a calculation, you do not necessarily need to display it." ], "previous_source": "", "target": [ "" ], "id_hash": -5614781346581602478, "content_hash": -5614781346581602478, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3146133\nhelp.text", "note": "AAZfA", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 107, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 45, "source_unit": "https://translations.documentfoundation.org/api/units/107515854/?format=api", "priority": 100, "id": 107675887, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/en_ZA/?checksum=32144a1d19839f52", "url": "https://translations.documentfoundation.org/api/units/107675887/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:34.219360Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en_ZA/?format=api", "source": [ "Criteria" ], "previous_source": "", "target": [ "" ], "id_hash": 469406007502932698, "content_hash": 469406007502932698, "location": "02010100.xhp", "context": "02010100.xhp\nhd_id3154714\nhelp.text", "note": "eQFRR", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 108, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/107515869/?format=api", "priority": 100, "id": 107675889, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/en_ZA/?checksum=8683aa46dca58ada", "url": "https://translations.documentfoundation.org/api/units/107675889/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:34.221851Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en_ZA/?format=api", "source": [ "<ahelp hid=\"HID_QRYDGN_ROW_CRIT\">Specifies a first criteria by which the content of the data field is to be filtered.</ahelp>" ], "previous_source": "", "target": [ "" ], "id_hash": 4919040097694507359, "content_hash": 4919040097694507359, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3145134\nhelp.text", "note": "fWRgB", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 109, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 17, "source_unit": "https://translations.documentfoundation.org/api/units/107515884/?format=api", "priority": 100, "id": 107675893, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/en_ZA/?checksum=c443f0e81afbe15f", "url": "https://translations.documentfoundation.org/api/units/107675893/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:34.224821Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en_ZA/?format=api", "source": [ "or" ], "previous_source": "", "target": [ "" ], "id_hash": -2192449250051491563, "content_hash": -2192449250051491563, "location": "02010100.xhp", "context": "02010100.xhp\nhd_id3152477\nhelp.text", "note": "qpADC", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 110, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/107515951/?format=api", "priority": 100, "id": 107675896, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/en_ZA/?checksum=6192db05ee9bf915", "url": "https://translations.documentfoundation.org/api/units/107675896/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:34.227505Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en_ZA/?format=api", "source": [ "Here you can enter one additional filter criterion for each line. Multiple criteria in a single column will be interpreted as boolean OR." ], "previous_source": "", "target": [ "" ], "id_hash": -5948053012660454605, "content_hash": -5948053012660454605, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3154585\nhelp.text", "note": "KFVy8", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 111, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 23, "source_unit": "https://translations.documentfoundation.org/api/units/107515974/?format=api", "priority": 100, "id": 107675897, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/en_ZA/?checksum=2d74454c932e7b33", "url": "https://translations.documentfoundation.org/api/units/107675897/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:34.229529Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en_ZA/?format=api", "source": [ "You can also use the context menu of the line headers in the lower area of the query design window to insert a filter based on a function:" ], "previous_source": "", "target": [ "" ], "id_hash": -4995871244841271865, "content_hash": -4995871244841271865, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3148800\nhelp.text", "note": "eXvp7", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 112, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 28, "source_unit": "https://translations.documentfoundation.org/api/units/107515995/?format=api", "priority": 100, "id": 107675901, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/en_ZA/?checksum=3aab199273a5bdc7", "url": "https://translations.documentfoundation.org/api/units/107675901/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:34.231988Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en_ZA/?format=api", "source": [ "Functions" ], "previous_source": "", "target": [ "" ], "id_hash": -3778155876137593813, "content_hash": -3778155876137593813, "location": "02010100.xhp", "context": "02010100.xhp\nhd_id3148419\nhelp.text", "note": "5x8LE", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 113, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/107516016/?format=api", "priority": 100, "id": 107675904, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/en_ZA/?checksum=4b914b3f88c3942b", "url": "https://translations.documentfoundation.org/api/units/107675904/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:34.233778Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en_ZA/?format=api", "source": [ "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\" visibility=\"hidden\">Select a function to run in the query.</ahelp> The functions which are available here depend on those provided by the database engine." ], "previous_source": "", "target": [ "" ], "id_hash": 1942541461262905934, "content_hash": 1942541461262905934, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3153233\nhelp.text", "note": "Cxhjn", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 114, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 24, "source_unit": "https://translations.documentfoundation.org/api/units/107516037/?format=api", "priority": 100, "id": 107675907, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/en_ZA/?checksum=9af54b2ac00b324e", "url": "https://translations.documentfoundation.org/api/units/107675907/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:34.235349Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en_ZA/?format=api", "source": [ "If you are working with the embedded HSQL database, the list box in the <emph>Function</emph> row offers you the following options:" ], "previous_source": "", "target": [ "" ], "id_hash": -4919950466613680551, "content_hash": -4919950466613680551, "location": "02010100.xhp", "context": "02010100.xhp\npar_id8760818\nhelp.text", "note": "qFuqw", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 115, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 21, "source_unit": "https://translations.documentfoundation.org/api/units/107516052/?format=api", "priority": 100, "id": 107675911, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/en_ZA/?checksum=3bb8d31e1cf96659", "url": "https://translations.documentfoundation.org/api/units/107675911/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:34.237079Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en_ZA/?format=api", "source": [ "Option" ], "previous_source": "", "target": [ "" ], "id_hash": -772347665347452252, "content_hash": -772347665347452252, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3150307\nhelp.text", "note": "9tdDn", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 116, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/107516083/?format=api", "priority": 100, "id": 107675914, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/en_ZA/?checksum=754811e3f3dce2a4", "url": "https://translations.documentfoundation.org/api/units/107675914/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:34.238666Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en_ZA/?format=api", "source": [ "Effect" ], "previous_source": "", "target": [ "" ], "id_hash": -7801313243572344229, "content_hash": -7801313243572344229, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3152993\nhelp.text", "note": "kBvXF", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 117, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/107516106/?format=api", "priority": 100, "id": 107675920, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/en_ZA/?checksum=13bc2af02751ea5b", "url": "https://translations.documentfoundation.org/api/units/107675920/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:34.240231Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en_ZA/?format=api", "source": [ "No function" ], "previous_source": "", "target": [ "" ], "id_hash": -7324759229702383126, "content_hash": -7324759229702383126, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3155377\nhelp.text", "note": "zCunm", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 118, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/107516121/?format=api", "priority": 100, "id": 107675923, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/en_ZA/?checksum=1a593a49f05359ea", "url": "https://translations.documentfoundation.org/api/units/107675923/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:34.244121Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en_ZA/?format=api", "source": [ "No function will be executed." ], "previous_source": "", "target": [ "" ], "id_hash": -619848378788163284, "content_hash": -619848378788163284, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3155533\nhelp.text", "note": "kZMTN", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 119, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/107516133/?format=api", "priority": 100, "id": 107675927, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/en_ZA/?checksum=7765db2effbad12c", "url": "https://translations.documentfoundation.org/api/units/107675927/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:34.246162Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en_ZA/?format=api", "source": [ "Average" ], "previous_source": "", "target": [ "" ], "id_hash": -3393985297947577142, "content_hash": -3393985297947577142, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3166420\nhelp.text", "note": "6dWZZ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 120, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/107516159/?format=api", "priority": 100, "id": 107675931, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/en_ZA/?checksum=50e6245a86efb4ca", "url": "https://translations.documentfoundation.org/api/units/107675931/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:34.248188Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en_ZA/?format=api", "source": [ "Calculates the arithmetic mean of a field." ], "previous_source": "", "target": [ "" ], "id_hash": 3066656777709062648, "content_hash": 3066656777709062648, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3154486\nhelp.text", "note": "NfRNs", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 121, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/107516172/?format=api", "priority": 100, "id": 107675936, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/en_ZA/?checksum=aa8ef4176b6489f8", "url": "https://translations.documentfoundation.org/api/units/107675936/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:34.252072Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en_ZA/?format=api", "source": [ "Count" ], "previous_source": "", "target": [ "" ], "id_hash": -5772603136064988624, "content_hash": -5772603136064988624, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3149979\nhelp.text", "note": "6z2Kj", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 122, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/107516190/?format=api", "priority": 100, "id": 107675939, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/en_ZA/?checksum=2fe39808458a5a30", "url": "https://translations.documentfoundation.org/api/units/107675939/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:34.253690Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en_ZA/?format=api", "source": [ "Determines the number of records in the table. Empty fields can either be counted (a) or excluded (b)." ], "previous_source": "", "target": [ "" ], "id_hash": -6730459759722231728, "content_hash": -6730459759722231728, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3155810\nhelp.text", "note": "rvWA5", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 123, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/107516224/?format=api", "priority": 100, "id": 107675942, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/en_ZA/?checksum=22989a820eb20850", "url": "https://translations.documentfoundation.org/api/units/107675942/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:34.254905Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en_ZA/?format=api", "source": [ "a) COUNT(*): Passing an asterisk as the argument counts all records in the table." ], "previous_source": "", "target": [ "" ], "id_hash": -6577677318719850332, "content_hash": -6577677318719850332, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3151333\nhelp.text", "note": "UyAx2", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 124, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/107516242/?format=api", "priority": 100, "id": 107675946, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/en_ZA/?checksum=24b76554228f38a4", "url": "https://translations.documentfoundation.org/api/units/107675946/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:34.256678Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en_ZA/?format=api", "source": [ "b) COUNT(column): Passing a field name as an argument counts only the records in which the specified field contains a value. Records in which the field has a Null value (i.e. contains no textual or numeric value) will not be counted." ], "previous_source": "", "target": [ "" ], "id_hash": -3702508971976732456, "content_hash": -3702508971976732456, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3152889\nhelp.text", "note": "FNCC8", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 125, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 41, "source_unit": "https://translations.documentfoundation.org/api/units/107516293/?format=api", "priority": 100, "id": 107675950, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/en_ZA/?checksum=4c9e0bb4eba150d8", "url": "https://translations.documentfoundation.org/api/units/107675950/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:34.258119Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en_ZA/?format=api", "source": [ "Maximum" ], "previous_source": "", "target": [ "" ], "id_hash": -3013235731327700788, "content_hash": -3013235731327700788, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3153067\nhelp.text", "note": "2ubvb", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 126, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/107516309/?format=api", "priority": 100, "id": 107675954, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/en_ZA/?checksum=562ed61131b2b0cc", "url": "https://translations.documentfoundation.org/api/units/107675954/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:34.259675Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en_ZA/?format=api", "source": [ "Determines the highest value of a record for that field." ], "previous_source": "", "target": [ "" ], "id_hash": -1271906049264834213, "content_hash": -1271906049264834213, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3159221\nhelp.text", "note": "ds4ey", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 127, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/107516343/?format=api", "priority": 100, "id": 107675959, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/en_ZA/?checksum=6e59482fe1e6295b", "url": "https://translations.documentfoundation.org/api/units/107675959/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:34.261337Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en_ZA/?format=api", "source": [ "Minimum" ], "previous_source": "", "target": [ "" ], "id_hash": -3369143774484625893, "content_hash": -3369143774484625893, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3146866\nhelp.text", "note": "EhSWy", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 128, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/107516351/?format=api", "priority": 100, "id": 107675964, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/en_ZA/?checksum=513e65966ca0061b", "url": "https://translations.documentfoundation.org/api/units/107675964/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:34.262963Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en_ZA/?format=api", "source": [ "Determines the lowest value of a record for that field." ], "previous_source": "", "target": [ "" ], "id_hash": 7910640238210885664, "content_hash": 7910640238210885664, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3157982\nhelp.text", "note": "VxmeB", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 129, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/107516366/?format=api", "priority": 100, "id": 107675967, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/en_ZA/?checksum=edc83d626078a820", "url": "https://translations.documentfoundation.org/api/units/107675967/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:34.264284Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en_ZA/?format=api", "source": [ "Sum" ], "previous_source": "", "target": [ "" ], "id_hash": -3951253331645022563, "content_hash": -3951253331645022563, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3154828\nhelp.text", "note": "CvkuF", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 130, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/107516372/?format=api", "priority": 100, "id": 107675971, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/en_ZA/?checksum=492a54078db83e9d", "url": "https://translations.documentfoundation.org/api/units/107675971/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:34.265963Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en_ZA/?format=api", "source": [ "Calculates the sum of the values of records for the associated fields." ], "previous_source": "", "target": [ "" ], "id_hash": -1293247112796432643, "content_hash": -1293247112796432643, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3154536\nhelp.text", "note": "82gAC", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 131, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/107516382/?format=api", "priority": 100, "id": 107675975, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/en_ZA/?checksum=6e0d769a52f816fd", "url": "https://translations.documentfoundation.org/api/units/107675975/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:34.268544Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en_ZA/?format=api", "source": [ "Group" ], "previous_source": "", "target": [ "" ], "id_hash": 5611092234196237787, "content_hash": 5611092234196237787, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3148820\nhelp.text", "note": "zCzVC", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 132, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/107516389/?format=api", "priority": 100, "id": 107675993, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/en_ZA/?checksum=cdde9aa87d383ddb", "url": "https://translations.documentfoundation.org/api/units/107675993/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:34.282668Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en_ZA/?format=api", "source": [ "Groups query data according to the selected field name. Functions are executed according to the specified groups. In SQL, this option corresponds to the GROUP BY clause. If a criterion is added, this entry appears in the SQL HAVING sub-clause." ], "previous_source": "", "target": [ "" ], "id_hash": -7409234191239514324, "content_hash": -7409234191239514324, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3149438\nhelp.text", "note": "tSPNG", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 133, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 40, "source_unit": "https://translations.documentfoundation.org/api/units/107516410/?format=api", "priority": 100, "id": 107675998, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/en_ZA/?checksum=192d1cc2457d772c", "url": "https://translations.documentfoundation.org/api/units/107675998/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:34.285309Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en_ZA/?format=api", "source": [ "You can also enter function calls directly into the SQL statement. The syntax is:" ], "previous_source": "", "target": [ "" ], "id_hash": -3806082811502480015, "content_hash": -3806082811502480015, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3156038\nhelp.text", "note": "qHfpD", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 134, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/107516415/?format=api", "priority": 100, "id": 107676003, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/en_ZA/?checksum=4b2e13d932acb571", "url": "https://translations.documentfoundation.org/api/units/107676003/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:34.288467Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en_ZA/?format=api", "source": [ "SELECT FUNCTION(column) FROM table." ], "previous_source": "", "target": [ "" ], "id_hash": -1305221081140801602, "content_hash": -1305221081140801602, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3156340\nhelp.text", "note": "Qg6Ue", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 135, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/107516420/?format=api", "priority": 100, "id": 107676008, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/en_ZA/?checksum=6de2ec5791404fbe", "url": "https://translations.documentfoundation.org/api/units/107676008/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:34.290331Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en_ZA/?format=api", "source": [ "For example, the function call in SQL for calculating a sum is:" ], "previous_source": "", "target": [ "" ], "id_hash": -7092442938933433496, "content_hash": -7092442938933433496, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3155075\nhelp.text", "note": "qAAoF", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 136, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/107516436/?format=api", "priority": 100, "id": 107676011, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/en_ZA/?checksum=1d9294b973252b68", "url": "https://translations.documentfoundation.org/api/units/107676011/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:34.291908Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en_ZA/?format=api", "source": [ "SELECT SUM(\"Price\") FROM \"Article\"." ], "previous_source": "", "target": [ "" ], "id_hash": 6764390312089837957, "content_hash": 6764390312089837957, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3154591\nhelp.text", "note": "VrHLf", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 137, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/107516457/?format=api", "priority": 100, "id": 107676015, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/en_ZA/?checksum=dddff1264a356185", "url": "https://translations.documentfoundation.org/api/units/107676015/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:34.293722Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en_ZA/?format=api", "source": [ "Except for the <emph>Group</emph> function, the above functions are called Aggregate functions. These are functions that calculate data to create summaries from the results. Additional functions that are not listed in the list box might be also possible. These depend on the specific database engine in use and on the current functionality provided by the Base driver used to connect to that database engine." ], "previous_source": "", "target": [ "" ], "id_hash": -5781971165104475833, "content_hash": -5781971165104475833, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3159205\nhelp.text", "note": "dABCo", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 138, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 64, "source_unit": "https://translations.documentfoundation.org/api/units/107516464/?format=api", "priority": 100, "id": 107676020, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/en_ZA/?checksum=2fc24fdc0a657147", "url": "https://translations.documentfoundation.org/api/units/107676020/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:34.295363Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en_ZA/?format=api", "source": [ "To use other functions not listed in the list box, you must enter them manually under <emph>Field</emph>." ], "previous_source": "", "target": [ "" ], "id_hash": -2209269641612400515, "content_hash": -2209269641612400515, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3148651\nhelp.text", "note": "BVC6J", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 139, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 17, "source_unit": "https://translations.documentfoundation.org/api/units/107516486/?format=api", "priority": 100, "id": 107676026, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/en_ZA/?checksum=615718f756a3687d", "url": "https://translations.documentfoundation.org/api/units/107676026/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:34.297721Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en_ZA/?format=api", "source": [ "You can also assign aliases to function calls. If you do not want to display the query string in the column header, enter a desired substitute name under <emph>Alias</emph>." ], "previous_source": "", "target": [ "" ], "id_hash": 4139553630722688505, "content_hash": 4139553630722688505, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3155098\nhelp.text", "note": "WkboS", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 140, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 29, "source_unit": "https://translations.documentfoundation.org/api/units/107516500/?format=api", "priority": 100, "id": 107676030, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/en_ZA/?checksum=b972a61847e785f9", "url": "https://translations.documentfoundation.org/api/units/107676030/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:34.300537Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en_ZA/?format=api", "source": [ "The corresponding function in an SQL statement is:" ], "previous_source": "", "target": [ "" ], "id_hash": 9037870816902336553, "content_hash": 9037870816902336553, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3155539\nhelp.text", "note": "98GCC", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 141, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/107516540/?format=api", "priority": 100, "id": 107676033, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/en_ZA/?checksum=fd6cf79f8f555029", "url": "https://translations.documentfoundation.org/api/units/107676033/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:34.302471Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en_ZA/?format=api", "source": [ "SELECT FUNCTION() AS alias FROM table" ], "previous_source": "", "target": [ "" ], "id_hash": 3137508638940812960, "content_hash": 3137508638940812960, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3149425\nhelp.text", "note": "WACG9", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 142, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/107516555/?format=api", "priority": 100, "id": 107676038, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/en_ZA/?checksum=ab8aab7bdfc956a0", "url": "https://translations.documentfoundation.org/api/units/107676038/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:34.304319Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en_ZA/?format=api", "source": [ "Example:" ], "previous_source": "", "target": [ "" ], "id_hash": 3538033891106052086, "content_hash": 3538033891106052086, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3144431\nhelp.text", "note": "EjzuD", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 143, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/107516563/?format=api", "priority": 100, "id": 107676046, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/en_ZA/?checksum=b1199f1422ab57f6", "url": "https://translations.documentfoundation.org/api/units/107676046/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:34.305973Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en_ZA/?format=api", "source": [ "SELECT COUNT(*) AS count FROM \"Item\"" ], "previous_source": "", "target": [ "" ], "id_hash": -5763803079986489729, "content_hash": -5763803079986489729, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3154614\nhelp.text", "note": "G9URE", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 144, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/107516591/?format=api", "priority": 100, "id": 107676051, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/en_ZA/?checksum=3002dba2fe1a567f", "url": "https://translations.documentfoundation.org/api/units/107676051/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:34.307587Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en_ZA/?format=api", "source": [ "If you run such a function, you cannot insert any additional columns for the query other than as an argument in a \"Group\" function." ], "previous_source": "", "target": [ "" ], "id_hash": 5156466470725607062, "content_hash": 5156466470725607062, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3154610\nhelp.text", "note": "xiNnR", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 145, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 24, "source_unit": "https://translations.documentfoundation.org/api/units/107516617/?format=api", "priority": 100, "id": 107676057, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/en_ZA/?checksum=c78f72ef5bcfde96", "url": "https://translations.documentfoundation.org/api/units/107676057/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:34.309214Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en_ZA/?format=api", "source": [ "<emph>Examples</emph>" ], "previous_source": "", "target": [ "" ], "id_hash": 8201778419404166585, "content_hash": 8201778419404166585, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3154644\nhelp.text", "note": "EHACK", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 146, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/107516631/?format=api", "priority": 100, "id": 107676065, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/en_ZA/?checksum=f1d292047f0cd5b9", "url": "https://translations.documentfoundation.org/api/units/107676065/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:34.311119Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en_ZA/?format=api", "source": [ "In the following example, a query is run through two tables: an \"Item\" table with the \"Item_No\" field and a \"Suppliers\" table with the \"Supplier_Name\" field. In addition, both tables have a common field name \"Supplier_No.\"" ], "previous_source": "", "target": [ "" ], "id_hash": 5859342271891411772, "content_hash": 5859342271891411772, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3151120\nhelp.text", "note": "N5CBE", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 147, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 36, "source_unit": "https://translations.documentfoundation.org/api/units/107516674/?format=api", "priority": 100, "id": 107676072, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/en_ZA/?checksum=d15090c08d84933c", "url": "https://translations.documentfoundation.org/api/units/107676072/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:34.313357Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en_ZA/?format=api", "source": [ "The following steps are required to create a query containing all suppliers who deliver more than three items." ], "previous_source": "", "target": [ "" ], "id_hash": -4011807035459456714, "content_hash": -4011807035459456714, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3155144\nhelp.text", "note": "P5hJD", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 148, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/107516687/?format=api", "priority": 100, "id": 107676078, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/en_ZA/?checksum=485332c1b806b136", "url": "https://translations.documentfoundation.org/api/units/107676078/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:34.315341Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en_ZA/?format=api", "source": [ "Insert the \"Item\" and \"Suppliers\" tables into the query design." ], "previous_source": "", "target": [ "" ], "id_hash": 1435240278817732818, "content_hash": 1435240278817732818, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3153240\nhelp.text", "note": "ZhRQD", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 149, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/107516695/?format=api", "priority": 100, "id": 107676085, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/en_ZA/?checksum=93eaff6dea4378d2", "url": "https://translations.documentfoundation.org/api/units/107676085/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:34.317164Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en_ZA/?format=api", "source": [ "Link the \"Supplier_No\" fields of the two tables if there is not already a relation of this type." ], "previous_source": "", "target": [ "" ], "id_hash": 2905548939711794635, "content_hash": 2905548939711794635, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3148807\nhelp.text", "note": "LMRUV", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 150, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/107516703/?format=api", "priority": 100, "id": 107676092, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsdatabase/en_ZA/?checksum=a852955dcd08cdcb", "url": "https://translations.documentfoundation.org/api/units/107676092/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T17:00:34.319000Z" } ] }{ "count": 1739, "next": "