Changes
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/libo_help-7-6/textsdatabase/en_GB/changes/?format=api&page=30
{ "count": 1740, "next": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en_GB/changes/?format=api&page=31", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en_GB/changes/?format=api&page=29", "results": [ { "unit": "https://translations.documentfoundation.org/api/units/96134207/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en_GB/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:37:03.910490Z", "action": 59, "target": "Fields involved", "id": 33513106, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33513106/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96134199/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en_GB/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:37:03.910446Z", "action": 59, "target": "<ahelp hid=\"dbaccess/ui/joindialog/table2\">Specifies two different tables that you want to join.</ahelp>", "id": 33513105, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33513105/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96134192/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en_GB/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:37:03.910398Z", "action": 59, "target": "Tables involved", "id": 33513104, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33513104/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96134186/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en_GB/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:37:03.910351Z", "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": 33513103, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33513103/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96134178/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en_GB/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:37:03.910307Z", "action": 59, "target": "Join Properties", "id": 33513102, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33513102/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96134137/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en_GB/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:37:03.910262Z", "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": 33513101, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33513101/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96134125/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en_GB/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:37:03.910221Z", "action": 59, "target": "Join Properties", "id": 33513100, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33513100/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96134118/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en_GB/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:37:03.910177Z", "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": 33513099, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33513099/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96134100/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en_GB/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:37:03.910135Z", "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": 33513098, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33513098/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96134088/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en_GB/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:37:03.910093Z", "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": 33513097, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33513097/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96134075/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en_GB/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:37:03.910048Z", "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": 33513096, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33513096/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96134061/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en_GB/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:37:03.910006Z", "action": 59, "target": "SQL stands for \"Structured Query Language\" and describes instructions for updating and administering relational databases.", "id": 33513095, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33513095/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96134057/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en_GB/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:37:03.909964Z", "action": 59, "target": "SQL Mode", "id": 33513094, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33513094/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96134052/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en_GB/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:37:03.909920Z", "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": 33513093, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33513093/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96134046/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en_GB/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:37:03.909877Z", "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": 33513092, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33513092/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96134040/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en_GB/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:37:03.909832Z", "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": 33513091, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33513091/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96134035/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en_GB/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:37:03.909790Z", "action": 59, "target": "Parameter Input", "id": 33513090, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33513090/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96134032/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en_GB/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:37:03.909748Z", "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": 33513089, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33513089/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96134030/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en_GB/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:37:03.909704Z", "action": 59, "target": "", "id": 33513088, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33513088/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96134026/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en_GB/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:37:03.909662Z", "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": 33513087, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33513087/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96134022/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en_GB/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:37:03.909620Z", "action": 59, "target": "", "id": 33513086, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33513086/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96134018/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en_GB/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:37:03.909578Z", "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": 33513085, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33513085/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96134002/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en_GB/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:37:03.909538Z", "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": 33513084, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33513084/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96133998/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en_GB/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:37:03.909498Z", "action": 59, "target": "Parameter queries", "id": 33513083, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33513083/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96133991/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en_GB/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:37:03.909458Z", "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": 33513082, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33513082/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96133984/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en_GB/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:37:03.909419Z", "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": 33513081, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33513081/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96133978/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en_GB/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:37:03.909380Z", "action": 59, "target": "IS NULL", "id": 33513080, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33513080/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96133972/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en_GB/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:37:03.909341Z", "action": 59, "target": "Null", "id": 33513079, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33513079/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96133965/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en_GB/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:37:03.909301Z", "action": 59, "target": "=0 returns all records for which the Yes/No field has the status \"No\" or \"Off\" (no selection).", "id": 33513078, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33513078/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96133958/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en_GB/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:37:03.909261Z", "action": 59, "target": ".", "id": 33513077, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33513077/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96133951/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en_GB/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:37:03.909219Z", "action": 59, "target": "No", "id": 33513076, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33513076/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96133943/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en_GB/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:37:03.909175Z", "action": 59, "target": "=1 returns all records where the Yes/No field has the status \"Yes\" or \"On\" (selected in black),", "id": 33513075, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33513075/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96133936/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en_GB/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:37:03.909133Z", "action": 59, "target": "for dBASE tables: not equal to any given value", "id": 33513074, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33513074/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96133928/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en_GB/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:37:03.909094Z", "action": 59, "target": "Yes", "id": 33513073, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33513073/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96133920/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en_GB/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:37:03.909055Z", "action": 59, "target": "Example", "id": 33513072, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33513072/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96133915/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en_GB/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:37:03.909015Z", "action": 59, "target": "Query criterion", "id": 33513071, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33513071/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96133909/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en_GB/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:37:03.908977Z", "action": 59, "target": "Status", "id": 33513070, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33513070/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96133903/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en_GB/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:37:03.908940Z", "action": 59, "target": "To query Yes/No fields, use the following syntax for dBASE tables:", "id": 33513069, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33513069/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96133895/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en_GB/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:37:03.908905Z", "action": 59, "target": "Querying Yes/No fields", "id": 33513068, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33513068/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96133891/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en_GB/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:37:03.908867Z", "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": 33513067, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33513067/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96133885/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en_GB/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:37:03.908830Z", "action": 59, "target": "DateTime", "id": 33513066, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33513066/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96133877/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en_GB/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:37:03.908790Z", "action": 59, "target": "Time", "id": 33513065, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33513065/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96133871/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en_GB/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:37:03.908748Z", "action": 59, "target": "Date", "id": 33513064, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33513064/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96133866/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en_GB/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:37:03.908703Z", "action": 59, "target": "SQL2 syntax", "id": 33513063, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33513063/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96133859/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en_GB/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:37:03.908659Z", "action": 59, "target": "SQL Escape syntax #2", "id": 33513062, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33513062/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96133853/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en_GB/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:37:03.908616Z", "action": 59, "target": "SQL Escape syntax #1 - may be obsolete", "id": 33513061, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33513061/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96133847/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en_GB/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:37:03.908574Z", "action": 59, "target": "Date Type Element", "id": 33513060, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33513060/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96133837/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en_GB/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:37:03.908527Z", "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": 33513059, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33513059/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96133829/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en_GB/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:37:03.908480Z", "action": 59, "target": "Querying date fields", "id": 33513058, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33513058/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/96133821/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en_GB/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:37:03.908434Z", "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": 33513057, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33513057/?format=api" } ] }