Changes

HTTP 200 OK
Allow: GET, HEAD, OPTIONS
Content-Type: application/json
Vary: Accept

{
    "count": 160790,
    "next": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/changes/?format=api&page=3212",
    "previous": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/changes/?format=api&page=3210",
    "results": [
        {
            "unit": "https://translations.documentfoundation.org/api/units/107519089/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T16:57:41.500209Z",
            "action": 59,
            "target": "Tables involved",
            "id": 45291331,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/45291331/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/107519062/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T16:57:41.500170Z",
            "action": 59,
            "target": "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.",
            "id": 45291330,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/45291330/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/107519046/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T16:57:41.500130Z",
            "action": 59,
            "target": "Join Properties",
            "id": 45291329,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/45291329/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/107519029/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T16:57:41.500090Z",
            "action": 59,
            "target": "<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>",
            "id": 45291328,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/45291328/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/107519013/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T16:57:41.500051Z",
            "action": 59,
            "target": "Join Properties",
            "id": 45291327,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/45291327/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/107519000/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T16:57:41.500014Z",
            "action": 59,
            "target": "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.",
            "id": 45291326,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/45291326/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/107518998/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T16:57:41.499976Z",
            "action": 59,
            "target": "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.",
            "id": 45291325,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/45291325/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/107518992/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T16:57:41.499937Z",
            "action": 59,
            "target": "You can formulate your query directly in SQL code. Note, however, that the special syntax is dependent upon the database system that you use.",
            "id": 45291324,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/45291324/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/107518984/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T16:57:41.499898Z",
            "action": 59,
            "target": "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.",
            "id": 45291323,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/45291323/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/107518974/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T16:57:41.499857Z",
            "action": 59,
            "target": "SQL stands for \"Structured Query Language\" and describes instructions for updating and administering relational databases.",
            "id": 45291322,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/45291322/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/107518962/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T16:57:41.499816Z",
            "action": 59,
            "target": "SQL Mode",
            "id": 45291321,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/45291321/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/107518948/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T16:57:41.499773Z",
            "action": 59,
            "target": "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.",
            "id": 45291320,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/45291320/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/107518905/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T16:57:41.499728Z",
            "action": 59,
            "target": "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.",
            "id": 45291319,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/45291319/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/107518886/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T16:57:41.499688Z",
            "action": 59,
            "target": "<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>",
            "id": 45291318,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/45291318/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/107518874/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T16:57:41.499648Z",
            "action": 59,
            "target": "Parameter Input",
            "id": 45291317,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/45291317/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/107518861/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T16:57:41.499608Z",
            "action": 59,
            "target": "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.",
            "id": 45291316,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/45291316/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/107518840/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T16:57:41.499568Z",
            "action": 59,
            "target": "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>.",
            "id": 45291315,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/45291315/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/107518824/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T16:57:41.499529Z",
            "action": 59,
            "target": "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.",
            "id": 45291314,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/45291314/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/107518814/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T16:57:41.499488Z",
            "action": 59,
            "target": "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>",
            "id": 45291313,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/45291313/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/107518803/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T16:57:41.499448Z",
            "action": 59,
            "target": "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.",
            "id": 45291312,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/45291312/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/107518781/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T16:57:41.499409Z",
            "action": 59,
            "target": "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.",
            "id": 45291311,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/45291311/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/107518768/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T16:57:41.499369Z",
            "action": 59,
            "target": "Parameter queries",
            "id": 45291310,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/45291310/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/107518752/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T16:57:41.499329Z",
            "action": 59,
            "target": "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).",
            "id": 45291309,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/45291309/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/107518735/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T16:57:41.499289Z",
            "action": 59,
            "target": "IS NULL returns all records for which the Yes/No field has neither of the states Yes or No (selected in gray).",
            "id": 45291308,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/45291308/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/107518728/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T16:57:41.499248Z",
            "action": 59,
            "target": "IS NULL",
            "id": 45291307,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/45291307/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/107518722/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T16:57:41.499208Z",
            "action": 59,
            "target": "Null",
            "id": 45291306,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/45291306/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/107518716/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T16:57:41.499168Z",
            "action": 59,
            "target": "=0 returns all records for which the Yes/No field has the status \"No\" or \"Off\" (no selection).",
            "id": 45291305,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/45291305/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/107518713/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T16:57:41.499127Z",
            "action": 59,
            "target": ".",
            "id": 45291304,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/45291304/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/107518708/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T16:57:41.499087Z",
            "action": 59,
            "target": "No",
            "id": 45291303,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/45291303/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/107518672/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T16:57:41.499048Z",
            "action": 59,
            "target": "=1 returns all records where the Yes/No field has the status \"Yes\" or \"On\" (selected in black),",
            "id": 45291302,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/45291302/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/107518651/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T16:57:41.499012Z",
            "action": 59,
            "target": "for dBASE tables: not equal to any given value",
            "id": 45291301,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/45291301/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/107518637/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T16:57:41.498972Z",
            "action": 59,
            "target": "Yes",
            "id": 45291300,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/45291300/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/107518628/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T16:57:41.498932Z",
            "action": 59,
            "target": "Example",
            "id": 45291299,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/45291299/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/107518620/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T16:57:41.498893Z",
            "action": 59,
            "target": "Query criterion",
            "id": 45291298,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/45291298/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/107518619/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T16:57:41.498854Z",
            "action": 59,
            "target": "Status",
            "id": 45291297,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/45291297/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/107518605/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T16:57:41.498811Z",
            "action": 59,
            "target": "To query Yes/No fields, use the following syntax for dBASE tables:",
            "id": 45291296,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/45291296/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/107518594/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T16:57:41.498454Z",
            "action": 59,
            "target": "Querying Yes/No fields",
            "id": 45291295,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/45291295/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/107518590/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T16:57:41.498414Z",
            "action": 59,
            "target": "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.)",
            "id": 45291294,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/45291294/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/107518580/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T16:57:41.498374Z",
            "action": 59,
            "target": "DateTime",
            "id": 45291293,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/45291293/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/107518572/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T16:57:41.498334Z",
            "action": 59,
            "target": "Time",
            "id": 45291292,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/45291292/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/107518564/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T16:57:41.498294Z",
            "action": 59,
            "target": "Date",
            "id": 45291291,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/45291291/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/107518559/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T16:57:41.498253Z",
            "action": 59,
            "target": "SQL2 syntax",
            "id": 45291290,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/45291290/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/107518534/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T16:57:41.498212Z",
            "action": 59,
            "target": "SQL Escape syntax #2",
            "id": 45291289,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/45291289/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/107518521/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T16:57:41.498172Z",
            "action": 59,
            "target": "SQL Escape syntax #1 - may be obsolete",
            "id": 45291288,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/45291288/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/107518515/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T16:57:41.498132Z",
            "action": 59,
            "target": "Date Type Element",
            "id": 45291287,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/45291287/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/107518510/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T16:57:41.498089Z",
            "action": 59,
            "target": "<emph>Date fields</emph> are represented as #Date# to clearly identify them as dates. Date, time and date/time constants (literals) used in conditions can be of either the SQL Escape Syntax type, or default SQL2 syntax.",
            "id": 45291286,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/45291286/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/107518501/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T16:57:41.498048Z",
            "action": 59,
            "target": "Querying date fields",
            "id": 45291285,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/45291285/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/107518492/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T16:57:41.498008Z",
            "action": 59,
            "target": "To query the content of a text field, you must put the expression between single quotes. The distinction between uppercase and lowercase letters depends on the database in use. LIKE, by definition, is case-sensitive (though some databases don't interpret this strictly).",
            "id": 45291284,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/45291284/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/107518480/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T16:57:41.497968Z",
            "action": 59,
            "target": "Querying text fields",
            "id": 45291283,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/45291283/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/107518468/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T16:57:41.497927Z",
            "action": 59,
            "target": "<emph>Outer Join</emph> Escape Sequence: {oj outer-join}",
            "id": 45291282,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/45291282/?format=api"
        }
    ]
}