Units

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/et/units/?format=api&page=7",
    "previous": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/et/units/?format=api&page=5",
    "results": [
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/et/?format=api",
            "source": [
                "All date expressions (date literals) must be enclosed with single quotation marks. (Consult the reference for the particular database and connector you are using for more details.)"
            ],
            "previous_source": "",
            "target": [
                ""
            ],
            "id_hash": -4673270034736519928,
            "content_hash": -4673270034736519928,
            "location": "02010100.xhp",
            "context": "02010100.xhp\npar_id3150510\nhelp.text",
            "note": "CZdA4",
            "flags": "",
            "labels": [],
            "state": 0,
            "fuzzy": false,
            "translated": false,
            "approved": false,
            "position": 251,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 27,
            "source_unit": "https://translations.documentfoundation.org/api/units/95832235/?format=api",
            "priority": 100,
            "id": 96178689,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/et/?checksum=3f2535a9d80d6508",
            "url": "https://translations.documentfoundation.org/api/units/96178689/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:37:36.756888Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/et/?format=api",
            "source": [
                "Querying Yes/No fields"
            ],
            "previous_source": "",
            "target": [
                ""
            ],
            "id_hash": 8163855836227489271,
            "content_hash": 8163855836227489271,
            "location": "02010100.xhp",
            "context": "02010100.xhp\nhd_id3150427\nhelp.text",
            "note": "HXdKT",
            "flags": "",
            "labels": [],
            "state": 0,
            "fuzzy": false,
            "translated": false,
            "approved": false,
            "position": 252,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 3,
            "source_unit": "https://translations.documentfoundation.org/api/units/95832309/?format=api",
            "priority": 100,
            "id": 96178693,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/et/?checksum=f14bd7a10bd6cdf7",
            "url": "https://translations.documentfoundation.org/api/units/96178693/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:37:36.759049Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/et/?format=api",
            "source": [
                "To query Yes/No fields, use the following syntax for dBASE tables:"
            ],
            "previous_source": "",
            "target": [
                ""
            ],
            "id_hash": 7542181489787428597,
            "content_hash": 7542181489787428597,
            "location": "02010100.xhp",
            "context": "02010100.xhp\npar_id3149523\nhelp.text",
            "note": "xWzix",
            "flags": "",
            "labels": [],
            "state": 0,
            "fuzzy": false,
            "translated": false,
            "approved": false,
            "position": 253,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 11,
            "source_unit": "https://translations.documentfoundation.org/api/units/95832346/?format=api",
            "priority": 100,
            "id": 96178703,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/et/?checksum=e8ab361ad24e5ef5",
            "url": "https://translations.documentfoundation.org/api/units/96178703/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:37:36.766633Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/et/?format=api",
            "source": [
                "Status"
            ],
            "previous_source": "",
            "target": [
                ""
            ],
            "id_hash": -1438940559154058398,
            "content_hash": -1438940559154058398,
            "location": "02010100.xhp",
            "context": "02010100.xhp\npar_id3153180\nhelp.text",
            "note": "A4Uh7",
            "flags": "",
            "labels": [],
            "state": 0,
            "fuzzy": false,
            "translated": false,
            "approved": false,
            "position": 254,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 1,
            "source_unit": "https://translations.documentfoundation.org/api/units/95832421/?format=api",
            "priority": 100,
            "id": 96178723,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/et/?checksum=6c07db2f6eb86b62",
            "url": "https://translations.documentfoundation.org/api/units/96178723/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:37:36.779249Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/et/?format=api",
            "source": [
                "Query criterion"
            ],
            "previous_source": "",
            "target": [
                ""
            ],
            "id_hash": 8650453120847444098,
            "content_hash": 8650453120847444098,
            "location": "02010100.xhp",
            "context": "02010100.xhp\npar_id3147481\nhelp.text",
            "note": "FnXiE",
            "flags": "",
            "labels": [],
            "state": 0,
            "fuzzy": false,
            "translated": false,
            "approved": false,
            "position": 255,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 2,
            "source_unit": "https://translations.documentfoundation.org/api/units/95832452/?format=api",
            "priority": 100,
            "id": 96178727,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/et/?checksum=f80c95480647f882",
            "url": "https://translations.documentfoundation.org/api/units/96178727/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:37:36.780845Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/et/?format=api",
            "source": [
                "Example"
            ],
            "previous_source": "",
            "target": [
                ""
            ],
            "id_hash": 8141292417662845597,
            "content_hash": 8141292417662845597,
            "location": "02010100.xhp",
            "context": "02010100.xhp\npar_id3155187\nhelp.text",
            "note": "e6DJr",
            "flags": "",
            "labels": [],
            "state": 0,
            "fuzzy": false,
            "translated": false,
            "approved": false,
            "position": 256,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 1,
            "source_unit": "https://translations.documentfoundation.org/api/units/95832475/?format=api",
            "priority": 100,
            "id": 96178728,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/et/?checksum=f0fbae51c760029d",
            "url": "https://translations.documentfoundation.org/api/units/96178728/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:37:36.782216Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/et/?format=api",
            "source": [
                "Yes"
            ],
            "previous_source": "",
            "target": [
                ""
            ],
            "id_hash": 4937219640899305490,
            "content_hash": 4937219640899305490,
            "location": "02010100.xhp",
            "context": "02010100.xhp\npar_id3156092\nhelp.text",
            "note": "Guy7d",
            "flags": "",
            "labels": [],
            "state": 0,
            "fuzzy": false,
            "translated": false,
            "approved": false,
            "position": 257,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 1,
            "source_unit": "https://translations.documentfoundation.org/api/units/95832529/?format=api",
            "priority": 100,
            "id": 96178731,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/et/?checksum=c484871ad9e28012",
            "url": "https://translations.documentfoundation.org/api/units/96178731/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:37:36.784553Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/et/?format=api",
            "source": [
                "for dBASE tables: not equal to any given value"
            ],
            "previous_source": "",
            "target": [
                ""
            ],
            "id_hash": -1485834374452513737,
            "content_hash": -1485834374452513737,
            "location": "02010100.xhp",
            "context": "02010100.xhp\npar_id3152414\nhelp.text",
            "note": "p9WTn",
            "flags": "",
            "labels": [],
            "state": 0,
            "fuzzy": false,
            "translated": false,
            "approved": false,
            "position": 258,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 9,
            "source_unit": "https://translations.documentfoundation.org/api/units/95832559/?format=api",
            "priority": 100,
            "id": 96178739,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/et/?checksum=6b6141823bb17437",
            "url": "https://translations.documentfoundation.org/api/units/96178739/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:37:36.791057Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/et/?format=api",
            "source": [
                "=1 returns all records where the Yes/No field has the status \"Yes\" or \"On\" (selected in black),"
            ],
            "previous_source": "",
            "target": [
                ""
            ],
            "id_hash": 4097363800793405340,
            "content_hash": 4097363800793405340,
            "location": "02010100.xhp",
            "context": "02010100.xhp\npar_id3151265\nhelp.text",
            "note": "RFrvz",
            "flags": "",
            "labels": [],
            "state": 0,
            "fuzzy": false,
            "translated": false,
            "approved": false,
            "position": 259,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 17,
            "source_unit": "https://translations.documentfoundation.org/api/units/95832593/?format=api",
            "priority": 100,
            "id": 96178745,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/et/?checksum=b8dcc2ab05d5d79c",
            "url": "https://translations.documentfoundation.org/api/units/96178745/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:37:36.793982Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/et/?format=api",
            "source": [
                "No"
            ],
            "previous_source": "",
            "target": [
                ""
            ],
            "id_hash": -1265902796848252916,
            "content_hash": -1265902796848252916,
            "location": "02010100.xhp",
            "context": "02010100.xhp\npar_id3152450\nhelp.text",
            "note": "3P4ZB",
            "flags": "",
            "labels": [],
            "state": 0,
            "fuzzy": false,
            "translated": false,
            "approved": false,
            "position": 260,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 1,
            "source_unit": "https://translations.documentfoundation.org/api/units/95832632/?format=api",
            "priority": 100,
            "id": 96178749,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/et/?checksum=6e6e9c1d01afb80c",
            "url": "https://translations.documentfoundation.org/api/units/96178749/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:37:36.795726Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/et/?format=api",
            "source": [
                "."
            ],
            "previous_source": "",
            "target": [
                ""
            ],
            "id_hash": -1104976539801341283,
            "content_hash": -1104976539801341283,
            "location": "02010100.xhp",
            "context": "02010100.xhp\npar_id3150997\nhelp.text",
            "note": "BzBAa",
            "flags": "",
            "labels": [],
            "state": 0,
            "fuzzy": false,
            "translated": false,
            "approved": false,
            "position": 261,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 1,
            "source_unit": "https://translations.documentfoundation.org/api/units/95832676/?format=api",
            "priority": 100,
            "id": 96178752,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/et/?checksum=70aa55b10400329d",
            "url": "https://translations.documentfoundation.org/api/units/96178752/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:37:36.797133Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/et/?format=api",
            "source": [
                "=0 returns all records for which the Yes/No field has the status \"No\" or \"Off\" (no selection)."
            ],
            "previous_source": "",
            "target": [
                ""
            ],
            "id_hash": -3974623853916560005,
            "content_hash": -3974623853916560005,
            "location": "02010100.xhp",
            "context": "02010100.xhp\npar_id3155331\nhelp.text",
            "note": "TFsQG",
            "flags": "",
            "labels": [],
            "state": 0,
            "fuzzy": false,
            "translated": false,
            "approved": false,
            "position": 262,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 17,
            "source_unit": "https://translations.documentfoundation.org/api/units/95832721/?format=api",
            "priority": 100,
            "id": 96178756,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/et/?checksum=48d74ca9cf82657b",
            "url": "https://translations.documentfoundation.org/api/units/96178756/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:37:36.798456Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/et/?format=api",
            "source": [
                "Null"
            ],
            "previous_source": "",
            "target": [
                ""
            ],
            "id_hash": -3383237762867038875,
            "content_hash": -3383237762867038875,
            "location": "02010100.xhp",
            "context": "02010100.xhp\npar_id3154179\nhelp.text",
            "note": "9KXzK",
            "flags": "",
            "labels": [],
            "state": 0,
            "fuzzy": false,
            "translated": false,
            "approved": false,
            "position": 263,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 1,
            "source_unit": "https://translations.documentfoundation.org/api/units/95832780/?format=api",
            "priority": 100,
            "id": 96178759,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/et/?checksum=510c532e099f7565",
            "url": "https://translations.documentfoundation.org/api/units/96178759/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:37:36.799807Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/et/?format=api",
            "source": [
                "IS NULL"
            ],
            "previous_source": "",
            "target": [
                ""
            ],
            "id_hash": 5893788471563971096,
            "content_hash": 5893788471563971096,
            "location": "02010100.xhp",
            "context": "02010100.xhp\npar_id3147035\nhelp.text",
            "note": "CwGZv",
            "flags": "",
            "labels": [],
            "state": 0,
            "fuzzy": false,
            "translated": false,
            "approved": false,
            "position": 264,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 2,
            "source_unit": "https://translations.documentfoundation.org/api/units/95832822/?format=api",
            "priority": 100,
            "id": 96178762,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/et/?checksum=d1caf16364dcea18",
            "url": "https://translations.documentfoundation.org/api/units/96178762/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:37:36.801303Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/et/?format=api",
            "source": [
                "IS NULL returns all records for which the Yes/No field has neither of the states Yes or No (selected in gray)."
            ],
            "previous_source": "",
            "target": [
                ""
            ],
            "id_hash": 6584486709762292464,
            "content_hash": 6584486709762292464,
            "location": "02010100.xhp",
            "context": "02010100.xhp\npar_id3159385\nhelp.text",
            "note": "dyXYc",
            "flags": "",
            "labels": [],
            "state": 0,
            "fuzzy": false,
            "translated": false,
            "approved": false,
            "position": 265,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 21,
            "source_unit": "https://translations.documentfoundation.org/api/units/95832852/?format=api",
            "priority": 100,
            "id": 96178766,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/et/?checksum=db60cbc6c3a97af0",
            "url": "https://translations.documentfoundation.org/api/units/96178766/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:37:36.802931Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/et/?format=api",
            "source": [
                "The syntax depends on the database system used. You should also note that Yes/No fields can be defined differently (only 2 states instead of 3)."
            ],
            "previous_source": "",
            "target": [
                ""
            ],
            "id_hash": 7229728358486624123,
            "content_hash": 7229728358486624123,
            "location": "02010100.xhp",
            "context": "02010100.xhp\npar_id3157888\nhelp.text",
            "note": "YWk5J",
            "flags": "",
            "labels": [],
            "state": 0,
            "fuzzy": false,
            "translated": false,
            "approved": false,
            "position": 266,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 25,
            "source_unit": "https://translations.documentfoundation.org/api/units/95832907/?format=api",
            "priority": 100,
            "id": 96178769,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/et/?checksum=e45527a32629c77b",
            "url": "https://translations.documentfoundation.org/api/units/96178769/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:37:36.804675Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/et/?format=api",
            "source": [
                "Parameter queries"
            ],
            "previous_source": "",
            "target": [
                ""
            ],
            "id_hash": 450583529009372135,
            "content_hash": 450583529009372135,
            "location": "02010100.xhp",
            "context": "02010100.xhp\nhd_id3145772\nhelp.text",
            "note": "mmVa8",
            "flags": "",
            "labels": [],
            "state": 0,
            "fuzzy": false,
            "translated": false,
            "approved": false,
            "position": 267,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 2,
            "source_unit": "https://translations.documentfoundation.org/api/units/95832932/?format=api",
            "priority": 100,
            "id": 96178773,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/et/?checksum=8640cb55143edbe7",
            "url": "https://translations.documentfoundation.org/api/units/96178773/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:37:36.806293Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/et/?format=api",
            "source": [
                "Parameter queries allow the user to input values at run-time. These values are used within the criteria for selecting the records to be displayed. Each such value has a parameter name associated with it, which is used to prompt the user when the query is run."
            ],
            "previous_source": "",
            "target": [
                ""
            ],
            "id_hash": -8140116745182247469,
            "content_hash": -8140116745182247469,
            "location": "02010100.xhp",
            "context": "02010100.xhp\npar_id191120151905346795\nhelp.text",
            "note": "ND7xd",
            "flags": "",
            "labels": [],
            "state": 0,
            "fuzzy": false,
            "translated": false,
            "approved": false,
            "position": 268,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 46,
            "source_unit": "https://translations.documentfoundation.org/api/units/95832959/?format=api",
            "priority": 100,
            "id": 96178788,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/et/?checksum=0f087ef2cd3405d3",
            "url": "https://translations.documentfoundation.org/api/units/96178788/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:37:36.817778Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/et/?format=api",
            "source": [
                "Parameter names are preceded by a colon in both the Design and SQL views of a query. This can be used wherever a value can appear. If the same value is to appear more than once in the query, the same parameter name is used."
            ],
            "previous_source": "",
            "target": [
                ""
            ],
            "id_hash": 4111393334921262894,
            "content_hash": 4111393334921262894,
            "location": "02010100.xhp",
            "context": "02010100.xhp\npar_id191120151905439551\nhelp.text",
            "note": "Be7XG",
            "flags": "",
            "labels": [],
            "state": 0,
            "fuzzy": false,
            "translated": false,
            "approved": false,
            "position": 269,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 45,
            "source_unit": "https://translations.documentfoundation.org/api/units/95832984/?format=api",
            "priority": 100,
            "id": 96178791,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/et/?checksum=b90e9a747be3f72e",
            "url": "https://translations.documentfoundation.org/api/units/96178791/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:37:36.819409Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/et/?format=api",
            "source": [
                "In the simplest case, where the user enters a value which is matched for equality, the parameter name with its preceding colon is simply entered in the Criterion row. In <link href=\"text/sdatabase/02010100.xhp#sqlmode\">SQL mode</link> this should be typed as <item type=\"input\">WHERE \"Field\" = :Parameter_name</item>"
            ],
            "previous_source": "",
            "target": [
                ""
            ],
            "id_hash": -8056140160250446947,
            "content_hash": -8056140160250446947,
            "location": "02010100.xhp",
            "context": "02010100.xhp\npar_id191120151905518123\nhelp.text",
            "note": "f2NMg",
            "flags": "",
            "labels": [],
            "state": 0,
            "fuzzy": false,
            "translated": false,
            "approved": false,
            "position": 270,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 43,
            "source_unit": "https://translations.documentfoundation.org/api/units/95833004/?format=api",
            "priority": 100,
            "id": 96178792,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/et/?checksum=1032d7351f837b9d",
            "url": "https://translations.documentfoundation.org/api/units/96178792/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:37:36.821063Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/et/?format=api",
            "source": [
                "Parameter names may not contain any of the characters <item type=\"input\"><space>`!\"$%^*()+={}[]@'~#<>?/,</item>. They may not be the same as field names or SQL reserved words. They may be the same as aliases."
            ],
            "previous_source": "",
            "target": [
                ""
            ],
            "id_hash": 2239266726598408603,
            "content_hash": 2239266726598408603,
            "location": "02010100.xhp",
            "context": "02010100.xhp\npar_id191120151905584287\nhelp.text",
            "note": "DZCXm",
            "flags": "",
            "labels": [],
            "state": 0,
            "fuzzy": false,
            "translated": false,
            "approved": false,
            "position": 271,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 31,
            "source_unit": "https://translations.documentfoundation.org/api/units/95833020/?format=api",
            "priority": 100,
            "id": 96178799,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/et/?checksum=9f137939443ff99b",
            "url": "https://translations.documentfoundation.org/api/units/96178799/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:37:36.824338Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/et/?format=api",
            "source": [
                "A useful construction for selecting records based on parts of a text field's content is to add a hidden column with <item type=\"input\">\"LIKE '%' || :Part_of_field || '%'\"</item> as the criterion. This will select records with an exact match. If a case-insensitive test is wanted, one solution is to use <item type=\"input\">LOWER (Field_Name)</item> as the field and <item type=\"input\">LIKE LOWER ( '%' || :Part_of_field || '%' )</item> as the criterion. Note that the spaces in the criterion are important; if they are left out the SQL parser interprets the entire criterion as a string to be matched. In <link href=\"text/sdatabase/02010100.xhp#sqlmode\">SQL mode</link> this should be typed as <item type=\"input\">LOWER ( \"Field_Name\" ) LIKE LOWER ( '%' || :Part_of_field || '%' )</item>."
            ],
            "previous_source": "",
            "target": [
                ""
            ],
            "id_hash": 7359674384784650935,
            "content_hash": 7359674384784650935,
            "location": "02010100.xhp",
            "context": "02010100.xhp\npar_id191120151931441881\nhelp.text",
            "note": "WBEtt",
            "flags": "",
            "labels": [],
            "state": 0,
            "fuzzy": false,
            "translated": false,
            "approved": false,
            "position": 272,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 120,
            "source_unit": "https://translations.documentfoundation.org/api/units/95833042/?format=api",
            "priority": 100,
            "id": 96178804,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/et/?checksum=e622d0dc17a172b7",
            "url": "https://translations.documentfoundation.org/api/units/96178804/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:37:36.826206Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/et/?format=api",
            "source": [
                "Parameter queries may be used as the data source for <link href=\"text/shared/02/01170203.xhp\">subforms</link>, to allow the user to restrict the displayed records."
            ],
            "previous_source": "",
            "target": [
                ""
            ],
            "id_hash": 2107924860811531621,
            "content_hash": 2107924860811531621,
            "location": "02010100.xhp",
            "context": "02010100.xhp\npar_id3150585\nhelp.text",
            "note": "EAESi",
            "flags": "",
            "labels": [],
            "state": 0,
            "fuzzy": false,
            "translated": false,
            "approved": false,
            "position": 273,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 21,
            "source_unit": "https://translations.documentfoundation.org/api/units/95833068/?format=api",
            "priority": 100,
            "id": 96178808,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/et/?checksum=9d40da7e1de2d565",
            "url": "https://translations.documentfoundation.org/api/units/96178808/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:37:36.827758Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/et/?format=api",
            "source": [
                "Parameter Input"
            ],
            "previous_source": "",
            "target": [
                ""
            ],
            "id_hash": 2456021578479157933,
            "content_hash": 2456021578479157933,
            "location": "02010100.xhp",
            "context": "02010100.xhp\nhd_id3151035\nhelp.text",
            "note": "DRj78",
            "flags": "",
            "labels": [],
            "state": 0,
            "fuzzy": false,
            "translated": false,
            "approved": false,
            "position": 274,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 2,
            "source_unit": "https://translations.documentfoundation.org/api/units/95833093/?format=api",
            "priority": 100,
            "id": 96178810,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/et/?checksum=a2158a9cf1f1c2ad",
            "url": "https://translations.documentfoundation.org/api/units/96178810/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:37:36.829225Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/et/?format=api",
            "source": [
                "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\">The <emph>Parameter Input</emph> dialog asks the user to enter the parameter values. Enter a value for each query parameter and confirm by clicking <emph>OK</emph> or typing <emph>Enter</emph>.</ahelp>"
            ],
            "previous_source": "",
            "target": [
                ""
            ],
            "id_hash": 264425641860169309,
            "content_hash": 264425641860169309,
            "location": "02010100.xhp",
            "context": "02010100.xhp\npar_id3153596\nhelp.text",
            "note": "BisCF",
            "flags": "",
            "labels": [],
            "state": 0,
            "fuzzy": false,
            "translated": false,
            "approved": false,
            "position": 275,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 28,
            "source_unit": "https://translations.documentfoundation.org/api/units/95833119/?format=api",
            "priority": 100,
            "id": 96178814,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/et/?checksum=83ab6db864947e5d",
            "url": "https://translations.documentfoundation.org/api/units/96178814/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:37:36.830620Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/et/?format=api",
            "source": [
                "The values entered by the user may consist of any characters which are allowable for the SQL for the relevant criterion; this may depend on the underlying database system."
            ],
            "previous_source": "",
            "target": [
                ""
            ],
            "id_hash": -7615090312441786881,
            "content_hash": -7615090312441786881,
            "location": "02010100.xhp",
            "context": "02010100.xhp\npar_id191120151924165870\nhelp.text",
            "note": "eGETM",
            "flags": "",
            "labels": [],
            "state": 0,
            "fuzzy": false,
            "translated": false,
            "approved": false,
            "position": 276,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 29,
            "source_unit": "https://translations.documentfoundation.org/api/units/95833207/?format=api",
            "priority": 100,
            "id": 96178818,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/et/?checksum=1651c3b512638dff",
            "url": "https://translations.documentfoundation.org/api/units/96178818/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:37:36.831971Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/et/?format=api",
            "source": [
                "The user can use the SQL wild-card characters \"%\" (arbitrary string) or \"_\" (arbitrary single character) as part of the value to retrieve records with more complex criteria."
            ],
            "previous_source": "",
            "target": [
                ""
            ],
            "id_hash": 7455332244107640153,
            "content_hash": 7455332244107640153,
            "location": "02010100.xhp",
            "context": "02010100.xhp\npar_id191120151939594217\nhelp.text",
            "note": "seFhG",
            "flags": "",
            "labels": [],
            "state": 0,
            "fuzzy": false,
            "translated": false,
            "approved": false,
            "position": 277,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 28,
            "source_unit": "https://translations.documentfoundation.org/api/units/95833263/?format=api",
            "priority": 100,
            "id": 96178822,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/et/?checksum=e776a92d0c8d3d59",
            "url": "https://translations.documentfoundation.org/api/units/96178822/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:37:36.833471Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/et/?format=api",
            "source": [
                "SQL Mode"
            ],
            "previous_source": "",
            "target": [
                ""
            ],
            "id_hash": 7952163570614096607,
            "content_hash": 7952163570614096607,
            "location": "02010100.xhp",
            "context": "02010100.xhp\nhd_id3145181\nhelp.text",
            "note": "wRe6v",
            "flags": "",
            "labels": [],
            "state": 0,
            "fuzzy": false,
            "translated": false,
            "approved": false,
            "position": 278,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 2,
            "source_unit": "https://translations.documentfoundation.org/api/units/95833316/?format=api",
            "priority": 100,
            "id": 96178827,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/et/?checksum=ee5bc2a2964152df",
            "url": "https://translations.documentfoundation.org/api/units/96178827/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:37:36.834959Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/et/?format=api",
            "source": [
                "SQL stands for \"Structured Query Language\" and describes instructions for updating and administering relational databases."
            ],
            "previous_source": "",
            "target": [
                ""
            ],
            "id_hash": 2645544768060911837,
            "content_hash": 2645544768060911837,
            "location": "02010100.xhp",
            "context": "02010100.xhp\npar_id3147013\nhelp.text",
            "note": "5avVu",
            "flags": "",
            "labels": [],
            "state": 0,
            "fuzzy": false,
            "translated": false,
            "approved": false,
            "position": 279,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 15,
            "source_unit": "https://translations.documentfoundation.org/api/units/95833357/?format=api",
            "priority": 100,
            "id": 96178831,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/et/?checksum=a4b6dcf329a9f0dd",
            "url": "https://translations.documentfoundation.org/api/units/96178831/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:37:36.836496Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/et/?format=api",
            "source": [
                "In $[officename] you do not need any knowledge of SQL for most queries, since you do not have to enter the SQL code. If you create a query in the query designer, $[officename] automatically converts your instructions into the corresponding SQL syntax. If, with the help of the <emph>Switch Design View On/Off </emph>button, you change to the SQL view, you can see the SQL commands for a query that has already been created."
            ],
            "previous_source": "",
            "target": [
                ""
            ],
            "id_hash": 7941331124243750945,
            "content_hash": 7941331124243750945,
            "location": "02010100.xhp",
            "context": "02010100.xhp\npar_id3152570\nhelp.text",
            "note": "wDAAY",
            "flags": "",
            "labels": [],
            "state": 0,
            "fuzzy": false,
            "translated": false,
            "approved": false,
            "position": 280,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 73,
            "source_unit": "https://translations.documentfoundation.org/api/units/95833430/?format=api",
            "priority": 100,
            "id": 96178836,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/et/?checksum=ee354695204d6021",
            "url": "https://translations.documentfoundation.org/api/units/96178836/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:37:36.838049Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/et/?format=api",
            "source": [
                "You can formulate your query directly in SQL code. Note, however, that the special syntax is dependent upon the database system that you use."
            ],
            "previous_source": "",
            "target": [
                ""
            ],
            "id_hash": 1166373493807955969,
            "content_hash": 1166373493807955969,
            "location": "02010100.xhp",
            "context": "02010100.xhp\npar_id3152412\nhelp.text",
            "note": "hBQFv",
            "flags": "",
            "labels": [],
            "state": 0,
            "fuzzy": false,
            "translated": false,
            "approved": false,
            "position": 281,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 24,
            "source_unit": "https://translations.documentfoundation.org/api/units/95833473/?format=api",
            "priority": 100,
            "id": 96178839,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/et/?checksum=902fca834ddac001",
            "url": "https://translations.documentfoundation.org/api/units/96178839/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:37:36.839662Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/et/?format=api",
            "source": [
                "If you enter the SQL code manually, you can create SQL-specific queries that are not supported by the graphical interface in the <emph>Query designer</emph>. These queries must be executed in native SQL mode."
            ],
            "previous_source": "",
            "target": [
                ""
            ],
            "id_hash": 5642149963125379485,
            "content_hash": 5642149963125379485,
            "location": "02010100.xhp",
            "context": "02010100.xhp\npar_id3146842\nhelp.text",
            "note": "kkuBG",
            "flags": "",
            "labels": [],
            "state": 0,
            "fuzzy": false,
            "translated": false,
            "approved": false,
            "position": 282,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 33,
            "source_unit": "https://translations.documentfoundation.org/api/units/95833505/?format=api",
            "priority": 100,
            "id": 96178853,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/et/?checksum=ce4cf17f8192519d",
            "url": "https://translations.documentfoundation.org/api/units/96178853/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:37:36.848772Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/et/?format=api",
            "source": [
                "By clicking the <link href=\"text/shared/02/14030000.xhp\"><emph>Run SQL command directly</emph></link> icon in the SQL view, you can formulate a query that is not processed by $[officename] and sent directly to the database engine."
            ],
            "previous_source": "",
            "target": [
                ""
            ],
            "id_hash": -1013675299276706472,
            "content_hash": -1013675299276706472,
            "location": "02010100.xhp",
            "context": "02010100.xhp\npar_id3149632\nhelp.text",
            "note": "LgvXF",
            "flags": "",
            "labels": [],
            "state": 0,
            "fuzzy": false,
            "translated": false,
            "approved": false,
            "position": 283,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 31,
            "source_unit": "https://translations.documentfoundation.org/api/units/95833552/?format=api",
            "priority": 100,
            "id": 96178867,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/et/?checksum=71eeb3af9d062d58",
            "url": "https://translations.documentfoundation.org/api/units/96178867/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:37:36.857201Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/et/?format=api",
            "source": [
                "Join Properties"
            ],
            "previous_source": "",
            "target": [
                ""
            ],
            "id_hash": -6678692574290660760,
            "content_hash": -6678692574290660760,
            "location": "02010101.xhp",
            "context": "02010101.xhp\ntit\nhelp.text",
            "note": "fKBDD",
            "flags": "",
            "labels": [],
            "state": 0,
            "fuzzy": false,
            "translated": false,
            "approved": false,
            "position": 284,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 2,
            "source_unit": "https://translations.documentfoundation.org/api/units/95833604/?format=api",
            "priority": 100,
            "id": 96178874,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/et/?checksum=2350847d295db268",
            "url": "https://translations.documentfoundation.org/api/units/96178874/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:37:36.860015Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/et/?format=api",
            "source": [
                "<bookmark_value>links;relational databases (Base)</bookmark_value>      <bookmark_value>inner joins (Base)</bookmark_value>      <bookmark_value>joins in databases (Base)</bookmark_value>      <bookmark_value>left joins (Base)</bookmark_value>      <bookmark_value>right joins (Base)</bookmark_value>      <bookmark_value>full joins (Base)</bookmark_value>"
            ],
            "previous_source": "",
            "target": [
                ""
            ],
            "id_hash": 1301543985542803826,
            "content_hash": 1301543985542803826,
            "location": "02010101.xhp",
            "context": "02010101.xhp\nbm_id3154015\nhelp.text",
            "note": "TTCNB",
            "flags": "",
            "labels": [],
            "state": 0,
            "fuzzy": false,
            "translated": false,
            "approved": false,
            "position": 285,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 19,
            "source_unit": "https://translations.documentfoundation.org/api/units/95833631/?format=api",
            "priority": 100,
            "id": 96178879,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/et/?checksum=9210035be5d33172",
            "url": "https://translations.documentfoundation.org/api/units/96178879/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:37:36.861583Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/et/?format=api",
            "source": [
                "Join Properties"
            ],
            "previous_source": "",
            "target": [
                ""
            ],
            "id_hash": 2689996371133773814,
            "content_hash": 2689996371133773814,
            "location": "02010101.xhp",
            "context": "02010101.xhp\nhd_id3154015\nhelp.text",
            "note": "DG7RD",
            "flags": "",
            "labels": [],
            "state": 0,
            "fuzzy": false,
            "translated": false,
            "approved": false,
            "position": 286,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 2,
            "source_unit": "https://translations.documentfoundation.org/api/units/95833656/?format=api",
            "priority": 100,
            "id": 96178883,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/et/?checksum=a554c9728484b7f6",
            "url": "https://translations.documentfoundation.org/api/units/96178883/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:37:36.864532Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/et/?format=api",
            "source": [
                "If you double-click a connection between two linked fields in the query design, or if you choose <emph>Insert - New Relation</emph>, the <emph>Join Properties</emph> dialog appears. These properties will be used in all queries created in the future."
            ],
            "previous_source": "",
            "target": [
                ""
            ],
            "id_hash": -8537690843307473250,
            "content_hash": -8537690843307473250,
            "location": "02010101.xhp",
            "context": "02010101.xhp\npar_id3151205\nhelp.text",
            "note": "MzpBt",
            "flags": "",
            "labels": [],
            "state": 0,
            "fuzzy": false,
            "translated": false,
            "approved": false,
            "position": 287,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 38,
            "source_unit": "https://translations.documentfoundation.org/api/units/95833679/?format=api",
            "priority": 100,
            "id": 96178885,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/et/?checksum=09840769a28d869e",
            "url": "https://translations.documentfoundation.org/api/units/96178885/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:37:36.866469Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/et/?format=api",
            "source": [
                "Tables involved"
            ],
            "previous_source": "",
            "target": [
                "Asjassepuutuvad tabelid"
            ],
            "id_hash": -36410145612706044,
            "content_hash": -36410145612706044,
            "location": "02010101.xhp",
            "context": "02010101.xhp\nhd_id3155066\nhelp.text",
            "note": "oszEF",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 288,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 2,
            "source_unit": "https://translations.documentfoundation.org/api/units/95833715/?format=api",
            "priority": 100,
            "id": 96178888,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/et/?checksum=7f7ea52a5c88cf04",
            "url": "https://translations.documentfoundation.org/api/units/96178888/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:37:36.868736Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/et/?format=api",
            "source": [
                "<ahelp hid=\"dbaccess/ui/joindialog/table2\">Specifies two different tables that you want to join.</ahelp>"
            ],
            "previous_source": "",
            "target": [
                "<ahelp hid=\"dbaccess/ui/joindialog/table2\">Määrab kaks erinevat tabelit, mida soovid ühendada.</ahelp>"
            ],
            "id_hash": 1333863119828857673,
            "content_hash": 1333863119828857673,
            "location": "02010101.xhp",
            "context": "02010101.xhp\npar_id3153924\nhelp.text",
            "note": "2AkcB",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 289,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 10,
            "source_unit": "https://translations.documentfoundation.org/api/units/95833786/?format=api",
            "priority": 100,
            "id": 96178890,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/et/?checksum=9282d570bc64b349",
            "url": "https://translations.documentfoundation.org/api/units/96178890/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:37:36.870692Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/et/?format=api",
            "source": [
                "Fields involved"
            ],
            "previous_source": "",
            "target": [
                "Asjassepuutuvad väljad"
            ],
            "id_hash": -1789859163330594308,
            "content_hash": -1789859163330594308,
            "location": "02010101.xhp",
            "context": "02010101.xhp\nhd_id3155766\nhelp.text",
            "note": "X6wkD",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 290,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 2,
            "source_unit": "https://translations.documentfoundation.org/api/units/95833829/?format=api",
            "priority": 100,
            "id": 96178898,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/et/?checksum=67292492f3b3b9fc",
            "url": "https://translations.documentfoundation.org/api/units/96178898/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:37:36.877815Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/et/?format=api",
            "source": [
                "<ahelp hid=\".\">Specifies two data fields that will be joined by a relation.</ahelp>"
            ],
            "previous_source": "",
            "target": [
                "<ahelp hid=\".\">Määrab kaks erinevat andmevälja, mis ühendatakse relatsiooniga.</ahelp>"
            ],
            "id_hash": 7574129023308213126,
            "content_hash": 7574129023308213126,
            "location": "02010101.xhp",
            "context": "02010101.xhp\npar_id3148994\nhelp.text",
            "note": "8bYEZ",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 291,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 12,
            "source_unit": "https://translations.documentfoundation.org/api/units/95833875/?format=api",
            "priority": 100,
            "id": 96178900,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/et/?checksum=e91cb6379d432b86",
            "url": "https://translations.documentfoundation.org/api/units/96178900/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:37:36.879598Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/et/?format=api",
            "source": [
                "Options"
            ],
            "previous_source": "",
            "target": [
                ""
            ],
            "id_hash": -2720686535624113612,
            "content_hash": -2720686535624113612,
            "location": "02010101.xhp",
            "context": "02010101.xhp\nhd_id3159267\nhelp.text",
            "note": "R8CbB",
            "flags": "",
            "labels": [],
            "state": 0,
            "fuzzy": false,
            "translated": false,
            "approved": false,
            "position": 292,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 1,
            "source_unit": "https://translations.documentfoundation.org/api/units/95833910/?format=api",
            "priority": 100,
            "id": 96178903,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/et/?checksum=5a3e2e02baefc234",
            "url": "https://translations.documentfoundation.org/api/units/96178903/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:37:36.881830Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/et/?format=api",
            "source": [
                "Type"
            ],
            "previous_source": "",
            "target": [
                ""
            ],
            "id_hash": -4053688658655726463,
            "content_hash": -4053688658655726463,
            "location": "02010101.xhp",
            "context": "02010101.xhp\nhd_id3147340\nhelp.text",
            "note": "MRJCp",
            "flags": "",
            "labels": [],
            "state": 0,
            "fuzzy": false,
            "translated": false,
            "approved": false,
            "position": 293,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 1,
            "source_unit": "https://translations.documentfoundation.org/api/units/95833944/?format=api",
            "priority": 100,
            "id": 96178908,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/et/?checksum=47be67a46ecbb481",
            "url": "https://translations.documentfoundation.org/api/units/96178908/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:37:36.888229Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/et/?format=api",
            "source": [
                "<ahelp hid=\"dbaccess/ui/joindialog/type\">Specifies the join type of the selected join.</ahelp> Some databases support only a subset of the various possible types."
            ],
            "previous_source": "",
            "target": [
                ""
            ],
            "id_hash": -7272426577638343159,
            "content_hash": -7272426577638343159,
            "location": "02010101.xhp",
            "context": "02010101.xhp\npar_id3152482\nhelp.text",
            "note": "rxAGo",
            "flags": "",
            "labels": [],
            "state": 0,
            "fuzzy": false,
            "translated": false,
            "approved": false,
            "position": 294,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 20,
            "source_unit": "https://translations.documentfoundation.org/api/units/95833971/?format=api",
            "priority": 100,
            "id": 96178912,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/et/?checksum=1b13268f00c1be09",
            "url": "https://translations.documentfoundation.org/api/units/96178912/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:37:36.890164Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/et/?format=api",
            "source": [
                "Inner Join"
            ],
            "previous_source": "",
            "target": [
                ""
            ],
            "id_hash": -7586144127754050114,
            "content_hash": -7586144127754050114,
            "location": "02010101.xhp",
            "context": "02010101.xhp\nhd_id3155334\nhelp.text",
            "note": "ngfse",
            "flags": "",
            "labels": [],
            "state": 0,
            "fuzzy": false,
            "translated": false,
            "approved": false,
            "position": 295,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 2,
            "source_unit": "https://translations.documentfoundation.org/api/units/95834014/?format=api",
            "priority": 100,
            "id": 96178918,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/et/?checksum=16b89a1be24de5be",
            "url": "https://translations.documentfoundation.org/api/units/96178918/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:37:36.894058Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/et/?format=api",
            "source": [
                "<ahelp hid=\"dbaccess/ui/joindialog/type\">In an inner join, the results table contains only those records for which the content of the linked fields is the same.</ahelp> In $[officename] SQL this type of link is created by a corresponding WHERE clause."
            ],
            "previous_source": "",
            "target": [
                ""
            ],
            "id_hash": -6113919658300017234,
            "content_hash": -6113919658300017234,
            "location": "02010101.xhp",
            "context": "02010101.xhp\npar_id3155936\nhelp.text",
            "note": "356Dv",
            "flags": "",
            "labels": [],
            "state": 0,
            "fuzzy": false,
            "translated": false,
            "approved": false,
            "position": 296,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 37,
            "source_unit": "https://translations.documentfoundation.org/api/units/95834031/?format=api",
            "priority": 100,
            "id": 96178925,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/et/?checksum=2b26fe76b5bff5ae",
            "url": "https://translations.documentfoundation.org/api/units/96178925/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:37:36.898024Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/et/?format=api",
            "source": [
                "Left Join"
            ],
            "previous_source": "",
            "target": [
                ""
            ],
            "id_hash": -9146645766165797204,
            "content_hash": -9146645766165797204,
            "location": "02010101.xhp",
            "context": "02010101.xhp\nhd_id3156372\nhelp.text",
            "note": "XYKGT",
            "flags": "",
            "labels": [],
            "state": 0,
            "fuzzy": false,
            "translated": false,
            "approved": false,
            "position": 297,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 2,
            "source_unit": "https://translations.documentfoundation.org/api/units/95834052/?format=api",
            "priority": 100,
            "id": 96178928,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/et/?checksum=01109622fd5b66ac",
            "url": "https://translations.documentfoundation.org/api/units/96178928/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:37:36.899891Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/et/?format=api",
            "source": [
                "<ahelp hid=\"dbaccess/ui/joindialog/type\">In a left join, the results table contains all records of the queried fields from the left table and only those records of the queried fields from the right table for which the content of the linked fields is the same.</ahelp> In $[officename] SQL this type of link corresponds to the LEFT OUTER JOIN command."
            ],
            "previous_source": "",
            "target": [
                ""
            ],
            "id_hash": 1610530649816152644,
            "content_hash": 1610530649816152644,
            "location": "02010101.xhp",
            "context": "02010101.xhp\npar_id3166450\nhelp.text",
            "note": "dRFux",
            "flags": "",
            "labels": [],
            "state": 0,
            "fuzzy": false,
            "translated": false,
            "approved": false,
            "position": 298,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 56,
            "source_unit": "https://translations.documentfoundation.org/api/units/95834075/?format=api",
            "priority": 100,
            "id": 96178934,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/et/?checksum=9659c117d22bba44",
            "url": "https://translations.documentfoundation.org/api/units/96178934/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:37:36.905805Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/et/?format=api",
            "source": [
                "Right Join"
            ],
            "previous_source": "",
            "target": [
                ""
            ],
            "id_hash": 6056042749440435176,
            "content_hash": 6056042749440435176,
            "location": "02010101.xhp",
            "context": "02010101.xhp\nhd_id3155607\nhelp.text",
            "note": "DxGWD",
            "flags": "",
            "labels": [],
            "state": 0,
            "fuzzy": false,
            "translated": false,
            "approved": false,
            "position": 299,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 2,
            "source_unit": "https://translations.documentfoundation.org/api/units/95834092/?format=api",
            "priority": 100,
            "id": 96178947,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/et/?checksum=d40b62cb58fa23e8",
            "url": "https://translations.documentfoundation.org/api/units/96178947/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:37:36.913050Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/et/?format=api",
            "source": [
                "<ahelp hid=\"dbaccess/ui/joindialog/type\">In a right join, the results table contains all records of the queried fields from the right table and only those records of the queried fields from the left table for which the content of the linked fields is the same.</ahelp> In $[officename] SQL this type of link corresponds to the RIGHT OUTER JOIN command."
            ],
            "previous_source": "",
            "target": [
                ""
            ],
            "id_hash": 2203328089698667858,
            "content_hash": 2203328089698667858,
            "location": "02010101.xhp",
            "context": "02010101.xhp\npar_id3150647\nhelp.text",
            "note": "9eD8R",
            "flags": "",
            "labels": [],
            "state": 0,
            "fuzzy": false,
            "translated": false,
            "approved": false,
            "position": 300,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 56,
            "source_unit": "https://translations.documentfoundation.org/api/units/95834104/?format=api",
            "priority": 100,
            "id": 96178951,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/et/?checksum=9e93cb394e210d52",
            "url": "https://translations.documentfoundation.org/api/units/96178951/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:37:36.915019Z"
        }
    ]
}