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/changes/?format=api&page=30
https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/changes/?format=api&page=31", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsdatabase/en/changes/?format=api&page=29", "results": [ { "unit": "https://translations.documentfoundation.org/api/units/95833829/?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/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:32:54.965885Z", "action": 59, "target": "Fields involved", "id": 33246563, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33246563/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/95833786/?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/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:32:54.965846Z", "action": 59, "target": "<ahelp hid=\"dbaccess/ui/joindialog/table2\">Specifies two different tables that you want to join.</ahelp>", "id": 33246562, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33246562/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/95833715/?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/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:32:54.965805Z", "action": 59, "target": "Tables involved", "id": 33246561, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33246561/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/95833679/?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/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:32:54.965765Z", "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": 33246560, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33246560/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/95833656/?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/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:32:54.965726Z", "action": 59, "target": "Join Properties", "id": 33246559, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33246559/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/95833631/?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/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:32:54.965687Z", "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": 33246558, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33246558/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/95833604/?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/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:32:54.965647Z", "action": 59, "target": "Join Properties", "id": 33246557, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33246557/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/95833552/?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/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:32:54.965608Z", "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": 33246556, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33246556/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/95833505/?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/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:32:54.965569Z", "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": 33246555, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33246555/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/95833473/?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/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:32:54.965530Z", "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": 33246554, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33246554/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/95833430/?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/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:32:54.965490Z", "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": 33246553, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33246553/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/95833357/?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/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:32:54.965450Z", "action": 59, "target": "SQL stands for \"Structured Query Language\" and describes instructions for updating and administering relational databases.", "id": 33246552, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33246552/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/95833316/?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/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:32:54.965412Z", "action": 59, "target": "SQL Mode", "id": 33246551, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33246551/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/95833263/?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/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:32:54.965369Z", "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": 33246550, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33246550/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/95833207/?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/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:32:54.965328Z", "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": 33246549, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33246549/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/95833119/?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/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:32:54.965289Z", "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": 33246548, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33246548/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/95833093/?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/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:32:54.965252Z", "action": 59, "target": "Parameter Input", "id": 33246547, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33246547/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/95833068/?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/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:32:54.965214Z", "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": 33246546, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33246546/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/95833042/?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/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:32:54.965172Z", "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": 33246545, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33246545/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/95833020/?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/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:32:54.965133Z", "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": 33246544, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33246544/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/95833004/?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/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:32:54.965094Z", "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": 33246543, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33246543/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/95832984/?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/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:32:54.965054Z", "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": 33246542, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33246542/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/95832959/?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/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:32:54.965015Z", "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": 33246541, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33246541/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/95832932/?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/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:32:54.964978Z", "action": 59, "target": "Parameter queries", "id": 33246540, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33246540/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/95832907/?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/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:32:54.964940Z", "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": 33246539, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33246539/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/95832852/?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/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:32:54.964899Z", "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": 33246538, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33246538/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/95832822/?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/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:32:54.964860Z", "action": 59, "target": "IS NULL", "id": 33246537, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33246537/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/95832780/?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/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:32:54.964820Z", "action": 59, "target": "Null", "id": 33246536, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33246536/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/95832721/?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/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:32:54.964780Z", "action": 59, "target": "=0 returns all records for which the Yes/No field has the status \"No\" or \"Off\" (no selection).", "id": 33246535, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33246535/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/95832676/?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/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:32:54.964741Z", "action": 59, "target": ".", "id": 33246534, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33246534/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/95832632/?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/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:32:54.964703Z", "action": 59, "target": "No", "id": 33246533, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33246533/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/95832593/?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/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:32:54.964662Z", "action": 59, "target": "=1 returns all records where the Yes/No field has the status \"Yes\" or \"On\" (selected in black),", "id": 33246532, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33246532/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/95832559/?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/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:32:54.964622Z", "action": 59, "target": "for dBASE tables: not equal to any given value", "id": 33246530, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33246530/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/95832529/?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/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:32:54.964583Z", "action": 59, "target": "Yes", "id": 33246528, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33246528/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/95832475/?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/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:32:54.964546Z", "action": 59, "target": "Example", "id": 33246526, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33246526/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/95832452/?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/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:32:54.964509Z", "action": 59, "target": "Query criterion", "id": 33246524, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33246524/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/95832421/?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/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:32:54.964470Z", "action": 59, "target": "Status", "id": 33246522, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33246522/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/95832346/?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/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:32:54.964433Z", "action": 59, "target": "To query Yes/No fields, use the following syntax for dBASE tables:", "id": 33246520, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33246520/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/95832309/?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/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:32:54.964395Z", "action": 59, "target": "Querying Yes/No fields", "id": 33246518, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33246518/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/95832235/?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/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:32:54.964358Z", "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": 33246516, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33246516/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/95832202/?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/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:32:54.964322Z", "action": 59, "target": "DateTime", "id": 33246514, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33246514/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/95832159/?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/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:32:54.964284Z", "action": 59, "target": "Time", "id": 33246512, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33246512/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/95832126/?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/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:32:54.964233Z", "action": 59, "target": "Date", "id": 33246510, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33246510/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/95831530/?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/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:32:54.963226Z", "action": 59, "target": "SQL2 syntax", "id": 33246508, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33246508/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/95831495/?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/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:32:54.963191Z", "action": 59, "target": "SQL Escape syntax #2", "id": 33246506, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33246506/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/95831459/?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/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:32:54.963154Z", "action": 59, "target": "SQL Escape syntax #1 - may be obsolete", "id": 33246504, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33246504/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/95831428/?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/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:32:54.963116Z", "action": 59, "target": "Date Type Element", "id": 33246502, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33246502/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/95831398/?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/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:32:54.963078Z", "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": 33246497, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33246497/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/95831372/?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/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:32:54.963041Z", "action": 59, "target": "Querying date fields", "id": 33246496, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33246496/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/95831337/?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/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T21:32:54.963001Z", "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": 33246495, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/33246495/?format=api" } ] }{ "count": 1740, "next": "