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=34
{ "count": 1740, "next": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en/changes/?format=api&page=35", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsdatabase/en/changes/?format=api&page=33", "results": [ { "unit": "https://translations.documentfoundation.org/api/units/107515727/?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.491958Z", "action": 59, "target": "<ahelp hid=\"dbaccess/ui/savedialog/schema\">Enter the name of the schema that is assigned to the query or table view.</ahelp>", "id": 45291133, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291133/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107515713/?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.491920Z", "action": 59, "target": "Schema", "id": 45291132, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291132/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107515695/?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.491881Z", "action": 59, "target": "Use the <emph>Save</emph> icon on the Standard toolbar to save the query. You will see a dialog that asks you to enter a name for the query. If the database supports schemas, you can also enter a schema name.", "id": 45291131, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291131/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107515687/?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.491842Z", "action": 59, "target": "Saving the query", "id": 45291130, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291130/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107515677/?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.491802Z", "action": 59, "target": "To remove a field name from the query, click the column header of the field and choose the <emph>Delete</emph> command on the context menu for the column.", "id": 45291129, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291129/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107515668/?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.491762Z", "action": 59, "target": "Deleting field names", "id": 45291128, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291128/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/107515657/?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.491723Z", "action": 59, "target": "First, select all field names from the tables that you want to add to the query. You can do this either by drag-and-drop or by double-clicking a field name in the table window. With the drag-and-drop method, use the mouse to drag a field name from the table window into the lower area of the query design window. As you do this, you can decide which column in the query design window will receive the selected field. A field name can also be selected by double-clicking. It will then be added to the next free column in the query design window.", "id": 45291127, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/45291127/?format=api" }, { "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" } ] }