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/bo/units/?format=api&page=7",
    "previous": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/bo/units/?format=api&page=5",
    "results": [
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/bo/?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": 95962767,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/bo/?checksum=3f2535a9d80d6508",
            "url": "https://translations.documentfoundation.org/api/units/95962767/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:34:17.243993Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/bo/?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": 95962772,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/bo/?checksum=f14bd7a10bd6cdf7",
            "url": "https://translations.documentfoundation.org/api/units/95962772/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:34:17.245542Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/bo/?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": 95962775,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/bo/?checksum=e8ab361ad24e5ef5",
            "url": "https://translations.documentfoundation.org/api/units/95962775/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:34:17.246611Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/bo/?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": 95962779,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/bo/?checksum=6c07db2f6eb86b62",
            "url": "https://translations.documentfoundation.org/api/units/95962779/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:34:17.247599Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/bo/?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": 95962795,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/bo/?checksum=f80c95480647f882",
            "url": "https://translations.documentfoundation.org/api/units/95962795/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:34:17.248672Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/bo/?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": 95962800,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/bo/?checksum=f0fbae51c760029d",
            "url": "https://translations.documentfoundation.org/api/units/95962800/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:34:17.259795Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/bo/?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": 95962803,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/bo/?checksum=c484871ad9e28012",
            "url": "https://translations.documentfoundation.org/api/units/95962803/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:34:17.261582Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/bo/?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": 95962806,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/bo/?checksum=6b6141823bb17437",
            "url": "https://translations.documentfoundation.org/api/units/95962806/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:34:17.262948Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/bo/?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": 95962809,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/bo/?checksum=b8dcc2ab05d5d79c",
            "url": "https://translations.documentfoundation.org/api/units/95962809/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:34:17.264266Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/bo/?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": 95962811,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/bo/?checksum=6e6e9c1d01afb80c",
            "url": "https://translations.documentfoundation.org/api/units/95962811/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:34:17.265495Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/bo/?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": 95962813,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/bo/?checksum=70aa55b10400329d",
            "url": "https://translations.documentfoundation.org/api/units/95962813/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:34:17.266722Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/bo/?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": 95962817,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/bo/?checksum=48d74ca9cf82657b",
            "url": "https://translations.documentfoundation.org/api/units/95962817/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:34:17.268018Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/bo/?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": 95962820,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/bo/?checksum=510c532e099f7565",
            "url": "https://translations.documentfoundation.org/api/units/95962820/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:34:17.269379Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/bo/?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": 95962821,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/bo/?checksum=d1caf16364dcea18",
            "url": "https://translations.documentfoundation.org/api/units/95962821/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:34:17.270415Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/bo/?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": 95962824,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/bo/?checksum=db60cbc6c3a97af0",
            "url": "https://translations.documentfoundation.org/api/units/95962824/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:34:17.271549Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/bo/?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": 95962827,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/bo/?checksum=e45527a32629c77b",
            "url": "https://translations.documentfoundation.org/api/units/95962827/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:34:17.272804Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/bo/?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": 95962832,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/bo/?checksum=8640cb55143edbe7",
            "url": "https://translations.documentfoundation.org/api/units/95962832/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:34:17.276195Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/bo/?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": 95962835,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/bo/?checksum=0f087ef2cd3405d3",
            "url": "https://translations.documentfoundation.org/api/units/95962835/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:34:17.277798Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/bo/?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": 95962837,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/bo/?checksum=b90e9a747be3f72e",
            "url": "https://translations.documentfoundation.org/api/units/95962837/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:34:17.279221Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/bo/?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": 95962839,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/bo/?checksum=1032d7351f837b9d",
            "url": "https://translations.documentfoundation.org/api/units/95962839/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:34:17.280596Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/bo/?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": 95962842,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/bo/?checksum=9f137939443ff99b",
            "url": "https://translations.documentfoundation.org/api/units/95962842/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:34:17.281940Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/bo/?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": 95962843,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/bo/?checksum=e622d0dc17a172b7",
            "url": "https://translations.documentfoundation.org/api/units/95962843/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:34:17.283458Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/bo/?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": 95962847,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/bo/?checksum=9d40da7e1de2d565",
            "url": "https://translations.documentfoundation.org/api/units/95962847/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:34:17.285322Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/bo/?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": 95962849,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/bo/?checksum=a2158a9cf1f1c2ad",
            "url": "https://translations.documentfoundation.org/api/units/95962849/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:34:17.286470Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/bo/?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": 95962851,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/bo/?checksum=83ab6db864947e5d",
            "url": "https://translations.documentfoundation.org/api/units/95962851/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:34:17.287810Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/bo/?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": 95962854,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/bo/?checksum=1651c3b512638dff",
            "url": "https://translations.documentfoundation.org/api/units/95962854/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:34:17.289310Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/bo/?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": 95962857,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/bo/?checksum=e776a92d0c8d3d59",
            "url": "https://translations.documentfoundation.org/api/units/95962857/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:34:17.290426Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/bo/?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": 95962859,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/bo/?checksum=ee5bc2a2964152df",
            "url": "https://translations.documentfoundation.org/api/units/95962859/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:34:17.291455Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/bo/?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": 95962870,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/bo/?checksum=a4b6dcf329a9f0dd",
            "url": "https://translations.documentfoundation.org/api/units/95962870/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:34:17.297764Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/bo/?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": 95962874,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/bo/?checksum=ee354695204d6021",
            "url": "https://translations.documentfoundation.org/api/units/95962874/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:34:17.299427Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/bo/?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": 95962877,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/bo/?checksum=902fca834ddac001",
            "url": "https://translations.documentfoundation.org/api/units/95962877/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:34:17.301284Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/bo/?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": 95962880,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/bo/?checksum=ce4cf17f8192519d",
            "url": "https://translations.documentfoundation.org/api/units/95962880/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:34:17.302725Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/bo/?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": 95962883,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/bo/?checksum=71eeb3af9d062d58",
            "url": "https://translations.documentfoundation.org/api/units/95962883/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:34:17.304412Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/bo/?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": 95962888,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/bo/?checksum=2350847d295db268",
            "url": "https://translations.documentfoundation.org/api/units/95962888/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:34:17.306308Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/bo/?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": 95962892,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/bo/?checksum=9210035be5d33172",
            "url": "https://translations.documentfoundation.org/api/units/95962892/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:34:17.308392Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/bo/?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": 95962896,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/bo/?checksum=a554c9728484b7f6",
            "url": "https://translations.documentfoundation.org/api/units/95962896/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:34:17.310105Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/bo/?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": 95962900,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/bo/?checksum=09840769a28d869e",
            "url": "https://translations.documentfoundation.org/api/units/95962900/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:34:17.311608Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/bo/?format=api",
            "source": [
                "Tables involved"
            ],
            "previous_source": "",
            "target": [
                ""
            ],
            "id_hash": -36410145612706044,
            "content_hash": -36410145612706044,
            "location": "02010101.xhp",
            "context": "02010101.xhp\nhd_id3155066\nhelp.text",
            "note": "oszEF",
            "flags": "",
            "labels": [],
            "state": 0,
            "fuzzy": false,
            "translated": false,
            "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": 95962903,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/bo/?checksum=7f7ea52a5c88cf04",
            "url": "https://translations.documentfoundation.org/api/units/95962903/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:34:17.313174Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/bo/?format=api",
            "source": [
                "<ahelp hid=\"dbaccess/ui/joindialog/table2\">Specifies two different tables that you want to join.</ahelp>"
            ],
            "previous_source": "",
            "target": [
                ""
            ],
            "id_hash": 1333863119828857673,
            "content_hash": 1333863119828857673,
            "location": "02010101.xhp",
            "context": "02010101.xhp\npar_id3153924\nhelp.text",
            "note": "2AkcB",
            "flags": "",
            "labels": [],
            "state": 0,
            "fuzzy": false,
            "translated": false,
            "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": 95962904,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/bo/?checksum=9282d570bc64b349",
            "url": "https://translations.documentfoundation.org/api/units/95962904/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:34:17.316373Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/bo/?format=api",
            "source": [
                "Fields involved"
            ],
            "previous_source": "",
            "target": [
                ""
            ],
            "id_hash": -1789859163330594308,
            "content_hash": -1789859163330594308,
            "location": "02010101.xhp",
            "context": "02010101.xhp\nhd_id3155766\nhelp.text",
            "note": "X6wkD",
            "flags": "",
            "labels": [],
            "state": 0,
            "fuzzy": false,
            "translated": false,
            "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": 95962907,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/bo/?checksum=67292492f3b3b9fc",
            "url": "https://translations.documentfoundation.org/api/units/95962907/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:34:17.318041Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/bo/?format=api",
            "source": [
                "<ahelp hid=\".\">Specifies two data fields that will be joined by a relation.</ahelp>"
            ],
            "previous_source": "",
            "target": [
                ""
            ],
            "id_hash": 7574129023308213126,
            "content_hash": 7574129023308213126,
            "location": "02010101.xhp",
            "context": "02010101.xhp\npar_id3148994\nhelp.text",
            "note": "8bYEZ",
            "flags": "",
            "labels": [],
            "state": 0,
            "fuzzy": false,
            "translated": false,
            "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": 95962910,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/bo/?checksum=e91cb6379d432b86",
            "url": "https://translations.documentfoundation.org/api/units/95962910/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:34:17.319549Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/bo/?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": 95962913,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/bo/?checksum=5a3e2e02baefc234",
            "url": "https://translations.documentfoundation.org/api/units/95962913/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:34:17.321031Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/bo/?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": 95962916,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/bo/?checksum=47be67a46ecbb481",
            "url": "https://translations.documentfoundation.org/api/units/95962916/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:34:17.322497Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/bo/?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": 95962918,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/bo/?checksum=1b13268f00c1be09",
            "url": "https://translations.documentfoundation.org/api/units/95962918/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:34:17.323936Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/bo/?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": 95962921,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/bo/?checksum=16b89a1be24de5be",
            "url": "https://translations.documentfoundation.org/api/units/95962921/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:34:17.325445Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/bo/?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": 95962923,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/bo/?checksum=2b26fe76b5bff5ae",
            "url": "https://translations.documentfoundation.org/api/units/95962923/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:34:17.327046Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/bo/?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": 95962927,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/bo/?checksum=01109622fd5b66ac",
            "url": "https://translations.documentfoundation.org/api/units/95962927/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:34:17.329016Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/bo/?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": 95962929,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/bo/?checksum=9659c117d22bba44",
            "url": "https://translations.documentfoundation.org/api/units/95962929/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:34:17.330738Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/bo/?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": 95962933,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/bo/?checksum=d40b62cb58fa23e8",
            "url": "https://translations.documentfoundation.org/api/units/95962933/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:34:17.332397Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/bo/?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": 95962954,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsdatabase/bo/?checksum=9e93cb394e210d52",
            "url": "https://translations.documentfoundation.org/api/units/95962954/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2023-09-11T21:34:17.402965Z"
        }
    ]
}