Changes
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/libo_help-24-2/textsbasicshared03/en/changes/?format=api&page=62
{ "count": 4174, "next": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en/changes/?format=api&page=63", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en/changes/?format=api&page=61", "results": [ { "unit": "https://translations.documentfoundation.org/api/units/110316492/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsbasicshared03/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:10:58.241348Z", "action": 59, "target": "<emph>sqlcommand</emph>: A query name (without square brackets) or a SQL statement.", "id": 48110197, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48110197/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110316474/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsbasicshared03/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:10:58.241314Z", "action": 59, "target": "The <literal>RunSql</literal> method is rejected with an error message in case the database was previously opened in read-only mode.", "id": 48110196, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48110196/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110316445/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsbasicshared03/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:10:58.241281Z", "action": 59, "target": "The method returns <literal>True</literal> when successful.", "id": 48110195, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48110195/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110316390/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsbasicshared03/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:10:58.241249Z", "action": 59, "target": "Executes an action query of an SQL statement such as creating a table, as well as inserting, updating and deleting records.", "id": 48110194, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48110194/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110316362/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsbasicshared03/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:10:58.241216Z", "action": 59, "target": "Cancels all changes made to the database since the last <literal>Commit</literal> or <literal>Rollback</literal> call.", "id": 48110193, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48110193/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110316361/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsbasicshared03/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:10:58.241181Z", "action": 59, "target": "<emph>tablename</emph>: The name of an existing table as a case-sensitive String.", "id": 48110192, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48110192/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110316351/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsbasicshared03/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:10:58.241150Z", "action": 59, "target": "Opens the Data View window of the specified table and returns an instance of the <literal>Datasheet</literal> service.", "id": 48110191, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48110191/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110316304/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsbasicshared03/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:10:58.241115Z", "action": 59, "target": "<emph>directsql</emph>: When <literal>True</literal>, the SQL command is sent to the database engine without pre-analysis (Default = <literal>False</literal>).", "id": 48110190, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48110190/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110316279/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsbasicshared03/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:10:58.241081Z", "action": 59, "target": "<emph>sql</emph>: A string containing a valid SQL SELECT statement. Identifiers may be enclosed by square brackets.", "id": 48110189, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48110189/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110316223/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsbasicshared03/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:10:58.241048Z", "action": 59, "target": "Runs a SQL <literal>SELECT</literal> command, opens a Data View window with the results and returns an instance of the <literal>Datasheet</literal> service.", "id": 48110188, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48110188/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110316184/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsbasicshared03/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:10:58.241012Z", "action": 59, "target": "<emph>queryname</emph>: The name of an existing query as a case-sensitive String.", "id": 48110187, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48110187/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110316156/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsbasicshared03/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:10:58.240975Z", "action": 59, "target": "If the query could not be opened, then <literal>Nothing</literal> is returned.", "id": 48110186, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48110186/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110316135/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsbasicshared03/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:10:58.240937Z", "action": 59, "target": "Opens the Data View window of the specified query and returns an instance of the <literal>Datasheet</literal> service.", "id": 48110185, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48110185/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110316120/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsbasicshared03/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:10:58.240899Z", "action": 59, "target": "If form documents are organized in folders, it becomes necessary to include the folder name to specify the form document to be opened, as illustrated in the following example:", "id": 48110184, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48110184/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110316119/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsbasicshared03/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:10:58.240862Z", "action": 59, "target": "Most form documents are stored in the root of the Base document and they can be opened simply using their names, as in the example below:", "id": 48110183, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48110183/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110316118/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsbasicshared03/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:10:58.240822Z", "action": 59, "target": "<emph>formdocument:</emph> The name of the <literal>FormDocument</literal> to be opened, as a case-sensitive string.", "id": 48110182, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48110182/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110316107/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsbasicshared03/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:10:58.240785Z", "action": 59, "target": "If the specified form document does not exist, then <literal>Nothing</literal> is returned.", "id": 48110181, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48110181/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110316093/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsbasicshared03/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:10:58.240747Z", "action": 59, "target": "If the form document is already open, the form document window is activated.", "id": 48110180, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48110180/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110316042/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsbasicshared03/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:10:58.240710Z", "action": 59, "target": "Opens the specified form document in normal mode. This method returns a <literal>FormDocument</literal> service instance corresponding to the specified form document.", "id": 48110179, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48110179/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110316031/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsbasicshared03/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:10:58.240672Z", "action": 59, "target": "' Returns the first 50 employee records ordered by the 'FirstName' field", "id": 48110178, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48110178/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110316018/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsbasicshared03/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:10:58.240635Z", "action": 59, "target": "' Returns all rows in the table with column headers", "id": 48110177, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48110177/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110316002/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsbasicshared03/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:10:58.240597Z", "action": 59, "target": "Below are a few examples of how the <literal>GetRows</literal> method can be used:", "id": 48110176, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48110176/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110315986/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsbasicshared03/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:10:58.240559Z", "action": 59, "target": "<emph>maxrows</emph>: The maximum number of rows to return. The default is zero, meaning there is no limit to the number of returned rows.", "id": 48110175, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48110175/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110315974/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsbasicshared03/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:10:58.240522Z", "action": 59, "target": "<emph>header</emph>: When <literal>True</literal>, the first row of the returned array contains the column headers.", "id": 48110174, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48110174/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110315963/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsbasicshared03/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:10:58.240484Z", "action": 59, "target": "<emph>directsql</emph>: When <literal>True</literal>, the SQL command is sent to the database engine without pre-analysis. Default is <literal>False</literal>. This argument is ignored for tables. For queries, the applied option is the one set when the query was defined.", "id": 48110173, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48110173/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110315949/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsbasicshared03/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:10:58.240446Z", "action": 59, "target": "<emph>sqlcommand</emph>: A table or query name (without square brackets) or a <literal>SELECT</literal> SQL statement.", "id": 48110172, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48110172/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110315939/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsbasicshared03/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:10:58.240408Z", "action": 59, "target": "The returned array will be empty if no rows are returned and the column headers are not required.", "id": 48110171, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48110171/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110315929/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsbasicshared03/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:10:58.240370Z", "action": 59, "target": "An upper limit can be specified to the number of returned rows. Optionally column names may be inserted in the first row of the array.", "id": 48110170, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48110170/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110315907/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsbasicshared03/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:10:58.240333Z", "action": 59, "target": "Stores the contents of a table or the results of a <literal>SELECT</literal> query or of an SQL statement in a two-dimensional array. The first index in the array corresponds to the rows and the second index refers to the columns.", "id": 48110169, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48110169/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110315863/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsbasicshared03/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:10:58.240295Z", "action": 59, "target": "<emph>orderclause</emph>: An <literal>ORDER BY</literal> clause without the \"ORDER BY\" keywords. Field names should be surrounded with square brackets.", "id": 48110168, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48110168/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110315837/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsbasicshared03/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:10:58.240256Z", "action": 59, "target": "<emph>criteria</emph>: A <literal>WHERE</literal> clause without the \"WHERE\" keyword, in which field names are surrounded with square brackets.", "id": 48110167, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48110167/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110315835/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsbasicshared03/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:10:58.240217Z", "action": 59, "target": "<emph>tablename</emph>: A table name (without square brackets).", "id": 48110166, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48110166/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110315833/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsbasicshared03/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:10:58.240178Z", "action": 59, "target": "<emph>expression</emph>: A SQL expression in which the field names are surrounded with square brackets.", "id": 48110165, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48110165/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110315831/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsbasicshared03/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:10:58.240138Z", "action": 59, "target": "If the query returns multiple records, only the first one is considered. Use the <literal>OrderClause</literal> parameter to determine how query results are sorted.", "id": 48110164, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48110164/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110315828/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsbasicshared03/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:10:58.240097Z", "action": 59, "target": "Computes a SQL expression on a single record returned by a <literal>WHERE</literal> clause defined by the <literal>Criteria</literal> parameter.", "id": 48110163, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48110163/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110315826/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsbasicshared03/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:10:58.240059Z", "action": 59, "target": "' Below are some examples of how tables can be filtered", "id": 48110162, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48110162/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110315824/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsbasicshared03/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:10:58.240021Z", "action": 59, "target": "' Returns the sum of all salaries in the table", "id": 48110161, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48110161/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110315817/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsbasicshared03/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:10:58.239982Z", "action": 59, "target": "' Counts the number of employees in the table", "id": 48110160, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48110160/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110315790/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsbasicshared03/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:10:58.239944Z", "action": 59, "target": "The example below assumes the file <literal>Employees.odb</literal> has a table named <literal>EmployeeData</literal>.", "id": 48110159, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48110159/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110315768/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsbasicshared03/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:10:58.239906Z", "action": 59, "target": "<emph>criteria</emph>: A <literal>WHERE</literal> clause without the \"WHERE\" keyword, in which field names are surrounded with square brackets.", "id": 48110158, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48110158/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110315753/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsbasicshared03/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:10:58.239867Z", "action": 59, "target": "<emph>tablename</emph>: A table name (without square brackets).", "id": 48110157, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48110157/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110315732/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsbasicshared03/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:10:58.239828Z", "action": 59, "target": "<emph>expression</emph>: A SQL expression in which the field names are surrounded with square brackets.", "id": 48110156, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48110156/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110315714/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsbasicshared03/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:10:58.239790Z", "action": 59, "target": "Optionally, a SQL <literal>WHERE</literal> clause can be specified as a filter that will be applied prior to the aggregate function.", "id": 48110155, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48110155/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110315713/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsbasicshared03/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:10:58.239751Z", "action": 59, "target": "Computes the given aggregate function on a field or expression belonging to a table.", "id": 48110154, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48110154/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110315711/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsbasicshared03/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:10:58.239713Z", "action": 59, "target": "dataset = myDatabase.CreateDataset(\"Customers\", Filter = \"[Name] LIKE 'A'\")", "id": 48110153, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48110153/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110315709/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsbasicshared03/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:10:58.239676Z", "action": 59, "target": "oDataset = myDatabase.CreateDataset(\"Customers\", Filter := \"[Name] LIKE 'A'\")", "id": 48110152, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48110152/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110315698/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsbasicshared03/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:10:58.239637Z", "action": 59, "target": "The following examples in Basic and Python return a dataset with the records of a table named \"Customers\".", "id": 48110151, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48110151/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110315688/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsbasicshared03/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:10:58.239587Z", "action": 59, "target": "<emph>orderby</emph>: Specifies the ordering of the dataset as a SQL <literal>ORDER BY</literal> statement without the \"ORDER BY\" keyword.", "id": 48110150, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48110150/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110315678/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsbasicshared03/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:10:58.239549Z", "action": 59, "target": "<emph>filter</emph>: Specifies the condition that records must match to be included in the returned dataset. This argument is expressed as a SQL <literal>WHERE</literal> statement without the \"WHERE\" keyword.", "id": 48110149, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48110149/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110315665/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsbasicshared03/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:10:58.239512Z", "action": 59, "target": "<emph>directsql</emph>: Set this argument to <literal>True</literal> to send the statement directly to the database engine without preprocessing by %PRODUCTNAME (Default = <literal>False</literal>).", "id": 48110148, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48110148/?format=api" } ] }