# ArticlesByServiceDeskIdAndQuery: JIRA Service Desk Articles by Service Desk ID or Query - Catalog: `JIRA` - Schema: `Service` - Primary Keys: `id` - Label: Articles by Service Desk ID or Query - Select JIRA Service Desk API URL: `/servicedesk/{serviceDeskId}/knowledgebase/article` - Insert JIRA Service Desk API URL: `/servicedesk/{serviceDeskId}/knowledgebase/article` - Update JIRA Service Desk API URL: `/servicedesk/{serviceDeskId}/knowledgebase/article` - Delete JIRA Service Desk API URL: `/servicedesk/{serviceDeskId}/knowledgebase/article` - Field Selection Method: NotRequired - Base Path: `values[*]` This is a read-only table function. The JIRA Service Desk API may not support changing the data or the Invantive SQL driver for JIRA Service Desk does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the JIRA Service Desk API. ## Parameters of Table Function | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `query` | `string` | ☑ | | The string used to filter the articles. | | `serviceDeskId` | `int64` | ☑ | | The ID of the service desk to return. This can alternatively be a project identifier. | ## Columns of Table Function The columns of the table function `ArticlesByServiceDeskIdAndQuery` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `content_iframeSrc` | `string` | | ☐ | URL containing the body of the article (without title), suitable for rendering in an iframe. | | `excerpt` | `string` | | ☐ | Excerpt of the article which matches the given query string. | | `source_type` | `string` | | ☐ | Type of the knowledge base source. | | `title` | `string` | | ☐ | Title of the article. |