# ActivityPages - Catalog: `YouTrack` - Schema: `Activities` - Select YouTrack API URL: `/activitiesPage` - Insert YouTrack API URL: `/activitiesPage` - Update YouTrack API URL: `/activitiesPage` - Delete YouTrack API URL: `/activitiesPage` - Field Selection Method: NotRequired - Select YouTrack API Operation: `get /activitiesPage` This is a read-only table function. The YouTrack API may not support changing the data or the Invantive SQL driver for YouTrack does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the YouTrack API. ## Parameters of Table Function | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `activityId` | `string` | ☐ | | ID of the activity that should be included in the page. The activity is allocated to the middle of the page. | | `author` | `string` | ☐ | | Parameter to filter activities by the author. The database id or login, or Hub id, or 'me' for the current logged in user could be specified. | | `categories` | `string` | ☐ | | | | `cursor` | `string` | ☐ | | | | `end` | `string` | ☐ | | End timestamp of the time interval the activity timestamp belongs to. If the parameter is not set, it is considered as Long.MAX_VALUE. | | `issueQuery` | `string` | ☐ | | Issues search query. Read more about <a href="Search-and-Command-Attributes.xml">search syntax</a>. | | `reverse` | `boolean` | ☐ | | Indicates whether the order of returning activities is from newest to oldest or the opposite. If "false", then the oldest activity item that matches a selected filter is returned first. If "true", then the newest activity is returned first. By default, "false". | | `start` | `string` | ☐ | | Start timestamp of the time interval the activity timestamp belongs to. If the parameter is not set, it is considered to be 0. | ## Columns of Table Function The columns of the table function `ActivityPages` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `$type` | `string` | | ☐ | | | `afterCursor` | `string` | After Cursor | ☐ | | | `beforeCursor` | `string` | Before Cursor | ☐ | | | `hasAfter` | `boolean` | Has After | ☐ | | | `hasBefore` | `boolean` | Has Before | ☐ | | | `id` | `string` | ID | ☐ | | | `reverse` | `boolean` | Reverse | ☐ | |