# ArticlesByQuery: JIRA Service Desk Articles by Query - Catalog: `JIRA` - Schema: `Service` - Primary Keys: `id` - Label: Articles by Query - Select JIRA Service Desk API URL: `/knowledgebase/article` - Insert JIRA Service Desk API URL: `/knowledgebase/article` - Update JIRA Service Desk API URL: `/knowledgebase/article` - Delete JIRA Service Desk API URL: `/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 | |---|:---:|:---:|:---:|---| | `highlight` | `boolean` | ☐ | False | If set to true matching query term in the title and excerpt will be highlighted using the {@code @@@hl@@@term@@@endhl@@@} syntax. Default: false. | | `highlight` | `boolean` | ☐ | False | If set to true matching query term in the title and excerpt will be highlighted using the {@code @@@hl@@@term@@@endhl@@@} syntax. Default: false. | | `query` | `string` | ☑ | | The string used to filter the articles. | ## Columns of Table Function The columns of the table function `ArticlesByQuery` 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. |