Changes
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/components/libo_help-24-2/textsdatabase/changes/?format=api&page=3219
{ "count": 160985, "next": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/changes/?format=api&page=3220", "previous": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsdatabase/changes/?format=api&page=3218", "results": [ { "unit": "https://translations.documentfoundation.org/api/units/107515648/?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.491683Z", "action": 59, "target": "Specifying field names", "id": 45291126, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291126/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107515631/?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.491646Z", "action": 59, "target": "<ahelp hid=\"HID_CTL_QRYDGNCRIT\">Select conditions to define the query.</ahelp> Each column of the design table accepts a data field for the query. The conditions in one row are linked with a Boolean AND.", "id": 45291125, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291125/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107515619/?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.491609Z", "action": 59, "target": "Defining the query", "id": 45291124, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291124/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107515601/?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.491572Z", "action": 59, "target": "Alternatively, delete the respective entries in <emph>Fields involved </emph>in the <emph>Relations</emph> dialog. Or press Tab until the connecting vector is displayed highlighted, then press Shift+F10 to open the context menu and select <emph>Delete </emph>command.", "id": 45291123, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291123/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107515574/?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.491535Z", "action": 59, "target": "To delete a relation between two tables, click the connection line and then press the Delete key.", "id": 45291122, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291122/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107515547/?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.491498Z", "action": 59, "target": "Deleting relations", "id": 45291121, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291121/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107515529/?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.491458Z", "action": 59, "target": "<ahelp hid=\"HID_QUERY_EDIT_JOINCONNECTION\" visibility=\"hidden\">Edit Join Properties.</ahelp> Alternatively, press Tab until the line is selected, then press Shift+F10 to display the context menu and there choose the command <emph>Edit</emph>. Some databases support only a subset of the possible join types.", "id": 45291120, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291120/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107515519/?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.491418Z", "action": 59, "target": "If you double-click on the line connecting two linked fields or call the menu command <emph>Insert - New Relation</emph>, you can specify the type of relation in the <link href=\"text/sdatabase/02010101.xhp\"><emph>Relations</emph></link> dialog.", "id": 45291119, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291119/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107515500/?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.491375Z", "action": 59, "target": "Specifying the relation type", "id": 45291118, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291118/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107515482/?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.491334Z", "action": 59, "target": "You cannot access tables from different databases in a query. Queries involving multiple tables can only be created within one database.", "id": 45291117, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291117/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107515463/?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.491293Z", "action": 59, "target": "The creation of a query that is based on several related sheets is only possible if you use $[officename] as the interface for a relational database.", "id": 45291116, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291116/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107515439/?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.491254Z", "action": 59, "target": "To do this, click a field name in a table (for example, the field name \"Item-Number\" from the Customer table), hold down the mouse button and then drag the field name to the field name of the other table (\"Item-Number\" from the Item table). When you release the mouse button, a line connecting the two fields between the two table windows appears. The corresponding condition that the content of the two field names must be identical is entered in the resulting SQL query.", "id": 45291115, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291115/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107515411/?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.491214Z", "action": 59, "target": "If, for example, you have a spreadsheet for articles identified by an article number, and a spreadsheet for customers in which you record all articles that a customer orders using the corresponding article numbers, then there is a relationship between the two \"article number\" data fields. If you now want to create a query that returns all articles that a customer has ordered, you must retrieve data from two spreadsheets. To do this, you must inform $[officename] about the relationship which exists between the data in the two spreadsheets.", "id": 45291114, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291114/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107515384/?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.491174Z", "action": 59, "target": "If there are data relations between a field name in one table and a field name in another table, you can use these relations for your query.", "id": 45291113, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291113/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107515361/?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.491134Z", "action": 59, "target": "Table Relations", "id": 45291112, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291112/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107515351/?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.491094Z", "action": 59, "target": "You can resize and arrange the tables according to your preferences. To move tables, drag the upper border to the desired position. Enlarge or reduce the size in which the table is displayed by positioning the mouse cursor on a border or on a corner and dragging the table until it is the desired size.", "id": 45291111, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291111/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107515333/?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.491056Z", "action": 59, "target": "Move table and modify table size", "id": 45291110, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291110/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107515311/?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.491019Z", "action": 59, "target": "To remove the table from Design View, click the upper border of the table window and display the context menu. You can use the <emph>Delete</emph> command to remove the table from the Design View. Another option is to press the Delete key.", "id": 45291109, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291109/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107515305/?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.490979Z", "action": 59, "target": "Remove tables", "id": 45291108, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291108/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107515289/?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.490939Z", "action": 59, "target": "While designing a query, you cannot modify the selected tables.", "id": 45291107, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291107/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107515274/?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.490899Z", "action": 59, "target": "<ahelp hid=\"HID_CTL_QRYDGNTAB\">Double-click fields to add them to the query. Drag-and-drop to define relations.</ahelp>", "id": 45291106, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291106/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107515263/?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.490858Z", "action": 59, "target": "When you open the query design for the first time, you see a dialog in which you must first select the table or query that will be the basis for your new query.", "id": 45291105, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291105/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107515249/?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.490818Z", "action": 59, "target": "Browse", "id": 45291104, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291104/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107515236/?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.490778Z", "action": 59, "target": "Add Table or Query", "id": 45291103, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291103/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107515224/?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.490736Z", "action": 59, "target": "F7", "id": 45291102, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291102/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107515200/?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.490687Z", "action": 59, "target": "Run Query", "id": 45291101, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291101/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107515188/?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.490647Z", "action": 59, "target": "F5", "id": 45291100, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291100/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107515181/?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.490611Z", "action": 59, "target": "Preview", "id": 45291099, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291099/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107515173/?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.490571Z", "action": 59, "target": "F4", "id": 45291098, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291098/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107515162/?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.490531Z", "action": 59, "target": "Function", "id": 45291097, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291097/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107515139/?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.490491Z", "action": 59, "target": "Key", "id": 45291096, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291096/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107515124/?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.490452Z", "action": 59, "target": "Keys in Query Design View", "id": 45291095, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291095/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107515114/?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.490417Z", "action": 59, "target": "If you want to test a query, double-click the query name in the database document. The query result is displayed in a table similar to the Data Source View. Note: the table displayed is only temporary.", "id": 45291094, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291094/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107515085/?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.490380Z", "action": 59, "target": "In the top of the query Design View window, the <link href=\"text/shared/main0214.xhp\">icons</link> of the <emph>Query Design</emph> Bar and the <emph>Design</emph> bar are displayed.", "id": 45291093, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291093/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107515069/?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.490343Z", "action": 59, "target": "The lower pane of the Design View is where you define the query. To define a query, specify the database field names to include and the criteria for displaying the fields. To rearrange the columns in the lower pane of the Design View, drag a column header to a new location, or select the column and press <switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+arrow key.", "id": 45291092, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291092/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107515028/?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.490307Z", "action": 59, "target": "To create a query, click the <emph>Queries</emph> icon in a database document, then click <emph>Create Query in Design View</emph>.", "id": 45291091, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291091/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107515007/?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.490267Z", "action": 59, "target": "The Design View", "id": 45291090, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291090/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107514989/?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.490220Z", "action": 59, "target": "The Query Design window layout is stored with a created query, but cannot be stored with a created view.", "id": 45291089, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291089/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107514976/?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.490180Z", "action": 59, "target": "Selecting the <emph>Create View</emph> command from the <emph>Tables</emph> tab page of a database document, you see the <emph>View Design</emph> window that resembles the <emph>Query Design</emph> window described here.", "id": 45291088, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291088/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107514961/?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.490140Z", "action": 59, "target": "Most databases use queries to filter or to sort database tables to display records on your computer. Views offer the same functionality as queries, but on the server side. If your database is on a server that supports views, you can use views to filter the records on the server to speed up the display time.", "id": 45291087, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291087/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107514936/?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.490101Z", "action": 59, "target": "<ahelp hid=\".\">The <emph>Query Design View </emph>allows you to create and edit a database query.</ahelp>", "id": 45291086, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291086/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107514902/?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.490063Z", "action": 59, "target": "<link href=\"text/sdatabase/02010100.xhp\">Query Design</link>", "id": 45291085, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291085/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107514888/?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.490024Z", "action": 59, "target": "<bookmark_value>views; creating database views (Base)</bookmark_value> <bookmark_value>queries; creating in design view (Base)</bookmark_value> <bookmark_value>designing; queries (Base)</bookmark_value> <bookmark_value>design view; queries/views (Base)</bookmark_value> <bookmark_value>joining;tables (Base)</bookmark_value> <bookmark_value>tables in databases; joining for queries (Base)</bookmark_value> <bookmark_value>queries; joining tables (Base)</bookmark_value> <bookmark_value>tables in databases; relations (Base)</bookmark_value> <bookmark_value>relations; joining tables (Base)</bookmark_value> <bookmark_value>queries; deleting table links (Base)</bookmark_value> <bookmark_value>criteria of query design (Base)</bookmark_value> <bookmark_value>queries; formulating filter conditions (Base)</bookmark_value> <bookmark_value>filter conditions;in queries (Base)</bookmark_value> <bookmark_value>parameters; queries (Base)</bookmark_value> <bookmark_value>queries; parameter queries (Base)</bookmark_value> <bookmark_value>SQL; queries (Base)</bookmark_value> <bookmark_value>native SQL (Base)</bookmark_value>", "id": 45291084, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291084/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107514826/?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.489985Z", "action": 59, "target": "Query Design", "id": 45291083, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291083/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107514801/?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.489947Z", "action": 59, "target": "<ahelp hid=\".\">If you selected the first option, but you still want to open the query in the graphics view in spite of missing elements, you can specify whether other errors are ignored.</ahelp> Therefore, in the current opening process, no error message will be displayed if the query can not be correctly interpreted.", "id": 45291082, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291082/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107514779/?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.489908Z", "action": 59, "target": "Also ignore similar errors", "id": 45291081, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291081/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107514758/?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.489867Z", "action": 59, "target": "<ahelp hid=\".\">Allows you to cancel the procedure and specify that the query should not be opened.</ahelp> This option corresponds to the function of the <emph>Cancel</emph> dialog button.", "id": 45291080, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291080/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107514741/?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.489829Z", "action": 59, "target": "Do not open the query", "id": 45291079, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291079/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107514729/?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.489791Z", "action": 59, "target": "<ahelp hid=\".\">Allows you to open the query design in the <link href=\"text/sdatabase/02010100.xhp\">SQL Mode</link> and to interpret the query as a <link href=\"text/shared/02/14030000.xhp\">Native SQL</link>.</ahelp> You can only quit the native SQL mode when the $[officename] statement is completely interpreted (only possible if the used tables or fields in the query really exist).", "id": 45291078, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291078/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107514709/?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.489753Z", "action": 59, "target": "Open the query in the SQL View", "id": 45291077, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291077/?format=api" } ] }