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_ZA/units/?format=api&page=3
HTTP 200 OK
Allow: GET, POST, HEAD, OPTIONS
Content-Type: application/json
Vary: Accept

{
    "count": 1739,
    "next": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en_ZA/units/?format=api&page=4",
    "previous": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en_ZA/units/?format=api&page=2",
    "results": [
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/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/95825571/?format=api",
            "priority": 100,
            "id": 96145443,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en_ZA/?checksum=fcd57e91e5320801",
            "url": "https://translations.documentfoundation.org/api/units/96145443/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:37:06.627309Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/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/95825652/?format=api",
            "priority": 100,
            "id": 96145445,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en_ZA/?checksum=301aa1e713a6d7b4",
            "url": "https://translations.documentfoundation.org/api/units/96145445/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:37:06.628962Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/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/95825774/?format=api",
            "priority": 100,
            "id": 96145448,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en_ZA/?checksum=088a4493861ee180",
            "url": "https://translations.documentfoundation.org/api/units/96145448/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:37:06.630702Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/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/95825842/?format=api",
            "priority": 100,
            "id": 96145452,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en_ZA/?checksum=5f877c7d442f21ff",
            "url": "https://translations.documentfoundation.org/api/units/96145452/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:37:06.632235Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/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/95825902/?format=api",
            "priority": 100,
            "id": 96145455,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en_ZA/?checksum=71b10434081d66d8",
            "url": "https://translations.documentfoundation.org/api/units/96145455/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:37:06.633537Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/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/95826013/?format=api",
            "priority": 100,
            "id": 96145459,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en_ZA/?checksum=dfb56ab36c4d8520",
            "url": "https://translations.documentfoundation.org/api/units/96145459/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:37:06.634995Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/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/95826058/?format=api",
            "priority": 100,
            "id": 96145462,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en_ZA/?checksum=32144a1d19839f52",
            "url": "https://translations.documentfoundation.org/api/units/96145462/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:37:06.636482Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/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/95826123/?format=api",
            "priority": 100,
            "id": 96145467,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en_ZA/?checksum=8683aa46dca58ada",
            "url": "https://translations.documentfoundation.org/api/units/96145467/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:37:06.638110Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/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/95826170/?format=api",
            "priority": 100,
            "id": 96145471,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en_ZA/?checksum=c443f0e81afbe15f",
            "url": "https://translations.documentfoundation.org/api/units/96145471/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:37:06.639593Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/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/95826203/?format=api",
            "priority": 100,
            "id": 96145475,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en_ZA/?checksum=6192db05ee9bf915",
            "url": "https://translations.documentfoundation.org/api/units/96145475/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:37:06.641031Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/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/95826251/?format=api",
            "priority": 100,
            "id": 96145479,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en_ZA/?checksum=2d74454c932e7b33",
            "url": "https://translations.documentfoundation.org/api/units/96145479/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:37:06.642441Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/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/95826316/?format=api",
            "priority": 100,
            "id": 96145486,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en_ZA/?checksum=3aab199273a5bdc7",
            "url": "https://translations.documentfoundation.org/api/units/96145486/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:37:06.645535Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/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/95826376/?format=api",
            "priority": 100,
            "id": 96145489,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en_ZA/?checksum=4b914b3f88c3942b",
            "url": "https://translations.documentfoundation.org/api/units/96145489/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:37:06.647092Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/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/95826419/?format=api",
            "priority": 100,
            "id": 96145492,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en_ZA/?checksum=9af54b2ac00b324e",
            "url": "https://translations.documentfoundation.org/api/units/96145492/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:37:06.648514Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/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/95826449/?format=api",
            "priority": 100,
            "id": 96145493,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en_ZA/?checksum=3bb8d31e1cf96659",
            "url": "https://translations.documentfoundation.org/api/units/96145493/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:37:06.650005Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/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/95826492/?format=api",
            "priority": 100,
            "id": 96145494,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en_ZA/?checksum=754811e3f3dce2a4",
            "url": "https://translations.documentfoundation.org/api/units/96145494/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:37:06.651615Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/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/95826517/?format=api",
            "priority": 100,
            "id": 96145496,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en_ZA/?checksum=13bc2af02751ea5b",
            "url": "https://translations.documentfoundation.org/api/units/96145496/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:37:06.653132Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/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/95826589/?format=api",
            "priority": 100,
            "id": 96145498,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en_ZA/?checksum=1a593a49f05359ea",
            "url": "https://translations.documentfoundation.org/api/units/96145498/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:37:06.654713Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/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/95826629/?format=api",
            "priority": 100,
            "id": 96145500,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en_ZA/?checksum=7765db2effbad12c",
            "url": "https://translations.documentfoundation.org/api/units/96145500/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:37:06.658514Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/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/95826691/?format=api",
            "priority": 100,
            "id": 96145502,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en_ZA/?checksum=50e6245a86efb4ca",
            "url": "https://translations.documentfoundation.org/api/units/96145502/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:37:06.660114Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/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/95826764/?format=api",
            "priority": 100,
            "id": 96145504,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en_ZA/?checksum=aa8ef4176b6489f8",
            "url": "https://translations.documentfoundation.org/api/units/96145504/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:37:06.661735Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/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/95826805/?format=api",
            "priority": 100,
            "id": 96145507,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en_ZA/?checksum=2fe39808458a5a30",
            "url": "https://translations.documentfoundation.org/api/units/96145507/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:37:06.663285Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/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/95826837/?format=api",
            "priority": 100,
            "id": 96145511,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en_ZA/?checksum=22989a820eb20850",
            "url": "https://translations.documentfoundation.org/api/units/96145511/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:37:06.664687Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/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/95826892/?format=api",
            "priority": 100,
            "id": 96145512,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en_ZA/?checksum=24b76554228f38a4",
            "url": "https://translations.documentfoundation.org/api/units/96145512/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:37:06.666179Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/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/95826934/?format=api",
            "priority": 100,
            "id": 96145514,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en_ZA/?checksum=4c9e0bb4eba150d8",
            "url": "https://translations.documentfoundation.org/api/units/96145514/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:37:06.667772Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/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/95826971/?format=api",
            "priority": 100,
            "id": 96145518,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en_ZA/?checksum=562ed61131b2b0cc",
            "url": "https://translations.documentfoundation.org/api/units/96145518/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:37:06.669417Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/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/95827011/?format=api",
            "priority": 100,
            "id": 96145520,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en_ZA/?checksum=6e59482fe1e6295b",
            "url": "https://translations.documentfoundation.org/api/units/96145520/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:37:06.670985Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/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/95827040/?format=api",
            "priority": 100,
            "id": 96145524,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en_ZA/?checksum=513e65966ca0061b",
            "url": "https://translations.documentfoundation.org/api/units/96145524/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:37:06.672599Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/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/95827059/?format=api",
            "priority": 100,
            "id": 96145525,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en_ZA/?checksum=edc83d626078a820",
            "url": "https://translations.documentfoundation.org/api/units/96145525/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:37:06.674184Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/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/95827094/?format=api",
            "priority": 100,
            "id": 96145529,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en_ZA/?checksum=492a54078db83e9d",
            "url": "https://translations.documentfoundation.org/api/units/96145529/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:37:06.675790Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/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/95827140/?format=api",
            "priority": 100,
            "id": 96145532,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en_ZA/?checksum=6e0d769a52f816fd",
            "url": "https://translations.documentfoundation.org/api/units/96145532/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:37:06.677368Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/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/95827182/?format=api",
            "priority": 100,
            "id": 96145535,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en_ZA/?checksum=cdde9aa87d383ddb",
            "url": "https://translations.documentfoundation.org/api/units/96145535/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:37:06.679027Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/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/95827224/?format=api",
            "priority": 100,
            "id": 96145538,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en_ZA/?checksum=192d1cc2457d772c",
            "url": "https://translations.documentfoundation.org/api/units/96145538/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:37:06.680614Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/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/95827257/?format=api",
            "priority": 100,
            "id": 96145540,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en_ZA/?checksum=4b2e13d932acb571",
            "url": "https://translations.documentfoundation.org/api/units/96145540/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:37:06.682175Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/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/95827296/?format=api",
            "priority": 100,
            "id": 96145543,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en_ZA/?checksum=6de2ec5791404fbe",
            "url": "https://translations.documentfoundation.org/api/units/96145543/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:37:06.683735Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/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/95827342/?format=api",
            "priority": 100,
            "id": 96145547,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en_ZA/?checksum=1d9294b973252b68",
            "url": "https://translations.documentfoundation.org/api/units/96145547/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:37:06.685375Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/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/95827373/?format=api",
            "priority": 100,
            "id": 96145549,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en_ZA/?checksum=dddff1264a356185",
            "url": "https://translations.documentfoundation.org/api/units/96145549/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:37:06.686855Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/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/95827394/?format=api",
            "priority": 100,
            "id": 96145552,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en_ZA/?checksum=2fc24fdc0a657147",
            "url": "https://translations.documentfoundation.org/api/units/96145552/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:37:06.688480Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/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/95827434/?format=api",
            "priority": 100,
            "id": 96145554,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en_ZA/?checksum=615718f756a3687d",
            "url": "https://translations.documentfoundation.org/api/units/96145554/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:37:06.689927Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/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/95827456/?format=api",
            "priority": 100,
            "id": 96145558,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en_ZA/?checksum=b972a61847e785f9",
            "url": "https://translations.documentfoundation.org/api/units/96145558/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:37:06.691190Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/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/95827484/?format=api",
            "priority": 100,
            "id": 96145561,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en_ZA/?checksum=fd6cf79f8f555029",
            "url": "https://translations.documentfoundation.org/api/units/96145561/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:37:06.692455Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/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/95827521/?format=api",
            "priority": 100,
            "id": 96145565,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en_ZA/?checksum=ab8aab7bdfc956a0",
            "url": "https://translations.documentfoundation.org/api/units/96145565/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:37:06.693736Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/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/95827555/?format=api",
            "priority": 100,
            "id": 96145567,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en_ZA/?checksum=b1199f1422ab57f6",
            "url": "https://translations.documentfoundation.org/api/units/96145567/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:37:06.695068Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/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/95827653/?format=api",
            "priority": 100,
            "id": 96145572,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en_ZA/?checksum=3002dba2fe1a567f",
            "url": "https://translations.documentfoundation.org/api/units/96145572/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:37:06.696529Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/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/95827708/?format=api",
            "priority": 100,
            "id": 96145574,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en_ZA/?checksum=c78f72ef5bcfde96",
            "url": "https://translations.documentfoundation.org/api/units/96145574/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:37:06.698033Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/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/95827720/?format=api",
            "priority": 100,
            "id": 96145576,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en_ZA/?checksum=f1d292047f0cd5b9",
            "url": "https://translations.documentfoundation.org/api/units/96145576/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:37:06.699814Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/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/95827737/?format=api",
            "priority": 100,
            "id": 96145581,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en_ZA/?checksum=d15090c08d84933c",
            "url": "https://translations.documentfoundation.org/api/units/96145581/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:37:06.701179Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/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/95827763/?format=api",
            "priority": 100,
            "id": 96145588,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en_ZA/?checksum=485332c1b806b136",
            "url": "https://translations.documentfoundation.org/api/units/96145588/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:37:06.704823Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/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/95827783/?format=api",
            "priority": 100,
            "id": 96145596,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en_ZA/?checksum=93eaff6dea4378d2",
            "url": "https://translations.documentfoundation.org/api/units/96145596/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:37:06.707811Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/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/95827822/?format=api",
            "priority": 100,
            "id": 96145601,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/en_ZA/?checksum=a852955dcd08cdcb",
            "url": "https://translations.documentfoundation.org/api/units/96145601/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:37:06.709938Z"
        }
    ]
}