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/changes/?format=api&page=32
{ "count": 1740, "next": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en/changes/?format=api&page=33", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en/changes/?format=api&page=31", "results": [ { "unit": "https://translations.documentfoundation.org/api/units/107517325/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T16:57:41.495973Z", "action": 59, "target": "... the content of the field is less than the specified expression.", "id": 45291233, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291233/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107517314/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T16:57:41.495937Z", "action": 59, "target": "less than", "id": 45291232, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291232/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107517299/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T16:57:41.495897Z", "action": 59, "target": "... the content of the field is greater than the specified expression.", "id": 45291231, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291231/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107517295/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T16:57:41.495856Z", "action": 59, "target": "greater than", "id": 45291230, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291230/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107517286/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T16:57:41.495817Z", "action": 59, "target": "... the content of the field does not correspond to the specified expression.", "id": 45291229, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291229/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107517280/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T16:57:41.495777Z", "action": 59, "target": "not equal to", "id": 45291228, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291228/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107517273/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T16:57:41.495738Z", "action": 59, "target": "The operator = will not be displayed in the query fields. If you enter a value without any operator, the = operator is automatically assumed.", "id": 45291227, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291227/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107517268/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T16:57:41.495698Z", "action": 59, "target": "... the content of the field is identical to the indicated expression.", "id": 45291226, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291226/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107517264/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T16:57:41.495658Z", "action": 59, "target": "equal to", "id": 45291225, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291225/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107517259/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T16:57:41.495618Z", "action": 59, "target": "Condition is satisfied if...", "id": 45291224, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291224/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107517246/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T16:57:41.495577Z", "action": 59, "target": "Meaning", "id": 45291223, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291223/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107517229/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T16:57:41.495538Z", "action": 59, "target": "Operator", "id": 45291222, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291222/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107517218/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T16:57:41.495498Z", "action": 59, "target": "When formulating filter conditions, various operators and commands are available to you. Apart from the relational operators, there are SQL-specific commands that query the content of database fields. If you use these commands in the $[officename] syntax, $[officename] automatically converts these into the corresponding SQL syntax via an internal parser. You can also enter the SQL command directly and bypass the internal parser. The following tables give an overview of the operators and commands:", "id": 45291221, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291221/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107517201/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T16:57:41.495459Z", "action": 59, "target": "Formulating filter conditions", "id": 45291220, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291220/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107517182/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T16:57:41.495422Z", "action": 59, "target": "If a <emph>Limit</emph> construction is added, you will get at most as many rows as the number you specify. Otherwise, you will see all records corresponding to the query criteria.", "id": 45291219, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291219/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107517161/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T16:57:41.495385Z", "action": 59, "target": "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\">Allows you to limit the maximum number of records returned by a query.</ahelp>", "id": 45291218, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291218/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107517140/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T16:57:41.495347Z", "action": 59, "target": "Limit", "id": 45291217, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291217/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107517128/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T16:57:41.495309Z", "action": 59, "target": "In SQL, this command corresponds to the DISTINCT predicate.", "id": 45291216, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291216/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107517104/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T16:57:41.495269Z", "action": 59, "target": "For a query involving several fields, the combination of values from all fields must be unique so that the result can be formed from a specific record. For example, you have \"Smith in Chicago\" once in your address book and \"Smith in London\" twice. With the<emph> Distinct Values</emph> command, the query will use the two fields \"last name\" and \"city\" and return the query result \"Smith in Chicago\" once and \"Smith in London\" once.", "id": 45291215, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291215/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107517089/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T16:57:41.495230Z", "action": 59, "target": "For example, if the name \"Smith\" occurs several times in your address database, you can choose the<emph> Distinct Values</emph> command to specify in the query that the name \"Smith\" will occur only once.", "id": 45291214, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291214/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107517068/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T16:57:41.495190Z", "action": 59, "target": "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\">Retrieves only distinct values from the query.</ahelp> This applies to multiple records that might contain several repeating occurrences of data in the selected fields. If the <emph>Distinct Values</emph> command is active, you should only see one record in the query (DISTINCT). Otherwise, you will see all records corresponding to the query criteria (ALL).", "id": 45291213, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291213/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107517041/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T16:57:41.495152Z", "action": 59, "target": "Distinct Values", "id": 45291212, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291212/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107517028/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T16:57:41.495115Z", "action": 59, "target": "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\">Shows or hides the row for the alias name.</ahelp>", "id": 45291211, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291211/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107517002/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T16:57:41.495080Z", "action": 59, "target": "Alias Name", "id": 45291210, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291210/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107516982/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T16:57:41.495041Z", "action": 59, "target": "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\">Shows or hides the row for the table name.</ahelp>", "id": 45291209, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291209/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107516968/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T16:57:41.495001Z", "action": 59, "target": "Table Name", "id": 45291208, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291208/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107516944/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T16:57:41.494963Z", "action": 59, "target": "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\">Shows or hides a row for the selection of functions.</ahelp>", "id": 45291207, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291207/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107516918/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T16:57:41.494923Z", "action": 59, "target": "Functions", "id": 45291206, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291206/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107516903/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T16:57:41.494883Z", "action": 59, "target": "The following context menu commands and symbols are available:", "id": 45291205, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291205/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107516885/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T16:57:41.494844Z", "action": 59, "target": "Run the query.", "id": 45291204, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291204/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107516865/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T16:57:41.494804Z", "action": 59, "target": "Choose Group for the \"Supplier_No\" field.", "id": 45291203, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291203/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107516853/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T16:57:41.494761Z", "action": 59, "target": "You can also enter \"Average\" in the line for the alias name (without quotation marks).", "id": 45291202, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291202/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107516836/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T16:57:41.494703Z", "action": 59, "target": "Enable the <emph>Function</emph> line and select the Average function from the \"Price\" field.", "id": 45291201, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291201/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107516809/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T16:57:41.494668Z", "action": 59, "target": "Double-click the \"Price\" and \"Supplier_No\" fields.", "id": 45291200, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291200/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107516792/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T16:57:41.494628Z", "action": 59, "target": "Insert the \"Item\" table into the query design.", "id": 45291199, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291199/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107516773/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T16:57:41.494587Z", "action": 59, "target": "If the \"price\" (for the individual price of an article) and \"Supplier_No\" (for the supplier of the article) fields exist in the \"Item\" table, you can obtain the average price of the item that a supplier provides with the following query:", "id": 45291198, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291198/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107516759/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T16:57:41.494545Z", "action": 59, "target": "Run the query.", "id": 45291197, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291197/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107516738/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T16:57:41.494505Z", "action": 59, "target": "Double-click the \"Supplier_Name\" field in the \"Suppliers\" table and choose the Group function.", "id": 45291196, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291196/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107516723/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T16:57:41.494465Z", "action": 59, "target": "Enter >3 as a criterion and disable the Visible field.", "id": 45291195, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291195/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107516707/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T16:57:41.494423Z", "action": 59, "target": "Double-click on the \"Item_No\" field from the \"Item\" table. Display the <emph>Function</emph> line using the context menu and select the Count function.", "id": 45291194, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291194/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107516703/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T16:57:41.494383Z", "action": 59, "target": "Link the \"Supplier_No\" fields of the two tables if there is not already a relation of this type.", "id": 45291193, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291193/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107516695/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T16:57:41.494343Z", "action": 59, "target": "Insert the \"Item\" and \"Suppliers\" tables into the query design.", "id": 45291192, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291192/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107516687/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T16:57:41.494301Z", "action": 59, "target": "The following steps are required to create a query containing all suppliers who deliver more than three items.", "id": 45291191, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291191/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107516674/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T16:57:41.494260Z", "action": 59, "target": "In the following example, a query is run through two tables: an \"Item\" table with the \"Item_No\" field and a \"Suppliers\" table with the \"Supplier_Name\" field. In addition, both tables have a common field name \"Supplier_No.\"", "id": 45291190, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291190/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107516631/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T16:57:41.494219Z", "action": 59, "target": "<emph>Examples</emph>", "id": 45291189, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291189/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107516617/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T16:57:41.494178Z", "action": 59, "target": "If you run such a function, you cannot insert any additional columns for the query other than as an argument in a \"Group\" function.", "id": 45291188, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291188/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107516591/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T16:57:41.494142Z", "action": 59, "target": "SELECT COUNT(*) AS count FROM \"Item\"", "id": 45291187, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291187/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107516563/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T16:57:41.494102Z", "action": 59, "target": "Example:", "id": 45291186, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291186/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107516555/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T16:57:41.494062Z", "action": 59, "target": "SELECT FUNCTION() AS alias FROM table", "id": 45291185, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291185/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107516540/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T16:57:41.494016Z", "action": 59, "target": "The corresponding function in an SQL statement is:", "id": 45291184, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291184/?format=api" } ] }