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/en/units/?format=api&page=3
https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/units/?format=api&page=4", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/units/?format=api&page=2", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?format=api", "source": [ "For example:" ], "previous_source": "", "target": [ "For example:" ], "id_hash": 8995234995823052801, "content_hash": 8995234995823052801, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3159335\nhelp.text", "note": "TWexq", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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/95825571/?format=api", "priority": 100, "id": 95825571, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=fcd57e91e5320801", "url": "https://translations.documentfoundation.org/api/units/95825571/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:08.090742Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?format=api", "source": [ "Table" ], "previous_source": "", "target": [ "Table" ], "id_hash": -5757111159800539212, "content_hash": -5757111159800539212, "location": "02010100.xhp", "context": "02010100.xhp\nhd_id3148485\nhelp.text", "note": "roTzi", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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/95825652/?format=api", "priority": 100, "id": 95825652, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=301aa1e713a6d7b4", "url": "https://translations.documentfoundation.org/api/units/95825652/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:08.119636Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?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": [ "<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." ], "id_hash": -8607992337364229760, "content_hash": -8607992337364229760, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3163665\nhelp.text", "note": "GM9Sp", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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/95825774/?format=api", "priority": 100, "id": 95825774, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=088a4493861ee180", "url": "https://translations.documentfoundation.org/api/units/95825774/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:08.153097Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?format=api", "source": [ "Sort" ], "previous_source": "", "target": [ "Sort" ], "id_hash": -2339764603938987521, "content_hash": -2339764603938987521, "location": "02010100.xhp", "context": "02010100.xhp\nhd_id3154207\nhelp.text", "note": "JGcfa", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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/95825842/?format=api", "priority": 100, "id": 95825842, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=5f877c7d442f21ff", "url": "https://translations.documentfoundation.org/api/units/95825842/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:08.167930Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?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": [ "<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." ], "id_hash": -1031038218170177832, "content_hash": -1031038218170177832, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3150979\nhelp.text", "note": "uXuDt", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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/95825902/?format=api", "priority": 100, "id": 95825902, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=71b10434081d66d8", "url": "https://translations.documentfoundation.org/api/units/95825902/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:08.186387Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?format=api", "source": [ "Visible" ], "previous_source": "", "target": [ "Visible" ], "id_hash": 6896535723236492576, "content_hash": 6896535723236492576, "location": "02010100.xhp", "context": "02010100.xhp\nhd_id3150384\nhelp.text", "note": "XsqW8", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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/95826013/?format=api", "priority": 100, "id": 95826013, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=dfb56ab36c4d8520", "url": "https://translations.documentfoundation.org/api/units/95826013/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:08.225367Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?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": [ "<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." ], "id_hash": -5614781346581602478, "content_hash": -5614781346581602478, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3146133\nhelp.text", "note": "AAZfA", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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/95826058/?format=api", "priority": 100, "id": 95826058, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=32144a1d19839f52", "url": "https://translations.documentfoundation.org/api/units/95826058/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:08.244107Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?format=api", "source": [ "Criteria" ], "previous_source": "", "target": [ "Criteria" ], "id_hash": 469406007502932698, "content_hash": 469406007502932698, "location": "02010100.xhp", "context": "02010100.xhp\nhd_id3154714\nhelp.text", "note": "eQFRR", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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/95826123/?format=api", "priority": 100, "id": 95826123, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=8683aa46dca58ada", "url": "https://translations.documentfoundation.org/api/units/95826123/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:08.264760Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?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": [ "<ahelp hid=\"HID_QRYDGN_ROW_CRIT\">Specifies a first criteria by which the content of the data field is to be filtered.</ahelp>" ], "id_hash": 4919040097694507359, "content_hash": 4919040097694507359, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3145134\nhelp.text", "note": "fWRgB", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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/95826170/?format=api", "priority": 100, "id": 95826170, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=c443f0e81afbe15f", "url": "https://translations.documentfoundation.org/api/units/95826170/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:08.280893Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?format=api", "source": [ "or" ], "previous_source": "", "target": [ "or" ], "id_hash": -2192449250051491563, "content_hash": -2192449250051491563, "location": "02010100.xhp", "context": "02010100.xhp\nhd_id3152477\nhelp.text", "note": "qpADC", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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/95826203/?format=api", "priority": 100, "id": 95826203, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=6192db05ee9bf915", "url": "https://translations.documentfoundation.org/api/units/95826203/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:08.293737Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?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": [ "Here you can enter one additional filter criterion for each line. Multiple criteria in a single column will be interpreted as boolean OR." ], "id_hash": -5948053012660454605, "content_hash": -5948053012660454605, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3154585\nhelp.text", "note": "KFVy8", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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/95826251/?format=api", "priority": 100, "id": 95826251, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=2d74454c932e7b33", "url": "https://translations.documentfoundation.org/api/units/95826251/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:08.321521Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?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": [ "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:" ], "id_hash": -4995871244841271865, "content_hash": -4995871244841271865, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3148800\nhelp.text", "note": "eXvp7", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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/95826316/?format=api", "priority": 100, "id": 95826316, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=3aab199273a5bdc7", "url": "https://translations.documentfoundation.org/api/units/95826316/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:08.346442Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?format=api", "source": [ "Functions" ], "previous_source": "", "target": [ "Functions" ], "id_hash": -3778155876137593813, "content_hash": -3778155876137593813, "location": "02010100.xhp", "context": "02010100.xhp\nhd_id3148419\nhelp.text", "note": "5x8LE", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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/95826376/?format=api", "priority": 100, "id": 95826376, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=4b914b3f88c3942b", "url": "https://translations.documentfoundation.org/api/units/95826376/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:08.371878Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?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": [ "<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." ], "id_hash": 1942541461262905934, "content_hash": 1942541461262905934, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3153233\nhelp.text", "note": "Cxhjn", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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/95826419/?format=api", "priority": 100, "id": 95826419, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=9af54b2ac00b324e", "url": "https://translations.documentfoundation.org/api/units/95826419/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:08.400028Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?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": [ "If you are working with the embedded HSQL database, the list box in the <emph>Function</emph> row offers you the following options:" ], "id_hash": -4919950466613680551, "content_hash": -4919950466613680551, "location": "02010100.xhp", "context": "02010100.xhp\npar_id8760818\nhelp.text", "note": "qFuqw", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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/95826449/?format=api", "priority": 100, "id": 95826449, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=3bb8d31e1cf96659", "url": "https://translations.documentfoundation.org/api/units/95826449/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:08.417343Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?format=api", "source": [ "Option" ], "previous_source": "", "target": [ "Option" ], "id_hash": -772347665347452252, "content_hash": -772347665347452252, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3150307\nhelp.text", "note": "9tdDn", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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/95826492/?format=api", "priority": 100, "id": 95826492, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=754811e3f3dce2a4", "url": "https://translations.documentfoundation.org/api/units/95826492/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:08.433258Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?format=api", "source": [ "Effect" ], "previous_source": "", "target": [ "Effect" ], "id_hash": -7801313243572344229, "content_hash": -7801313243572344229, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3152993\nhelp.text", "note": "kBvXF", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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/95826517/?format=api", "priority": 100, "id": 95826517, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=13bc2af02751ea5b", "url": "https://translations.documentfoundation.org/api/units/95826517/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:08.447139Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?format=api", "source": [ "No function" ], "previous_source": "", "target": [ "No function" ], "id_hash": -7324759229702383126, "content_hash": -7324759229702383126, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3155377\nhelp.text", "note": "zCunm", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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/95826589/?format=api", "priority": 100, "id": 95826589, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=1a593a49f05359ea", "url": "https://translations.documentfoundation.org/api/units/95826589/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:08.474647Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?format=api", "source": [ "No function will be executed." ], "previous_source": "", "target": [ "No function will be executed." ], "id_hash": -619848378788163284, "content_hash": -619848378788163284, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3155533\nhelp.text", "note": "kZMTN", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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/95826629/?format=api", "priority": 100, "id": 95826629, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=7765db2effbad12c", "url": "https://translations.documentfoundation.org/api/units/95826629/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:08.490139Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?format=api", "source": [ "Average" ], "previous_source": "", "target": [ "Average" ], "id_hash": -3393985297947577142, "content_hash": -3393985297947577142, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3166420\nhelp.text", "note": "6dWZZ", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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/95826691/?format=api", "priority": 100, "id": 95826691, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=50e6245a86efb4ca", "url": "https://translations.documentfoundation.org/api/units/95826691/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:08.509189Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?format=api", "source": [ "Calculates the arithmetic mean of a field." ], "previous_source": "", "target": [ "Calculates the arithmetic mean of a field." ], "id_hash": 3066656777709062648, "content_hash": 3066656777709062648, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3154486\nhelp.text", "note": "NfRNs", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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/95826764/?format=api", "priority": 100, "id": 95826764, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=aa8ef4176b6489f8", "url": "https://translations.documentfoundation.org/api/units/95826764/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:08.536597Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?format=api", "source": [ "Count" ], "previous_source": "", "target": [ "Count" ], "id_hash": -5772603136064988624, "content_hash": -5772603136064988624, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3149979\nhelp.text", "note": "6z2Kj", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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/95826805/?format=api", "priority": 100, "id": 95826805, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=2fe39808458a5a30", "url": "https://translations.documentfoundation.org/api/units/95826805/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:08.558799Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?format=api", "source": [ "Determines the number of records in the table. Empty fields can either be counted (a) or excluded (b)." ], "previous_source": "", "target": [ "Determines the number of records in the table. Empty fields can either be counted (a) or excluded (b)." ], "id_hash": -6730459759722231728, "content_hash": -6730459759722231728, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3155810\nhelp.text", "note": "rvWA5", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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/95826837/?format=api", "priority": 100, "id": 95826837, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=22989a820eb20850", "url": "https://translations.documentfoundation.org/api/units/95826837/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:08.573625Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?format=api", "source": [ "a) COUNT(*): Passing an asterisk as the argument counts all records in the table." ], "previous_source": "", "target": [ "a) COUNT(*): Passing an asterisk as the argument counts all records in the table." ], "id_hash": -6577677318719850332, "content_hash": -6577677318719850332, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3151333\nhelp.text", "note": "UyAx2", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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/95826892/?format=api", "priority": 100, "id": 95826892, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=24b76554228f38a4", "url": "https://translations.documentfoundation.org/api/units/95826892/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:08.600966Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?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": [ "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." ], "id_hash": -3702508971976732456, "content_hash": -3702508971976732456, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3152889\nhelp.text", "note": "FNCC8", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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/95826934/?format=api", "priority": 100, "id": 95826934, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=4c9e0bb4eba150d8", "url": "https://translations.documentfoundation.org/api/units/95826934/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:08.622457Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?format=api", "source": [ "Maximum" ], "previous_source": "", "target": [ "Maximum" ], "id_hash": -3013235731327700788, "content_hash": -3013235731327700788, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3153067\nhelp.text", "note": "2ubvb", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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/95826971/?format=api", "priority": 100, "id": 95826971, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=562ed61131b2b0cc", "url": "https://translations.documentfoundation.org/api/units/95826971/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:08.643474Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?format=api", "source": [ "Determines the highest value of a record for that field." ], "previous_source": "", "target": [ "Determines the highest value of a record for that field." ], "id_hash": -1271906049264834213, "content_hash": -1271906049264834213, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3159221\nhelp.text", "note": "ds4ey", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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/95827011/?format=api", "priority": 100, "id": 95827011, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=6e59482fe1e6295b", "url": "https://translations.documentfoundation.org/api/units/95827011/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:08.666050Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?format=api", "source": [ "Minimum" ], "previous_source": "", "target": [ "Minimum" ], "id_hash": -3369143774484625893, "content_hash": -3369143774484625893, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3146866\nhelp.text", "note": "EhSWy", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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/95827040/?format=api", "priority": 100, "id": 95827040, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=513e65966ca0061b", "url": "https://translations.documentfoundation.org/api/units/95827040/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:08.688670Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?format=api", "source": [ "Determines the lowest value of a record for that field." ], "previous_source": "", "target": [ "Determines the lowest value of a record for that field." ], "id_hash": 7910640238210885664, "content_hash": 7910640238210885664, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3157982\nhelp.text", "note": "VxmeB", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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/95827059/?format=api", "priority": 100, "id": 95827059, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=edc83d626078a820", "url": "https://translations.documentfoundation.org/api/units/95827059/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:08.698780Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?format=api", "source": [ "Sum" ], "previous_source": "", "target": [ "Sum" ], "id_hash": -3951253331645022563, "content_hash": -3951253331645022563, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3154828\nhelp.text", "note": "CvkuF", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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/95827094/?format=api", "priority": 100, "id": 95827094, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=492a54078db83e9d", "url": "https://translations.documentfoundation.org/api/units/95827094/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:08.710595Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?format=api", "source": [ "Calculates the sum of the values of records for the associated fields." ], "previous_source": "", "target": [ "Calculates the sum of the values of records for the associated fields." ], "id_hash": -1293247112796432643, "content_hash": -1293247112796432643, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3154536\nhelp.text", "note": "82gAC", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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/95827140/?format=api", "priority": 100, "id": 95827140, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=6e0d769a52f816fd", "url": "https://translations.documentfoundation.org/api/units/95827140/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:08.723087Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?format=api", "source": [ "Group" ], "previous_source": "", "target": [ "Group" ], "id_hash": 5611092234196237787, "content_hash": 5611092234196237787, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3148820\nhelp.text", "note": "zCzVC", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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/95827182/?format=api", "priority": 100, "id": 95827182, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=cdde9aa87d383ddb", "url": "https://translations.documentfoundation.org/api/units/95827182/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:08.735330Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?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": [ "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." ], "id_hash": -7409234191239514324, "content_hash": -7409234191239514324, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3149438\nhelp.text", "note": "tSPNG", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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/95827224/?format=api", "priority": 100, "id": 95827224, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=192d1cc2457d772c", "url": "https://translations.documentfoundation.org/api/units/95827224/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:08.747059Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?format=api", "source": [ "You can also enter function calls directly into the SQL statement. The syntax is:" ], "previous_source": "", "target": [ "You can also enter function calls directly into the SQL statement. The syntax is:" ], "id_hash": -3806082811502480015, "content_hash": -3806082811502480015, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3156038\nhelp.text", "note": "qHfpD", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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/95827257/?format=api", "priority": 100, "id": 95827257, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=4b2e13d932acb571", "url": "https://translations.documentfoundation.org/api/units/95827257/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:08.766783Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?format=api", "source": [ "SELECT FUNCTION(column) FROM table." ], "previous_source": "", "target": [ "SELECT FUNCTION(column) FROM table." ], "id_hash": -1305221081140801602, "content_hash": -1305221081140801602, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3156340\nhelp.text", "note": "Qg6Ue", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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/95827296/?format=api", "priority": 100, "id": 95827296, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=6de2ec5791404fbe", "url": "https://translations.documentfoundation.org/api/units/95827296/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:08.787579Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?format=api", "source": [ "For example, the function call in SQL for calculating a sum is:" ], "previous_source": "", "target": [ "For example, the function call in SQL for calculating a sum is:" ], "id_hash": -7092442938933433496, "content_hash": -7092442938933433496, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3155075\nhelp.text", "note": "qAAoF", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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/95827342/?format=api", "priority": 100, "id": 95827342, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=1d9294b973252b68", "url": "https://translations.documentfoundation.org/api/units/95827342/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:08.807328Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?format=api", "source": [ "SELECT SUM(\"Price\") FROM \"Article\"." ], "previous_source": "", "target": [ "SELECT SUM(\"Price\") FROM \"Article\"." ], "id_hash": 6764390312089837957, "content_hash": 6764390312089837957, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3154591\nhelp.text", "note": "VrHLf", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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/95827373/?format=api", "priority": 100, "id": 95827373, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=dddff1264a356185", "url": "https://translations.documentfoundation.org/api/units/95827373/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:08.832488Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?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": [ "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." ], "id_hash": -5781971165104475833, "content_hash": -5781971165104475833, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3159205\nhelp.text", "note": "dABCo", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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/95827394/?format=api", "priority": 100, "id": 95827394, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=2fc24fdc0a657147", "url": "https://translations.documentfoundation.org/api/units/95827394/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:08.845158Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?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": [ "To use other functions not listed in the list box, you must enter them manually under <emph>Field</emph>." ], "id_hash": -2209269641612400515, "content_hash": -2209269641612400515, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3148651\nhelp.text", "note": "BVC6J", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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/95827434/?format=api", "priority": 100, "id": 95827434, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=615718f756a3687d", "url": "https://translations.documentfoundation.org/api/units/95827434/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:08.868178Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?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": [ "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>." ], "id_hash": 4139553630722688505, "content_hash": 4139553630722688505, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3155098\nhelp.text", "note": "WkboS", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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/95827456/?format=api", "priority": 100, "id": 95827456, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=b972a61847e785f9", "url": "https://translations.documentfoundation.org/api/units/95827456/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:08.882947Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?format=api", "source": [ "The corresponding function in an SQL statement is:" ], "previous_source": "", "target": [ "The corresponding function in an SQL statement is:" ], "id_hash": 9037870816902336553, "content_hash": 9037870816902336553, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3155539\nhelp.text", "note": "98GCC", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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/95827484/?format=api", "priority": 100, "id": 95827484, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=fd6cf79f8f555029", "url": "https://translations.documentfoundation.org/api/units/95827484/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:08.894811Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?format=api", "source": [ "SELECT FUNCTION() AS alias FROM table" ], "previous_source": "", "target": [ "SELECT FUNCTION() AS alias FROM table" ], "id_hash": 3137508638940812960, "content_hash": 3137508638940812960, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3149425\nhelp.text", "note": "WACG9", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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/95827521/?format=api", "priority": 100, "id": 95827521, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=ab8aab7bdfc956a0", "url": "https://translations.documentfoundation.org/api/units/95827521/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:08.909100Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?format=api", "source": [ "Example:" ], "previous_source": "", "target": [ "Example:" ], "id_hash": 3538033891106052086, "content_hash": 3538033891106052086, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3144431\nhelp.text", "note": "EjzuD", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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/95827555/?format=api", "priority": 100, "id": 95827555, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=b1199f1422ab57f6", "url": "https://translations.documentfoundation.org/api/units/95827555/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:08.926775Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?format=api", "source": [ "SELECT COUNT(*) AS count FROM \"Item\"" ], "previous_source": "", "target": [ "SELECT COUNT(*) AS count FROM \"Item\"" ], "id_hash": -5763803079986489729, "content_hash": -5763803079986489729, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3154614\nhelp.text", "note": "G9URE", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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/95827653/?format=api", "priority": 100, "id": 95827653, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=3002dba2fe1a567f", "url": "https://translations.documentfoundation.org/api/units/95827653/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:08.972454Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?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": [ "If you run such a function, you cannot insert any additional columns for the query other than as an argument in a \"Group\" function." ], "id_hash": 5156466470725607062, "content_hash": 5156466470725607062, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3154610\nhelp.text", "note": "xiNnR", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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/95827708/?format=api", "priority": 100, "id": 95827708, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=c78f72ef5bcfde96", "url": "https://translations.documentfoundation.org/api/units/95827708/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:09.002783Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?format=api", "source": [ "<emph>Examples</emph>" ], "previous_source": "", "target": [ "<emph>Examples</emph>" ], "id_hash": 8201778419404166585, "content_hash": 8201778419404166585, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3154644\nhelp.text", "note": "EHACK", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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/95827720/?format=api", "priority": 100, "id": 95827720, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=f1d292047f0cd5b9", "url": "https://translations.documentfoundation.org/api/units/95827720/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:09.015071Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?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": [ "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.\"" ], "id_hash": 5859342271891411772, "content_hash": 5859342271891411772, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3151120\nhelp.text", "note": "N5CBE", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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/95827737/?format=api", "priority": 100, "id": 95827737, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=d15090c08d84933c", "url": "https://translations.documentfoundation.org/api/units/95827737/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:09.025801Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?format=api", "source": [ "The following steps are required to create a query containing all suppliers who deliver more than three items." ], "previous_source": "", "target": [ "The following steps are required to create a query containing all suppliers who deliver more than three items." ], "id_hash": -4011807035459456714, "content_hash": -4011807035459456714, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3155144\nhelp.text", "note": "P5hJD", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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/95827763/?format=api", "priority": 100, "id": 95827763, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=485332c1b806b136", "url": "https://translations.documentfoundation.org/api/units/95827763/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:09.037148Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?format=api", "source": [ "Insert the \"Item\" and \"Suppliers\" tables into the query design." ], "previous_source": "", "target": [ "Insert the \"Item\" and \"Suppliers\" tables into the query design." ], "id_hash": 1435240278817732818, "content_hash": 1435240278817732818, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3153240\nhelp.text", "note": "ZhRQD", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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/95827783/?format=api", "priority": 100, "id": 95827783, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=93eaff6dea4378d2", "url": "https://translations.documentfoundation.org/api/units/95827783/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:09.048464Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/?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": [ "Link the \"Supplier_No\" fields of the two tables if there is not already a relation of this type." ], "id_hash": 2905548939711794635, "content_hash": 2905548939711794635, "location": "02010100.xhp", "context": "02010100.xhp\npar_id3148807\nhelp.text", "note": "LMRUV", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "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/95827822/?format=api", "priority": 100, "id": 95827822, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en/?checksum=a852955dcd08cdcb", "url": "https://translations.documentfoundation.org/api/units/95827822/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T21:32:09.076181Z" } ] }{ "count": 1739, "next": "