Changes
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/libo_help-24-2/textsdatabase/en_GB/changes/?format=api&page=30
{ "count": 1740, "next": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en_GB/changes/?format=api&page=31", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en_GB/changes/?format=api&page=29", "results": [ { "unit": "https://translations.documentfoundation.org/api/units/107669675/?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_GB/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T17:00:33.345483Z", "action": 59, "target": "Fields involved", "id": 45410396, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45410396/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107669673/?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_GB/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T17:00:33.345450Z", "action": 59, "target": "<ahelp hid=\"dbaccess/ui/joindialog/table2\">Specifies two different tables that you want to join.</ahelp>", "id": 45410395, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45410395/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107669672/?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_GB/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T17:00:33.345417Z", "action": 59, "target": "Tables involved", "id": 45410394, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45410394/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107669665/?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_GB/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T17:00:33.345384Z", "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> dialogue box appears. These properties will be used in all queries created in the future.", "id": 45410393, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45410393/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107669662/?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_GB/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T17:00:33.345353Z", "action": 59, "target": "Join Properties", "id": 45410392, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45410392/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107669658/?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_GB/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T17:00:33.345321Z", "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": 45410391, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45410391/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107669653/?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_GB/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T17:00:33.345290Z", "action": 59, "target": "Join Properties", "id": 45410390, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45410390/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107669650/?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_GB/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T17:00:33.345258Z", "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": 45410389, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45410389/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107669645/?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_GB/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T17:00:33.345227Z", "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": 45410388, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45410388/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107669642/?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_GB/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T17:00:33.345195Z", "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": 45410387, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45410387/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107669637/?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_GB/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T17:00:33.345163Z", "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": 45410386, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45410386/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107669634/?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_GB/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T17:00:33.345130Z", "action": 59, "target": "SQL stands for \"Structured Query Language\" and describes instructions for updating and administering relational databases.", "id": 45410385, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45410385/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107669633/?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_GB/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T17:00:33.345095Z", "action": 59, "target": "SQL Mode", "id": 45410384, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45410384/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107669630/?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_GB/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T17:00:33.345059Z", "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": 45410383, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45410383/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107669628/?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_GB/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T17:00:33.345021Z", "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": 45410382, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45410382/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107669625/?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_GB/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T17:00:33.344982Z", "action": 59, "target": "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\">The <emph>Parameter Input</emph> dialogue box 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": 45410381, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45410381/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107669623/?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_GB/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T17:00:33.344943Z", "action": 59, "target": "Parameter Input", "id": 45410380, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45410380/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107669621/?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_GB/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T17:00:33.344902Z", "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": 45410379, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45410379/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107669618/?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_GB/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T17:00:33.344863Z", "action": 59, "target": "", "id": 45410378, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45410378/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107669617/?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_GB/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T17:00:33.344821Z", "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": 45410377, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45410377/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107669615/?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_GB/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T17:00:33.344782Z", "action": 59, "target": "", "id": 45410376, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45410376/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107669613/?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_GB/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T17:00:33.344739Z", "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": 45410375, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45410375/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107669611/?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_GB/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T17:00:33.344698Z", "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": 45410374, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45410374/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107669609/?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_GB/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T17:00:33.344659Z", "action": 59, "target": "Parameter queries", "id": 45410373, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45410373/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107669607/?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_GB/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T17:00:33.344618Z", "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": 45410372, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45410372/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107669604/?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_GB/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T17:00:33.344576Z", "action": 59, "target": "IS NULL returns all records for which the Yes/No field has neither of the states Yes or No (selected in grey).", "id": 45410371, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45410371/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107669603/?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_GB/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T17:00:33.344533Z", "action": 59, "target": "IS NULL", "id": 45410370, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45410370/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107669601/?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_GB/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T17:00:33.344464Z", "action": 59, "target": "Null", "id": 45410369, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45410369/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107669599/?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_GB/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T17:00:33.344423Z", "action": 59, "target": "=0 returns all records for which the Yes/No field has the status \"No\" or \"Off\" (no selection).", "id": 45410368, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45410368/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107669598/?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_GB/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T17:00:33.344370Z", "action": 59, "target": ".", "id": 45410367, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45410367/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107669596/?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_GB/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T17:00:33.344328Z", "action": 59, "target": "No", "id": 45410366, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45410366/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107669594/?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_GB/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T17:00:33.344286Z", "action": 59, "target": "=1 returns all records where the Yes/No field has the status \"Yes\" or \"On\" (selected in black),", "id": 45410365, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45410365/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107669592/?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_GB/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T17:00:33.344247Z", "action": 59, "target": "for dBASE tables: not equal to any given value", "id": 45410364, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45410364/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107669591/?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_GB/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T17:00:33.344208Z", "action": 59, "target": "Yes", "id": 45410363, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45410363/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107669586/?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_GB/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T17:00:33.344168Z", "action": 59, "target": "Example", "id": 45410362, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45410362/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107669583/?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_GB/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T17:00:33.344127Z", "action": 59, "target": "Query criterion", "id": 45410361, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45410361/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107669580/?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_GB/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T17:00:33.344086Z", "action": 59, "target": "Status", "id": 45410360, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45410360/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107669579/?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_GB/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T17:00:33.344046Z", "action": 59, "target": "To query Yes/No fields, use the following syntax for dBASE tables:", "id": 45410359, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45410359/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107669576/?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_GB/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T17:00:33.344006Z", "action": 59, "target": "Querying Yes/No fields", "id": 45410358, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45410358/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107669573/?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_GB/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T17:00:33.343963Z", "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": 45410357, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45410357/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107669570/?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_GB/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T17:00:33.343919Z", "action": 59, "target": "DateTime", "id": 45410356, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45410356/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107669569/?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_GB/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T17:00:33.343878Z", "action": 59, "target": "Time", "id": 45410355, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45410355/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107669567/?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_GB/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T17:00:33.343840Z", "action": 59, "target": "Date", "id": 45410354, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45410354/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107669564/?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_GB/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T17:00:33.343793Z", "action": 59, "target": "SQL2 syntax", "id": 45410353, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45410353/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107669562/?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_GB/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T17:00:33.343743Z", "action": 59, "target": "SQL Escape syntax #2", "id": 45410352, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45410352/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107669559/?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_GB/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T17:00:33.343703Z", "action": 59, "target": "SQL Escape syntax #1 - may be obsolete", "id": 45410351, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45410351/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107669556/?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_GB/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T17:00:33.343662Z", "action": 59, "target": "Date Type Element", "id": 45410350, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45410350/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107669554/?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_GB/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T17:00:33.343620Z", "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": 45410349, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45410349/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107669551/?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_GB/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T17:00:33.343580Z", "action": 59, "target": "Querying date fields", "id": 45410348, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45410348/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107669548/?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_GB/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T17:00:33.343541Z", "action": 59, "target": "To query the content of a text field, you must put the expression between single quotes. The distinction between upper-case and lower-case letters depends on the database in use. LIKE, by definition, is case-sensitive (though some databases don't interpret this strictly).", "id": 45410347, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45410347/?format=api" } ] }