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=33
{ "count": 1740, "next": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en/changes/?format=api&page=34", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en/changes/?format=api&page=32", "results": [ { "unit": "https://translations.documentfoundation.org/api/units/107516500/?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.493972Z", "action": 59, "target": "You can also assign aliases to function calls. If you do not want to display the query string in the column header, enter a desired substitute name under <emph>Alias</emph>.", "id": 45291183, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291183/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107516486/?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.493932Z", "action": 59, "target": "To use other functions not listed in the list box, you must enter them manually under <emph>Field</emph>.", "id": 45291182, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291182/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107516464/?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.493892Z", "action": 59, "target": "Except for the <emph>Group</emph> function, the above functions are called Aggregate functions. These are functions that calculate data to create summaries from the results. Additional functions that are not listed in the list box might be also possible. These depend on the specific database engine in use and on the current functionality provided by the Base driver used to connect to that database engine.", "id": 45291181, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291181/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107516457/?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.493852Z", "action": 59, "target": "SELECT SUM(\"Price\") FROM \"Article\".", "id": 45291180, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291180/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107516436/?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.493815Z", "action": 59, "target": "For example, the function call in SQL for calculating a sum is:", "id": 45291179, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291179/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107516420/?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.493775Z", "action": 59, "target": "SELECT FUNCTION(column) FROM table.", "id": 45291178, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291178/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107516415/?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.493735Z", "action": 59, "target": "You can also enter function calls directly into the SQL statement. The syntax is:", "id": 45291177, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291177/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107516410/?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.493695Z", "action": 59, "target": "Groups query data according to the selected field name. Functions are executed according to the specified groups. In SQL, this option corresponds to the GROUP BY clause. If a criterion is added, this entry appears in the SQL HAVING sub-clause.", "id": 45291176, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291176/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107516389/?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.493656Z", "action": 59, "target": "Group", "id": 45291175, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291175/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107516382/?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.493613Z", "action": 59, "target": "Calculates the sum of the values of records for the associated fields.", "id": 45291174, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291174/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107516372/?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.493572Z", "action": 59, "target": "Sum", "id": 45291173, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291173/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107516366/?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.493531Z", "action": 59, "target": "Determines the lowest value of a record for that field.", "id": 45291172, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291172/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107516351/?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.493491Z", "action": 59, "target": "Minimum", "id": 45291171, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291171/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107516343/?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.493451Z", "action": 59, "target": "Determines the highest value of a record for that field.", "id": 45291170, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291170/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107516309/?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.493411Z", "action": 59, "target": "Maximum", "id": 45291169, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291169/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107516293/?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.493372Z", "action": 59, "target": "b) COUNT(column): Passing a field name as an argument counts only the records in which the specified field contains a value. Records in which the field has a Null value (i.e. contains no textual or numeric value) will not be counted.", "id": 45291168, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291168/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107516242/?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.493332Z", "action": 59, "target": "a) COUNT(*): Passing an asterisk as the argument counts all records in the table.", "id": 45291167, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291167/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107516224/?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.493293Z", "action": 59, "target": "Determines the number of records in the table. Empty fields can either be counted (a) or excluded (b).", "id": 45291166, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291166/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107516190/?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.493253Z", "action": 59, "target": "Count", "id": 45291165, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291165/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107516172/?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.493212Z", "action": 59, "target": "Calculates the arithmetic mean of a field.", "id": 45291164, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291164/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107516159/?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.493171Z", "action": 59, "target": "Average", "id": 45291163, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291163/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107516133/?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.493130Z", "action": 59, "target": "No function will be executed.", "id": 45291162, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291162/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107516121/?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.493089Z", "action": 59, "target": "No function", "id": 45291161, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291161/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107516106/?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.493048Z", "action": 59, "target": "Effect", "id": 45291160, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291160/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107516083/?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.493010Z", "action": 59, "target": "Option", "id": 45291159, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291159/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107516052/?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.492967Z", "action": 59, "target": "If you are working with the embedded HSQL database, the list box in the <emph>Function</emph> row offers you the following options:", "id": 45291158, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291158/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107516037/?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.492927Z", "action": 59, "target": "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\" visibility=\"hidden\">Select a function to run in the query.</ahelp> The functions which are available here depend on those provided by the database engine.", "id": 45291157, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291157/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107516016/?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.492886Z", "action": 59, "target": "Functions", "id": 45291156, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291156/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107515995/?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.492845Z", "action": 59, "target": "You can also use the context menu of the line headers in the lower area of the query design window to insert a filter based on a function:", "id": 45291155, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291155/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107515974/?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.492804Z", "action": 59, "target": "Here you can enter one additional filter criterion for each line. Multiple criteria in a single column will be interpreted as boolean OR.", "id": 45291154, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291154/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107515951/?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.492763Z", "action": 59, "target": "or", "id": 45291153, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291153/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107515884/?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.492719Z", "action": 59, "target": "<ahelp hid=\"HID_QRYDGN_ROW_CRIT\">Specifies a first criteria by which the content of the data field is to be filtered.</ahelp>", "id": 45291152, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291152/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107515869/?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.492678Z", "action": 59, "target": "Criteria", "id": 45291151, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291151/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107515854/?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.492638Z", "action": 59, "target": "<ahelp hid=\"HID_QRYDGN_ROW_VISIBLE\">If you mark the <emph>Visible</emph> property for a data field, that field will be visibly displayed in the resulting query</ahelp>. If you are only using a data field to formulate a condition or make a calculation, you do not necessarily need to display it.", "id": 45291150, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291150/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107515842/?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.492598Z", "action": 59, "target": "Visible", "id": 45291149, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291149/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107515838/?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.492559Z", "action": 59, "target": "<ahelp hid=\"HID_QRYDGN_ROW_ORDER\">If you click on this cell, you can choose a sort option: ascending, descending and unsorted.</ahelp> Text fields will be sorted alphabetically and numerical fields numerically. For most databases, administrators can set the sorting options at the database level.", "id": 45291148, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291148/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107515836/?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.492518Z", "action": 59, "target": "Sort", "id": 45291147, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291147/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107515833/?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.492475Z", "action": 59, "target": "<ahelp hid=\"HID_QRYDGN_ROW_TABLE\">The corresponding database table of the selected data field is listed here.</ahelp> If you activate this cell with a mouse click, an arrow will appear which enables you to select a different table for the current query.", "id": 45291146, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291146/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107515831/?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.492434Z", "action": 59, "target": "Table", "id": 45291145, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291145/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107515828/?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.492395Z", "action": 59, "target": "For example:", "id": 45291144, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291144/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107515826/?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.492360Z", "action": 59, "target": "SELECT column AS alias FROM table.", "id": 45291143, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291143/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107515824/?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.492321Z", "action": 59, "target": "In a SQL statement, aliases are defined as follows:", "id": 45291142, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291142/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107515820/?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.492281Z", "action": 59, "target": "<ahelp hid=\"HID_QRYDGN_ROW_ALIAS\">Specifies an alias. This alias will be listed in the query instead of the field name. This makes it possible to use user-defined column labels.</ahelp> For example, if the data field is named PtNo and, instead of that name, you would like to have PartNum appear in the query, enter PartNum as the alias.", "id": 45291141, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291141/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107515812/?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.492241Z", "action": 59, "target": "Alias", "id": 45291140, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291140/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107515801/?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.492202Z", "action": 59, "target": "<ahelp hid=\"HID_QRYDGN_ROW_FIELD\">Enter the name of the data field that is referred to in the Query. All settings made in the filter option rows refer to this field.</ahelp> If you activate a cell here with a mouse click you'll see an arrow button, which enables you to select a field. The \"Table name.*\" option selects all data fields with the effect that the specified criteria will be applied to all table fields.", "id": 45291139, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291139/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107515784/?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.492162Z", "action": 59, "target": "Field", "id": 45291138, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291138/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107515777/?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.492122Z", "action": 59, "target": "To filter data for the query, set the desired criteria in the lower area of the query design window. The following options are available:", "id": 45291137, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291137/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107515768/?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.492081Z", "action": 59, "target": "Filtering data", "id": 45291136, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291136/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107515749/?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.492041Z", "action": 59, "target": "<ahelp hid=\"dbaccess/ui/savedialog/title\">Enter the name of the query or table view.</ahelp>", "id": 45291135, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291135/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107515737/?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.491999Z", "action": 59, "target": "Query name or table view name", "id": 45291134, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291134/?format=api" } ] }