KnowledgeBaseArticles
The articles which match the given query string across all service desks.
Select
To query this table, you must specify either the Query column or both ServiceDeskId and Query in the WHERE clause. For example:
SELECT * FROM KnowledgeBaseArticles WHERE Query = 'guide'; SELECT * FROM KnowledgeBaseArticles WHERE Query = 'guide' AND ServiceDeskId = 2;
Aside from the required columns mentioned above and the Highlights pseudo-column used by the connector to process server-side filtering through the Jira Service Management API, all other filters in the WHERE clause are applied client-side by the connector.
Note: This view is available only for Jira Service Management Cloud instances. It is not supported on Jira Service Management Server or Data Center deployments.
Columns
| Name | Type | Description |
| ServiceDeskId | String | The Id of the service desk. |
| Title | String | The title of the article. |
| Excerpt | String | The excerpt of the article. |
| SourceType | String | The article's source type |
| SourcePageId | String | The article's source page id |
| SourceSpaceKey | String | The article's source space key |
| ContentiFramesource | String | The link to the article. |
| Query | String | The string used to filter the articles (required). |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| Highlight | Boolean | If set to true matching query term in the title and excerpt will be highlighted using the {@code @@@hl@@@term@@@endhl@@@} syntax. Default: false. |